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 8 of 11
- A. Stringent real-time requirements
- B. Complex relationships among data
- C. All of these
- D. Multiple users wish to access the data
Explanation: A query is a request for data or information from a database table or combination of tables.
Correct answer: All of these- A. Byte
- B. Record
- C. Character
- D. Field
Explanation: Correct answer is: RecordInformation is data that has been processed in such a way as to be meaningful to the person who receives it.
Correct answer: Record- A. Processing
- B. Calculation
- C. Data
- D. Information
Explanation: Correct answer: InformationThe past activities will be the data (raw facts and figures) while it can be converted into information after…
Correct answer: Information- A. Storing
- B. Reprographic
- C. Producing
- D. Reproduction
Explanation: Correct answer is: ReproductionIt is a basic definition.
Correct answer: Reproduction- A. .txt
- B. .eps
- C. .wav
- D. .mid
Explanation: Encapsulated Postscript file is an extension of vector image file and maybe helpful for you.
Correct answer: .eps- A. is no need of primary key data
- B. are explicit relationships among records
- C. is much more data independence than some other database models
- D. are tables with many dimensions
Explanation: Correct answer is: is much more data independence than some other database models.
Correct answer: is much more data independence than some other database models- A. RDBMS
- B. DBMS
- C. PDMS
- D. EBMS
Explanation: (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database.
Correct answer: DBMS- A. Less cost of conversion
- B. Minimum cost of conversion
- C. High cost of conversion
- D. Depends upon the change
Explanation: Correct answer is: High cost of conversion
Correct answer: High cost of conversion- A. DB system mature
- B. DB system immature
- C. DB system grow
- D. DB system obsolete
Explanation: By its very nature, a DBMS permits many users to have access to its database either individually or simultaneously.
Correct answer: DB system mature150. The internal data content of a company's databases needs to be documented in a consistent manner.
- A. Corporate data
- B. Data bank
- C. Data dictionary
- D. Database
Explanation: A data dictionary is a file or a set of files that contains a database's metadata.
Correct answer: Data dictionary- A. Roll no., Name
- B. Age, Date of birth
- C. Class, Marks
- D. Subject, Semester
Explanation: This information is redundant. If the student's date of birth is stored, their age can be easily calculated In conclusion, storing both a…
Correct answer: Age, Date of birth- A. Tuple
- B. Relation
- C. File
- D. Schema
Explanation: In a relational database, a table is also called a relation. A relation is a logical structure that stores data in a two-dimensional table…
Correct answer: Relation- A. Mutually exclusive
- B. Redundant Information
- C. Homonyms
- D. Synonyms
Explanation: Mutually exclusive attributes are those that cannot both be true for the same thing at the same time.
Correct answer: Mutually exclusive- A. Data correctness
- B. Data integrity
- C. Data redundancy
- D. Data independence
Explanation: Data integrity refers to the accuracy and consistency of data within a database.
Correct answer: Data integrity- A. Functional relation
- B. Attribute dependency
- C. Functional dependency
- D. Functional relation constraint
Explanation: A functional dependency is a constraint between two sets of attributes in a relation from a database.
Correct answer: Functional dependency- A. Non-key attribute
- B. Key attribute (*CORRECT)
- C. Primary attribute
- D. Sort key
Explanation: In Third Normal Form (3NF), a non-key attribute's value must be determined solely by the entire primary key, and not by any other non-key…
Correct answer: Key attribute (*CORRECT)- A. Integrity constraint
- B. Redundancy constraint
- C. Referential integrity constraint
- D. Entity integrity constraint
Explanation: A primary key constraint is a type of integrity constraint applied to a relational database table.
Correct answer: Integrity constraint- A. Insertion
- B. Deletion
- C. Modification
- D. All of the above
Explanation: An update anomaly occurs in a relational database when modifying data leads to inconsistencies.
Correct answer: Modification- A. Where it belongs
- B. Where it doesn't belong
- C. Where it originates
- D. Where it nearly belongs
Explanation: Where it originates refers to the most appropriate table or location within the database schema where the repeating attributes can be…
Correct answer: Where it originates160. In which normalization every non-key attribute must depend on the key and all parts of the key?
- A. 1NF
- B. 2NF
- C. 3NF
- D. 4NF
Explanation: Third Normal Form (3NF) is a level of database normalization that ensures minimal data redundancy by enforcing a specific dependency…
Correct answer: 3NF