单项选择题

What is true about sequences?（）

A. The start value of the sequence is always 1.
B. A sequence always increments by 1.
C. The minimum value of an ascending sequence defaults to 1.
D. The maximum value of descending sequence defaults to 1.

点击查看答案

上一题目录下一题

相关考题

单项选择题

The DBA issues this SQL command:

What privileges does the user Scott have at this point?（）

A. No privileges.
B. Only the SELECT privilege.
C. Only the CONNECT privilege.
D. All the privileges of a default user.

单项选择题

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2 (25)
LAST_NAME VARCHAR2 (25)
HIRE_DATE DATE
Which UPDATE statement is valid?（）

A. UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
B. UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
C. UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
D. UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;

单项选择题

Examine the statement:Create synonym emp for hr. employees;What happens when you issue the statement?（）

A. An error is generated.
B. You will have two identical tables in the HR schema with different names.
C. You create a table called employees in the HR schema based on you EMP table.
D. You create an alternative name for the employees table in the HR schema in your own schema.