Oracle 1z0-071 Dumps Dumps PDF - Latest 1z0-071 Dumps Practice Test Questions
SAMPLE QUESTIONS:
Question No. 1
Which two statements are true regarding operators used with subqueries (Choose two.)
A. The NOT IN operator is equivalent to IS NULL.
B. The <ANY operator means less than the maximum.
C. =ANY and =ALL operators have the same functionality.
D. The IN operator cannot be used in single-row subqueries.
E. The NOT operator can be used with IN, ANY and ALL operators.
ANSWER : B, E
Question No. 2
You create a table by using this command: CREATE TABLE rate_list (rate NUMBER(6,2)); Which two are true about executing statements?
A. INSERT INTO rate_list VALUES (-10) produces an error.
B. INSERT INTO rate_list VALUES (87654.556) inserts the value as 87654.6.
C. INSERT INTO rate_list VALUES (0.551) inserts the value as .55.
D. INSERT INTO rate_list VALUES (-99.99) inserts the value as 99.99.
E. INSERT INTO rate_list VALUES (0.999) produces an error.
F. INSERT INTO rate_list VALUES (-.9) inserts the value as -.9.
ANSWER : C, D
Question No. 3
Which two statements are true regarding working with dates? (Choose two.)
A. The RR date format automatically calculates the century from the SYSDATE function but allows the session user to enter the century.
B. The RR date format automatically calculates the century from the SYSDATE function and does not allow a session user to enter the century.
C. The default internal storage of dates is in character format.
D. The default internal storage of dates is in numeric format.
ANSWER : A, D
Question No. 4
You issued this command: SQL > DROP TABLE employees; Which three statements are true? (Choose three.)
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 : B, C, F
Question No. 5
Which three statements are true about multiple row subqueries?
A. They can contain GROUP BY clauses.
B. They can return multiple columns.
C. Two or more values are always returned from the subquery.
D. They can contain HAVING clauses.
E. They cannot contain a subquery.
ANSWER : A, B, C
FOR MORE INFORMATION
VISIT NOW:
Comments
Post a Comment