Oracle Database 12c: SQL Fundamentals - 1z0-061 Exam Practice Test

A. The OR REPLACE option is used to change the definition of an existing view without dropping and recreating it.

B. The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.

C. A simple view in which column aliases have been used cannot be updated.

D. Rows added through a view are deleted from the table automatically when the view is dropped.

E. Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.

A. It produces an error because flower braces have been used.

B. It produces an error because the data types are not matching.

C. It executes successfully and introduces an 's at the end of each PROMO_NAME in the output.

D. It executes successfully and displays the literal "{'s start date was \} * for each row in the output.

A. It generates an error because rrrr should be replaced by rr in the format string.

B. It executes successfully but does not return the correct result.

C. It generates an error because TO_CHAR should be replaced with TO_DATE.

D. It generates an error because fm and double quotation marks should not be used in the format string.

E. It executes successfully and returns the correct result.

A. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

B. It fails because no SQL *Loader control file location is specified.

C. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

D. It fails because no SQL *Loader data file location is specified.

A. All data along with the table structure is deleted.

B. A pending transaction in the session is committed.

C. All data in the table is deleted but the table structure remains.

D. All indexes on the table remain but they are invalidated.

E. All views and synonyms remain but they are invalidated.

A. It allows you to insert IDs, last names, and job IDs of the sales staff from the view if it is used in multitable INSERT statements

B. It allows you to insert rows into the EMPLOYEES table

C. It allows you to update job IDs of the existing sales staff to any other job ID in the EMPLOYEES table

D. It allows you to delete details of the existing sales staff from the EMPLOYEES table

A. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY gpa DESC, semester_end ASC;

B. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY gpa DESC, semester_end DESC;

C. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY
semester_end DESC, gpa DESC;

D. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY
semester_end, gpa DESC

E. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY gpa DESC, semester_end ASC;

F. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY
semester_end, gpa ASC

A. A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be updated

B. A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table

C. A view is created with the sub query having the DISTINCT keyword can be updated

D. A sub query that defines a view cannot include the GROUP BY clause

A. SELECT transdate + '10' FROM cust_trans;

B. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';

C. SELECT * FROM cust_trans WHERE transdate = '01-01-07';

D. SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;

E. SELECT transamt FROM cust_trans WHERE custno > '11';

A. A table name can be of any length.

B. A table and a view can have the same name in the same schema.

C. The same table name can be used in different schemas in the same database.

D. A table and a synonym can have the same name in the same schema.

E. A column that has a DEFAULT value cannot store null values.

F. A table can have any number of columns.

A. 45 and 45.93

B. 46 and 45.93

C. 50 and 45.93

D. 46 and 45

E. 45.95 and 45.93

F. 50 and 45.9

A. CHECK

B. NOT NULL

C. PRIMARY KEY

D. FOREIGN KEY

E. UNIQUE

A. SELECT promo_begin_dateFROM promotionsWHERE
TO_CHAR(promo_begin_date,'mon dd yy')='jul 01 98';

B. UPDATE promotionsSET promo_cost = promo_cost+ 100WHERE promo_end_date > TO_DATE(SUBSTR('01-JAN-2000', 8));

C. UPDATE promotionsSET promo_cost = promo_cost+ 100WHERE
TO_CHAR(promo_end_date,'yyyy') > '2000';

D. SELECT TO_CHAR(promo_begin_date,'dd/month')FROM promotionsWHERE
promo_begin_date IN (TO_DATE('JUN 01 98'), TO_DATE('JUL 01 98'));

A. The total price value would be lower than the correct value.

B. The total price value would be higher than the correct value.

C. It produces a syntax error.

D. The result remains unchanged.