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

Which four are attributes of single row functions? (Choose four.)

• A.accept arguments which can be a column or an expression
• B.act on each row returned
• C.manipulate data items
• D.cannot be nested
• E.accept only one argument and return only one value
• F.return one result per row

Which two statements are true regarding the ORDER BY clause? (Choose two.)

• A.It cannot be used in a SELECT statement containing a HAVING clause.
• B.It is executed first in the query execution.
• C.It must be the last clause in the SELECT statement.
• D.You can specify a combination of numeric positions and column names in this clause.
• E.You cannot specify a column name followed by an expression in this clause.

Examine the structure of the customers table:

CUSTNO is the primary key in the table. You want to find out if any customers' details have been entered more than once using different CUSTNO, by listing all the duplicate names.
Which two methods can you use to get the required result?

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

A sequence is created as follows: create sequence seq1 maxvalue 50;
If the current value is already 50, when you attempt to select SEQ1.NEXTVAL what will happen?

• A.There will be an error.
• B.The sequence will reissue 50.
• C.The sequence will cycle and issue 0.
• D.The sequence will cycle and issue 1.

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 e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id =manager_id;
• B.SELECT employees.last_name, departments.department_name,
  departments.location_id FROM employees e, departments D WHERE e.department_id
  = d.department_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 last_name, department_name, location_id FROM employees , departments ;