1z0-082 Free Practice Test

In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

1. A. Set OS_AUTHEN_PREFIX to OPS$
2. B. Have the OS administrator add KING to the OSDBA group
3. C. Grant DBA to KING
4. D. Unset REMOTE_LOGIN_PASSWORDFILE
5. E. Alter user KING to be IDENTIFIED EXTERNALLY

Correct Answer: D

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

1. A. They can be written by server processes
2. B. Trace files are written to the Fast Recovery Area (FRA)
3. C. They can be written by background processes
4. D. All trace files contain error information that require contacting Oracle Support
5. E. Trace file names are based on the database name concatenated with a sequential number

Correct Answer: AC

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

1. A. analysis of all privileges used by all users including administrative users in the database
2. B. analysis of all privileges used by all users but excluding administrative users in the database
3. C. analysis of privileges that a user has on their own schema objects that they did not use
4. D. analysis of privileges that a user has on their own schema objects that they did use
5. E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
6. F. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Correct Answer: ACF

Which three statements are true about single-row functions? (Choose three.)

1. A. They can be used only in the WHERE clause of a SELECT statement
2. B. The argument can be a column name, variable, literal or an expression
3. C. The data type returned can be different from the data type of the argument
4. D. They can be nested to any level
5. E. They can accept only one argument
6. F. They return a single result row per table

Correct Answer: BCF

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

1. A. The Oracle join syntax supports creation of a Cartesian product of two tables
2. B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
3. C. The SQL:1999 compliant ANSI join syntax supports natural joins
4. D. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
5. E. The Oracle join syntax only supports right outer joins
6. F. The Oracle join syntax supports natural joins
7. G. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

Correct Answer: CDF