移动端

  • 题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

多选题 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?()

A

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.

B

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.

C

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.

D

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

E

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.

F

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?()

A

It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

B

It fails because no SQL *Loader data file location is specified.

C

It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

D

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?()

A

They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

B

They are created only in the Fast Recovery Area.

C

They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

D

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?()

A

Effectively implements role separation

B

Enables you to take advantage of Oracle Managed Files.

C

Automatically registers the database with Oracle Restart.

D

Helps you to easily upgrade the database from a prior release.

E

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?()

A

Corrupted blocks, if any, are repaired.

B

Checks are performed for physical corruptions.

C

Checks are performed for logical corruptions.

D

Checks are performed to confirm whether all database files exist in correct locations

E

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?()

A

Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

B

Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

C

Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

D

Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

E

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?()

A

It succeeds because the PDB_ADMIN user has the required privileges.

B

It fails because common users are unable to use the SET CONTAINER statement.

C

It fails because local users are unable to use the SET CONTAINER statement.

D

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?()

A

They are able to perform only queries.

B

They are not affected and continue to function normally.

C

They are terminated and the active transactions are rolled back.

D

They are not allowed to perform any operations until the listener LISTENER is started

单选题 Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?()

A

By default, EM express is available for a database after database creation.

B

You can use EM express to manage multiple databases running on the same server.

C

You can perform basic administrative tasks for pluggable databases by using the EM express interface.

D

You cannot start up or shut down a database Instance by using EM express.

E

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?()

A

Parallel compilation of only the stored PL/SQL code

B

Sequential recompilation of only the stored PL/SQL code

C

Parallel recompilation of any stored PL/SQL code

D

Sequential recompilation of any stored PL/SQL code

E

Parallel recompilation of Java code

F

Sequential recompilation of Java code

最新资讯

1 2 3 4 5 下一页 尾页 /

到第