单项选择题
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.
