What does the computer Motherboard contains that houses setting configurations and is powered by the onboard battery?
Sol. The CMOS is a physical part of the motherboard: it is a memory chip that houses setting configurations and is powered by the onboard battery. The CMOS is reset and loses all custom settings in case the battery runs out of energy, additionally, the system clock resets when the CMOS loses power.
Which of the following communications modes support two-way traffic but in only one direction of a time?
Sol. Half Duplex support two-way traffic but in only one direction of a time. For example, a walkie-talkie is a half-duplex device because only one party can talk at a time. In contrast, a telephone is a full-duplex device because both parties can talk simultaneously.
Where are the files deleted from the hard disk sent to?
Answer: Recycle bin
Sol. Files deleted from the hard disk sent to the recycle bin.
Which of the following are type of Twisted Pair Cable?
Answer: Only (b) and (c)
Sol. STP and UTP are type of Twisted Pair Cable which are mostly used in all Networks.
What is an ad hoc query?
Answer: Spur-of-the-moment question
Sol. An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools.
Dr. E.F. Codd represented ______ rules that a database must obey if it has to be considered truly relational.
Sol. Dr Edgar F. Codd, after his extensive research on the Relational Model of database systems, came up with twelve rules of his own, which according to him, a database must obey in order to be regarded as a true relational database.
Which of the following is true about Page Preview Mode?
Answer: You can see all pages of your document
Sol. In page preview mode you can preview all the pages of the document.
Network __________ is the arrangement of the various elements (links, nodes, etc.) of a computer network.
Sol. Network topology is the arrangement of the various elements (links, nodes, etc.) of a computer network. There are two basic categories of network topologies: Physical topologies and Logical topologies.
Which of the following terms is associated with Internet?
Sol. A bookmark is a saved shortcut that directs your browser to a specific webpage. It stores the title, URL, and favicon of the corresponding page.
A relational database consists of a collection of
Sol. 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. Records are each row in relation. Keys are the constraints in a relation.
The term attribute refers to a ___________ of a table.
Sol. Attribute may refer to columns in a table and tuple refers to rows in a table.
Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
Answer: Schema, Instance
Sol. Instance is an instance of time and schema is a representation.
In relational database, a field is a
Answer: Category of information
Sol. A field is category of information.
Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
Answer: Super key
Sol. Super key is a set of one or more attributes taken collectively to uniquely identify a record.
A __________ is an abstract model that describes, how the data are organized and represented.
Answer: Data model
Sol. A Data Model is a logical structure of Database. Data model is an abstract model that describes, how the data are organized and represented.
Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
Sol. 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.
Before use of DBMS information was stored using
Answer: File Management System
Sol. Earlier File Management Systems were used, before the usage of DBMS.
____________ is an interface between low level database and application program.
Answer: Database or Store Manager
Sol. 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.The storage manager is responsible to the following tasks: interaction with the file manager;and efficient storing, retrieving and updating of data.
Which of the following is a binary number?
Sol. Binary Numbers use only '0' and '1'.
What type of software creates a smaller file that is faster to transfer over the Internet?
Sol. Compression is the process of reducing the size of a file by encoding its data information more efficiently. By doing this, the result is a reduction in the number of bits and bytes used to store the information.
Miscellaneous GK Questions