1z0-062無料問題集「Oracle Database 12c: Installation and Administration」

質問 1

Examine the following command:
CREATE TABLE (prod_id number(4),
Prod_name varchar2 (20),
Category_id number(30),
Quantity_on_hand number (3) INVISIBLE);
Which three statements are true about using an invisible column in the PRODUCTS table? (Choose three.)

（A）The invisible column cannot be made visible and can only be marked as unused.

（B）The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.

（C）Referential integrity constraint cannot be set on the invisible column.

（D）A primary key constraint can be added on the invisible column.

（E）The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.

正解：B、D、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

Which statement is true about a database in ARCHIVELOG mode?

（A）Full database backups can be performed when the database is opened.

（B）A Fast Recovery Area (FRA) must be configured for the database.

（C）All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery.

（D）Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.

正解：A 解答を投票する

質問 3

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK');
1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH');
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?

（A）The transaction in Scott's session is rolled back and the tablespace becomes readonly.

（B）The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.

（C）The command fails as a transaction is still pending.

（D）The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.

正解：A 解答を投票する

質問 4

You execute this command:

Which two statements are true about segment space management for segments in this tablespace? (Choose two.)

（A）The PCTFREE storage parameter has no effect on segments created in this tablespace.

（B）Segments are automatically shrunk and compressed when rows are deleted.

（C）Space utilization inside segments is mapped by bitmaps.

（D）The PCTUSED storage parameter has no effect on segments created in this tablespace.

正解：C、D 解答を投票する

質問 5

Identify two correct statements about multitenant architectures.

（A）Patches are always applied at the CDB level.

（B）Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.

（C）A PDB can have a private undo tablespace.

（D）Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.

（E）Multiple CDBs share certain PDB resources.

（F）Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.

正解：A、B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?

（A）The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.

（B）Only timed operating system (OS) statistics and plan execution statistics are collected.

（C）Optimizer statistics are collected automatically.

（D）Automatic Workload Repository (AWR) snapshots are not generated automatically.

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

Examine the command:
SQL> CREATE TABLESPACE test1
DATAFILE '/u01/app/oracle/oradata/orc1/test01.dbf' SIZE 5M
AUTOEXTEND ON UNIFORM;
Which statement is true?

（A）Allocated and free extents are tracked using bitmaps.

（B）The data file, TEST01.DBF, can be auto extended to a maximum size of 5M.

（C）Segment free space is tracked in the data dictionary.

（D）The tablespace, TEST1, can contain a maximum of one data file.

正解：A 解答を投票する

質問 8

In your database, USERS is the default permanent tablespace.
Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true? (Choose two.)

（A）The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.

（B）The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.

（C）The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.

（D）The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.

（E）The MYTAB table is owned by the SYS user.

正解：C、E 解答を投票する

質問 9

Identify two situations in which the alert log file is updated.

（A）Running a query on a table returns ORA-600: Internal Error.

（B）Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.

（C）Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

（D）Inserting a value into a table returns ORA-01722: invalid number.

（E）Creating a table returns ORA-00955: name us already in used by an existing objects.

正解：A、C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 10

Which three are true about the default database buffer cache? (Choose three.)

（A）Its buffers can contain data block images for blocks that have a corresponding image in a data file.

（B）It is in the fixed area of the SGA.

（C）Buffers containing block images may be selected for reuse based only on a Least Recently Used (LRU) algorithm.

（D）Its buffers can contain data block images for blocks that have no corresponding image in a data file.

（E）Buffers containing block images may be selected for reuse based only on a touch count algorithm.

（F）The keep and recycle cache memory is sub-allocated from memory allocated to the default buffer cache.

（G）It can contain block images only for database blocks whose block size is equal to the buffer size.

正解：B、D、F 解答を投票する

質問 11

Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file?
(Choose three.)

（A）Field names should be the first line in the both the SQL* Loader data files.

（B）The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

（C）The SQL* Loader data file myfile1.dat has the column names for the EMP table.

（D）The SQL* Loader operation fails because no record terminators are specified.

（E）An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.

正解：B、C、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 12

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= '/dev/flash_device_1 ',' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

（A）Set DB_FLASH_CACHE_ZISE = 128G.

（B）DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

（C）Set DB_FLASH_CACHE_ZISE = 64G.

（D）Set DB_FLASH_CACHE_ZISE = 64G, 64G

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 13

Which two tools can be used to configure static service information in the listener.ora file? (Choose two.)

（A）Oracle Net Configuration Assistant

（B）Oracle Enterprise Manager Database Express

（C）Oracle Enterprise Manager Cloud Control

（D）Listener Control Utility (LSNRCTL)

（E）Oracle Net Manager

正解：C、E 解答を投票する

質問 14

Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)

（A）The ability of users to audit their own schema objects is not available in the post-migrated database.

（B）Network auditing is available in the post-migrated database.

（C）Mandatory auditing of audit administrative actions is available in the post-migrated database.

（D）Operating system audit trail is available in the post-migrated database.

正解：A、C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 15

Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager Database Express (EM Express)? (Choose two.)

（A）A SYSMAN user with SYSDBA privilege must be created

（B）The APEX_PUBLIC_USER role must be granted to SYSMAN

（C）At least one TCP/IP dispatcher must be configured

（D）A port number for Oracle HTTP Server must be configured

（E）The Oracle HTTP Server must be installed

正解：B、C 解答を投票する

質問 16

Which two statements are true about resumable space allocation? (Choose two.)

（A）Resumable space allocation does not apply when a database instance uses asynchronous commit.

（B）Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace.

（C）SELECT statements that run out of temporary space for sort areas are candidates for resumable execution.

（D）A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions.

（E）A resumable statement can be suspended and resumed only once during a session.

（F）Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of-space condition.

正解：C、D 解答を投票する

質問 17

You plan to upgrade your Oracle Database 9i to Oracle Database 12c.
Which two methods can you use? (Choose two.)

（A）Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).

（B）Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database.

（C）Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database
12c.

（D）Perform a rolling upgrade.

（E）Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.

正解：C、D 解答を投票する

質問 18

Which three statements are true about Database Resource Manager? (Choose three.)

（A）A resource plan change can be automated by using the Oracle Scheduler.

（B）It can be used to control the consumption of only physical I/Os where excessive physical I/Os can trigger an automatic session termination but excessive logical I/Os cannot.

（C）It can be used to enable resumable timeout for user sessions.

（D）A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.

（E）It can be used to control the usage of the temp tablespace by consumer groups.

（F）It can be used to control the usage of the undo tablespace by consumer groups.

正解：A、D、F 解答を投票する

1z0-062 無料問題集「Oracle Database 12c: Installation and Administration」

弊社を連絡する

関連リンク

トップ試験