Oracle 1z0-497 問題集

質問 1：
Which two statements are true regarding undo data records?
A. They are required to support Flashback features.
B. Undo records contain copies of data as it appears before a change is made.
C. Undo records contain copies of data as it appears after a change is made.
D. They are not required if Flashback features are enabled.
E. They are retained until the session making the changes ends.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Examine the error:
GSM-45054: GSM error or NET-40006: unable to start GSH
What is the cause of this error, and what troubleshooting steps should you perform?
A. The GDS pool database's local listener may be down. Make sure that it is running.
B. The GDS pool database may be down. Make sure that the GDS pool databases are up and the service is enabled and started.
C. The GDS catalog database of its listener may be down. Verify that the GDS catalog database and its local listener are running.
D. The global service may be disabled. Make sure that the pool databases are up and the service is enabled and started.
E. The global service may be down. Verify that the pool databases are up and the service is started.
正解：C

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

質問 4：
Which two statements represent where Oracle Net must reside?
A. On both the client and database server for traditional client/server applications.
B. Only on the client for traditional client/server applications
C. Only on the database server for web-based applications
D. On both the web server and database server for web-based applications
正解：A,C

質問 5：
Examine the commands:
SQL> CONNECT sys@CDBl AS SYSDBA
$QL>STARTUP MOUNT
SQL> ALTER DATABASE cdbl MOUNT;
Which four options represent what happens when these commands are executed?
A. The PDBs are mounted.
B. The CDB control files are opened for the instance.
C. The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.
D. The instance is started.
E. The PDBs are mounted, and the seed is opened in READ ONLY mode.
F. The root is opened.
G. The root is mounted.
正解：A,B,D,G

質問 6：
Which three operations can the PUBLIC user with the SYSOPER privilege perform?
A. STARTUP
B. SHUTDOWN
C. ALTER DATABASE RECOVER
D. CREATE DATABASE
E. DROP DATABASE
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)

質問 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 three background processes are mandatory in a database Instance started with a minimally configured Initialization parameter file?
A. Recoverer process (RECO)
B. Flashback Data Archive process (FBDA)
C. Process Monitor Process (PMON)
D. Space Management Coordinator process (SMCO)
E. Listener Registration process (LREG)
F. Checkpoint Process
正解：A,C,F
解説: (Topexam メンバーにのみ表示されます)

質問 9：
What happens if you execute these SQL statements?
SQL> show con_name
CON_NAME
CDB$ROOT
SQL> create user 1_freed identified by y container=current;
A. The second SQL statement fails because a local user cannot be created in the root container.
B. A common user is created in the root container.
C. A local user is created in all the PDBs.
D. A local user is created in the root container.
正解：A