Search
Question: What is the purpose of ETL in data warehousing?Options: Extract, Transform, LoadEvaluate, ..
Question: Which of the following is NOT a type of data warehouse architecture?Options: Single-tier a..
Question: What is the main advantage of using indexing in a data warehouse?Options: Increased data r..
Question: In a star schema, what do the fact tables represent?Options: Dimensions of the dataAggrega..
Question: Which of the following is a characteristic of a data warehouse?Options: Normalized data st..
Question: What is the primary purpose of a data warehouse?Options: To store operational dataTo suppo..
Question: What is the purpose of a data model in database design?Options: To define the physical sto..
Question: In a relational database, what is a foreign key?Options: A unique identifier for a recordA..
Question: Which of the following is NOT a property of transactions in a DBMS?Options: AtomicityConsi..
Question: What is a transaction in the context of a database management system?Options: A single SQL..
Question: What is the main advantage of using indexing in a database?Options: Increases data redunda..
Question: In an Entity-Relationship (ER) model, what does a diamond shape represent?Options: EntityA..
Question: What is the primary purpose of normalization in database design?Options: To increase data ..
Question: In an ER diagram, how is a multi-valued attribute represented?Options: As a rectangleAs an..
Question: What is the role of attributes in an ER model?Options: To define relationshipsTo provide a..
Question: Which of the following is NOT a type of relationship in an ER model?Options: One-to-OneOne..
Question: What does a primary key in an ER model signify?Options: A unique identifier for an entityA..
Question: Which of the following is a characteristic of a weak entity?Options: It can exist independ..
Question: What is the purpose of normalization in database design?Options: To increase redundancyTo ..
Question: What does an entity represent in an ER model?Options: A relationship between two tablesA r..
Question: What is denormalization?Options: The process of reducing redundancyThe process of increasi..
Question: In SQL, which clause is used to filter records after grouping?Options: WHEREHAVINGGROUP BY..
Question: What is the purpose of an API?Options: To create user interfacesTo connect different softw..
Question: Which of the following is a front-end framework?Options: DjangoFlaskReactSpringCorrect Ans..
Question: What does normalization aim to achieve?Options: Reduce data redundancyIncrease data integr..
Question: What is normalization?Options: The process of organizing dataThe process of backing up dat..
Question: Which SQL command is used to remove a table from a database?Options: DELETEDROPREMOVETRUNC..
Question: What is a foreign key?Options: A primary key in another tableA unique identifier for a tab..
Question: Which architecture is commonly used in a DBMS?Options: Two-Tier ArchitectureThree-Tier Arc..
Question: What is the main goal of concurrency control in a DBMS?Options: To prevent data redundancy..