Online Access Free 1Z1-051 Exam Questions

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

• A.CURRVAL is used to refer to the last sequence number that has been generated
• B.The numbers generated by a sequence can be used only for one table
• C.When the MAXVALUE limit for a sequence isreached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement
• 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.DELETE would remove a sequence from the database

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

• A.Combining more than two columns or expressions into a single column in the output
• B.Displaying a date in a nondefault format
• C.Finding the number of characters in an expression
• D.Substituting a character string in a text expression with a specified string

Which view should a user query to display the columns associated with the constraints on a table owned by the user?

• A.USER_CONSTRAINTS
• B.USER_COLUMNS
• C.USER_OBJECTS
• D.ALL_CONSTRAINTS
• E.USER_CONS_COLUMNS

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.SELECTstudent_ id, marks, ROWNUM "Rank"
  FROMstudents
  WHEREROWNUM <= 10
  ANDfinish_date BETWEEN '01-JAN-99' AND '31-DEC-99
  ANDcourse_id = 'INT_SQL'
  ORDER BYmarks DESC;
• B.SELECTstudent_id, marks, ROWID "Rank"
  FROMstudents
  WHEREROWID <= 10
  ANDfinish_date BETWEEN '01-JAN-99' AND '31-DEC-99'
  ANDcourse_id = 'INT_SQL'
  ORDER BYmarks;
• C.SELECTstudent_id, marks, ROWNUM "Rank"
  FROM(SELECT student_id, marks
  FROMstudents
  WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99'
  AND course_id = 'INT_SQL'
  ORDER BY marks DESC)
  WHEREROWNUM <= 10 ;
• D.SELECTstudent id, marks, ROWNUM "Rank"
  FROM(SELECT student_id, marks
  FROM students
  ORDER BY marks)
  WHEREROWNUM <= 10
  ANDfinish date BETWEEN '01-JAN-99' AND '31-DEC-99'
  ANDcourse_id = 'INT_SQL';
• E.SELECTstudent_id, marks, ROWNUM "Rank"
  FROM(SELECT student_id, marks
  FROMstudents
  WHEREROWNUM <= 10
  ANDfinish_date BETWEEN '01-JAN-99' AND '31-DEC-
  99'
  ANDcourse_id = 'INT_SQL'
  ORDER BYmarks DESC);

The user Sue issues this SQL statement:
GRANT SELECT ON sue.EMP TO alice WITH GRANT OPTION;
The user Alice issues this SQL statement:
GRANT SELECT ON sue.EMP TO reena WITH GRANT OPTION;
The user Reena issues this SQL statement:
GRANT SELECT ON sue.EMP TO timber;
The user Sue issues this SQL statement:
REVOKE select on sue.EMP FROM alice;
For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?

• A.Alice only
• B.Sue, Alice, Reena, and Timber
• C.Alice, Reena, and Timber
• D.Alice and Reena