WGU D426 (New 2023/ 2023 Update) Data Management Foundations Exam|| Grade A Review with Questions and Verified Answers|100% Correct
WGU D426 (New 2023/ 2023 Update) Data
Management Foundations Exam|| Grade A
Review with Questions and Verified
Answers|100% Correct
QUESTION
What is a database system instance?
Answer:
A single executing copy of a database system.
QUESTION
What does CREATE DATABASE do?
Answer:
Creates a new database.
QUESTION
What does DROP DATABASE do?
Answer:
Deletes a database, including all tables.
QUESTION
What does USE DatabaseName do?
Answer:
Selects a default database for use in subsequent SQL statements.
QUESTION
What does SHOW DATABASES do?
Answer:
Lists all databases in the database system instance.
QUESTION
What does SHOW TABLES do?
Answer:
Lists all tables in the default database.
QUESTION
What does SHOW COLUMNS FROM TableName do?
Answer:
Lists all columns in the TableName table of the default database.
QUESTION
What does SHOW CREATE TABLE TableName do?
Answer:
Shows the CREATE TABLE statement for the TableName table of the default database.
QUESTION
What is a table?
Answer:
A structure with a name, columns, and rows.
QUESTION
What is a column?
Answer:
A named attribute in a table with a data type.
QUESTION
What is a row?
Answer:
An unnamed sequence of values in a table.
QUESTION
What is a cell?
Answer:
A single value in a column of a row.
QUESTION
What is an empty table?
Answer:
A table without any rows.
QUESTION
What is data independence?
Answer:
Rule 4 that allows changes in the physical storage of data without affecting the logical view.
QUESTION
What does CREATE TABLE do?
Answer:
Creates a new table with specified column names and data types.
QUESTION
What does DROP TABLE do?
Answer:
Deletes a table and its rows from a database.
QUESTION
What does ALTER TABLE do?
Answer:
Modifies an existing table by adding, modifying, or deleting columns.
QUESTION
What does the ALTER TABLE statement do?
Answer:
Adds, deletes, or modifies columns on an existing table.
QUESTION
What is a data type?
Answer:
A named set of values from which column values are drawn.
Powered by https://learnexams.com/search/study?query=