Database Systems Practice Test

These questions are part of the practice quiz. Start practicing

• What does time variant imply for a data warehouse?
• Which component enables data input and retrieval for end users?
• Which clause eliminates duplicate values from the result set?
• Concatenating Strings means combining strings together
• What is the purpose of the recovery log in a database system?
• What does the Delete Restrict rule prevent?
• Which function creates a date or time value from components?
• Which term best describes the process of combining analytically useful data from multiple operational databases into a single data warehouse?
• Which term describes the degree to which all required data is present in the data collection?
• Which of the following can be managed with ALTER TABLE according to the described capabilities?
• Which term is the information scrambling algorithm?
• What is operational information?
• Which component is used to develop front-end interfaces?
• What does a Unique Constraint enforce?
• What does Uniqueness guarantee in data modeling?
• Which of the following describes what DDL statements can do?
• Which of the following is an example of a Data Manipulation Language statement?
• Data governance is best described as which of the following?
• What does UNION do?
• Which set operations are used to combine results of two SELECT statements that are union compatible?
• Having: if you want to use a filter that contains an aggregate function, you can't use WHERE.
• Which function converts the entire string to proper case (first letter of each word uppercase)?
• A data warehouse may contain data at the first level of detail and summarized data. Which statement describes this capability?
• Which constraint allows enforcing rules such as minimum, maximum, or a specific value range?
• Which of the following operations is explicitly listed as being supported by ALTER TABLE?
• Between: which operator checks for values within a range?
• Which statement best describes a data warehouse?
• Which of the following is an example of a Data Control Language statement?
• Which component of a DBMS is responsible for evaluating different query execution strategies and selecting the best one?
• What does a commit operation do in a database?
• Which term refers to actions taken to preclude data quality problems?
• IN is equivalent to multiple OR statements
• Which term describes the storage of a view as a table on disk?
• Which option describes Update Set-to-Null?
• Which statement best describes the Not Null constraint in SQL?
• Which construct groups rows and provides a single value for each group in SQL?
• Which component is used to develop front-end applications?
• Which operation is NOT performed by the ALTER TABLE statement?
• What does Uniqueness ensure in a data collection?
• What does enterprise wide mean in the context of data warehousing?
• Which SQL sublanguage is used to insert, update, delete, and retrieve data?
• Which feature allows guiding the optimizer to prefer certain plans without changing the SQL text?
• Which term denotes a point in the log where pending changes are guaranteed to be written to disk?
• What does EXCEPT do?
• Which statement about data governance roles is true?
• Which statement describes Update Cascade?
• Which function is typically used to obtain the leftmost five characters of a string?
• Which function adds the values in a column?
• Which term implements the access privileges provided by the DBMS but managed by the DBA?
• Which of the following functions extracts a date component?
• What does the LIMIT clause do in a query?
• Which concept allows you to combine data from two relational tables for additional insights?
• Trim removes trailing and leading blank spaces
• Which term describes the privileges assigned to a database user?
• Which term saves additional physical copies of the data?
• NOT NULL is categorized as which type of constraint?
• Which statement describes Delete Cascade?
• Which term describes data following the specified structure or format?
• Which function returns the rightmost n characters of a string?
• Which function returns the number of characters in a string?
• Which statement describes an inner join?
• What are the three V's commonly associated with Big Data?
• Which role is responsible for the proper use of the data in a database?
• Which join type returns all rows from the left table, even if there are no matches in the right table?
• To group timestamps by a fixed interval, you would use which function?
• MapReduce is best described as which of the following?
• What is the basic building block of a data query that pulls data from a table?
• NOT can negate IN, Between, LIKE or conditional statement
• Which description matches Update Restrict?
• What does query optimization involve?
• Date_Part: pulls out a specific date part from a date.
• CAST changes the data type of a column in the query
• Which function returns the difference between two date/time values?
• Which statement describes the purpose of the WHERE clause?
• What best summarizes the role of a data warehouse in an organization?
• Which term describes the degree to which data is aligned with the proper time window in its real-world representation?
• Which function returns the position of a substring within a string?
• Which function returns the current date and time?
• Which term scrambles data so that information becomes unreadable unless someone has an encryption key?
• Which term refers to the data dictionary created by the DBMS?
• Data governance formalizes which of the following?
• Group By returns a single value for each value in the column(s) specified in the ____ clause.
• Which term describes data that supports routine operations, not analytics?
• Which constraint guarantees uniqueness and non-null values for a set of columns?
• What is the primary purpose of a data warehouse?
• Enterprise Resource Planning stands for what, and how is it best described?
• Which join type returns all rows from the first table and pairs with every row of the second table?
• Which join type selects all rows from both tables as long as there is a match between the columns in both tables?
• Which term refers to the fundamental difference in the purpose of an operational database system and a data warehouse?
• Which function returns the number of unique columns in an array?
• What is described by rollback?
• Which concept best describes the cost associated with a query’s execution, used by the optimizer to compare plans?
• Which statement best describes a left join?
• Which function returns the number of times a column appears?
• Which operator is the case-insensitive version of LIKE?
• NOT: which operator negates a set of conditions in a WHERE clause?
• Extract: same as date_part.
• Which approach uses a single central copy of the master data for all operational information systems?
• Which statement describes Delete Set-to-Default?
• Which function truncates date/time to a specified interval?
• Which SQL component is used for managing database transactions?
• Which SQL sublanguage is used for data access control?
• Which term refers to how well data adheres to a defined format or schema?
• What is a subquery?
• What does INTERSECT do?
• Which term best describes data being aligned with the appropriate time period?
• Which function returns the maximum value in a column?
• Which constraint enforces value rules such as minimum, maximum, or a specified set of values?
• Which statement defines an Index?
• Which statement about the LIKE operator is true?
• Which term describes a data governance initiative that ensures consistency of key data across the organization?
• Which function returns the starting position of a substring within a string?
• Which element is primarily used to input new records into the database and retrieve them?
• Which join type selects all rows from both tables even if there is no match?
• Which term refers to databases that are not solely based on the relational model?
• What is a nested subquery?
• What is a query hint used for?
• Which term reverts the information to its original state?
• Which function returns a substring given a starting position and a length?
• Which statement about Null Values is true?
• What does a referential integrity constraint with a foreign key enforce?
• Which statement about data slices in a data warehouse is accurate?
• Which statement describes a natural join?
• Which statement best describes a nested subquery?
• Which of the following is an example of a Data Retrieval Language statement?
• Which function converts a string to uppercase?
• Which statement best describes the relationship of SQL sublanguages?
• In SQL, what must a statement contain at least one of?
• Which component presents the data and calculations from one or more tables from the database in a formatted way?
• Which term describes actions taken to correct data quality problems?
• Which function would you use to compute the total of a numeric column?
• The derived column is the result of a calculation and is created with a SELECT clause expression that is something other than a simple reference to the column
• Which of the following is an example of a Data Definition Language statement?
• Which approach entails a central master data copy while individual operational systems may also maintain their own copies?
• What term describes saving a view as an actual physical table?
• Which set operation returns only the rows that are in the first query but not in the second?
• BETWEEN can be used to find a range instead of > and <
• Which role is responsible for the technical aspects of data management, including protection, transport, and storage of data?
• Which term refers to the extent to which the data properly conforms to and matches up with the other data?
• Which term describes a column produced by a calculation in a SELECT clause?
• Which function returns the current date or current time?
• Which description matches Delete Cascade?
• Which term represents the data dictionary created by the DBMS?
• Which statement about a structured repository is correct?
• Which term describes a wildcard placeholder for text used with LIKE or ILIKE statements?
• What term refers to the names of tables and columns that are called or manipulated?
• What describes Delete Set-to-Null?
• Which term describes the login procedure using user ID and password?
• Which term recovers the content of the database after a failure?
• Which function would you use to replace NULLs with a specified value?
• Which function returns the minimum value in a column?
• Which term refers to the mechanism that implements privileges but is managed by the DBA?
• Which statement best describes the purpose of a data warehouse in relation to an operational database?
• What is a natural join?
• Which function extracts a substring by specifying a starting position and length (distinct from Mid)?
• What term describes dispersed master data connected via a central master data registry?
• Which term describes actions taken to correct data quality problems after discovery?
• Which function creates a specific date or time value from components?
• Which sublanguage is used to query or retrieve data from a database?
• Master data provides a common reference point for the organization's information systems. Which term describes this concept?
• In SQL, it is possible to use the WHERE clause instead of the ON clause to specify join conditions for an inner join.
• Which function is commonly used to extract a portion of a string by specifying a starting position and length?
• If you need the difference between two timestamps, which function would you apply?
• What term denotes the process by which a user proves identity to the DBMS?
• Which technology is commonly used to process large-scale data by distributing computation across clusters?
• What does Accuracy measure in data quality?
• Master data is defined as which of the following?
• In a referential integrity constraint with a foreign key, the value must be:
• Which function replaces occurrences of a value with a new value in a string?
• Which function returns the leftmost n characters of a string?
• Which function returns the first five characters of a string?
• Which function converts a string to lowercase?
• Which SQL sublanguage is used to create and modify the database structure?
• Which statement describes Update Cascade?
• Which DBMS feature identifies possible ways to execute the query and chooses the fastest query plan?
• Which of the following describes the HAVING clause?
• Which term identifies a point in the recovery process when updates are written to disk?
• Which option describes Delete Set-to-Null?
• Which statement defines an Index in databases?
• COALESCE replaces NULL values with another value
• Which forms can be used to delete and update items as well?
• Master data management is best described as which of the following?
• Which function converts a string to proper case (initial capital letters)?
• What is query cost?
• Concatenating Strings: which operation would you use to join strings?
• Null Value is a marker for data that has not been entered or is missing, unknown, or inapplicable.
• Which function calculates the average of a column?
• Which option describes Update Set-to-Default?
• Which statement describes the relationship between Extract and Date_Part?
• What defines a subquery in SQL?
• Which concept describes massive volumes of diverse and rapidly growing data that are not formally modeled?
• Which statement best describes the data stored in a data warehouse?
• Which term is assigned to the database user account?
• Which clause is used to sort query results by one or more columns?
• What is the purpose of a complete mirrored backup?