Oracle 1Z0-071 Quiz 19 Topic 3 Questions 91-95

Question: 1

Evaluate the following SQL statement:

q1_1Z0-071

Which statement is true regarding the outcome of the above query?

AIt executes successfully and displays rows in the descending order of PROMO_CATEGORY.

BIt produces an error because positional notation cannot be used in the ORDER BY clause with SET operators.

CIt executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement.

DIt produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last SELECT statement.

Show Answer

Question: 2

View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE and ORDER_TOTAL have the default values 'direct' and 0 respectively.

q2_1Z0-071

Which two INSERT statements are valid? (Choose two.)

AINSERT INTO ordersVALUES (1,'09-mar-2007', 'online','', 1000);

BINSERT INTO orders(order_id,order_date,order_mode,(customer_id,order_total)VALUES (1,TO_DATE(NULL), 'online', 101, NULL);

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

DINSERT INTO ordersVALUES (1,'09-mar-2007', DEFAULT, 101, DEFAULT);

EINSERT INTO orders(order_id,order_date,order_mode,order_total)VALUES (1,'10-mar-2007','online',1000);

Show Answer

Question: 3

What is the primary difference between the relational database (RDB) and object-oriented database (OODB) models?

AOODB supports multiple objects in the same database, whereas RDB supports only tables.

BRDB supports only E.F. Codd's rules, whereas OODB does not support them.

COODB incorporates methods with data structure definition, whereas RDB does not allow this.

DRDB allows the definition of relationships between different tables, whereas OODB does not allow this.

Show Answer

Question: 4

Examine the command to create the BOOKS table.

q4_1Z0-071

The BOOK_ID value 101 does not exist in the table.

Examine the SQL statement:

q4_1Z0-071

Which statement is true?

AIt executes successfully and the row is inserted with a rule PUBLISHER_ID.

BIt executes successfully only if NULL is explicitly specified in the INSERT statement.

CIt executes successfully only if the PUBLISHER_ID column name is added to the columns list in the INSERT statement.

DIt executes successfully only if the PUBLISHER_ID column name is added to the columns list and NULL is explicitly specified in the INSERT statement.

Show Answer

Question: 5

You need to list the employees in DEPARTMENT_ID 20 days in a single row, ordered by HIRE_DATE.

Examine the sample output:

q5_1Z0-071

Which query will provide the required output?

ASELECT LISTAGG(last_name)WITHIN GROUP ORDER BY (hire_date) ''Emp_list'', MIN(hire_date) ''Earliest''FROM employeesWHERE department_id = 30;

BSELECT LISTAGG(last_name, '; ')WITHIN GROUP ORDER BY (hire_date) ''Emp_list'', MIN(hire_date) ''Earliest''FROM employeesWHERE department_id = 30;

CSELECT LISTAGG(last_name, '; ') ''Emp_list'', MIN(hire_date) ''Earliest''FROM employeesWHERE department_id = 30;WITHIN GROUP ORDER BY (hire_date);

DSELECT LISTAGG(last_name, '; ') ''Emp_list'', MIN(hire_date) ''Earliest''FROM employeesWHERE department_id = 30;ORDER BY (hire_date);

Show Answer

Oracle 1Z0-071 Quiz:19 Topic:3 Questions:91-95