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 5 of 11
- A. Record
- B. Field
- C. Cell
- D. File
Explanation: The correct answer is A. Record.In a database, a record refers to a collection of related data fields that represents a single entity or…
Correct answer: Record- A. Record
- B. Field
- C. Cell
- D. File
Explanation: The answer is D. File.Here's why the other options are incorrect:A. Record: A record is a single entry in a database table containing a…
Correct answer: File- A. Report
- B. Letter
- C. Table
- D. Query
Explanation: The correct answer is (D) A Query.In database terminology, a query is a formal request for data from a database.
Correct answer: Query- A. Programs are independent of data format
- B. Reduces security and the control of data
- C. Increases duplication of data
- D. All of the above
Explanation: The correct answer is (D) All of the above.Database management systems (DBMS) offer several advantages over traditional file-based systems…
Correct answer: All of the above85. SQL stands for
- A. Structure Query Language
- B. Sort Query Language
- C. Self Query Language
- D. Seek Query Language
Explanation: The correct answer is (A) Structure Query Language.SQL is a standardized language used to manage relational databases.
Correct answer: Structure Query Language- A. Master file
- B. Transaction file
- C. Backup file
- D. Index sequential file
Explanation: The correct answer is (D) Index sequential file.Here's why the other options are considered file types from a usage point of view:(A)…
Correct answer: Index sequential file- A. Summarizing
- B. Sorting
- C. Classifying
- D. Data retrieval
Explanation: The answer is D. Data retrieval.Here's why the other options are incorrect:A.
Correct answer: Data retrieval- A. dat
- B. dbf
- C. wks
- D. mdb
Explanation: The correct answer is (D) .mdb.Here's why the other options are file extensions for database files:.dat is a generic data file extension…
Correct answer: mdb- A. Sequential files
- B. Direct or random files
- C. Indexed sequential files
- D. Master files
Explanation: The correct answer is C. Indexed sequential files.Indexed sequential files (ISAM) use an indexing technique to improve the speed of data…
Correct answer: Indexed sequential files- A. Query language
- B. Utilities
- C. Data dictionary
- D. Database Management System (DBMS}
Explanation: The answer is (D) Database Management System (DBMS).Here's why the other options are incorrect:A.
Correct answer: Database Management System (DBMS}- A. Network Model
- B. Hierarchical Model
- C. Relational Model
- D. Object Data Model
Explanation: The correct answer is (C) Relational Model.The relational model is a type of data model that stores data in tables (also called…
Correct answer: Relational Model- A. Data capturing
- B. Data manipulation
- C. Managing output results
- D. Data Analysis
Explanation: The answer is C. Managing output results.Here's why the other options are incorrect:A.
Correct answer: Managing output results- A. Object
- B. Information
- C. Data
- D. File
Explanation: The manipulated and processed form of data is called information.
Correct answer: Information- A. Phonebook
- B. Library catalog
- C. Student records
- D. All of the above
Explanation: A database is a collection of logically related data sets or files.All the above mentioned examples satisfy the Database requirements.
Correct answer: All of the above95. SQL stands for:
- A. Structured Query Language
- B. Sort Query Language
- C. Self Query Language
- D. Seek Query Language
Explanation: Correct answer is: Structured Query LanguageIt is a basic abbreviation.SQL is used to create databases.It is a structured programming…
Correct answer: Structured Query Language- A. Master File
- B. Backup File
- C. Transaction File
- D. Data File
Explanation: Backup is used to store a copy of important data in a database. The recovery process uses the data in backup if the original data is…
Correct answer: Backup File- A. Summarizing
- B. Sorting
- C. Classifying
- D. Data Capturing
Explanation: Correct answer is: sortingArranging items in a particular order or sequence.
Correct answer: Sorting- A. Sequential file
- B. Random file
- C. Indexed sequential file
- D. Direct acess file
Explanation: Sequential files require longer processing times compared to other types of files because they are accessed in a linear fashion, from…
Correct answer: Sequential file- A. Master file
- B. Transaction file
- C. Backup file
- D. Indexed sequential file
Explanation: Correct answer is: Index sequential fileA file organization method that combines sequential and random access by using an index to allow…
Correct answer: Indexed sequential file- A. Grand data
- B. Teradata
- C. Tieradata
- D. Meta data
Explanation: Metadata is "data that provides information about other data". In other words, it is "data about data." Many distinct types of metadata…
Correct answer: Meta data