1z0-061 試験問題を無料オンラインアクセス

Examine the following Entity Relationship Model diagram:

Which three statements are true? (Choose three.)

• A.YEARS_EMPLOYED is a key attribute.
• B.SKILL is a composite attribute.
• C.SKILL is a multi-valued attribute.
• D.YEARS_EMPLOYED is a derived attribute.
• E.EMP_ID is a key attribute.
• F.EMPLOYEE is a weak entity.

What is true about sequences?

• A.The maximum value of descending sequence defaults to 1.
• B.A sequence always increments by 1.
• C.The minimum value of an ascending sequence defaults to 1.
• D.The start value of the sequence is always 1.

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 > ANY (SELECT promo_begin_dateFROM promotionsWHERE
  promo_category = 'INTERNET');
• B.SELECT promo_name, promo_begin_date FROM promotionsWHERE
  promo_begin_date > ALL (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');

Which two statements complete a transaction? (Choose two)

• A.DESCRIBE employees;
• B.GRANT SELECT ON employees TO SCOTT;
• C.ROLLBACK TO SAVEPOINT C;
• D.DELETE employees;
• E.ALTER TABLE employeesSET UNUSED COLUMN sal;
• F.Select MAX(sal)FROM employeesWHERE department_id = 20;

Which statement is true regarding synonyms?

• A.Synonyms are used to reference only those tables that are owned by another user
• B.A public synonym and a private synonym can exist with the same name for the same table
• C.The DROP SYNONYM statement removes the synonym and the table on which the synonym has been created becomes invalid
• D.Synonyms can be created only for a table