Oracle 1Z0-071 Quiz 72 Topic 2 Questions 356-360

Question: 1

Which two statements are true about sequences crated in a single instance Oracle database?

AThe numbers generated by an explicitly defined sequence can only be used to insert data in one table.

BDELETE <sequencename> would remove a sequence from the database.

CCURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.

DWhen the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.

EWhen the database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted.

Show Answer

Question: 2

Which three statements are true regarding the SQL WHERE and HAVING clauses?

AThe HAVING clause conditions can have aggregating functions.

BThe HAVING clause conditions can use aliases for the columns.

CThe WHERE and HAVING clauses cannot be used together in a SQL statement.

DThe WHERE clause is used to exclude rows before grouping data.

EThe HAVING clause is used to exclude one or more aggregated results after grouping data.

Show Answer

Question: 3

Evaluate the following statement.

INSERT ALL

WHEN order_total < 10000 THEN

INTO small_orders

WHEN order_total > 10000 AND order_total < 20000 THEN

INTO medium_orders

WHEN order_total > 200000 THEN

INTO large_orders

SELECT order_id, order_total, customer_id

FROM orders;

Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

AEach row is evaluated by the first WHEN clause and if the condition is false then the row would be evaluated by the subsequent when clauses.

BAll rows are evaluated by all the three WHEN clauses.

CEach row is evaluated by the first WHEN clause and if the condition is true, then the row would be evaluated by the subsequent when clauses.

DThe INSERT statement will return an error because the ELSE clause is missing.

Show Answer

Question: 4

Which two statements are true regarding the SQL GROUP BY clause?

AYou can use a column alias in the GROUP BY clause.

BUsing the WHERE clause after the GROUP BY clause excludes rows after creating groups.

CThe GROUP BY clause is mandatory if you are using an aggregating function in the SELECT clause.

DUsing the WHERE clause before the GROUP BY clause excludes rows before creating groups.

EIf the SELECT clause has an aggregating function, then columns without an aggregating function in the SELECT clause should be included in the GROUP BY clause.

Show Answer

Question: 5

You issue this command which succeeds:

SQL> DROP TABLE products;

Which three statements are true?

AAll existing views and synonyms that refer to the table are invalidated but retained.

BAny uncommitted transaction in the session is committed.

CTable data and the table structure are deleted.

DAll the table's indexes if any exist, are invalidated but retained.

ETable data is deleted but the table structure is retained.

Show Answer

Oracle 1Z0-071 Quiz:72 Topic:2 Questions:356-360