CS 331 Final Exam ACTUAL UPDATED QUESTIONS AND CORRECT ANSWERS
What is a logging attribute controls whether certain DML operations are logged in the redo log file (logging)
or not (no logging)
What is the default for the logging attribute LOGGING
what is a table data arranged in records (rows) and fields (columns)
, What does SQL stand for Structured Query Language
What does DQL stand for Data Query Language
What is DQL statements that are used for performing queries on the data within scheme
objects
What does DML stand for Data Manipulation Language
What does DML do Deals with the manipulation of data present in the database. Example: Inserting,
updating, and deleting records in a table
What does DDL stand for Data Definition Language.
What does DDL do Deals with the descriptions of the database schema and is used to create and
modify the structure of the database objects in the database. Example: Creating a
DB, Dropping objects from a DB, Truncate... Alter...
What does TCL Transaction Control Language
What does TCL do deals with the transactions within a database. Example: Commit, Rollback,
SavePoint
What does DCL stand for Data Control Language
What does DCL do Deals with rights, permissions, and other controls of the database system.
Example: Grant, Revoke
What does the WHERE clause do? Acts as filter in a SELECT statement. The results will only include rows where the
condition matches True.
What does the ORDER BY clause do? Sorts the result set by a particular column either alphabetically or numerically
What does the IN clause do? specifies multiple values in a WHERE clause
What does the BETWEEN clause do? alter the result set within a certain range of values that can be numbers, text, or
dates
What does the EXISTS clause do? tests for the existence of any record in a subquery
What does the LIKE clause do? used with the WHERE clause to search for a specific pattern in a column
What does the IS NULL/ IS NOT NULL clause do? used with the WHERE clause to test for empty values
What is a logging attribute controls whether certain DML operations are logged in the redo log file (logging)
or not (no logging)
What is the default for the logging attribute LOGGING
what is a table data arranged in records (rows) and fields (columns)
, What does SQL stand for Structured Query Language
What does DQL stand for Data Query Language
What is DQL statements that are used for performing queries on the data within scheme
objects
What does DML stand for Data Manipulation Language
What does DML do Deals with the manipulation of data present in the database. Example: Inserting,
updating, and deleting records in a table
What does DDL stand for Data Definition Language.
What does DDL do Deals with the descriptions of the database schema and is used to create and
modify the structure of the database objects in the database. Example: Creating a
DB, Dropping objects from a DB, Truncate... Alter...
What does TCL Transaction Control Language
What does TCL do deals with the transactions within a database. Example: Commit, Rollback,
SavePoint
What does DCL stand for Data Control Language
What does DCL do Deals with rights, permissions, and other controls of the database system.
Example: Grant, Revoke
What does the WHERE clause do? Acts as filter in a SELECT statement. The results will only include rows where the
condition matches True.
What does the ORDER BY clause do? Sorts the result set by a particular column either alphabetically or numerically
What does the IN clause do? specifies multiple values in a WHERE clause
What does the BETWEEN clause do? alter the result set within a certain range of values that can be numbers, text, or
dates
What does the EXISTS clause do? tests for the existence of any record in a subquery
What does the LIKE clause do? used with the WHERE clause to search for a specific pattern in a column
What does the IS NULL/ IS NOT NULL clause do? used with the WHERE clause to test for empty values
