Oracle 1z0-497 問題集

質問 1：
Which three are initialization parameters for backup and recovery?
A. CLONEDB
B. FILESYSTEMIO_OPTIONS
C. RECYCLEBIN
D. DB_CREATE_FILE_DEST
E. TAPE_ASYNCH_IO
正解：A,C,E

質問 2：
Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.
A. Automatic SGA Memory Management
B. object-level statistics
C. Oracle Database Trace files
D. all server-generated alerts
E. Oracle Database alert.log file
正解：A,B,D

質問 3：
Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?
A. stabilizing
B. proactive
C. multi-version
D. non-cumulative
E. cumulative
正解：A,B,E

質問 4：
In Oracle Database 12c, when does a transaction begin?
A. when the first executable SQL statement is encountered
B. when a transaction ID is allocated for it.
C. when a user explicitly issues a "begin" statement
D. when a transaction is assigned to an available undo data segment to record undo entries for the new transaction
正解：B

質問 5：
Which two statements are true when you execute an invoker's rights procedure?
A. The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure.
B. The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.
C. The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege.
D. Invoking users can control who can access their privileges when they run an invoker's rights procedure.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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

質問 7：
There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, only LISIENER1 is started. You issue the command:
lsnrctl start listener2
What would be the outcome?
A. It gives an error because multiple listeners cannot run simultaneously.
B. It starts the second listener without affecting current sessions.
C. It starts the second listener and terminates all current sessions.
D. It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which process is responsible for writing the contents of database buffers to data files?
A. Database Writer process (DBW)
B. System Monitor process (SMON)
C. Checkpoint process (CKPT)
D. Process Monitor process (PMON)
E. Listener Registration process (LREG)
F. Log Writer process (LGWR)
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Which two statements about ADDM are true?
A. Regular ADDM uses AWR snapshots that are not yet purged.
B. Real-Time ADDM uses ASH recent activity from SGA data.
C. Real-Time ADDM uses AWR snapshots of the last 10 minutes.
D. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
正解：A,B