Search
Question: What is a key feature of Object-Oriented Databases?Options: Support for complex data types..
Question: Which of the following best describes a \'weak entity\' in an ER model?Options: An entity ..
Question: What is an object in Object-Oriented Data Modeling?Options: A table in a databaseAn instan..
Question: Which of the following is NOT a type of database concurrency control?Options: Pessimistic ..
Question: In the context of DBMS architecture, what is a \'data model\'?Options: A way to visualize ..
Question: In a multiuser database environment, what is the role of a DBMS?Options: To manage user in..
Question: Which of the following is a common method for implementing concurrency control?Options: Tw..
Question: Which of the following is a valid JDBC URL format for MySQL?Options: jdbc:mysql://localhos..
Question: What is the primary purpose of Java Server Pages (JSP)?Options: To create dynamic web cont..
Question: Which of the following is a component of DBMS architecture?Options: User InterfaceDatabase..
Question: Which of the following is NOT a component of a DBMS architecture?Options: Database engineU..
Question: What is the purpose of a primary key in a database?Options: To uniquely identify a recordT..
Question: What is the purpose of a foreign key in a database?Options: To uniquely identify a recordT..
Question: In an ER model, what does a solid line between two entities indicate?Options: A weak relat..
Question: What is the role of an attribute in an ER model?Options: To represent a relationshipTo def..
Question: Which of the following best describes a primary key?Options: A unique identifier for a rec..
Question: What is a business rule in the context of an ER model?Options: A guideline for database pe..
Question: What is the purpose of indexing in distributed databases?Options: To increase data redunda..
Question: Which of the following is NOT a characteristic of distributed databases?Options: Data is s..
Question: What is the role of a distributed transaction manager?Options: To manage data replicationT..
Question: In the context of distributed databases, what is \'eventual consistency\'?Options: All nod..
Question: What does the term \'horizontal partitioning\' refer to in distributed databases?Options: ..
Question: In a star schema, what type of table is the central fact table?Options: Dimension tableLoo..
Question: In SQL, which command is used to create a new table?Options: INSERTUPDATECREATEALTERCorrec..
Question: What is a key benefit of data warehousing for businesses?Options: Increased operational co..
Question: What is the role of a data mart in a data warehousing environment?Options: To store all en..
Question: Which of the following best describes a snowflake schema?Options: A denormalized structure..
Question: Which of the following is NOT a characteristic of a relational database?Options: Data is s..
Question: What is the purpose of an ER model?Options: To define the physical storage of dataTo provi..
Question: In an ER diagram, how is a primary key typically represented?Options: Underlined textBold ..