View the Exhibit and examine the structure of the BOOKStable.

The BOOKS table contains details of 100 books.
Examine the commands executed and their outcome:

Which statement is true?

• A.Both ROLLBACKcommands restore the 100 rows that were deleted.
• B.Both ROLLBACKcommands restore the 101 rows that were deleted.
• C.The first rollback restores the 100 rows that were deleted and the second rollback commits only the changes.
• D.The first rollback restores the 101 rows that were deleted and the second rollback causes the row was inserted to be deleted and commits the changes.

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?

• A.listing of customers who do not have a credit limit and were born before 1980
• B.listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.
• C.finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'
• D.finding the number of customers, in each city, who's marital status is 'married'.
• 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: *

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 database administrators are stored in the data dictionary.
• D.The USER_CONS_COLUMNSview should be queried to find the names of columns to which constraints apply.
• E.Both USER_OBJECTSand CATviews provide the same information about all 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: *

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

• A.Employees 100 and 200 will have the same JOB_ID as before the update command
• B.Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• C.Employees 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
• D.Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• E.Employees 100 and 200 will have the same SALARY as before the update command
• F.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about aggregate functions?

• A.The AVG function implicitly converts NULLSto zero.
• B.Aggregate functions can be nested to any number of levels.
• C.The MAXand MINfunctions can be used on columns with character data types.
• D.Aggregate functions can be used in any clause of a SELECTstatement.

Comment: *

Name: *

Email: *

Verification: *