View the Exhibit and examine the structure of CUSTOMERStable.

Evaluate the following query:

Which statement is true regarding the above query?

• A.It produces an error because the condition on the CUST_FIRST_NAMEcolumn is not valid.
• B.It executes successfully.
• C.It produces an error because the condition on the CUST_CITYcolumn is not valid.
• D.It produces an error because conditions on the CUST_CREDIT_LIMITcolumn are not valid.

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: *

Examine this query:
SELECT TRUNC(ROUND(156.00, -2), -1) FROM DUAL;
What is the result?

• A.16
• B.200
• C.100
• D.160
• E.150

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the Books_TRANSACTIONS table:

Examine the SQl statement:
SQL> SELECT * FROM books_transactions WHERE brrrowed_data<SYSDATE AND
transaction_type='RM' OR MEMBER_ID IN
('A101; 'A102');
Which statement is true about the outcome?

• A.It displays details only for the members who have borrowed before today with RM as TRANSACTION_TYPE.
• B.It displays details for members who have borrowed before today's with either RM as TRANSACTION_TYPE or MEMBER_ID as A101 and A102.
• C.It displays details for members who have borrowed today with RM as TRANSACTION_TYPE and details for member A101 or A102.
• D.It displays details for only member A101 and A102 have borrowed before today with RM as TRANSACTION-TYPE.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.

The CUSTOMERS table contains the current location of all currently active customers.
The CUST_HISTORY table stores historical details relating to any changes in the location of all current as well as previous customers who are no longer active with the company.
You need to find those customers who have never changed their address.
Which SET operator would you use to get the required output?

• A.UNION ALL
• B.MINUS
• C.INTERSECT
• D.UNION

Comment: *

Name: *

Email: *

Verification: *