When renaming columns, you include the new column names in ____ following the name of the view
0%
REVOKE
0%
Spacebar
0%
parentheses
0%
intersect
Q.2.
The system catalog is also called the ____.
0%
primary key
0%
data dictionary
0%
data
0%
query
Q.3.
A(n) ____ is a pointer to a row in the collection of rows retrieved by an SQL command
0%
UPPER
0%
cursor
0%
parent
0%
INSERT
Q.4.
To add data from an existing table to a new table, use a SELECT command in a(n) ____ command
0%
VIEW
0%
UPDATE
0%
INSERT
0%
DELETE
Q.5.
The UPDATE command contains the word ____________________, followed by the name of the column to be updated, an equals sign, and the new value.
0%
COMMIT
0%
EXISTS
0%
AS
0%
SET
Q.6.
To remove extra spaces to the right of a value, for example, the value in a FIRST_NAME column, use the ____ function.
0%
FLOOR
0%
ROUND
0%
COMMIT
0%
RTRIM
Q.7.
In Oracle and SQL Server, use the ____ function to truncate everything to the right of the decimal point
0%
UPPER
0%
ALTER
0%
union
0%
FLOOR
Q.8.
In Oracle, to add a specific number of months to a date, use the ____ function.
0%
DBA_TABLES
0%
ADD_MONTHS
0%
SYSDATE
0%
DESCRIBE
Q.9.
The ____ of two tables is the set of all rows that are in the first table but that are not in the second table.
0%
difference
0%
intersect
0%
Autocommit
0%
union
Q.10.
To sort rows in a specific order, use the ____________________ clause with the desired sort key(s).
0%
primary key
0%
DATEADD()
0%
ORDER BY
0%
UPDATE
Q.11.
A(n) ____ can be viewed as a sequence of steps that accomplishes a single task.
0%
transaction
0%
trigger
0%
INTERSECT
0%
cursor
Q.12.
In SQL, use the ____ data type for variable-length character columns
0%
UPPER
0%
DATEADD()
0%
VARCHAR
0%
Cartesian
Q.13.
In SQL Server, you can use the ____ function to obtain today's date.
0%
DATE()
0%
SYSDATE
0%
DATEADD()
0%
GETDATE()
Q.14.
You can use the ____ command to delete an entire table and its data
0%
DROP TABLE
0%
DELETE
0%
ALTER
0%
UPDATE
Q.15.
In PL/SQL, you can ensure that a variable has the same data type as a particular column by using the ____ attribute
0%
SYSDATE
0%
%TYPE
0%
LOWER
0%
ROUND
Q.16.
In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table.
0%
correlated
0%
spacebar
0%
union
0%
full outer
Q.17.
Before beginning the updates for a transaction, commit any previous updates by executing the ____________________ command.
0%
SELECT
0%
COMMIT
0%
UPDATE
0%
ROLLBACK
Q.18.
In Oracle and SQL Server, the ____ function displays a value in uppercase letters
0%
INTERSECT
0%
ROUND
0%
DBA_TABLES
0%
UPPER
Q.19.
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.
0%
UPDATE
0%
EXISTS
0%
union
0%
COMMIT
Q.20.
A(n) ____ clause can include statistics calculated for only the groups or columns whose values are identical for each row in a group
0%
DELETE
0%
cursor
0%
full outer
0%
SELECT
Q.21.
Which of the following is a valid SQL command?
0%
DROP TABLE LEVEL1_CUSTOMER;
0%
DROP TABLE LEVEL101_CUSTOMER;
0%
DROP TABLE LEVEL2_CUSTOMER;
0%
DROP TABLE LEVEL0_CUSTOMER;
Q.22.
When you specify a foreign key, the table referenced by the foreign key is the ____.
0%
INSERT
0%
parent
0%
NOT NULL
0%
DATE()
Q.23.
To add a new column, use the ____________________ clause of the ALTER TABLE command.
0%
INSERT
0%
ADD
0%
ROUND
0%
SET
Q.24.
The command to delete a view is ____
0%
COMMIT
0%
ROLLBACK;
0%
Cartesian
0%
DROP VIEW
Q.25.
The privilege ____ can be granted to change data.
0%
INSERT
0%
DELETE
0%
SELECT
0%
UPDATE
Q.26.
Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths
0%
ROUND
0%
inner
0%
FLOOR
0%
union
Q.27.
To qualify a column name, precede the name of the column with the name of the table, followed by a(n) ____.
0%
GETDATE()
0%
DATEADD()
0%
ORDER BY
0%
period (.)
Q.28.
Which of the following commands deletes an index?
0%
DROP TABLE
0%
UPDATE
0%
DROP INDEX
0%
DELETE
Q.29.
To add a primary key after creating a table, you can use the ____________________ clause of the ALTER TABLE command.
0%
CREATE PROCEDURE
0%
ADD
0%
Autocommit
0%
add primary key
Q.30.
What happens if you run a DELETE command that does not contain a WHERE clause?
0%
parent
0%
All rows will be deleted from the table.
0%
transaction
0%
intersect
Q.31.
In Oracle, the ____ table contains information about the tables known to SQL.
0%
DBA_TABLES
0%
INTERSECT
0%
LOWER
0%
SYSDATE
Q.32.
In Oracle, you can use the ____ function to obtain today's date.
0%
DBA_TABLES
0%
DATE()
0%
SYSDATE
0%
UPDATE
Q.33.
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
0%
FETCH
0%
SELECT
0%
union
0%
REVOKE
Q.34.
You create an alias by typing the name of the table, pressing the ____, and then typing the name of the alias.
0%
ROLLBACK
0%
CREATE TABLE
0%
duplicate
0%
Spacebar
Q.35.
The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query
0%
union
0%
AS
0%
IN
0%
UCASE
Q.36.
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.
0%
NOT NULL
0%
ANY
0%
union
0%
ROUND
Q.37.
The privilege ____ can be granted to change the table structure
0%
INSERT
0%
ALTER
0%
DELETE
0%
UPDATE
Q.38.
Variable names in PL/SQL must start with a letter and can contain letters, dollar signs, underscores, and number signs, but cannot exceed ____ characters
0%
IN
0%
30
0%
ADD
0%
ALL
Q.39.
To ensure the uniqueness of values in a nonprimary key column, use the ____ command to create an index
0%
CREATE UNIQUE INDEX
0%
CREATE PROCEDURE
0%
correlated
0%
parentheses
Q.40.
To create a stored procedure in Oracle, use the ____ command.
0%
DELETE
0%
INTERSECT
0%
DROP INDEX
0%
CREATE PROCEDURE
Q.41.
In Microsoft Access, you can use the ____ function to obtain today's date
0%
UCASE
0%
DATE()
0%
Dim
0%
UPDATE
Q.42.
The types of constraints supported in SQL are ____.
0%
primary keys foreign keys legal values
0%
CREATE PROCEDURE
0%
Cartesian
0%
primary key
Q.43.
To retrieve data from multiple tables in a query you can use the ____ operator with a subquery.
0%
IN
0%
ANY
0%
INSERT
0%
inner
Q.44.
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).
0%
data dictionary
0%
left outer join
0%
intersect
0%
right outer join
Q.45.
For an SQL implementation to truly support the union operation, it must remove ____ rows automatically.
0%
CREATE TABLE
0%
duplicate
0%
difference
0%
Spacebar
Q.46.
In Microsoft Access, the ____ function displays a value in lowercase letters.
0%
UCASE
0%
LCASE
0%
UPPER
0%
WHERE
Q.47.
If you have not run the COMMIT command, executing the ____ command will reverse all updates made during the current work session
0%
DELETE
0%
UPDATE
0%
COMMIT
0%
ROLLBACK
Q.48.
To call a procedure in SQL Server, use the ____ command
0%
UPDATE
0%
EXEC
0%
ADD
0%
SELECT
Q.49.
In Oracle, use the ____ command to display the structure of a table.
0%
UPPER
0%
DESCRIBE
0%
DROP TABLE
0%
Cartesian
Q.50.
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
0%
right outer join
0%
difference
0%
trigger
0%
transaction
Q.51.
The ____ of two tables is a table containing all rows that are in both tables.
0%
intersect
0%
difference
0%
Cartesian
0%
INSERT
Q.52.
"Item classes for parts must be AP, HW, or SG because these are the only valid item classes." is an example of an _________________.
0%
integrity constraint
0%
CREATE UNIQUE INDEX
0%
CREATE TABLE
0%
parentheses
Q.53.
In Microsoft Access, the ____ function displays a value in uppercase letters
0%
LOWER
0%
LCASE
0%
UCASE
0%
data
Q.54.
In Oracle, SQL Server, and Microsoft Access, use the ____ function to round a numeric value to a desired number of decimal places
0%
UPPER
0%
RTRIM
0%
LOWER
0%
ROUND
Q.55.
The product of two tables is formally called the ____ Product
0%
Cartesian
0%
intersect
0%
correlated
0%
VARCHAR
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.