Question 1

You issued this command: SQL > DROP TABLE employees; Which three statements are true? (Choose three.)

Options :

A : Sequences used in the EMPLOYEES table become invalid.

B : If there is an uncommitted transaction in the session, it is committed.

C : All indexes and constraints defined on the table being dropped are also dropped.

D : The space used by the EMPLOYEES table is always reclaimed immediately.

E : The EMPLOYEES table can be recovered using the ROLLBACK command.

F : The EMPLOYEES table may be moved to the recycle bin.

Answer: A,B,C

Question 2

You execute these commands:

SQL> DEFINE hiredate = '01-APR -2011';

SQL> SELECT employee_id, first_name, salary FROM employees WHERE hire date > &hiredate AND manager_id >&mgr_id;

For which substitution variables will you be prompted?

Options :

A : none

B : &hiredate and &mgr_id

C : only &hiredate

D : only &mgr_id

Answer: D

Question 3

Which two statements are true regarding the SQL GROUP BY clause? (Choose two.)

Options :

A : You can use a column alias in the GROUP BY clause.

B : Using the WHERE clause after the GROUP BY clause excludes rows after creating groups.

C : The GROUP BY clause is mandatory if you are using an aggregating function in the SELECT clause.

D : Using the WHERE clause before the GROUP BY clause excludes rows before creating groups.

E : If the SELECT clause has an aggregating function, then columns without an aggregating function in the SELECT clause should be included in the GROUP BY clause.

Answer: A,D

Question 4

Which three statements are true regarding the data types? (Choose three.)

Options :

A : The minimum column width that can be specified for a varchar2 data type column is one

B : Only one LONG column can be used per table.

C : A TIMESTAMP data type column stores only time values with fractional seconds.

D : The BLOB data type column is used to store binary data in an operating system file.

E : The value for a CHAR data type column is blank-padded to the maximum defined column width.

Answer: A,B,E

Question 5

Examine the description of the EMPLOYEES table:

You write this falling statement:

SELECT dept-no AS department_id MAX (salary) AS max-sal

FROM employees

WHERE salary > 10000

GROUP BY department_id

ORDER BY max-sal:

Which clause causes the error?

Options :

A : WHERE

B : SELECT

C : ORDER BY

D : GROUP BY

Answer: D

Fill Preparation Gaps with Free Online 1Z0-071 Exam Practice

Buying Options: