1z0-497無料問題集「Oracle Database 12c Essentials」

質問 1

Which option represents the steps to add a multiplexed copy of the current control file or to rename a control file in Oracle Database 12c?
a - Shut down the database.
b - Restart the database.
c - Copy an existing control file to a new location by using operating system commands.
d - Edit the CONTROL_FILESparameter in the database initialization parameter file to add the new control file name, or to change the existingcontrol file name.

（A）b, c, d

（B）a, c, d, b

（C）c, d, b

（D）a, d, b, c

正解：B 解答を投票する

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

質問 2

Your customer is looking for a solution that meets these four needs:
1 - Replicate data from source to target for reporting purposes.
2 -Replicate data from one source to multiple targets.
3 - Replicate data between two databases for instant failover.
4 - Replicate data from multiple sources to a single target for a data warehouse.
Which GoldenGate-supported topology would you recommended?

（A）Peer-to-peer for 1 Broadcast for 2 Bi-directional for 3 Consolidation for 4

（B）Uni-directional for 1 Peer-to-peer for 2 Bi-directional for 3 Consolidation for 4

（C）Peer-to-peer for 1 Consolidation for 2 Broadcast for 3 Cascading for 4

（D）Uni-directional for 1 Broadcast for 2 Bi-directional for 3 Consolidation for 4

正解：D 解答を投票する

質問 3

In which situation would you use static database registration for a listener?

（A）when users need to connect the database instance by using the host naming method

（B）when DBAs need to connect remotely to start up the database instance

（C）when multiple databases are to be registered with the listener

（D）when the database instance to be registered with the listener is configured in shared server mode

正解：B 解答を投票する

質問 4

Which statement about the Queryable Patch inventory feature is false?

（A）It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances and DG instances.

（B）DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

（C）It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.

（D）It is used to retrieve installed patch information from a SQL prompt.

正解：A 解答を投票する

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

質問 5

Which three events signal a database writer (DWR) to write buffers to disk?

（A）A server process cannot find non-dirty blocks after scanning a threshold number of buffers.

（B）The redo log buffer becomes full.

（C）The database is shut down in immediate mode.

（D）A tablespace is changed to read-only status.

（E）A client process commits a transaction.

（F）The database advances a checkpoint.

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

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

質問 6

Examine the output:
SQL> SELECT index_name, status FROM dba_indexes WHEREstatus='UNUSABLE';
INDEX_NAME STATUS
EIND UNUSABLE
Which two statements about this index are true?

（A）It is ignored by the query optimizer.

（B）The index is automatically rebuilt when used the next time.

（C）The index cannot be rebuilt, and has to be re-created.

（D）It is not used while the index is being rebuilt.

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

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

質問 7

Which logical storage relationship is correct?

（A）B) Segment < Extent < Oracle Datablock<Tablespace

（B）Tablespace< Segment < Extent < Oracle Datablock

（C）Tablespace< Extent < Segment < Oracle Datablock

（D）Data File <Tablespace< Segment < Extent < Oracle Datablock

正解：B 解答を投票する

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

質問 8

Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.

（A）less instance overhead

（B）same time needed for patching and upgrade as in the previous release

（C）isolation

（D）fast and easy provisioning

（E）minor application changes

（F）increased storage cost

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

質問 9

Which two statements are true when you execute an invoker's rights procedure?

（A）The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

（B）The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege.

（C）Invoking users can control who can access their privileges when they run an invoker's rights procedure.

（D）The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

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

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

質問 10

Which normalization level is adopted in real-world database systems?

（A）2NF

（B）BCNF

（C）3NF

（D）1NF

正解：D 解答を投票する

1z0-497 無料問題集「Oracle Database 12c Essentials」

弊社を連絡する

関連リンク

トップ試験