Download DATABASE SYSTEMS QUESTIONS and more Study notes Database Programming in PDF only on Docsity!
DATABASE SYSTEM QUESTIONS.
1. What is a database?
A. A programming language B. A collection of related data C. A hardware device D. An operating system Answer: B
2. DBMS stands for:
A. Data Backup Management System B. Database Management System C. Data Binary Management Software D. Digital Base Management System Answer: B
3. Which of the following is an example of DBMS?
A. Windows B. MySQL C. Python D. Excel Answer: B
4. The main purpose of a DBMS is to:
A. Delete files B. Store and manage data C. Play media D. Design websites Answer: B
5. Data redundancy means:
A. Data is secure B. Data is duplicated unnecessarily C. Data is encrypted
D. Data is sorted Answer: B
6. A table in a database is also called:
A. Schema B. Tuple C. Relation D. Query Answer: C
7. A row in a table is called:
A. Attribute B. Record C. Field D. Domain Answer: B
8. A column in a table is called:
A. Tuple B. Record C. Attribute D. Key Answer: C
9. The unique identifier of a record is:
A. Foreign key B. Candidate key C. Primary key D. Composite key Answer: C
15. Which command removes records?
A. DELETE
B. REMOVE
C. CLEAR
D. ERASE
Answer: A
16. Which command removes a table permanently?
A. DELETE
B. DROP
C. ERASE
D. UPDATE
Answer: B
17. Which clause filters records?
A. WHERE
B. ORDER BY
C. GROUP BY
D. HAVING
Answer: A
18. Which clause sorts results?
A. SORT
B. ORDER BY
C. GROUP BY
D. FILTER
Answer: B
19. COUNT() function is used to:
A. Add values B. Multiply values C. Count rows
D. Delete rows Answer: C
20. Which symbol represents “all columns” in SQL?
A.
B. %
C. *
D. &
Answer: C
21. Normalization reduces:
A. Security B. Redundancy C. Queries D. Tables Answer: B
22. First Normal Form (1NF) removes:
A. Keys B. Duplicate tables C. Repeating groups D. Null values Answer: C
23. Second Normal Form requires:
A. 1NF only B. No partial dependency C. No transitive dependency D. No foreign keys Answer: B
29. A view is:
A. A real table B. A virtual table C. A key D. A record Answer: B
30. Which command creates a table?
A. MAKE
B. BUILD
C. CREATE
D. ADD
Answer: C
31. Which clause groups rows?
A. ORDER BY
B. GROUP BY
C. WHERE
D. SORT
Answer: B
32. HAVING clause is used with:
A. SELECT
B. GROUP BY
C. INSERT
D. DELETE
Answer: B
33. Index improves:
A. Storage B. Speed of retrieval C. Security
D. Redundancy Answer: B
34. Which model uses tables?
A. Hierarchical B. Network C. Relational D. Object Answer: C
35. A database schema defines:
A. Users B. Structure of database C. Queries D. Security Answer: B
36. Which language defines structure?
A. DML
B. DDL
C. DCL
D. TCL
Answer: B
37. Which language manipulates data?
A. DML
B. DDL
C. DCL
D. TCL
Answer: A
43. Durability means:
A. Data is temporary B. Data persists after commit C. Data is deleted D. Data is compressed Answer: B
44. Which join returns matching rows only?
A. LEFT JOIN
B. RIGHT JOIN
C. INNER JOIN
D. FULL JOIN
Answer: C
45. LEFT JOIN returns:
A. Only right table B. Only left table C. All left + matches D. No rows Answer: C
46. RIGHT JOIN returns:
A. All right + matches B. Only left C. Only matching D. None Answer: A
47. Backup is important for:
A. Security only B. Speed C. Data recovery
D. Formatting Answer: C
48. A composite key contains:
A. One field B. Two or more fields C. No fields D. Only foreign keys Answer: B
49. Metadata is:
A. Data about data B. Raw data C. Temporary data D. Duplicate data Answer: A
50. Which SQL statement changes table structure?
A. UPDATE
B. ALTER
C. INSERT
D. SELECT
Answer: B
