50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.
0/50 answered0 correct
Question 1 of 50
A company requires that their database system be hosted on a service like Microsoft Azure or Amazon AWS. What type of database is most suitable for this?
Correct answer: B) Distributed database
Explanation: A cloud database is hosted and maintained on cloud services like Microsoft Azure or Amazon AWS, providing scalability and flexibility.
Question 2 of 50
What term refers to a situation where the same data is stored unnecessarily in different locations?
Correct answer: C) Data redundancy
Explanation: Data redundancy occurs when the same data is stored unnecessarily in multiple locations, leading to inefficiency.
Question 3 of 50
Which of the following best describes an "ad hoc query"?
Correct answer: C) A "spur-of-the-moment" question
Explanation: An ad hoc query is a spur-of-the-moment question or request made to retrieve specific data.
Question 4 of 50
Which type of database is typically focused on historical data and business metrics for decision-making?
Correct answer: B) Analytical database
Explanation: An analytical database stores historical data and business metrics used for tactical or strategic decision-making.
Question 5 of 50
Which of the following ensures that data remains accurate and consistent in a relational database?
Correct answer: D) Data integrity
Explanation: Data integrity ensures that data remains accurate and consistent by complying with entity and referential integrity constraints.
Question 6 of 50
What does the term "data independence" refer to?
Correct answer: A) Data is unaffected by changes in storage characteristics
Explanation: Data independence means that data access is unaffected by changes in the physical storage characteristics.
Question 7 of 50
What term is used to describe a collection of related data stored in a shared, integrated computer structure?
Correct answer: A) Database
Explanation: A database is a shared, integrated structure that houses related data, including end-user data and metadata.
Question 8 of 50
Which database component is responsible for storing metadata and data definitions?
Correct answer: B) Data dictionary
Explanation: A data dictionary is a DBMS component that stores metadata, data definitions, and their characteristics and relationships.
Question 9 of 50
In which type of relationship does one record in a table correspond to only one record in another table?
Correct answer: A) One-to-one (1:1)
Explanation: A one-to-one relationship exists when a single record in one table corresponds to only one record in another table.
Question 10 of 50
What is the primary role of a DBMS (Database Management System)?
Correct answer: C) Managing the database structure and controlling access to the data
Explanation: A DBMS manages the database structure and controls access to the data stored within the database.
Question 11 of 50
Which of the following describes an OLAP system?
Correct answer: B) A decision support system using multidimensional data analysis
Explanation: OLAP (Online Analytical Processing) provides decision support by using multidimensional data analysis.
Question 12 of 50
What is a key characteristic of a distributed database?
Correct answer: B) Data distributed across multiple sites
Explanation: A distributed database supports data storage across multiple sites, ensuring scalability and fault tolerance.
Question 13 of 50
Which of the following is a condition in which the database schema affects data access?
Correct answer: B) Data dependence
Explanation: Structural dependence means that changes to the database schema affect data access and require modifications to all access programs.
Question 14 of 50
What is the purpose of a primary key in a relational table?
Correct answer: C) It uniquely identifies each row in the table
Explanation: A primary key uniquely identifies each row in a relational table, ensuring that no two rows are identical.
Question 15 of 50
Which of the following is an example of a NoSQL database?
Correct answer: C) A database that stores structured and unstructured data
Explanation: NoSQL databases are designed to efficiently store both structured and unstructured data.
Question 16 of 50
Which of the following is the result of processing raw data?
Correct answer: A) Information
Explanation: Information is the result of processing raw data to reveal its meaning and support decision-making.
Question 17 of 50
Which type of key contains a unique value for every row in a relational table?
Correct answer: B) Primary key
Explanation: A primary key contains a unique value for every row in a relational table, ensuring that no duplicate rows exist.
Question 18 of 50
What term refers to a specific collection of logically related fields?
Correct answer: A) Record
Explanation: A record is a collection of logically related fields, representing a single entity or instance within a table.
Question 19 of 50
Which SQL clause is used to limit the rows returned by a query?
Correct answer: C) WHERE
Explanation: The WHERE clause is used to add conditional restrictions to a SQL query, limiting the rows returned.
Question 20 of 50
What does a relational database primarily use to relate data in different tables?
Correct answer: A) Foreign keys
Explanation: A foreign key in one table is used to relate data to a primary key in another table, establishing relationships between tables.
Question 21 of 50
What is the key characteristic of "structured data"?
Correct answer: B) It has been formatted to facilitate storage and information generation
Explanation: Structured data is formatted in a way that makes it easier to store and generate information from.
Question 22 of 50
Which database system function ensures that only authorized users can access specific data?
Correct answer: B) Security management
Explanation: Security management sets rules and restrictions on who can access and manage specific data within the database.
Question 23 of 50
What type of relationship exists when a single record in one table can be related to multiple records in another table?
Correct answer: B) One-to-many (1)
Explanation: A one-to-many relationship exists when a single record in one table can relate to multiple records in another table.
Question 24 of 50
In the context of data warehousing, what is a "data mart"?
Correct answer: A) A small, single-subject data warehouse subset
Explanation: A data mart is a smaller subset of a data warehouse focused on a specific subject or area.
Question 25 of 50
What is an entity in the context of databases?
Correct answer: C) A person, place, thing, concept, or event for which data can be stored
Explanation: An entity represents a real-world object for which data is stored in a database, such as a person or product.
Question 26 of 50
What is the process of transforming raw data into useful information called?
Correct answer: B) Data processing
Explanation: Data processing is the process of transforming raw data into meaningful information that supports decision-making.
Question 27 of 50
Which SQL command is used to add a new row of data to a table?
Correct answer: C) INSERT
Explanation: The INSERT command is used to add a new row of data into a table in a SQL database.
Question 28 of 50
Which attribute type can only have a single value for each entity occurrence?
Correct answer: C) Single-valued attribute
Explanation: A single-valued attribute can only have one value for each entity occurrence, such as an SSN or customer ID.
Question 29 of 50
Which type of query involves a question issued by the end user of a database using SQL?
Correct answer: D) Ad hoc query
Explanation: An ad hoc query is a spur-of-the-moment request issued by the end user of a database, often using SQL.
Question 30 of 50
Which SQL command permanently removes data from a table?
Correct answer: A) DELETE
Explanation: The DELETE command permanently removes data rows from a table.
Question 31 of 50
What kind of relationship describes a connection between three entities?
Correct answer: C) Ternary relationship
Explanation: A ternary relationship involves an association between three entities in a database.
Question 32 of 50
Which type of key is used strictly for data retrieval purposes?
Correct answer: B) Secondary key
Explanation: A secondary key is used strictly for data retrieval purposes and does not necessarily have to be unique.
Question 33 of 50
What term describes the collection of programs that manages a relational database?
Correct answer: B) RDBMS
Explanation: A relational database management system (RDBMS) is the collection of programs that manages relational databases.
Question 34 of 50
Which of the following best describes the term "data anomaly"?
Correct answer: A) An inconsistency in data caused by redundancy
Explanation: A data anomaly occurs when inconsistent changes have been made to redundant data in a database.
Question 35 of 50
Which database management system allows users to manage data using objects, inheritance, and classes?
Correct answer: B) Object-oriented DBMS
Explanation: An object-oriented DBMS allows users to manage data using objects, inheritance, and classes, typical of an object-oriented data model.
Question 36 of 50
Which of the following is a representation of a relational database's entities, attributes, and relationships?
Correct answer: A) ER model
Explanation: The entity relationship (ER) model represents the entities, attributes, and relationships within a database.
Question 37 of 50
Which SQL command is used to modify the structure of an existing table?
Correct answer: A) ALTER TABLE
Explanation: The ALTER TABLE command allows users to modify the structure of an existing table by adding or changing columns.
Question 38 of 50
What type of attribute can be subdivided into additional attributes?
Correct answer: C) Composite attribute
Explanation: A composite attribute can be subdivided into additional attributes, such as an address divided into street, city, and postal code.
Question 39 of 50
In a star schema, what type of tables are used to classify or filter facts?
Correct answer: B) Dimension tables
Explanation: Dimension tables in a star schema are used to classify, search, or filter facts in a data warehouse.
Question 40 of 50
What is a NoSQL database primarily designed to handle?
Correct answer: C) Structured and unstructured data
Explanation: NoSQL databases are designed to handle both structured and unstructured data in various formats.
Question 41 of 50
Which SQL clause groups rows that share the same values in specified columns?
Correct answer: C) GROUP BY
Explanation: The GROUP BY clause groups rows that share the same values in specified columns, often used with aggregate functions.
Question 42 of 50
What does the term "atomicity" refer to in database transactions?
Correct answer: B) All parts of a transaction must be completed or the entire transaction is aborted
Explanation: Atomicity ensures that all parts of a database transaction are treated as a single, indivisible unit.
Question 43 of 50
Which SQL command undoes changes made to a database since the last commit?
Correct answer: C) ROLLBACK
Explanation: The ROLLBACK command undoes changes made to a database since the last COMMIT statement.
Question 44 of 50
What is a key feature of a hierarchical database model?
Correct answer: B) Data organized in an upside-down tree structure
Explanation: A hierarchical database organizes data in an upside-down tree structure, with a one-to-many relationship between segments.
Question 45 of 50
Which of the following is an advantage of denormalization?
Correct answer: B) Improves query performance by reducing joins
Explanation: Denormalization improves query performance by reducing the need for joins, though it may increase data redundancy.
Question 46 of 50
Which SQL clause is used to filter rows after an aggregation is applied using GROUP BY?
Correct answer: B) HAVING
Explanation: The HAVING clause filters rows after an aggregation is applied using GROUP BY, typically based on aggregate conditions.
Question 47 of 50
Which entity type cannot exist without another related entity?
Correct answer: B) Weak entity
Explanation: A weak entity is existence-dependent and cannot exist without another related entity, typically inheriting the primary key of the related entity.
Question 48 of 50
What term describes an attribute that does not physically exist within the entity but can be derived?
Correct answer: C) Derived attribute
Explanation: A derived attribute does not physically exist within the entity and is calculated or derived from other attributes.
Question 49 of 50
What is the purpose of a composite entity?
Correct answer: B) To transform an M relationship into two 1 relationships
Explanation: A composite entity is used to transform a many-to-many (M) relationship into two one-to-many (1) relationships in database design.
Question 50 of 50
What does the term "functional dependence" refer to?
Correct answer: A) One attribute determines another
Explanation: Functional dependence refers to a situation where one attribute determines the value of another attribute in a relational table.
Set 1 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).