單項(xiàng)選擇題

What is true about the WITH GRANT OPTION clause?（）

A.It allows a grantee DBA privileges.
B.It is required syntax for object privileges.
C.It allows privileges on specified columns of tables.
D.It is used to grant an object privilege on a foreign key column.
E.It allows the grantee to grant object privileges to other users and roles.

你可能感興趣的試題

單項(xiàng)選擇題

The EMP table has these columns:

Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?（）

A. SELECT ENAME   FROM EMP   WHERE SYSDATE-HIRE_DATE > 5;
B. SELECT ENAME   FROM EMP   WHERE HIRE_DATE-SYSDATE > 5;
C. SELECT ENAME   FROM EMP   WHERE (SYSDATE-HIRE_DATE)/365 > 5;
D. SELECT ENAME   FROM EMP   WHERE (SYSDATE-HIRE_DATE)* 365 > 5;

單項(xiàng)選擇題

Which constraint can be defines only at the column level?（）

A.UNIQUE
B.NOT NULL
C.CHECK
D.PRIMARY KEY
E.FOREIGN KEY

What is true about the WITH GRANT OPTION clause?（）

你可能感興趣的試題

The EMP table has these columns: Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?（）

Which constraint can be defines only at the column level?（）

The EMP table has these columns:

Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?（）