Skip to content
Pass Any WGU OA Exam Now & Pay After You Pass. Contact Us!
  1. Home
  2. WGU Exams
  3. WGU D426
  4. Set 1
WGU D426 · Data Management – Foundations

WGU D426 Practice Questions – Set 1

50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.

Question 1 of 50

Which normal form ensures that every cell contains exactly one value and every table has a primary key?

Question 2 of 50

In SQL, which keyword is used to prevent a column from having a NULL value?

Question 3 of 50

Which type of join in SQL selects all rows from the left table and only matching rows from the right table?

Question 4 of 50

Which SQL operator is used to compare columns using the = operator?

Question 5 of 50

Which type of key in a table uniquely identifies a row and cannot be NULL?

Question 6 of 50

In database design, which phase specifies the structure and organization of the database tables?

Question 7 of 50

Which type of index contains an entry for every row in a table?

Question 8 of 50

In relational databases, what does the term “cardinality” refer to?

Question 9 of 50

Which SQL statement is used to create a new table in a database?

Question 10 of 50

Which type of relationship is defined when a foreign key in one table refers to the primary key of another table?

Question 11 of 50

Which SQL function returns the minimum value in a set of rows?

Question 12 of 50

What is the primary purpose of the TRUNCATE statement in SQL?

Question 13 of 50

Which database object is used to define rules that enforce data integrity, such as preventing invalid values?

Question 14 of 50

What is the key characteristic of an AUTO_INCREMENT column in SQL?

Question 15 of 50

In which normal form are all non-key columns dependent on the whole primary key and nothing else?

Question 16 of 50

Which SQL clause is used to filter results based on a condition?

Question 17 of 50

Which type of index only stores entries for certain blocks of a table rather than every row?

Question 18 of 50

Which type of join returns rows that have matching values in both the left and right tables?

Question 19 of 50

What is the primary function of a foreign key in a relational database?

Question 20 of 50

Which aggregate function in SQL calculates the total sum of values in a column?

Question 21 of 50

In database design, what does a composite primary key consist of?

Question 22 of 50

Which type of join includes all rows from the left and right tables, regardless of whether they have matches?

Question 23 of 50

Which type of index is used in SQL databases to assign entries to buckets?

Question 24 of 50

What does the SQL clause GROUP BY do?

Question 25 of 50

Which command in SQL deletes a table from a database entirely, including all rows and structure?

Question 26 of 50

In SQL, which operator is used for pattern matching with wildcards?

Question 27 of 50

Which SQL statement is used to change the data in an existing row in a table?

Question 28 of 50

Which SQL command is used to create an index on one or more columns of a table?

Question 29 of 50

Which clause in SQL is used to limit the number of rows returned by a SELECT statement?

Question 30 of 50

In a relational database, what does the term “schema” refer to?

Question 31 of 50

Which SQL operator is used to return unique values from a column?

Question 32 of 50

Which type of key in a table is used to refer to the primary key in another table?

Question 33 of 50

What is the purpose of a CHECK constraint in SQL?

Question 34 of 50

In which normal form is a table if all columns are functionally dependent on the primary key, and there are no transitive dependencies?

Question 35 of 50

Which SQL statement is used to delete specific rows from a table based on a condition?

Question 36 of 50

Which clause in SQL is used to filter rows before grouping them in a GROUP BY query?

Question 37 of 50

Which type of key uniquely identifies each row in a table and must always contain unique, non-null values?

Question 38 of 50

What is the main purpose of the ALTER TABLE command in SQL?

Question 39 of 50

Which type of join includes all rows from the right table and only matching rows from the left table?

Question 40 of 50

Which term describes the dependence of one column on another in a table, where one value determines another?

Question 41 of 50

Which SQL operator is used to compare a value to a range of values?

Question 42 of 50

Which SQL function calculates the number of rows returned by a query?

Question 43 of 50

What is the primary function of a Unique Key in a database table?

Question 44 of 50

Which aggregate function in SQL calculates the average of values in a column?

Question 45 of 50

In relational databases, what does the term “entity” refer to?

Question 46 of 50

Which SQL statement is used to change the values of existing rows in a table?

Question 47 of 50

Which SQL operator is used to filter results based on matching patterns in a text field?

Question 48 of 50

Which type of key is used to uniquely identify each row in a table and must contain unique, non-null values?

Question 49 of 50

Which type of join returns rows from the left table and matching rows from the right table, filling in NULLs where there is no match?

Question 50 of 50

In relational databases, which constraint ensures that a foreign key value must match an existing primary key value or be NULL?

Set 1 complete

You scored 0%

0 correct out of 0 answered (50 questions in this set).

Next: Set 2

Struggling with WGU D426?

If this exam is giving you a hard time, let us be your helping hand. Contact us, and we'll provide the assistance you need to pass and move forward.

Chat Now