多选题 A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）
Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column
Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
多选题 On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）
It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
It fails because no SQL *Loader data file location is specified.
It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
It fails because no SQL *Loader control file location is specified.
单选题 You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）
They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
They are created only in the Fast Recovery Area.
They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.
多选题 What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?（）
Effectively implements role separation
Enables you to take advantage of Oracle Managed Files.
Automatically registers the database with Oracle Restart.
Helps you to easily upgrade the database from a prior release.
Enables the Installation of Grid Infrastructure files on block or raw devices.
多选题 You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）
Corrupted blocks, if any, are repaired.
Checks are performed for physical corruptions.
Checks are performed for logical corruptions.
Checks are performed to confirm whether all database files exist in correct locations
Backup sets containing both data files and archive logs are created.
多选题 Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）
Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
单选题 You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?（）
It succeeds because the PDB_ADMIN user has the required privileges.
It fails because common users are unable to use the SET CONTAINER statement.
It fails because local users are unable to use the SET CONTAINER statement.
If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
单选题 Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?（）
They are able to perform only queries.
They are not affected and continue to function normally.
They are terminated and the active transactions are rolled back.
They are not allowed to perform any operations until the listener LISTENER is started
By default, EM express is available for a database after database creation.
You can use EM express to manage multiple databases running on the same server.
You can perform basic administrative tasks for pluggable databases by using the EM express interface.
You cannot start up or shut down a database Instance by using EM express.
You can create and configure pluggable databases by using EM express.
多选题 You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?（）
Parallel compilation of only the stored PL/SQL code
Sequential recompilation of only the stored PL/SQL code
Parallel recompilation of any stored PL/SQL code
Sequential recompilation of any stored PL/SQL code
Parallel recompilation of Java code
Sequential recompilation of Java code