Oracle Database SQL - 1z1-071 Exam Practice Test

A. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 NOCACHE;

B. CREATE SEQUENCE emp_seq NOCACHE;

C. CREATE SEQUENCE emp_seq;

D. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CACHE;

E. CREATE SEQUENCE emp_seq START WITH 1 CACHE;

F. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CYCLE;

A. COMMIT ends the transaction and makes all its changes permanent.

B. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not release its locks.

C. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not erase its savepoints.

D. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes, releases its locks and erases its savepoints.

E. ROLLBACK TO SAVEPOINT undoes the transaction's changes made since the named savepoint and then ends the transaction.

F. COMMIT erases all the transaction's savepoints and releases its locks.

A. It generates an error because the alias is not valid.

B. It executes successfully but does not give the correct output.

C. IT executes successfully and gives the correct output.

D. It generates an error because the usage of the ROUND function in the expression is not valid.

E. It generates an error because the concatenation operator can be used to combine only two items.

A. SYSDATE can be used in expressions only if the default date format is DD-MON-RR.

B. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds.

C. CURRENT_DATE returns the current date and time as per the session time zone.

D. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server.

E. SYSDATE can be queried only from the DUAL table.

F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.

A. MOD: returns the quotient of a division

B. CONCAT: can be used to combine any number of values

C. INSTR: can be used to find only the first occurrence of a character in a string

D. SYSDATE: returns the database server current date and time

E. TRIM: can be used to remove all the occurrences of a character from a string

F. TRUNC: can be used with number and date values

A. 4,1,2,3

B. 2,1,4,3

C. 4,2,1,3

D. 2,4,1,3

A. GROUP BY ch.channel_type, t.month, co.country_code;

B. GROUP BY CUBE(ch.channel_type, t.month, co.country_code);

C. GROUP BY ch.channel_type, t.month, ROLLUP(co.country_code);

D. GROUP BY ch.channel_type, ROLLUP(t.month, co.country_code);

A. The result of a DELETE can be undone by issuing a ROLLBACK.

B. TRUNCATE can use a WHERE clause to determine which row(s) should be removed.

C. DELETE can use a WHERE clause to determine which row(s) should be removed.

D. The result of a TRUNCATE can be undone by issuing a ROLLBACK.

E. TRUNCATE leaves any indexes on the table in an UNUSABLE state.

A. providing an alternative name for a table

B. preventing data retrieval from a table outside of office hours

C. preventing any data modification to a table

D. creating multiple savepoints to enable partial rollback of a transaction

E. modifying a table to prevent data that violate certain conditions from being entered in a column

A. Compare Period ADDM report

B. Active Session History (ASH) report

C. Taking a new snapshot and comparing it with a preserved snapshot

D. AWR Compare Period report

A. INSERT INTO orders
(order_id,order_date,order_mode,
(customer_id,order_total)
VALUES (1,TO_DATE(NULL), `online', 101, NULL);

B. INSERT INTO
(SELECT order_id,order_date,customer_id
FROM orders)
VALUES (1,'09-mar-2007', 101);

C. INSERT INTO orders
VALUES (1,'09-mar-2007', DEFAULT, 101, DEFAULT);

D. INSERT INTO orders
(order_id,order_date,order_mode,order_total)
VALUES (1,'10-mar-2007',`online',1000);

E. INSERT INTO orders
VALUES (1,'09-mar-2007', `online','', 1000);

A. CURRENT_DATE

B. CURRENT_TIMESTAMP

C. SYSDATE

D. LOCALTIMESTAMP