WGU D426 Objective Assessments (Latest 2024/ 2025
Updates STUDY BUNDLE PACKAGE) Data Management
Foundations | Questions and Verified Answers|100%
Correct| Grade A
What does SQL stand for? - ANSWERSQL stands for structured query language..
What is SQL used as? - ANSWERIt is widely used as a relational database language.
What is SQL? - ANSWERIt is a complete database language
What is SQL used for? - ANSWERSQL is used for defining a relational database,
creating views, and specifying queries.
What does SQL allow for? - ANSWERSQL allows for rows to be inserted, updated, and
deleted.
In database terminology what is it? - ANSWERSQL is a data definition language (DDL),
a data manipulation language (DML), and a data control language (DCL).
Is it a complete programming language? - ANSWERNo it is used in conjunction with
PHP and Java.
What type of language is SQL? - ANSWERSQL is a declarative language, because you
declare the desired results. The SQL programmer can focus on defining what is
required rather than detailing the process to achieve what is required.
What handles the database processing? - ANSWERThe embedded SQL statements
handle the database processing.
What is a major advantage of a RDBMS? - ANSWEROne of the major advantages of a
relational database management system is that DDL statements can be executed at
any time. New tables, views, and indexes can be created without interfering with
current operational use.
What is a base table? - ANSWERA base table is an autonomous, named table. It is
autonomous because it exists in its own right; it is physically stored within the
database.
Is a view autonomous? - ANSWERNo a view is a virtual table.
How is a base table referenced? - ANSWERIt is referenced by the name that is
chosen when the base table is generated using the CREATE statement.
, What is the concept of a key in SQL? - ANSWERA key is one or more columns
identified as such in the description of a table, an index, or a referential constraint.
The same column can be part of more than one key.
What can the key be part of? - ANSWERIt can be part of a primary key and a foreign
key.
What is a composite key? - ANSWERA composite key is an ordered set of columns of
the same table. In other words, the primary key of lineitem is always the composite
of saleno, lineno in that order. The order cannot be changed.
What does comparing composite keys actually mean? - ANSWERIt means that
corresponding components of the keys are compared. Thus the value of a foreign
key must be equal to a value of the primary key. This means that each component of
the foreign key must be equal to a corresponding component of a composite primary
key.
What is the purpose of a unique key? - ANSWERIts purpose is to ensure that no two
values of a key are equal. This constraint is enforced by the DBMS during the
execution of INSERT and UPDATE statements. A unique key is part of the index
mechanism.
Indexes are used for what? - ANSWERIndexes are used to accelerate data access and
ensure uniqueness.
What is an index? - ANSWERAn index is an ordered set of pointers to rows of a base
table.
What is searching an index like? - ANSWERIt is like searching a phone book by a
person's last name.
CREATE TABLE is used to define what? - ANSWERCREATE TABLE is used to define a
new base table. The statement specifies a table's name, provides details of its
columns, and provides integrity checks.
What does CREATE TABLE do? - ANSWERIt specifies a table's name, provides details
of its columns, and provides integrity checks.
The NOT NULL clause specifies what? - ANSWERIt specifies that the particular
column must have a value whenever a new row is inserted.
What is a constraint? - ANSWERA constraint is a rule defined as part of CREATE
TABLE that defines valid sets of values for a base table by placing limits on INSERT,
UPDATE, and DELETE operations.
The primary key constraint block specifies what? - ANSWERA set of columns that
constitute the primary key.
Updates STUDY BUNDLE PACKAGE) Data Management
Foundations | Questions and Verified Answers|100%
Correct| Grade A
What does SQL stand for? - ANSWERSQL stands for structured query language..
What is SQL used as? - ANSWERIt is widely used as a relational database language.
What is SQL? - ANSWERIt is a complete database language
What is SQL used for? - ANSWERSQL is used for defining a relational database,
creating views, and specifying queries.
What does SQL allow for? - ANSWERSQL allows for rows to be inserted, updated, and
deleted.
In database terminology what is it? - ANSWERSQL is a data definition language (DDL),
a data manipulation language (DML), and a data control language (DCL).
Is it a complete programming language? - ANSWERNo it is used in conjunction with
PHP and Java.
What type of language is SQL? - ANSWERSQL is a declarative language, because you
declare the desired results. The SQL programmer can focus on defining what is
required rather than detailing the process to achieve what is required.
What handles the database processing? - ANSWERThe embedded SQL statements
handle the database processing.
What is a major advantage of a RDBMS? - ANSWEROne of the major advantages of a
relational database management system is that DDL statements can be executed at
any time. New tables, views, and indexes can be created without interfering with
current operational use.
What is a base table? - ANSWERA base table is an autonomous, named table. It is
autonomous because it exists in its own right; it is physically stored within the
database.
Is a view autonomous? - ANSWERNo a view is a virtual table.
How is a base table referenced? - ANSWERIt is referenced by the name that is
chosen when the base table is generated using the CREATE statement.
, What is the concept of a key in SQL? - ANSWERA key is one or more columns
identified as such in the description of a table, an index, or a referential constraint.
The same column can be part of more than one key.
What can the key be part of? - ANSWERIt can be part of a primary key and a foreign
key.
What is a composite key? - ANSWERA composite key is an ordered set of columns of
the same table. In other words, the primary key of lineitem is always the composite
of saleno, lineno in that order. The order cannot be changed.
What does comparing composite keys actually mean? - ANSWERIt means that
corresponding components of the keys are compared. Thus the value of a foreign
key must be equal to a value of the primary key. This means that each component of
the foreign key must be equal to a corresponding component of a composite primary
key.
What is the purpose of a unique key? - ANSWERIts purpose is to ensure that no two
values of a key are equal. This constraint is enforced by the DBMS during the
execution of INSERT and UPDATE statements. A unique key is part of the index
mechanism.
Indexes are used for what? - ANSWERIndexes are used to accelerate data access and
ensure uniqueness.
What is an index? - ANSWERAn index is an ordered set of pointers to rows of a base
table.
What is searching an index like? - ANSWERIt is like searching a phone book by a
person's last name.
CREATE TABLE is used to define what? - ANSWERCREATE TABLE is used to define a
new base table. The statement specifies a table's name, provides details of its
columns, and provides integrity checks.
What does CREATE TABLE do? - ANSWERIt specifies a table's name, provides details
of its columns, and provides integrity checks.
The NOT NULL clause specifies what? - ANSWERIt specifies that the particular
column must have a value whenever a new row is inserted.
What is a constraint? - ANSWERA constraint is a rule defined as part of CREATE
TABLE that defines valid sets of values for a base table by placing limits on INSERT,
UPDATE, and DELETE operations.
The primary key constraint block specifies what? - ANSWERA set of columns that
constitute the primary key.
