oracle plsql考试试卷.docVIP

Oracle SQLPL/SQL Test 选择题(45 * 2) 用下列代码块回答问题： SQL select ______(-45) as output from dual; OUTPUT ------ -45 下列哪个单行函数无法产生这个输出？ A．abs() B．ceil() C．floor() D．round() 用下列代码回答问题： Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), loc VARCNAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set? 哪个语句是正确的？ A. The DESCRIBE DEPT statement displays the structure of the DEPT table. B. The ROLLBACK statement frees the storage space occupies by the DEPT table. C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist. D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement. 用下列代码回答问题： Examine the structure of the EMPLOYEES and DEPARTMENTS tables: 检查如下表结构 EMPLOYEES Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTS Column name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e.department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement? 一下哪个语句和上面的语句执行结果相同？ A. SELECT employee_id, department_id, department_name,salary FROM employees WHERE department_id IN (SELECT department_id FROM departments); B. SELECT employee_id, department_id, department_name,salary FROM employees NATURAL JOIN departments; C. SELECT employee_id, d.department_id, department_name,salary FROM employees e JOIN departments d ON e.department_id = d.department_id; D. SELECT employee_id, department_id, department_name,Salary FROM employees JOIN department