EMPLOYEE 

ID 

LAST_NAME 

MONTHLY_SALARY 

MONTHLY_COMMISSION_PCT

 ------------------ ------------------- --------------------------- ------------------------------------------ 

101 Kochhar 24000

102 Ernst 17000 .5 

103 Rajs 21000 .2 

104 Lorentz 25000 

105 Morris 12000 

Which statement will compute the total annual compensation for each employee?

Name Null? Type ------------------- ------------- --------------- 

PROD_ID NOT NULL NUMBER 

PROD_NAME VARCHAR2 (40) 

COST NUMBER(8,2) 

RELEASE_DATE DATE 

Which query is valid?

Name Null? 

Type ---------------------------------------------------------------------------- 

EMPLOYEE_NAME NOT NULL VARCHAR2 (5) 

HIRE_DATE DATE 

SALARY NUMBER(7,2) 

The session time zone is the same as the database server. 

Which two statements will list only the employees who have been working with the company for more than five years?

Name Null? Type ----------------------- ---------------------- -------------------

EMPLOYEE_ID NOT NULL NUMBER(6) 

SALARY NUMBER(8,2) 

DEPARTMENT_ID NUMBER (4) 

Which two queries return the highest salary in the table?

[oracle@host01 ~] impdp system/oracle \ -> SCHEMAS = sh,oe \ -> REMAP_SCHEMA = sh:hr \ -> DUMPFILE = orcl.dmp \ -> EXCLUDE = index \ -> TABLE_EXISTS_ACTION = replace \ -> LOGFILE = impdp.log 

Which two statements are true?

DROP TABLESPACE tbs1; 

Which two will ensure that TBS1 is dropped and its datafiles are deleted from the file system?

Name Null? Type ----------------- ------------- ---------------- 

TRANSACTION_ID NOT NULL VARCHAR2 (6) 

TRANSACTION_DATE DATE 

AMOUNT NUMBER(10,2) 

CUSTOMER_ID VARCHAR2 (6) 

Now examine this sequence of statements issued in a new session: 

INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL) ; 

SAVEPOINT a; 

DELETE FROM books; 

ROLLBACK TO SAVEPOINT a; 

ROLLBACK; 

Which three statements are true?

GRANT CREATE VIEW TO usr1 WITH ADMIN OPTION; 

USR1 then executes this command: 

GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION; 

USR2 then executes this command: 

GRANT CREATE VIEW TO usr3; 

Which statement is true?

[oracle@host01 ~]$ expdp system/oracle \ 

> FULL=Y \ 

> DUMPFILE=exp_db_full.dmp \ 

> PARALLEL=4 

> LOGFILE=exp_db_full.log \ 

> JOB_NAME=exp_db_full 

During the export operation, you detach from the job by using 

CTRL+C and then execute this command: 

Export> STOP_JOB= immediate 

Are you sure you wish to stop the job ([yes]/no): yes 

Which two statements are true about the job?