单项选择题
Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）
A.&
B.ACCEPT
C.PROMPT
D.&&
点击查看答案
相关考题
-
单项选择题
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. -
单项选择题
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; -
单项选择题
Which constraint can be defines only at the column level?（）
A.UNIQUE
B.NOT NULL
C.CHECK
D.PRIMARY KEY
E.FOREIGN KEY
