Free Test Introduction to Databases – Databas...

Q1: What is a database?

A. A collection of related data B. A program to access data C. A type of hardware D. None of the above

Q2: Which of the following is a DBMS?

A. MySQL B. Microsoft Word C. Excel D. Notepad

Q3: The full form of SQL is?

A. Structured Query Language B. Simple Query Language C. Sequential Query Language D. Structured Question Language

Q4: Which language is used to define database schema?

A. DML B. DCL C. DDL D. TCL

Q5: Which operation is NOT part of CRUD?

A. Create B. Read C. Update D. Calculate

Q6: Which one is NOT a database model?

A. Hierarchical B. Network C. Relational D. Python

Q7: In a relational database, data is stored in?

A. Tables B. Files C. Indexes D. Pointers

Q8: A primary key is?

A. A unique identifier for a record B. A key to encrypt data C. A type of database user D. A foreign key

Q9: Which command is used to remove a table?

A. DROP B. DELETE C. REMOVE D. CLEAR

Q10: Which of the following is NOT a DML command?

A. INSERT B. UPDATE C. SELECT D. CREATE

Q11: What is data independence?

A. Ability to change schema without affecting application B. Ability to delete data easily C. Ability to access data quickly D. None of these

Q12: Which of the following ensures data integrity?

A. Constraints B. Indexes C. Triggers D. Views

Q13: Which is an example of a NoSQL database?

A. MongoDB B. Oracle C. MySQL D. SQL Server

Q14: What does ACID stand for in DBMS?

A. Atomicity, Consistency, Isolation, Durability B. Accuracy, Consistency, Integrity, Durability C. Atomicity, Consistency, Integrity, Data D. Atomicity, Control, Isolation, Data

Q15: A foreign key is?

A. A key used to link two tables B. A key to encrypt data C. A primary key D. A unique index

Q16: Which SQL statement is used to retrieve data?

A. SELECT B. GET C. RETRIEVE D. FETCH

Q17: What is normalization?

A. Process of organizing data to reduce redundancy B. Backing up data C. Increasing data D. Deleting data

Q18: Which of the following is a database constraint?

A. PRIMARY KEY B. FOREIGN KEY C. UNIQUE D. All of the above

Q19: Which of the following is a transaction property?

A. Atomicity B. Relational C. Distributed D. Hierarchical

Q20: Which of the following is a type of database user?

A. Database Administrator B. End User C. Application Programmer D. All of the above

Quiz for Introduction to Databases