Online Access Free 1Z0-082 Practice Test

Which two statements are true about Database Instances and Real Application Clusters (RAC)?

• A.A RAC database can have one Instance.
• B.Two RAC databases can share their instances.
• C.A RAC database must have three or more Instances.
• D.A RAC database can have instances on separate servers.
• E.A RAC database must have two or more instances.

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

• A.The sales user must have been granted the CREATE SESSION privilege
• B.The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
• C.The sales user must have a quota on the TEMP tablespace
• D.The sales user must have their quota on the users tablespace removed
• E.The sales user must have been granted the CREATE TABLE privilege
• F.The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

• A.Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
• B.Base tables can be queried directly
• C.Usernames of all users including database administrators are stored in the data dictionary
• D.The data dictionary is created and maintained by the database administrator
• E.Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
• F.It is owned by the SYSTEM user

Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

• A.The value is changed only in the PFILE and takes effect at the next instance startup
• B.It fails because the SCOPE clause is missing
• C.The value is changed for the current instance and in the PFILE
• D.Change is applied to the current instance, but does not persist after instance restart

Which two statements are true regarding a SAVEPOINT? (Choose two.)

• A.A SAVEPOINT does not issue a COMMIT
• B.Rolling back to a SAVEPOINT can undo a TRUNCATE statement
• C.Only one SAVEPOINT may be issued in a transaction
• D.Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
• E.Rolling back to a SAVEPOINT can undo a DELETE statement