WGU D427 FREQUENTLY TESTED QUESTIONS (2025)
ALREADY GRADED A
1) What is a logical construct that facilitates data relationships in a relational database?
a) Tuple
b) Relation
c) Attribute
d) Entity set
2) Which is NOT a characteristic of a relational table?
a) Each row represents a single entity occurrence
b) Columns represent attributes
c) Column order is important
d) Columns have distinct names
3) What consists of attributes that determine other attributes?
a) Key
b) Relation
c) Entity set
d) Tuple
4) What is a key composed of more than one attribute called?
a) Primary key
b) Foreign key
c) Composite key
d) Alternate key
5) What constraint ensures each row has a unique identity?
a) Referential integrity
,b) Entity integrity
c) Domain integrity
d) User-defined integrity
6) What is a primary key from one table placed in another table called?
a) Secondary key
b) Foreign key
c) Composite key
d) Alternate key
7) What is a key used strictly for retrieval purposes called?
a) Primary key
b) Foreign key
c) Secondary key
d) Alternate key
8) What operator allows information to be combined from two or more tables?
a) SELECT
b) PROJECT
c) JOIN
d) PRODUCT
9) What provides detailed description of tables created by users and designers?
a) Data dictionary
b) Metadata
c) System catalog
d) Data repository
10) What is used to implement many-to-many relationships between tables?
,a) Referential integrity
b) Linking table
c) Foreign key
d) Index
11) What is an ordered arrangement used to logically access table rows?
a) Schema
b) View
c) Index
d) Catalog
12) What command is used to create a database schema?
a) CREATE DATABASE
b) CREATE SCHEMA
c) CREATE TABLE
d) CREATE VIEW
13) What SQL data type is used for variable length text?
a) VARCHAR
b) CHAR
c) INTEGER
d) DATE
14) What constraint assigns a default value when adding a new row?
a) NOT NULL
b) CHECK
c) DEFAULT
d) UNIQUE
, 15) What command adds or changes columns in a table?
a) CREATE INDEX
b) ALTER TABLE
c) CREATE VIEW
d) DROP TABLE
16) What command deletes rows from a table?
a) DELETE
b) DROP
c) UPDATE
d) INSERT
17) What command restores a table's contents before changes?
a) UPDATE
b) COMMIT
c) ROLLBACK
d) ALTER
18) What combines rows from two queries excluding duplicates?
a) JOIN
b) UNION
c) INTERSECT
d) MINUS
19) What returns rows appearing in both result sets?
a) UNION
b) INTERSECT
c) JOIN
d) MINUS
ALREADY GRADED A
1) What is a logical construct that facilitates data relationships in a relational database?
a) Tuple
b) Relation
c) Attribute
d) Entity set
2) Which is NOT a characteristic of a relational table?
a) Each row represents a single entity occurrence
b) Columns represent attributes
c) Column order is important
d) Columns have distinct names
3) What consists of attributes that determine other attributes?
a) Key
b) Relation
c) Entity set
d) Tuple
4) What is a key composed of more than one attribute called?
a) Primary key
b) Foreign key
c) Composite key
d) Alternate key
5) What constraint ensures each row has a unique identity?
a) Referential integrity
,b) Entity integrity
c) Domain integrity
d) User-defined integrity
6) What is a primary key from one table placed in another table called?
a) Secondary key
b) Foreign key
c) Composite key
d) Alternate key
7) What is a key used strictly for retrieval purposes called?
a) Primary key
b) Foreign key
c) Secondary key
d) Alternate key
8) What operator allows information to be combined from two or more tables?
a) SELECT
b) PROJECT
c) JOIN
d) PRODUCT
9) What provides detailed description of tables created by users and designers?
a) Data dictionary
b) Metadata
c) System catalog
d) Data repository
10) What is used to implement many-to-many relationships between tables?
,a) Referential integrity
b) Linking table
c) Foreign key
d) Index
11) What is an ordered arrangement used to logically access table rows?
a) Schema
b) View
c) Index
d) Catalog
12) What command is used to create a database schema?
a) CREATE DATABASE
b) CREATE SCHEMA
c) CREATE TABLE
d) CREATE VIEW
13) What SQL data type is used for variable length text?
a) VARCHAR
b) CHAR
c) INTEGER
d) DATE
14) What constraint assigns a default value when adding a new row?
a) NOT NULL
b) CHECK
c) DEFAULT
d) UNIQUE
, 15) What command adds or changes columns in a table?
a) CREATE INDEX
b) ALTER TABLE
c) CREATE VIEW
d) DROP TABLE
16) What command deletes rows from a table?
a) DELETE
b) DROP
c) UPDATE
d) INSERT
17) What command restores a table's contents before changes?
a) UPDATE
b) COMMIT
c) ROLLBACK
d) ALTER
18) What combines rows from two queries excluding duplicates?
a) JOIN
b) UNION
c) INTERSECT
d) MINUS
19) What returns rows appearing in both result sets?
a) UNION
b) INTERSECT
c) JOIN
d) MINUS
