Online Access Free 1z1-061 Practice Test

What is true about sequences?

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

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
NEW_EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
NAME VARCHAR2(60)
Which MERGE statement is valid?

• A.MERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT INTO new_employees VALUES (e.employee_id, e.first_name ||', '||e.last_name);
• B.MERGE new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET c.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES (e.employee_id, e.first_name ||', '||e.last_name);
• C.MERGE INTO new_employees c USING employees e ON (c.employee_id
  e.employee_id) WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES (e.employee_id, e.first_name ||', '||e.last_name);
• D.MERGE INTO new_employees c USING employees e ON (c.employee_id
  e.employee_id) WHEN EXISTS THEN UPDATE SET c.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES(e.employee_id, e.first_name ||', '||e.last_name);

Which two statements complete a transaction? (Choose two)

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

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
EMP_NAME VARCHAR2(30)
JOB_ID NUMBER\
SAL NUMBER
MGR_ID NUMBER . References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER . Foreign key to DEPARTMENT_ID column of the. .
DEPARTMENTS table
You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table.
Which two statements regarding the EMP_ID_SEQ sequence are true? (Choose two.)

• A.The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
• B.Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
• C.You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
• D.The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
• E.The EMP_ID_SEQ sequence is dropped automatically when you drop the
  EMPLOYEE_ID column.
• F.The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.

View the Exhibit and examine the data in the promotions table.

PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name, cost, and start date of all promos in the post category that were launched before January 1, 2000.
Which SQL statement would you use?

• A.Option D
• B.Option A
• C.Option B
• D.Option C