OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P2: There is high demand for professionals in the information technology (IT) industry, and Oracle certifications are the hottest credential in the database world. You have made the right decision to pursue certification, because being Oracle Database 11g certified will give you a distinct advantage in this highly competitive market. | SQL Fundamentals I Assessment Test xlv 36. A view is created using the following code. Which of the following operations are permitted on the view CREATE VIEW USA_STATES AS SELECT FROM STATE WHERE CNT_CODE 1 WITH READ ONLY A. SELECT B. SELECT UPDATE C. SELECT DELETE D. SELECT INSERT 37. You query the database with the following SELECT PRODUCT_ID FROM PRODUCTS WHERE PRODUCT_ID LIKE S _J _C ESCAPE Choose the two PRODUCT_ID strings that will satisfy the query. A. BTS_J_C B. SJC C. SKJKC D. S_J_C 38. The EMPLOYEE table is defined as follows EMP_NAME VARCHAR2 40 HIRE_DATE DATE SALARY NUMBER 14 2 Which query is most appropriate to use if you need to find the employees who were hired before January 1 1998 and have a salary greater than 5 000 or less than 1 000 A. SELECT emp_name FROM employee WHERE hire_date TO_DATE 01011998 MMDDYYYY AND SALARY 1000 OR 5000 B. SELECT emp_name FROM employee WHERE hire_date TO_DATE 01011998 MMDDYYYY AND SALARY 1000 OR SALARY 5000 C. SELECT emp_name FROM employee WHERE hire_date TO_DATE 01011998 MMDDYYYY AND SALARY 1000 OR SALARY 5000 D. SELECT emp_name FROM employee WHERE hire_date TO_DATE 01011998 MMDDYYYY AND SALARY BETWEEN 1000 AND 5000 xlvi SQL Fundamentals I Assessment Test 39. What happens when you issue the following command Choose all that apply. TRUNCATE TABLE A. All the rows in the table EMPLOYEE owned by SCOTT are removed. B. The storage space used by the table EMPLOYEE is released except the initial extent . C. If foreign key constraints are defined to this table using the ON DELETE CASCADE clause the rows from the child tables are also removed. D. The indexes on the table are dropped. E. You cannot truncate a table if triggers are defined on the table. 40. Which two statements will drop the primary key defined on table EMP The primary key name is PK_EMP. A. ALTER TABLE EMP DROP PRIMARY KEY B. DROP CONSTRAINT PK_EMP C. ALTER TABLE EMP DROP CONSTRAINT PK_EMP D. ALTER CONSTRAINT PK_EMP DROP CASCADE E. DROP .
