Author name: Umar Draz

educationist

In a relational database, a row is also known as a:

A. Attribute

B. Tuple

C. Field

D. Relation

Correct answer is: B. Tuple

SQL stands for:

A. Simple Query Language

B. Structured Query Language

C. Standard Query Logic

D. Sequential Query List

Correct answer is: B. Structured Query Language

Which key uniquely identifies a record in a table?

A. Foreign Key

B. Primary Key

C. Candidate Key

D. Super Key

Correct answer is: B. Primary Key

Which SQL command is used to delete all records from a table without deleting the table structure?

A. DROP

B. TRUNCATE

C. DELETE

D. REMOVE

Correct answer is: B. TRUNCATE

The ‘ACID’ property in DBMS stands for Atomicity, Consistency, Isolation, and:

A. Data

B. Durability

C. Database

D. Degree

Correct answer is: B. Durability

Which of the following is a NoSQL database?

A. MySQL

B. Oracle

C. MongoDB

D. PostgreSQL

Correct answer is: C. MongoDB

A ‘Join’ operation in SQL combines:

A. Columns

B. Rows from two or more tables

C. Databases

D. Files

Correct answer is: B. Rows from two or more tables

Normalization is used to:

A. Increase Speed

B. Reduce Data Redundancy

C. Encrypt Data

D. Backup Data

Correct answer is: B. Reduce Data Redundancy

Which level of database abstraction describes how data is stored?

A. View Level

B. Logical Level

C. Physical Level

D. User Level

Correct answer is: C. Physical Level

What is a “Deadlock” in DBMS?

A. Data corruption

B. Processes blocking each other

C. Server crash

D. Network lag

Correct answer is: B. Processes blocking each other