1z0-061 무료 덤프문제 온라인 액세스

View the Exhibit and examine the structure of ORD and ORD_ITEMS tables.
The ORD_NO column is PRIMARY KEY in the ORD table and the ORD_NO and ITEM_NO columns are composite PRIMARY KEY in the ORD_ITEMS table.
Which two CREATE INDEX statements are valid? (Choose two.)

• A.CREATE INDEX ord_idx1ON ord(ord_no);
• B.CREATE INDEX ord_idx3ON ord_items(item_no);
• C.CREATE INDEX ord_idx4ON ord, ord_items(ord_no, ord_date, qty);
• D.CREATE INDEX ord_idx2ON ord_items(ord_no);

Which tasks can be performed using SQL functions that are built into Oracle database?
(Choose three.)

• A.comparing two expressions to check whether they are equal
• B.adding a number to a date for a resultant date value
• C.checking whether a specified character exists in a given string
• D.finding the remainder of a division
• E.removing trailing, leading, and embedded characters from a character string

Examine the structure of the STUDENTS table:

You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.
Which SQL statement accomplishes this task?

• A.SELECT . student_ id, marks, ROWNUM "Rank"FROM . studentsWHERE . ROWNUM
  < = 10AND . finish_date BETWEEN '01-JAN-99' AND '31-DEC-99AND . course_id
  'INT_SQL'ORDER BY . marks DESC;
• B.SELECT . student_id, marks, ROWNUM "Rank". FROM . (SELECT student_id, marks.
  FROM . students. WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99'. AND course_id = 'INT_SQL'. ORDER BY marks DESC). WHERE . ROWNUM <= 10 ;.
• C.SELECT . student_id, marks, ROWID "Rank". FROM . students. WHERE . ROWID <
  1 0. AND . finish_date BETWEEN '01-JAN-99' AND '31-DEC-99'. AND . course_id
  'INT_SQL'. ORDER BY . marks;
• D.SELECT. student id, marks, ROWNUM "Rank". FROM. (SELECT student_id, marks.
  FROM students. ORDER BY marks). WHERE. ROWNUM <= 10. AND. finish date
  BETWEEN '01-JAN-99' AND '31-DEC-99'. AND. course_id = 'INT_SQL';
• E.SELECT . student_id, marks, ROWNUM "Rank". FROM . (SELECT student_id, marks.
  FROM . students. WHERE . ROWNUM <= 10. AND . finish_date BETWEEN '01-JAN-99' AND '31-DEC-. 99'. AND . course_id = 'INT_SQL'. ORDER BY . marks DESC);

Which two statements are true about sequences created in a single instance database?
(Choose two.)

• A.DELETE <sequencename> would remove a sequence from the database
• B.When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement
• C.The numbers generated by a sequence can be used only for one table
• D.When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted
• E.CURRVAL is used to refer to the last sequence number that has been generated

View the Exhibit and examine the data in the employees table:

You want to display all the employee names and their corresponding manager names.
Evaluate the following query:

Which join option can be used in the blank in the above query to get the required output?

• A.FULL OUTER JOIN
• B.LEFT OUTER JOIN
• C.RIGHT OUTER JOIN
• D.INNER JOIN