Computer Awareness MCQs for Banking : Set 28 | GK Infopedia

Spread the love

[1] The full form of DDL is:
A. Dynamic Data Language
B. Detailed Data Language
C. Data Definition Language
D. Data Derivation Language
Ans: Data Definition Language
Explanation : DDL stands for Data Definition Language.

[2] In relational database, a field is a:
A. label
B. table of information
C. group of related tables
D. category of information
Ans: category of information
Explanation : A field is category of information.

[3] Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
A. Candidate key
B. Sub key
C. Super key
D. Foreign key
Ans: Super key
Explanation : Super key is a set of one or more attributes taken collectively to uniquely identify a record.

[4] A is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
A. Rows
B. Key
C. Attribute
D. Fields
Ans: Key
Explanation : Key is a property of the entire relation (relation is a table).

[5] A is an abstract model that describes, how the data are organized and represented.
A. data model
B. instances
C. schema
D. database
Ans: data model
Explanation : A Data Model is a logical structure of Database. Data model is an abstract model that describes, how the data are organized and represented.

[6] Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
A. IDMS
B. DB2
C. dBase-II
D. R:base
Ans: DB2
Explanation : DB2 is a database product from IBM. It is a Relational Database Management System (RDBMS). DB2 is designed to store, analyze and retrieve the data efficiently.

[7] Before use of DBMS information was stored using:
A. Cloud Storage
B. Data System
C. File Management System
D. Cloud Computing
Ans: File Management System
Explanation : Earlier File Management Systems were used, before the usage of DBMS.

[8] is an interface between low level database and application program.
A. Database Associate
B. Database Server
C. Database or Store Manager
D. Database Constrains
Ans: Database or Store Manager
Explanation : Storage manager is a program module that provides the interface between the low-level data stored in the database and the application programs and queries submitted to the system.

[9] Which one of the following design is both software and hardware independent?
A. Logical
B. Physical
C. Conceptual
D. Rational
Ans: Conceptual
Explanation : Conceptual design is both software and hardware independent.

[10] Which of the following are type of Twisted Pair Cable?
A. Coaxial Cable
B. Shielded Twisted Pair (STP)
C. Unshielded Twisted Pair (UTP)
D. Only (2) and (3)
Ans: Only (2) and (3)
Explanation : STP and UTP are type of Twisted Pair Cable which are mostly used in all Networks.

[11] Which among the following is a software package from Sun Microsystems?
A. JPEG
B. JDK
C. IDE
D. IRQ
Ans: JDK
Explanation : The Java Development Kit (JDK) is a software development environment used for developing Java applications and applets.

[12] A relational database consists of a collection of:
A. Tables
B. Fields
C. Records
D. Keys
Ans: Tables
Explanation : Relational database is a collection of Relations or Table. A table is also known as relation in RDBMS. Fields are the column of the relation or tables.

[13] The term attribute refers to a of a table.
A. Record
B. Column
C. Tuple
D. Key
Ans: Column
Explanation : Attribute may refer to columns in a table and tuple refers to rows in a table.

[14] For each attribute of a relation, there is a set of permitted values, called the of that attribute.
A. Domain
B. Relation
C. Set
D. Schema
Ans: Domain
Explanation : The values of the attribute should be present in the domain. Domain is a set of values permitted.

[15] In the architecture of a database system external level is the:
A. physical level
B. logical level
C. conceptual level
D. view level
Ans: view level
Explanation : An external schema specifies a view of the data in terms of the conceptual level. This is also referred to as the view level.

[16] The language used in application programs to request or select data from the DBMS is referred to as the:
A. DML
B. DDL
C. VDL
D. SDL
Ans: DML
Explanation : A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for selecting, requesting, inserting, deleting and updating data in a database.

[17] Star Topology is based on a central device that can be a:
A. HUB
B. Switch
C. Modem
D. Both (1) and (2)
Ans: Both (1) and (2)
Explanation : Hub and Switch can be used as central device in star topology.

[18] Routing is done on which layer?
A. Datalink Layer
B. Network Layer
C. Session
D. Presentation
Ans: Network Layer
Explanation : Routing is done on Network Layer.

[19] Which among the following device performs modulation and demodulation?
A. Modem
B. Fiber optic
C. Satellite
D. Coaxial Cable
Ans: Modem
Explanation : A modem (modulator-demodulator) is a network hardware device that modulates one or more carrier wave signals to encode digital information for transmission and demodulates signals to decode the transmitted information.

[20] Name the program a personal computer's microprocessor uses to get the computer system started after you turn it on.
A. BIOS
B. VAIO
C. I/O
D. AVG
Ans: BIOS
Explanation : BIOS (basic input/output system) is the program a personal computer's microprocessor uses to get the computer system started after you turn it on.

[21]Microsoft Office is a .
A. Shareware
B. Public-domain software
C. Open source software
D. An application suite
Ans: An application suite
Explanation : MS Office is an application suite consisting many application software such as MS Word, PowerPoint, Excel, Outlook etc.

[22] Which among the following key combination can be used to search in Windows Explorer?
A. Ctrl+F
B. Ctrl+S
C. Ctrl+G
D. Alt+S
Ans: Ctrl+F
Explanation : Ctrl+F is the short cut key combination that can be used to search in Windows Explorer.

[23] Which among the following is a cloud computing platform and infrastructure created by Microsoft?
A. Simple Storage Service
B. Atmos
C. Openstack Swift
D. Azure
Ans: Azure
Explanation : Microsoft is a cloud computing platform and infrastructure created by Microsoft for building, deploying, and managing applications and services through a global network of Microsoft-managed data centers.

[24] What is the shortcut key combination for deleting the selected item without moving it to the Recycle Bin first?
A. Shift+Delete
B. Ctrl+D
C. Alt+Delete
D. Ctrl+X
Ans: Shift+Delete
Explanation : To delete selected item without moving to recycle bin- Shift+Delete

[25] Which among the following is a popular program for documents that can be read on both a Windows and a Mac PC?
A. Microsoft Excel
B. Adobe in Design
C. Adobe Acrobat
D. QuarkXPress
Ans: Adobe Acrobat
Explanation : Adobe Acrobat can be used to read documents on Windows and Mac PC.



Spread the love

Leave a Reply

Your email address will not be published. Required fields are marked *