- | P a g e
WGU D426 OBJECTIVE ASSESSMENT FINAL EXAM
NEWEST 2024-2025 ACTUAL EXAM COMPLETE 260
QUESTIONS AND CORRECT ANSWERS (VERIFIED
ANSWERS) |ALREADY GRADED A+
In SQL language, what sublanguage retrieves data from the database? - ANSWER- Data Query Language (DQL)
In SQL language, what sublanguage manipulates (inserts, updates and deletes) data stored in a database? - ANSWER- Data Manipulation Language (DML)
In SQL language, what sublanguage controls database user access? (grants and revokes permissions to and from users) - ANSWER- Data Control Language (DCL)
In SQL language, what sublanguage manages database transactions? (commits data to a database, rolls back data from a database, and creates save points) - ANSWER- Data Transaction Language (DTL)
- / 4
- | P a g e
What is, a series of SQL statements that are executed repeatedly? - ANSWER- Automated script
What command lists all databases in the database system instance? - ANSWER- SHOW DATABASES
What command selects a database? - ANSWER- USE
What command lists all columns in the TableName table of the default database? - ANSWER- SHOW COLUMNS FROM
What command adds, deletes, or modifies columns on an existing table? - ANSWER- ALTER TABLE
What is the name of an operation on a table in which rows become columns, and columns become rows? - ANSWER- Transpose
Which data types represent whole numbers, numbers without fractional values? - ANSWER- Integer (INT)
- / 4
- | P a g e
Which data types represent a fixed or variable length textual characters - ANSWER- Character (CHAR) and Variable Character (VARCHAR)
Mention 3 common date and time data types - ANSWER- DATE, DATETIME and TIMESTAMP
What is a symbol that computes a value from one or more other values? - ANSWER- Operator
What is a string of operators, operands, and parentheses that evaluates to a single value? - ANSWER- Expression
What is called when a column, or group of columns, used to identify a row? - ANSWER- A primary key
What statement automatically increments a value when a new row is inserted? - ANSWER- AUTO_INCREMENT
Which requirement within large, complex databases ensures users have limited access to the database? - ANSWER- Authorization
- / 4
- | P a g e
Which design type specifies database requirements without regard to a specific database system? - ANSWER- Conceptual design
What characterizes the rules of relational databases? - ANSWER- They are logical constraints that ensure the data is valid.
Which event will result in an error code and error description when using MySQL Server? - ANSWER- When an SQL statement is syntactically incorrect
Which data type should be used to store whole integer values, such as age? - ANSWER- INT
Which text-based interface is included in the MySQL Server Download? - ANSWER- MySQL Command-Line Client
Which database system includes the World database during its installation? - ANSWER- MySQL
What is the standardized language of relational database systems? - ANSWER- Structured Query Language
- / 4