Free Databases MCQs with Answers
210 Databases MCQs from Computer Science and IT, each with the correct answer and a written explanation of why it is correct. Free and unlimited, with no account needed.
Databases cover tables, records, fields, keys and relationships, together with database management systems and relational database design. The subject includes primary and foreign keys, normalization, SQL commands such as SELECT, INSERT, UPDATE and DELETE, queries, forms and reports, while distinguishing a database from a spreadsheet used for simple tabular data.
Last updated
210 questions · page 7 of 11
- A. data are to a files
- B. a column is to a row
- C. files are to a tables
- D. attributes are to column
Explanation: A field is to a record as a column is to a row. In a database table, each row represents a record, and each column represents a field.In a…
Correct answer: a column is to a row- A. data integrity
- B. data integration
- C. data interdependence
- D. data organization
Explanation: Data interdependence refers to the relationship between data elements where changes in one can affect others, crucial for maintaining…
Correct answer: data interdependence- A. record
- B. field
- C. cell
- D. file
Explanation: A database is a collection of information organized in such a way that it can be easily accessed, managed, and updated.
Correct answer: field124. A database containing all students in a class would store the information of individual students in:
- A. record
- B. field
- C. cell
- D. file
Explanation: A collection of related fields treated as a single unit is known as record.
Correct answer: record- A. hardware, hard drive, monitor, data, user
- B. hardware, software, people, and data
- C. software, you, me, DBA, client
- D. DBMS, hardware, user, programmer, engineer
Explanation: A database management system consists of several components. Each component plays a very important role in DBMS environment.
Correct answer: hardware, software, people, and data- A. programs are independent of data format
- B. reduces security and the control of data
- C. increased duplication of data
- D. all of the above
Explanation: It means that while using a database management system we can add data of any data type here.Following are the basic advantages of DBMS…
Correct answer: programs are independent of data format- A. program files
- B. data files
- C. both a and b
- D. all of the above
Explanation: Program file: A file containing executable code, typically written in a programming language, that instructs a computer on how to perform…
Correct answer: both a and b- A. master file
- B. transaction file
- C. backup file
- D. all of the above
Explanation: From a usage point of view, program files are used to store the instructions that a computer needs to execute a program, while data files…
Correct answer: all of the above- A. database integrity
- B. database integration
- C. availability
- D. all of the above
Explanation: Following are the objectives of DBMS, such as shareability, availability, evolvability and data integrity.
Correct answer: all of the above- A. data dictionary
- B. table
- C. fields
- D. records
Explanation: A data dictionary, or metadata repository, is a "centralized repository of information about data such as meaning, relationships to other…
Correct answer: data dictionary- A. Data dependence
- B. Data independence
- C. Data integration
- D. Data relationships
Explanation: The separation of data structure of database from the application program that uses the data is called data independence.
Correct answer: Data independence- A. Adding records
- B. Deleting records
- C. Processing queries
- D. All of above
Explanation: A data application typically contains procedures for adding records, deleting records, and processing queries.
Correct answer: All of above- A. Data redundancy
- B. Data multiplication
- C. Data Integrity
- D. Normalization
Explanation: Duplicate data in multiple files refers to the situation where the same data is stored in more than one file or location.
Correct answer: Data redundancy- A. Data warehouse
- B. Data model
- C. Data structure
- D. Data type
Explanation: A data model is a conceptual representation of the structure of a database, describing the relationships between different data elements…
Correct answer: Data model- A. Sequential files
- B. Direct or Random file
- C. Index Sequential
- D. All of them
Explanation: All of the files are types from usage point of view.All these store data in different ways.
Correct answer: All of them- A. Folder system
- B. Database system
- C. Drive system
- D. DBMS
Explanation: A database is a collection of information that is organized so that it can be easily accessed, managed and updated.
Correct answer: Database system- A. Relational
- B. Hierarchical
- C. Network
- D. Relational Schema
Explanation: Correct answer is: Relational Relational database is a collection of data items organized as a set of formally described tables from which…
Correct answer: Relational- A. Data integrity
- B. Data Security
- C. Data independence
- D. All of them
Explanation: Correct answer is: All of them.These all are the advantages of DBMS over file processing systems.
Correct answer: All of them- A. Data integrity
- B. Data Security
- C. Data independence
- D. All of them
Explanation: Correct answer is: All of themThese all are the advantages of DBMS over file processing systems.
Correct answer: All of them- A. Data dictionary
- B. Data mining
- C. Structured query language
- D. Report generator
Explanation: A data dictionary, or metadata repository, is a "centralized repository of information about data such as meaning, relationships to other…
Correct answer: Data dictionary