Multiple Choice Questions

When renaming columns, you include the new column names in ____ following the name of the view
  • REVOKE
  • Spacebar
  • parentheses
  • intersect
The system catalog is also called the ____.
  • primary key
  • data dictionary
  • data
  • query
A(n) ____ is a pointer to a row in the collection of rows retrieved by an SQL command
  • UPPER
  • cursor
  • parent
  • INSERT
To add data from an existing table to a new table, use a SELECT command in a(n) ____ command
  • VIEW
  • UPDATE
  • INSERT
  • DELETE
The UPDATE command contains the word ____________________, followed by the name of the column to be updated, an equals sign, and the new value.
  • COMMIT
  • EXISTS
  • AS
  • SET
To remove extra spaces to the right of a value, for example, the value in a FIRST_NAME column, use the ____ function.
  • FLOOR
  • ROUND
  • COMMIT
  • RTRIM
In Oracle and SQL Server, use the ____ function to truncate everything to the right of the decimal point
  • UPPER
  • ALTER
  • union
  • FLOOR
In Oracle, to add a specific number of months to a date, use the ____ function.
  • DBA_TABLES
  • ADD_MONTHS
  • SYSDATE
  • DESCRIBE
The ____ of two tables is the set of all rows that are in the first table but that are not in the second table.
  • difference
  • intersect
  • Autocommit
  • union
To sort rows in a specific order, use the ____________________ clause with the desired sort key(s).
  • primary key
  • DATEADD()
  • ORDER BY
  • UPDATE
A(n) ____ can be viewed as a sequence of steps that accomplishes a single task.
  • transaction
  • trigger
  • INTERSECT
  • cursor
In SQL, use the ____ data type for variable-length character columns
  • UPPER
  • DATEADD()
  • VARCHAR
  • Cartesian
In SQL Server, you can use the ____ function to obtain today's date.
  • DATE()
  • SYSDATE
  • DATEADD()
  • GETDATE()
You can use the ____ command to delete an entire table and its data
  • DROP TABLE
  • DELETE
  • ALTER
  • UPDATE
In PL/SQL, you can ensure that a variable has the same data type as a particular column by using the ____ attribute
  • SYSDATE
  • %TYPE
  • LOWER
  • ROUND
In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table.
  • correlated
  • spacebar
  • union
  • full outer
Before beginning the updates for a transaction, commit any previous updates by executing the ____________________ command.
  • SELECT
  • COMMIT
  • UPDATE
  • ROLLBACK
In Oracle and SQL Server, the ____ function displays a value in uppercase letters
  • INTERSECT
  • ROUND
  • DBA_TABLES
  • UPPER
You can precede a subquery with the ____ operator to create a condition that is true if one or more rows are obtained when the subquery is executed.
  • UPDATE
  • EXISTS
  • union
  • COMMIT
A(n) ____ clause can include statistics calculated for only the groups or columns whose values are identical for each row in a group
  • DELETE
  • cursor
  • full outer
  • SELECT
Which of the following is a valid SQL command?
  • DROP TABLE LEVEL1_CUSTOMER;
  • DROP TABLE LEVEL101_CUSTOMER;
  • DROP TABLE LEVEL2_CUSTOMER;
  • DROP TABLE LEVEL0_CUSTOMER;
When you specify a foreign key, the table referenced by the foreign key is the ____.
  • INSERT
  • parent
  • NOT NULL
  • DATE()
To add a new column, use the ____________________ clause of the ALTER TABLE command.
  • INSERT
  • ADD
  • ROUND
  • SET
The command to delete a view is ____
  • COMMIT
  • ROLLBACK;
  • Cartesian
  • DROP VIEW
The privilege ____ can be granted to change data.
  • INSERT
  • DELETE
  • SELECT
  • UPDATE
Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths
  • ROUND
  • inner
  • FLOOR
  • union
To qualify a column name, precede the name of the column with the name of the table, followed by a(n) ____.
  • GETDATE()
  • DATEADD()
  • ORDER BY
  • period (.)
Which of the following commands deletes an index?
  • DROP TABLE
  • UPDATE
  • DROP INDEX
  • DELETE
To add a primary key after creating a table, you can use the ____________________ clause of the ALTER TABLE command.
  • CREATE PROCEDURE
  • ADD
  • Autocommit
  • add primary key
What happens if you run a DELETE command that does not contain a WHERE clause?
  • parent
  • All rows will be deleted from the table.
  • transaction
  • intersect
In Oracle, the ____ table contains information about the tables known to SQL.
  • DBA_TABLES
  • INTERSECT
  • LOWER
  • SYSDATE
In Oracle, you can use the ____ function to obtain today's date.
  • DBA_TABLES
  • DATE()
  • SYSDATE
  • UPDATE
When you use a cursor in a procedure, the ____ command advances the cursor to the next row in the set of rows retrieved by the query and places the contents of the row in the indicated variables
  • FETCH
  • SELECT
  • union
  • REVOKE
You create an alias by typing the name of the table, pressing the ____, and then typing the name of the alias.
  • ROLLBACK
  • CREATE TABLE
  • duplicate
  • Spacebar
The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query
  • union
  • AS
  • IN
  • UCASE
If you precede the subquery by the ____ operator, the condition is true only if it satisfies any value (one or more) produced by the subquery.
  • NOT NULL
  • ANY
  • union
  • ROUND
The privilege ____ can be granted to change the table structure
  • INSERT
  • ALTER
  • DELETE
  • UPDATE
Variable names in PL/SQL must start with a letter and can contain letters, dollar signs, underscores, and number signs, but cannot exceed ____ characters
  • IN
  • 30
  • ADD
  • ALL
To ensure the uniqueness of values in a nonprimary key column, use the ____ command to create an index
  • CREATE UNIQUE INDEX
  • CREATE PROCEDURE
  • correlated
  • parentheses
To create a stored procedure in Oracle, use the ____ command.
  • DELETE
  • INTERSECT
  • DROP INDEX
  • CREATE PROCEDURE
In Microsoft Access, you can use the ____ function to obtain today's date
  • UCASE
  • DATE()
  • Dim
  • UPDATE
The types of constraints supported in SQL are ____.
  • primary keys foreign keys legal values
  • CREATE PROCEDURE
  • Cartesian
  • primary key
To retrieve data from multiple tables in a query you can use the ____ operator with a subquery.
  • IN
  • ANY
  • INSERT
  • inner
In a ____, all rows from the table on the left (the table listed first in the query) will be included regardless of whether they match rows from the table on the right (the table listed second in the query).
  • data dictionary
  • left outer join
  • intersect
  • right outer join
For an SQL implementation to truly support the union operation, it must remove ____ rows automatically.
  • CREATE TABLE
  • duplicate
  • difference
  • Spacebar
In Microsoft Access, the ____ function displays a value in lowercase letters.
  • UCASE
  • LCASE
  • UPPER
  • WHERE
If you have not run the COMMIT command, executing the ____ command will reverse all updates made during the current work session
  • DELETE
  • UPDATE
  • COMMIT
  • ROLLBACK
To call a procedure in SQL Server, use the ____ command
  • UPDATE
  • EXEC
  • ADD
  • SELECT
In Oracle, use the ____ command to display the structure of a table.
  • UPPER
  • DESCRIBE
  • DROP TABLE
  • Cartesian
In a ____, all rows from the table on the right will be included regardless of whether they match rows from the table on the left
  • right outer join
  • difference
  • trigger
  • transaction
The ____ of two tables is a table containing all rows that are in both tables.
  • intersect
  • difference
  • Cartesian
  • INSERT
"Item classes for parts must be AP, HW, or SG because these are the only valid item classes." is an example of an _________________.
  • integrity constraint
  • CREATE UNIQUE INDEX
  • CREATE TABLE
  • parentheses
In Microsoft Access, the ____ function displays a value in uppercase letters
  • LOWER
  • LCASE
  • UCASE
  • data
In Oracle, SQL Server, and Microsoft Access, use the ____ function to round a numeric value to a desired number of decimal places
  • UPPER
  • RTRIM
  • LOWER
  • ROUND
The product of two tables is formally called the ____ Product
  • Cartesian
  • intersect
  • correlated
  • VARCHAR
0 h : 0 m : 1 s

Multiple Choice Questions
Answered Not Answered Not Visited Correct : 0 Incorrect : 0