2018 OCP 1z0-071 最新题库

1z0-071.OCM之家.exam.161q

Number: 1z0-071

Passing Score: 800

Time Limit: 120 min

File Version: 2.0

1z0-071

Oracle Database 12c SQL

Exam A

SELECT cust_id CUST_NO, cust_last_name

FROM customers

WHERE country_id = 30

Identify three ORDER BY clauses either one of which can complete the query.

A.

ORDER BY "Last name"

B.

ORDER BY 2, cust_id

C.

ORDER BY CUST_NO

Explanation

Explanation/Reference:

Explanation:

Using the ORDER BY Clause in Set Operations

-The ORDER BY clause can appear only once at the end of the compound query.

-Component queries cannot have individual ORDER BY clauses.

-The ORDER BY clause recognizes only the columns of the first SELECT query.

-By default, the first column of the first SELECT query is used to sort the output in an

ascending order.

QUESTION 2

D. The WHERE clause is used to exclude rows before the grouping of data.

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

Correct Answer: ABD

Section: (none)

Explanation

Explanation/Reference:

QUESTION 3

Which statement is true regarding external tables?

Explanation/Reference:

References:

https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm

QUESTION 4

Which two statements are true about Data Manipulation Language (DML) statements?

A. An INSERT INTO...VALUES.. statement can add multiple rows per execution to a table.

B. An UPDATE... SET... statement can modify multiple rows based on multiple conditions on a table.

C. A DELETE FROM..... statement can remove rows based on only a single condition on a table.

D. An INSERT INTO... VALUES..... statement can add a single row based on multiple conditions on a table.

E. A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.

Correct Answer: BE

QUESTION 5

Which two statements are true regarding roles? (Choose two.)

A. A role can be granted to itself.

B. A role can be granted to PUBLIC.

C. A user can be granted only one role at any point of time.

D. The REVOKE command can be used to remove privileges but not roles from other users.

E. Roles are named groups of related privileges that can be granted to users or other roles.

Correct Answer: BE

Section: (none)

Explanation

B. A foreign key cannot contain NULL values.

C. The column with a UNIQUE constraint can store NULLS.

D. You can have more than one column in a table as part of a primary key.

Correct Answer: CD

Section: (none)

Explanation

Explanation/Reference:

QUESTION 7

Evaluate the following statement.

INSERT ALL

SELECT order_id, order_total, customer_id

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

A. They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

B. They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

C. They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.

D. The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true.

Correct Answer: A

Section: (none)

Explanation

QUESTION 8

MEMBER_ID NOT NULL VARCHAR2 (6)

FIRST_NAME VARCHAR2 (50)

LAST_NAME NOT NULL VARCHAR2 (50)

ADDRESS VARCHAR2 (50)

CITY VARCHAR2 (25)