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 2 of 11
- A. Sort Key
- B. Foreign Key
- C. Composite Key
- D. Primary Key
Explanation: Every relation (table) in a relational database must have a primary key.
Correct answer: Primary Key- A. View
- B. Table
- C. Relations
- D. Tuple
Explanation: A view is a virtual table in a database that is based on a SQL query. It acts like a regular table, allowing users to query and retrieve…
Correct answer: View- A. Table
- B. Tupple
- C. Relation
- D. Attribute
Explanation: A two-dimensional array of data that contains descriptive information about an entity is known as table or relation
Correct answer: Table- A. Person
- B. Object
- C. Action
- D. Concept
Explanation: An entity is a thing about which information is stored in the database.
Correct answer: Action- A. Table
- B. Record
- C. Field
- D. Cell
Explanation: A set of related characters that represent a unit of data is called a field.
Correct answer: Field- A. Table
- B. Relation
- C. Row
- D. Field
Explanation: The named columns of the relation are called attributes
Correct answer: Field- A. One
- B. At least one but not more than two
- C. Between 1 and 5
- D. No limit
Explanation: The attribute or combination of attributes that uniquely identifies a row or record in a relation is known as the primary key.
Correct answer: One- A. Candidate Key
- B. Sub Key
- C. Super key
- D. Foreign key
Explanation: A super key is any set of one or more attributes that can uniquely identify a record in a table.
Correct answer: Super key- A. Candidate Key
- B. Foreign key
- C. Primary Key
- D. Secondary Key
Explanation: A secondary key is made on a field that you would like to be indexed for faster searches A table can have more than one secondary key.
Correct answer: Secondary Key- A. Modality of relation
- B. Cardinality of relation
- C. Degree of Relation
- D. None of these
Explanation: The degree of a relation refers to the number of participating entities in a relationship.
Correct answer: Degree of Relation- A. The candidate key
- B. Primary key
- C. Foreign key
- D. Sort key
Explanation: A candidate key is a combination of attributes that can be uniquely used to identify = database record without referring to any other…
Correct answer: The candidate key- A. Query
- B. Table
- C. Form
- D. Report
Explanation: A two-dimensional array of data that contains descriptive information about an entity is known as table or relation
Correct answer: Table- A. Sort Key
- B. Secondary Key
- C. Primary Key
- D. Control Key
Explanation: The answer to the question is (c) Primary Key.The primary key is a special attribute (or set of attributes) that uniquely identifies each…
Correct answer: Primary Key- A. DBMS
- B. FMS
- C. Logical design
- D. Physical design
Explanation: A file management system is a type of software that manages data files in a computer system.
Correct answer: FMS- A. File
- B. Field
- C. Record
- D. Row
Explanation: A collection of related records as a single unit is called a file.
Correct answer: File- A. File = Column
- B. Field = Row
- C. Record = Occurrence
- D. Record = Table
Explanation: • Record: A record in a database table represents a single instance of an entity.
Correct answer: Record = Occurrence- A. Attribute
- B. Entity
- C. Tuple
- D. Field
Explanation: In the context of databases, a tuple is a single row of data in a table.
Correct answer: Tuple- A. Database administrator
- B. Data administrator
- C. The end user
- D. System analyst
Explanation: A Database Administrator is responsible for the design, implementation, operation, management and maintenance of database.
Correct answer: Database administrator- A. Attribute
- B. Data Item
- C. Record
- D. Tuple
Explanation: The named columns of the relation are called attributes.
Correct answer: Attribute40. It is made upto rows and columns and may display information that is restricted to a part of table
- A. Index
- B. Query
- C. Report
- D. View
Explanation: A database view is a searchable object in a database that is defined by a query.
Correct answer: View