Examine the structure of the BOOKS_TRANSACTIONS table.

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:

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

• A.MEMBER_ID = NULL;
• B.MEMBER_ID IS NULL;
• C.MEMBER_ID = '';
• D.MEMBER_ID = "";

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true? (Choose three.)

• A.The data dictionary is created and maintained by the database administrator.
• B.The data dictionary views consist of joins of dictionary base tables and user-defined tables.
• C.The usernames of all the users including the database administrators are stored in the data dictionary.
• D.The USER_CONS_COLUMNSview should be queried to find the names of the columns to which constraints apply.
• E.Both USER_OBJECTSand CATviews provide the same information about all the objects that are owned by the user.
• F.Views with the same name but different prefixes, such as DBA, ALLand USER, reference the same base tables from the data dictionary.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following CREATE TABLE command:

Which statement is true regarding the above SQL statement?

• A.It would give an error because the USING INDEX is not permitted in the CRETAE TABLE command.
• B.It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID PK would be created.
• C.It would give an error because the USING INDEX clause cannot be used on a composite primary.
• D.It would execute successfully and only ORD_ITM_IDX index would be created.

Comment: *

Name: *

Email: *

Verification: *

The following are the steps for a correlated subquery, listed in random order:
1. The WHEREclause of the outer query is evaluated.
2. The candidate row is fetched from the table specified in the outer query.
3. This is repeated for the subsequent rows of the table, till all the rows are processed.
4. Rows are returned by the inner query, after being evaluated with the value from the candidate row in the outer query.
Which is the correct sequence in which the Oracle server evaluates a correlated subquery?

• A.2, 1, 4, 3
• B.4, 1, 2, 3
• C.4, 2, 1, 3
• D.2, 4, 1, 3

Comment: *

Name: *

Email: *

Verification: *

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

Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

• A.listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.
• B.listing of customers who do not have a credit limit and were born before 1980
• C.finding the number of customers, in each city, whose marital status is 'married'.
• D.finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'
• E.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers

Comment: *

Name: *

Email: *

Verification: *