Oracle 1Z0-071 Quiz 25 Topic 7 Questions 121-125

Question: 1

Examine the structure of the BOOKS_TRANSACTIONS table.

q1_1Z0-071

You want to update this table such that BOOK_ID is set to 'INVALID' for all rows where no MEMBER_ID has been entered.

Examine this partial SQL statement:

q1_1Z0-071

Which condition must be used in the WHERE clause to perform the required update?

AMEMBER_ID = '';

BMEMBER_ID = NULL;

CMEMBER_ID IS NULL;

DMEMBER_ID = '';

Show Answer

Question: 2

Evaluate the following SQL commands:

q2_1Z0-071

The command to create a table fails. Identify the reason for the SQL statement failure.

AYou cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD_NO is also the FOREIGN KEY.

BYou cannot use the BETWEEN clause in the condition of a CHECK constraint.

CYou cannot use the NEXTVAL sequence value as a DEFAULT value for a column.

DYou cannot use SYSDATE in the condition of a CHECK constraint.

Show Answer

Question: 3

Evaluate the following query:

q3_1Z0-071

What would be the outcome of the above query?

AIt produces an error because the data types are not matching.

BIt executes successfully and displays the literal ' {'s start date was \> ' for each row in the output.

CIt executes successfully and introduces an 's at the end of each promo_name in the output.

DIt produces an error because flower braces have been used.

Show Answer

Question: 4

View the exhibit and examine the description for the SALES and CHANNELS tables.

q4_1Z0-071

You issued this SQL statement:

q4_1Z0-071

Which statement is true regarding the result?

AThe statement will fail because the subquery in the VALUES clause is not enclosed within single quotation marks.

BThe statement will fail because a subquery cannot be used in a VALUES clause.

CThe statement will fail because the VALUES clause is not required with a subquery.

DThe statement will execute and a new row will be inserted in the SALES table.

Show Answer

Question: 5

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

q5_1Z0-071

Evaluate the following SQL statement:

q5_1Z0-071

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

AIt returns an error because the BETWEEN operator cannot be used in the HAVING clause.

BIt returns an error because WHERE and HAVING clauses cannot be used in the same SELECT statement.

CIt returns an error because WHERE and HAVING clauses cannot be used to apply conditions on the same column.

DIt executes successfully.

Show Answer

Oracle 1Z0-071 Quiz:25 Topic:7 Questions:121-125