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;
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.