Free Oracle 1Z1-171 Exam Dumps Questions & Answers

What is a role in Oracle Database?

• A.A predefined SQL statement stored in the database
• B.A set of privileges that can be granted to users or other roles
• C.A user-defined function
• D.A database object used to enforce constraints

What happens when the maximum value of a sequence is reached?

• A.The sequence stops generating values.
• B.An error is raised, and the sequence must be recreated.
• C.The sequence resets to the starting value if the CYCLE option is specified.
• D.The sequence starts decrementing values.

Which data dictionary view provides information about all tables accessible to the current user?

• A.USER_TABLES
• B.ALL_TABLES
• C.DBA_TABLES
• D.SESSION_TABLES

Which data dictionary view provides information about all the columns in tables accessible to the current user?

• A.USER_COLUMNS
• B.ALL_TAB_COLUMNS
• C.ALL of the above
• D.DBA_TAB_COLUMNS

Which of the following statements creates an ascending sequence starting at 100 and incrementing by 10?

• A.CREATE SEQUENCE seq_1 START WITH 10 INCREMENT BY 100;
• B.CREATE SEQUENCE seq_1 START WITH 10 INCREMENT BY -100;
• C.CREATE SEQUENCE seq_1 START WITH 100 INCREMENT BY 10;
• D.CREATE SEQUENCE seq_1 START WITH 100 INCREMENT BY -10;