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

Examine the data in the PROMO_BEGIN_DATE column of the promotions table:

You want to display the number of promotions started in 1999 and 2000.
Which query gives the correct output?

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

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?

• A.SELECT last_name, department_name, location_id FROM employees , departments ;
• B.SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id =manager_id;
• C.SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id =d.department_id;
• D.SELECT employees.last_name, departments.department_name,
  departments.location_id FROM employees e, departments D WHERE e.department_id
  = d.department_id;

Which constraint can be defined only at the column level?

• A.NOT NULL
• B.CHECK
• C.PRIMARY KEY
• D.FOREIGN KEY
• E.UNIQUE

Study the following exhibit:

Assuming that the sequence SEQ1 was created with the option ORDER and INCREMENT BY set to 1, what value will be returned by the final SELECT statement?

• A.It will depend on whether any other sessions are selecting from the sequence while the statements in the exhibit are being run.
• B.4
• C.2
• D.3

Which is the valid CREATE [TABLE statement?

• A.CREATE TABLE emp9$# (emp_no NUMBER(4). date DATE);
• B.CREATE TABLE emp9$# (emp_no NUMBER(4));
• C.CREATE TABLE emp*123 (emp_no NUMBER(4));
• D.CREATE TABLE 9emp$# (emp_no NUMBER(4));