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 6 of 11
- A. Database administrators
- B. Separate file
- C. Database
- D. Users
Explanation: Separate files is a module in file processing system while in Database data is gathered in the form of tables.
Correct answer: Separate file102. DBMS stands for
- A. Database management system
- B. Database model system
- C. Distant base model system
- D. Digital bus model system
Explanation: Correct answer is: Database Management System The Database management system is a collection of programs, which are used for sorting and…
Correct answer: Database management system- A. 2
- B. 3
- C. 4
- D. 5
Explanation: Correct answer is: 2A data model is a logic organization of the real-world objects(entities), constraints on them, and the relationships…
Correct answer: 2- A. Network data model
- B. Data Hierarchical Model
- C. Data relational model
- D. Object data model
Explanation: The relational data model is generally considered more flexible than the hierarchical and network data models.
Correct answer: Data relational model- A. Record
- B. Field
- C. Cell
- D. File
Explanation: A file is a collection of records. For example, a telephone book is analogous to a file.
Correct answer: File- A. Person
- B. Product
- C. Event
- D. All of above
Explanation: Correct answer is: All of AboveA record in a database is a collection of related data items treated as a single until Here all the options…
Correct answer: All of above- A. Data capturing
- B. Data manipulation
- C. Managing output results
- D. Analvsis
Explanation: Correct answer is:Managing output resultsA file that is used to store input data before processing is called a transaction file.
Correct answer: Managing output results- A. Executable file
- B. Transaction file
- C. Dynamic link library file
- D. Data file
Explanation: Transaction file is typically considered a temporary file. It contains records of individual transactions or events that occur within a…
Correct answer: Transaction file- A. Good data
- B. Data integrity
- C. Data redundancy
- D. Data anomaly
Explanation: Data integrity is the maintenance of and the assurance of the accuracy and consistency of data over its entire life-cycle, and is a…
Correct answer: Data integrity- A. File
- B. Field
- C. Record
- D. Database
Explanation: Correct answer is: Record A collection of related fields treated as a single unit is known as record.
Correct answer: Record- A. Table
- B. Record
- C. Field
- D. Query
Explanation: Correct answer is: Record A collection of related data items treated as a single unit in a database.
Correct answer: Record- A. File
- B. Record
- C. Field
- D. All of above
Explanation: Correct answer is: Field A logical group of characters is often referred to as a field in the context of databases or data structure..
Correct answer: Field- A. Select
- B. Point
- C. Projection
- D. Union
Explanation: The "Projection" operation in relational algebra is used to extract a subset of columns (attributes) from a relation, effectively reducing…
Correct answer: Projection- A. File
- B. Record
- C. Field
- D. Database
Explanation: Correct answer is: file A collection of related records is called a data set or file a logical group of characters is often referred to as…
Correct answer: File- A. Direct file
- B. Program file
- C. Data file
- D. Index sequential file
Explanation: Correct answer is: DIrect FilesRandom or direct file organization. Records are stored randomly but accessed directly.
Correct answer: Direct file- A. Data capturing
- B. Data manipulation
- C. Managing output
- D. All of above
Explanation: The process of manipulating data to achieve the required objectives and results is called processing .
Correct answer: Data manipulation- A. storing and retrieval
- B. communication
- C. reproduction
- D. all of the above
Explanation: It is basic concept. After the data has been captured and manipulated. It can be stored, retrieved, reproduced and communicated as well.
Correct answer: all of the above- A. contents
- B. structure
- C. both a and b
- D. file type
Explanation: Although it is not compulsory yet most of the times all records in the file have the same structures.
Correct answer: structure- A. file
- B. field
- C. tuple
- D. all of the above
Explanation: A field in a record is a specific piece of data within that record, corresponding to a particular attribute or characteristic of the…
Correct answer: field- A. data are files
- B. a column is to a row
- C. files are to table
- D. attributes are to column
Explanation: Data is written to files by serializing it into a format like text or binary, organized according to the file's structure, using file…
Correct answer: data are files