- 1. Database management involves the design, implementation, and maintenance of database systems to efficiently store and retrieve data. It includes tasks such as defining database structures, organizing data, ensuring data integrity, and optimizing database performance. Database management also encompasses security measures to protect data from unauthorized access or corruption. Effective database management is crucial for businesses to make informed decisions, streamline operations, and enhance customer experiences.
Which language is commonly used to query databases?
A) C++
B) SQL
C) Python
D) Java
- 2. What does CRUD stand for in database management?
A) Copy, Read, Upload, Display
B) Create, Read, Update, Delete
C) Connect, Retrieve, Utilize, Delete
D) Calculate, Rearrange, Update, Delete
- 3. What is normalization in database design?
A) Scrambling data for security
B) Adding duplicate records for safety
C) Deleting unnecessary data
D) Organizing data to minimize redundancy
- 4. What type of relationship exists between two tables when one record in the first table can have many related records in the second table?
A) None of the above
B) One-to-Many
C) Many-to-Many
D) One-to-One
- 5. Which of the following is a NoSQL database?
A) Oracle
B) MongoDB
C) MySQL
D) PostgreSQL
- 6. Which command is used to remove a table from a database?
A) ERASE TABLE
B) DELETE TABLE
C) DROP TABLE
D) REMOVE TABLE
- 7. Which statement is used to retrieve data from a database?
A) SELECT
B) SEARCH
C) FETCH
D) RETRIEVE
- 8. What is the purpose of an index in a database?
A) To slow down data retrieval
B) To limit data access
C) To confuse the database engine
D) To speed up data retrieval
- 9. Which type of join returns all records when there is a match in both tables?
A) LEFT JOIN
B) RIGHT JOIN
C) OUTER JOIN
D) INNER JOIN
- 10. What is data integrity in database management?
A) The accuracy, consistency, and reliability of data stored in a database
B) The size of the database
C) The speed of data retrieval
D) The structure of the data
- 11. Which command is used to change the structure of a table in a database?
A) CHANGE TABLE
B) MODIFY TABLE
C) ALTER TABLE
D) RESTRUCTURE TABLE
- 12. Which SQL clause is used to group rows based on a specified condition?
A) GROUP BY
B) FILTER
C) HAVING
D) ORDER BY
- 13. Which database model allows for objects to be stored as collections of attributes and methods?
A) Hierarchical
B) Relational
C) Object-oriented
D) Network
- 14. Which type of database relationship requires a linking table?
A) Many-to-One
B) One-to-One
C) One-to-Many
D) Many-to-Many
- 15. What does the term 'relational database' refer to?
A) A type of database that stores and provides access to data points that are related to one another
B) A database without any relationships
C) A database used by multiple organizations
D) A database that stores only text data
- 16. Which statement is used to enforce referential integrity in a database?
A) UNIQUE
B) FOREIGN KEY
C) PRIMARY KEY
D) CHECK
- 17. Which SQL statement is used to insert new data into a database?
A) SELECT *
B) UPDATE
C) INSERT INTO
D) CREATE TABLE
- 18. What is denormalization in database design?
A) Organizing data logically
B) Intentionally adding redundancy to improve performance
C) Removing unnecessary data
D) Encrypting all data
- 19. Which type of database model allows for flexible and scalable data storage without fixed table schema?
A) Relational
B) Hierarchical
C) NoSQL
D) Object-oriented
- 20. Which command is used to query data from multiple tables in a database?
A) COMBINE
B) JOIN
C) LINK
D) MERGE
- 21. What does SQL stand for?
A) Standardized Query Language
B) System Query Logic
C) Software Query Library
D) Structured Query Language
- 22. What does the term 'OLAP' stand for in database management?
A) Object-Oriented Language Adaptation Protocol
B) Offline Automated Processing
C) Optimized Local Access Protocol
D) Online Analytical Processing
- 23. What is a backup in database management?
A) A copy of data that can be restored in case of data loss
B) A report of database activities
C) Data sent to a remote location
D) A separate database
- 24. Which database model represents data as connections or relationships between different entities?
A) NoSQL
B) Network
C) Relational
D) Hierarchical
- 25. Which SQL clause is used to filter records in a SELECT statement based on a specified condition?
A) ORDER BY
B) HAVING
C) GROUP BY
D) WHERE
- 26. Which database model uses tables to store data and relationships between those tables?
A) Hierarchical
B) Relational
C) Object-oriented
D) NoSQL
- 27. Which database management system is open-source and commonly used for web applications?
A) MySQL
B) Microsoft SQL Server
C) IBM Db2
D) Oracle Database
- 28. Which SQL function is used to calculate the total number of rows that match a specific condition?
A) AVG
B) COUNT
C) SUM
D) MAX
- 29. Which type of database model uses a tree-like structure with parent-child relationships?
A) Network model
B) NoSQL model
C) Hierarchical model
D) Relational model
|