Oracle 1z0-497 問題集

質問 1：
Your customer needs server availability that provides uninterrupted access to database services, handling any unexpected failure of one or more machines hosting the database server, due to a hardware or software fault. Which product should your customer use?
A. Oracle Real Application Clusters
B. Oracle Streams
C. Oracle Data Guard
D. Oracle GoldenGate
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?
A. ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements
B. ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword
C. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword
D. D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements
正解：C

質問 3：
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 advances a checkpoint.
D. A tablespace is changed to read-only status.
E. The database is shut down in immediate mode.
F. A client process commits a transaction.
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
As part of your Oracle Database 12c post-installation tasks, you run these commands:
Cd $ORACLE_HOME/bin
srvctl stop database -d myDb
chopt enable dm
srvctl start database -d myDb
What does this do?
A. It configures Oracle Net Services.
B. It generates Client Static Library.
C. It creates the Fast Recovery Area disk group.
D. It configures one of the Oracle user accounts.
E. It configures Oracle Messaging Gateway.
F. It enables the Oracle Data Mining option in your Oracle binary files.
正解：F
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two statements about Database Express are true?
A. It uses internal infrastructure components, such as XDB and SQL*Net.
B. It is not supported on Standard Edition (SE) and Express Edition (XE).
C. It can perform actions outside the database.
D. It has background tasks and processes that periodically collect information via FTP.
E. It has two new features: Performance Hub and Composite Active Reports.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
John is a CDB administrator, and Mike and Tim are PDB administrators of their respective databases- John takes a complete CDB backup by using RMAN>Backup Database. Mike and Tim may need point-in-time recovery of their PDBs. Which statement is true?
A. Recovery of individual PDBs is not possible at all.
B. Mike and Tim need to individually take backups of their respective PDBs, because CDB-level backup does not include PDB data dictionary objects.
C. Mike and Tim do not need to worry, because recovery of individual PDBs is possible.
D. Recovery of individual PDBs is not possible, because John did not back up by using RMAN>Backup Pluggable database pdb1 pdb2. However, complete CDB recovery is still possible.
正解：D

質問 7：
Which statement regarding Oracle Active Data Guard 12c is false?
A. Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.
B. It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.
C. It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.
D. It provides new support for DML to global temporary tables and the use of sequences in the standby database.
E. It repairs block corruptions detected in the primary or standby database.
正解：C

質問 8：
Which is the default port number for Database Express?
A. 1521
B. 7801
C. 5500
D. 2243
E. 22
正解：A
解説: (Topexam メンバーにのみ表示されます)