Question : Which of the following best defines a database?
Solution :
Correct Answer : An organized collection of data for easy access and management
Description -
Question : What is the primary purpose of a database system?
Solution :
Correct Answer : To store, retrieve, and manage large amounts of data
Description -
Question : Which of the following is NOT a characteristic of a database?
Solution :
Correct Answer : Data cannot be modified once stored
Description -
Question : Which language is commonly used to operate and manage data in relational databases?
Solution :
Correct Answer : SQL
Description -
Question : Which of the following correctly differentiates a database from a manual file system?
Solution :
Correct Answer : Databases handle large data efficiently and reduce complexity
Description -
Question : Which of the following databases allows multiple parent-child relationships (many-to-many)?
Solution :
Correct Answer : Network Database
Description -
Question : In which type of database is data stored across multiple locations but appears as a single database to users?
Solution :
Correct Answer : Distributed Database
Description -
Question : Which type of database is best suited for handling large-scale unstructured data like JSON, images, and big data applications?
Solution :
Correct Answer : NoSQL Database
Description -
Question : Which database model organizes data in a tree-like structure with parent-child relationships?
Solution :
Correct Answer : Hierarchical Database
Description -
Question : Which type of database is designed to store data in the form of tables with rows and columns?
Solution :
Correct Answer : Relational Database
Description -
Question : Which of the following best describes a relation in RDBMS?
Solution :
Correct Answer : A table consisting of rows and columns
Description -
Question : Which of the following statements about a primary key is correct?
Solution :
Correct Answer : It uniquely identifies each row in a table
Description -
Question : In RDBMS, what is the degree of a relation?
Solution :
Correct Answer : Number of columns (attributes) in a table
Description -
Question : Which property ensures that no duplicate rows exist in a relation?
Solution :
Correct Answer : Entity Integrity
Description -
Question : Which of the following correctly defines cardinality in RDBMS?
Solution :
Correct Answer : Number of rows (tuples) in a table
Description -
Question : Why is 3-tier architecture preferred for large web applications?
Solution :
Correct Answer : It provides scalability and load balancing
Description -
Question : Which APIs are commonly used in 2-tier DBMS architecture for communication?
Solution :
Correct Answer : JDBC and ODBC
Description -
Question : Which of the following is a major advantage of 3-tier architecture over 2-tier architecture?
Solution :
Correct Answer : Improved security due to middle layer
Description -
Question : Which architecture is considered equivalent to basic client-server architecture?
Solution :
Correct Answer : 2-tier
Description -
Question : Which of the following statements best describes 1-tier DBMS architecture?
Solution :
Correct Answer : Database is directly accessible to the user without any network
Description -