单选题You are granted the CREATE VIEW privilege. What does this allow you to do? （）A Create a table view.B Create a view in any schema.C Create a view in your schema.D Create a sequence view in any schema.E Create a view that is accessible by everyone.F Crea

TIMESTAMP

INTERVAL MONTH TO DAY

INTERVAL DAY TO SECOND

INTERVAL YEAR TO MONTH

TIMESTAMP WITH DATABASE TIMEZONE

CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;

CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;

GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***

UPDATEnew_employeesSETname=（SELECTlast_nameFirst_nameFROMemployeesWHEREemployee_id=180）WHEREemployee_id=180；

UPDATEnew_employeesSETname=（SELECTlast_nameFirst_nameFROMemployees）WHEREemployee_id=180；

UPDATEnew_employeesSETname=（SELECTlast_nameFirst_nameFROMemployeesWHEREemployee_id=180）   WHEREemployee_id=（SELECTemployee_idFROMnew_employees）；

UPDATEnew_employeesSETname=（SELECTlast_nameFirst_nameFROMemployeesWHEREemployee_id=（SELECTemployee_idFROMnew_employees）   WHEREemployee_id=180；

TRIM

REPLACE

TRUNC

TO_DATE

MOD

CASE

The value displayed in the CALC_VALUE column will be lower.

The value displayed in the CALC_VALUE column will be higher.

There will be no difference in the value displayed in the CALC_VALUE column.

An error will be reported.

Column definitions cannot be altered to add DEFAULT values.

A change to the DEFAULT value affects only subsequent insertions to the table.

Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.

All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

COUNT(UPPER(country_address))

COUNT(DIFF(UPPER(country_address)))

COUNT(UNIQUE(UPPER(country_address)))

COUNT DISTINTC UPPER(country_address)

COUNT(DISTINTC (UPPER(country_address)))

SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Martin' AND ord_date IN ('18-JUL-2000','21-JUL-2000');

SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Martin'));

SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders, customers WHERE cust_name = 'Martin');

SELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust_name = 'Martin');

0

1

0.00

an error statement

=

LIKE

BETWEEN

NOT IN

IS

<>

DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);

DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);

DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');

DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');

SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;

SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;

SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;

SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;

SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE /;

SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';

SELECT * FROM emp_dept_vu;

SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;

SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;

SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000

None of the statements produce an error; all are valid.

You cannot use IN operator in a condition that involves an outerjoin.

You use (+) on both sides of the WHERE condition to perform an outerjoin.

You use (*) on both sides of the WHERE condition to perform an outerjoin.

You use an outerjoin to see only the rows that do not meet the join condition.

In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.

You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.

/SQL*Plus commands cannot be abbreviated.

/SQL*Plus commands are accessed from a browser.

/SQL*Plus commands are used to manipulate data in tables.

/SQL*Plus commands manipulate table definitions in the database.

/SQL*Plus is the Oracle proprietary interface for executing SQL statements.

CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3

CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;

CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;

You can use aggregate functions in any clause of a SELECT statement.

You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.

You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.

You can pass column names, expressions, constants, or functions as parameters to an aggregate function.

You can use aggregate functions on a table, only by grouping the whole table as one single group.

You cannot group the rows of a table by more than one column while using aggregate functions.

SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;

SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;

SELECT student_id, gpa FROM student_grades ORDER BY gpa;

SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;

SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

The results are not sorted.

The results are sorted numerically.

The results are sorted alphabetically.

The results are sorted numerically and then alphabetically.

ALTER TABLE students ADD PRIMARY KEY student_id;

ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

Convert any date literal to a date

Convert any numeric literal to a date

Convert any character literal to a date

Convert any date to a character literal

Format '10-JAN-99' to 'January 10 1999'

SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' OR gpa > 3.;

SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa gt 3.0;

SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa > 3.0;

SELECT student_id, gpa FROM student_grades WHERE semester_end > '01-JAN-2001' OR semester_end < '31-DEC-2001' AND gpa >=s 3.0;