Oracle Database: SQL Fundamentals I - 1Z0-051 Exam Practice Test

A. SELECT promo_name, TO_CHAR(promo_end_date,'Day') ', '
TO_CHAR(promo_end_date,'Month') ' '
TO_CHAR(promo_end_date,'DD, YYYY') AS last_day
FROM promotions;

B. SELECTpromo_name,TO_CHAR(promo_end_date,'fmDay')','
TO_CHAR(promo_end_date,'fmMonth') ' '
TO_CHAR(promo_end_date,'fmDD, YYYY') AS last_day
FROM promotions;

C. SELECT promo_name, TRIM(TO_CHAR(promo_end_date,'Day')) ', ' TRIM(TO_CHAR
(promo_end_date,'Month')) ' '
TRIM(TO_CHAR(promo_end_date,'DD, YYYY')) AS last_day
FROM promotions;

D. SELECT promo_name,TO_CHAR (promo_end_date,'fxDay') ', '
TO_CHAR(promo_end_date,'fxMonth') ' '
TO_CHAR(promo_end_date,'fxDD, YYYY') AS last_day
FROM promotions;

A. You cannot add a new column to the table with LONG as the data type

B. An EMP_IMAGE column can be included in the GROUP BY clause

C. You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column

D. An EMP_IMAGE column cannot be included in the ORDER BY clause

A. The DROP SYNONYM statement removes the synonym and the table on which the synonym has been created becomes invalid

B. Synonyms can be created only for a table

C. A public synonym and a private synonym can exist with the same name for the same table

D. Synonyms are used to reference only those tables that are owned by another user

A. SELECT * FROM custjrans WHERE transdate = '01-01-07':

B. SELECT transdate + '10' FROM custjrans;

C. SELECT custno - 'A' FROM custjrans WHERE transamt > 2000:

D. SELECT * FROM custjrans WHERE transdate='01-JANUARY-07':

E. SELECT transamt FROM custjrans WHERE custno > '11':

A. After it is enforced by a SELECT statement, no other query can access the same rows until a COMMIT or ROLLBACK is issued.

B. It can be used in SELECT statements that are based on a single or multiple tables.

C. It locks the rows that satisfy the condition in the SELECT statement.

D. It locks only the columns specified in the SELECT list.

E. It can be used only in SELECT statements that are based on a single table.

A. You want to work on your own tables.

B. You have too many columns in your tables.

C. Your tables names are too long.

D. Your tables have difficult names.

E. You have too many tables.

F. You want to use another schema's tables.

A. Both the statements execute and give different results

B. Only the second SQL statement executes successfully

C. Both the statements execute and give the same result

D. Only the first SQL statement executes successfully

A. 100

B. 160

C. 200

D. 150

E. 16

A. The statement fails because there is more than one row matching the employee name Smith.

B. The statement fails because there is no 'Administration' department in the DEPARTMENTS table.

C. The statement fails because there is more than one row matching the IT_ADMIN job ID in the EMPLOYEES table.

D. The statement executes successfully, leaves the manager ID as the existing value, and changes the salary to 4000 for the employees with ID 103 and 105.

E. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 3000 for the employees with ID 103 and 105.

F. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 4000 for the employees with ID 103 and 105.

A. All data in the table is deleted, and the table structure is also deleted.

B. You cannot roll back this statement.

C. All indexes based on the DEPT table are dropped.

D. All pending transactions are committed.

E. All views based on the DEPT table are deleted.

F. All data in the table is deleted, but the structure of the table is retained.

G. All synonyms based on the DEPT table are deleted.