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.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, who's marital status is 'married'.
• D.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers
• E.finding the average credit limit of male customers residing in 'Tokyo'or 'Sydney'

Comment: *

Name: *

Email: *

Verification: *

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

Which two tasks would require subqueries? (Choose two.)

• A.display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE.
• B.display all products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
• C.display suppliers whose PROD_LIST_PRICE is less than 1000
• D.display the total number of products supplied by supplier 102 and have product status as 'OBSOLETE'
• E.display the minimum PROD_LIST_PRICE for each product status

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the CUSTOMERS table: (Choose two.)

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?

• A.Subquery
• B.Full outer-join with self-join
• C.Self-join
• D.Left outer-join with self-join
• E.Right outer-join with self-join

Comment: *

Name: *

Email: *

Verification: *

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

You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the 'INTERNET' category.
Which query would give you the required output?

• A.SELECT promo_name, promo_begin_date FROM promotionsWHERE
  promo_begin_date > ALL (SELECT promo_begin_dateFROM promotionsWHERE
  promo_category = 'INTERNET');
• B.SELECT promo_name, promo_begin_date FROM promotionsWHERE
  promo_begin_date> ANY (SELECT promo_begin_dateFROM promotionsWHERE
  promo_category= 'INTERNET');
• C.SELECT promo_name, promo_begin_date FROM promotionsWHERE
  promo_begin_date> ALL (SELECT MAX (promo_begin_date)FROM promotions)
  ANDpromo_category= 'INTERNET';
• D.SELECT promo_name, promo_begin_date FROM promotionsWHERE
  promo_begin_date IN (SELECT promo_begin_dateFROM promotionsWHERE
  promo_category= 'INTERNET');

Comment: *

Name: *

Email: *

Verification: *

Which three actions can you perform only with system privileges? (Choose three.)

• A.Use the WITH GRANT OPTIONclause.
• B.Log in to a database.
• C.Execute a procedure in another schema.
• D.Access flat files via a database, which are stored in an operating system directory.
• E.Query any table in a database.
• F.Truncate a table in another schema.

Comment: *

Name: *

Email: *

Verification: *