Oracle 1Z0-071 Quiz 62 Topic 5 Questions 306-310

Question: 1

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

AALTER TABLE SPLIT PARTITION

BALTER TABLE MERGE PARTITION

CALTER TABLE TRUNCATE PARTITION

DALTER TABLE ADD PARTITION

EALTER TABLE DROP PARTITION

FALTER TABLE MOVE PARTITION

Show Answer

Question: 2

View the Exhibit and examine the structures of the employees and departments tables.

q2_1Z0-071

You must update the employees table according to these requirements::

-Update only those employees who work in Boston or Seattle (locations 2900 and 2700).

-Set department_id for these employees to the department id corresponding to London (locationid 2100).

-Set the employees' salary in iocation_id 2100 to 1.1 times the average salary of their department.

-Set the employees' commission In location_id 2100 to 1.5 times the average commission of their department.

You issue this command:

q2_1Z0-071

What is the result?

AIt executes successfully but does not produce the desired update.

BIt executes successfully and produces the desired update.

CIt generates an error because multiple columns cannot be specified together in an UPDATE statement.

DIt generates an error because a subquery cannot have a join condition in an update statement.

Show Answer

Question: 3

View the Exhibit and examine the data in the employees table.

q3_1Z0-071

You want to generate a report showing the total compensation paid to each employee to date.

You issue the following query:

q3_1Z0-071

What is the outcome?

AIt executes successfully but does not give the correct output.

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

CIt generates an error because the usage of the round function in the expression is not valid

DIt generates an error because the alias is not valid.

EIt executes successfully and gives the correct output.

Show Answer

Question: 4

Evaluate the following query:

q4_1Z0-071

Which is the correct output of the above query?

A+00-300, +54-02,+00 11:12:10.123457

B+00-300,+00-650,+00 11:12:10.123457

C+25-00, +54-02, +00 11:12:10.123457

D+25-00,+00-650,+00 11:12:10.123457

Show Answer

Question: 5

Examine the commands used to create the DEPARTMENT_DETAILS and the COURSE-DETAILS tables:

SQL> CREATE TABLE DEPARTMfiNT_DTAILS

DEPARTMENT_ID NUMBER PRIMARY KEY ,

DEPARTMEHT_NAME VARCHAR2(50) ,

HOD VARCHAP2(50));

SQL> CREATE TABLE COURSE-DETAILS

(COURSE ID NUMBER PRIMARY KEY ,

COURS_NAME VARCHAR2 (50) ,

DEPARTMEHT_ID NUMBER REFERENCES DEPARTMENT_DETAIL

You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.

Which SQL statement must you use?

ASELECT d.departranc_id, c.cours_id FROM cource_deatils c LEFT OUTER JOIN departmnt_details d ON (c.dapartmsnt_id=d.departtnent_id);

BSELECT d.department_id, c. course_id FROM dapartment_details d RIGHT OUTER JOIN course_dotails c ON (c.depattnient_id=d.department_id) ;

CSELECT d.department id. ccours_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d.department_id);

DSELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON (d.department___id).- (DEPARTMENT_ID) ;

Show Answer

Oracle 1Z0-071 Quiz:62 Topic:5 Questions:306-310