Oracle 1Z0-071 Quiz 40 Topic 11 Questions 196-200

Question: 1

Which three statements are true regarding subqueries? (Choose three.)

AThe ORDER BY Clause can be used in a subquery.

BA subquery can be used in the FROM clause of a SELECT statement.

CIf a subquery returns NULL, the main query may still return rows.

DA subquery can be placed in a WHERE clause, a GROUP BY clause, or a HAVING clause.

ELogical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a subquery.

Show Answer

Question: 2

Which two statements are true regarding single row functions? (Choose two.)

AMOD: returns the quotient of a division.

BTRUNC: can be used with NUMBER and DATE values.

CCONCAT: can be used to combine any number of values.

DSYSDATE: returns the database server current date and time.

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

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

Show Answer

Question: 3

View the Exhibit and examine the structure of the ORDERS table.

q3_1Z0-071

You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101.

Which query would give you the desired result?

ASELECT order_id, order_date FROM ordersWHERE order_date >ANY(SELECT order_date FROM orders WHERE customer_id = 101);

BSELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT MAX(order_date) FROM orders ) AND customer_id = 101;

CSELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT order_date FROM orders WHERE customer_id = 101);

DSELECT order_id, order_date FROM ordersWHERE order_date > IN(SELECT order_date FROM orders WHERE customer_id = 101);

Show Answer

Question: 4

You must display details of all users whose username contains the string 'ch_'.

Which query generates the required output? (Choose the best answer.)

ASELECT *FROM usersWHERE user_name LIKE '%ch_';

BSELECT *FROM usersWHERE user_name LIKE '%ch_%'ESCAPE'%';

CSELECT *FROM usersWHERE user_name LIKE 'ch\_%' ESCAPE '_';

DSELECT *FROM usersWHERE user_name LIKE '%ch\_%' ESCAPE '\';

Show Answer

Question: 5

Which three statements are true regarding the usage of the WITH clause in complex correlated subqueries? (Choose three.)

AIt can be used only with the SELECT clause.

BThe WITH clause can hold more than one query.

CIf the query block name and the table name are the same, then the table name takes precedence.

DThe query name in the WITH clause is visible to other query blocks in the WITH clause as well as to the main query block

Show Answer

Oracle 1Z0-071 Quiz:40 Topic:11 Questions:196-200