ORACLE OCA 007题库.doc

Oracle 1Z0-007 Introduction to Oracle9i: SQL 156 QA Q: 1 Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? (Choose three.) A. INSERT INTO employees VALUES ( NULL, John, Smith); B. INSERT INTO employees( first_name, last_name) VALUES( John, Smith); C. INSERT INTO employees VALUES ( 1000, John, NULL); D. INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, John, Smith); E. INSERT INTO employees (employee_id) VALUES (1000); F. INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, John, ); Q: 2 Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed? A. 46 and 45 B. 46 and 45.93 C. 50 and 45.93 D. 50 and 45.9 E. 45 and 45.93 F. 45.95 and 45.93 Q: 3 Which are DML statements? (Choose all that apply.) A. COMMIT B. MERGE C. UPDATE D. DELETE E. CREATE F. DROP... Q: 4 Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(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 occupied 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. Q: 5 Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as monthly salary plus a monthly bonus of $100, multiplied by 12? A. No change is required to achieve the desired results. B. SELECT ename, sal, 12*(sal+100) FROM emp; C. SELECT ename, sal,