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 4 of 11
- A. Table
- B. Report
- C. Query
- D. Form
Explanation: The CREATE command is used in SQL (Structured Query Language) to create database objects, and one of the most fundamental objects is a…
Correct answer: Table- A. Logical design
- B. Physical design
- C. Analysis
- D. Implementation
Explanation: Physical design deals with how the data will be physically stored and accessed on the storage media.
Correct answer: Physical design63. Which technique is used for physically arranging the records of a file on secondary storage devices
- A. Indexes
- B. File organization
- C. Integrity constraints
- D. Implementation
Explanation: File organization is a technique for physically arranging records of a file on a secondary storage device like a hard disk or solid-state…
Correct answer: File organization- A. Critical fragments
- B. Non-critical fragments
- C. Critical and non-critical fragments
- D. Only large fragments
Explanation: These are fragments that are essential for the operation of the system or specific applications.
Correct answer: Critical fragments- A. Table
- B. Relation
- C. Row
- D. Field
Explanation: In a Relational Database Management System (RDBMS), an attribute is also known as a field.
Correct answer: Field- A. Entity
- B. Attribute
- C. Identifier
- D. Relationship
Explanation: In a database, a relationship is an association between two or more entities.
Correct answer: Relationship- A. File
- B. Tuple
- C. Relation
- D. Attribute
Explanation: In the context of relational databases, a relation refers to a two-dimensional table that holds data according to a specific structure.
Correct answer: Relation- A. Data independence
- B. Data integration
- C. Data integrity
- D. Data model
Explanation: Data integrity refers to the overall accuracy, completeness, and consistency of data over its entire lifecycle.
Correct answer: Data integrity- A. Object-oriented data
- B. Network data model
- C. Implementation
- D. Hermetic model
Explanation: A network data model is one type of logical data model that allows for more complex relationships between entities compared to the…
Correct answer: Network data model- A. Foreign key
- B. Composite Key
- C. Multi Value Key
- D. Compound Key
Explanation: A primary key that consists of two or more attributes is known as a composite key.
Correct answer: Composite Key- A. Contents
- B. Structure
- C. Data
- D. File type
Explanation: The correct answer is B. Structure.File Structure refers to the way data is organized within a file.
Correct answer: Structure- A. System overhead
- B. Training of staff
- C. Need of data dictionary
- D. All of these
Explanation: Here are the options, along with explanations for why each option is correct:(A) System overhead - This is correct.
Correct answer: System overhead- A. Network data model
- B. Hierarchical data model
- C. Relational data model
- D. Object-oriented data model
Explanation: The most flexible data model among the choices is:C. Relational data modelHere's why relational data models are considered more…
Correct answer: Relational data model- A. Hierarchical
- B. Network
- C. Relational
- D. Object-oriented
Explanation: The answer is A. Hierarchical.Hierarchical database models organize data in a tree-like structure, where each record (except the root) has…
Correct answer: Hierarchical- A. Logically
- B. Physically
- C. Loosely
- D. Badly
Explanation: Here are the options, along with explanations for why each option is correct or incorrect:(A) Logically - This is the correct answer.
Correct answer: Logically- A. Sequential file
- B. Random file
- C. Indexed sequential file
- D. Direct access file
Explanation: Answer: C. Indexed sequential fileIndexed sequential files typically require the longest processing time among the listed options.
Correct answer: Indexed sequential file- A. Files
- B. Data
- C. Data Processing
- D. Information
Explanation: The answer is B. Data.Here's why the other options are incorrect:A. Files: Files are collections of data stored on a computer system, but…
Correct answer: Data- A. Network data model
- B. Object data model
- C. Relational data model
- D. Hierarchical data model
Explanation: The correct answer is C. Relational data model.Relational data models store data in two-dimensional tables with rows and columns.
Correct answer: Relational data model- A. Data integrity
- B. Data security
- C. Data independence
- D. All of the above
Explanation: The correct answer is D. All of the above.A Database Management System (DBMS) plays a crucial role in managing data effectively.
Correct answer: All of the above- A. Hardware
- B. Software
- C. Data
- D. All of these
Explanation: The correct answer is (D) All of these.A Database Management System (DBMS) relies on all three of these components to function:Hardware…
Correct answer: All of these