Which three statements are true about defining relations between tables in a relational database?

• A.Every primary or unique key value must refer to a matching foreign key value.
• B.Every foreign key value must refer to a matching primary or unique key value.
• C.Foreign key columns allow null values.
• D.Unique key columns allow null values.
• E.Primary key columns allow null values.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the CUSTOMERStable.

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

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

You issued this command: DROP TABLE hr. employees;
Which three statements are true?

• A.All indexes defined on HR, EMPLOYEES are dropped.
• B.Synonyms for HR EMPLOYEES are dropped.
• C.Views referencing HR, EMPLOYEES are dropped.
• D.Sequences used to populate columns in the HR. EMPLOYEES table are dropped.
• E.ALL constraints defined on HR, EMPLOYEES are dropped.
• F.The HR. EMPLOYEES table may be moved to the recycle bin.

Comment: *

Name: *

Email: *

Verification: *

Which statement correctly grants a system privilege?

• A.GRANT CREATE VIEWON table1 TOuser1;
• B.GRANT ALTER TABLETO PUBLIC;
• C.GRANT CREATE SESSIONTO ALL;
• D.GRANT CREATE TABLETO user1, user2;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the details of the PRODUCT_INFORMATION table. (Choose two.)

Evaluate this SQL statement:
SELECT TO_CHAR(list_price,'$9,999')
From product_information;
Which two statements are true regarding the output? (Choose two.)

• A.A row whose LIST_PRICE column contains value 11235.90 would be displayed as $1,123.
• B.A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,123.
• C.A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,124.
• D.A row whose LIST_PRICE column contains value 11235.90 would be displayed as #######.

Comment: *

Name: *

Email: *

Verification: *