🔹 1
DBMS stands for:
A. Data Backup Management System
B. Database Management System
C. Data Binary Management System
D. Database Monitoring System
👉 Answer: B
🔹 2
A database is:
A. Collection of programs
B. Collection of data
C. Collection of hardware
D. Collection of networks
👉 Answer: B
🔹 3
Which of the following is NOT a DBMS?
A. MySQL
B. Oracle
C. Windows
D. SQL Server
👉 Answer: C
🔹 4
Which language is used in DBMS?
A. HTML
B. SQL
C. C++
D. Python
👉 Answer: B
🔹 5
Which of the following is a relational DBMS?
A. MySQL
B. Excel
C. Notepad
D. Paint
👉 Answer: A
🔹 6
A table in DBMS is also called:
A. Record
B. Relation
C. Field
D. Tuple
👉 Answer: B
🔹 7
A row in a table is called:
A. Attribute
B. Field
C. Tuple
D. Column
👉 Answer: C
🔹 8
A column in a table is called:
A. Tuple
B. Record
C. Attribute
D. Key
👉 Answer: C
🔹 9
Which key uniquely identifies a record?
A. Foreign Key
B. Primary Key
C. Candidate Key
D. Composite Key
👉 Answer: B
🔹 10
A key that can uniquely identify records is:
A. Candidate Key
B. Foreign Key
C. Super Key
D. All of these
👉 Answer: D
🔹 11
Foreign key is used to:
A. Identify record
B. Link tables
C. Delete data
D. Sort data
👉 Answer: B
🔹 12
Which of the following is not a type of key?
A. Primary
B. Foreign
C. Secondary
D. Candidate
👉 Answer: C
🔹 13
Which normal form removes partial dependency?
A. 1NF
B. 2NF
C. 3NF
D. BCNF
👉 Answer: B
🔹 14
Which normal form removes transitive dependency?
A. 1NF
B. 2NF
C. 3NF
D. 4NF
👉 Answer: C
🔹 15
Which normal form ensures atomic values?
A. 1NF
B. 2NF
C. 3NF
D. BCNF
👉 Answer: A
🔹 16
Which operation is used to retrieve data?
A. INSERT
B. DELETE
C. SELECT
D. UPDATE
👉 Answer: C
🔹 17
Which command removes table completely?
A. DELETE
B. DROP
C. REMOVE
D. ERASE
👉 Answer: B
🔹 18
Which command removes records?
A. DROP
B. DELETE
C. CREATE
D. ALTER
👉 Answer: B
🔹 19
Which command modifies table structure?
A. UPDATE
B. ALTER
C. SELECT
D. DELETE
👉 Answer: B
🔹 20
Which command creates table?
A. CREATE
B. INSERT
C. UPDATE
D. DELETE
👉 Answer: A
🔹 21
Which clause is used to filter records?
A. WHERE
B. SELECT
C. GROUP
D. ORDER
👉 Answer: A
🔹 22
Which clause is used for sorting?
A. WHERE
B. ORDER BY
C. GROUP BY
D. HAVING
👉 Answer: B
🔹 23
Which clause groups rows?
A. GROUP BY
B. ORDER BY
C. WHERE
D. SELECT
👉 Answer: A
🔹 24
Which clause filters grouped data?
A. WHERE
B. HAVING
C. SELECT
D. ORDER
👉 Answer: B
🔹 25
Which function counts rows?
A. SUM()
B. AVG()
C. COUNT()
D. MAX()
👉 Answer: C
🔹 26
Which function finds maximum value?
A. MAX()
B. MIN()
C. SUM()
D. AVG()
👉 Answer: A
🔹 27
Which function finds average?
A. SUM()
B. COUNT()
C. AVG()
D. MAX()
👉 Answer: C
🔹 28
Which JOIN returns matching records?
A. LEFT JOIN
B. RIGHT JOIN
C. INNER JOIN
D. FULL JOIN
👉 Answer: C
🔹 29
Which JOIN returns all from left table?
A. INNER
B. LEFT
C. RIGHT
D. FULL
👉 Answer: B
🔹 30
Which JOIN returns all records from both tables?
A. INNER
B. LEFT
C. RIGHT
D. FULL
👉 Answer: D
0 Komentar