Online Access Free 1Z1-182 Practice Test

Which two statements are true about database instances and Real Application Clusters (RAC)?

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

You execute this command: CREATE BIGFILE TABLESPACE big_tbs DATAFILE '/u01/oracle/data/big_f1.dbf' SIZE 20G; Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace?

• A.It must be bigger than the largest SMALLFILE tablespace.
• B.Additional data files may not be added.
• C.It will always have a 32K blocksize.
• D.It will be a dictionary-managed tablespace by default.
• E.AUTOEXTEND is possible for the datafile.

You must create a tablespace of nonstandard block size in a new file system and plan to use this command: CREATE TABLESPACE ns_tbs DATAFILE '/u02/oracle/data/nstbs_f01.dbf' SIZE 100G BLOCKSIZE 32K; The standard block size is 8K, but other nonstandard block sizes will also be used. Which two are requirements for this command to succeed?

• A.DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.
• B.DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.
• C.The operating system must use a 32K block size.
• D.The /u02 file system must have at least 100G space for the datafile.
• E.DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.

Which two SQL Plan Management Advisor tasks are part of Automatic Maintenance Tasks?

• A.The Automatic SQL Access Advisor task, which is used to manage an application SQL load.
• B.The Automatic Index Advisor task, which is used to create and maintain table indexes based on the DML load and operations.
• C.The Automatic SQL Plan Management Evolve Advisor task, which evolves plans that have recently been added as the SQL plan baseline for statements.
• D.The Automatic SQL Tuning Advisor tasks, which would examine the performance of high-load SQL statements and make recommendations for those statements.
• E.The Automatic SQL Performance Analyzer task, which is used to provide details about impact of database changes to application SQL batch.

Which statement regarding PDBs (Pluggable Databases) is correct?

• A.When the relocation of a PDB is finished, the source PDB must be dropped.
• B.You can drop a PDB as long as it is not the PDB seed.
• C.You can drop an application root along with the associated PDBs.
• D.You cannot drop a source PDB of a refreshable PDB.