Oracle 1z0-497 問題集

質問 1：
Which three statements are true about a database instance that has mounted a database but has not opened it?
A. System administrators and users with the CREATE SESSION system privilege may connect to the instance.
B. Instance recovery is performed for the database.
C. A control file is open.
D. An alert log and trace files are open.
E. Data files are open in read-only mode.
F. System Global Area (SGA) is allocated and background processes are started.
正解：C,D,F

質問 2：
All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions:
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
123 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?
A. all sessions of the HR user and the SYS user
B. all sessions for which database users have access privileges to the PERSONS table
C. the session of the HR user that executed the commands
D. all sessions of the HR user
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A DBA informs you that an Oracle instance has started. What does this imply?
A. Users can access the data in the database.
B. Only background and user processes are running.
C. Memory areas have been allocated and background processes have been started.
D. Only SGA has been allocated for the database.
正解：C

質問 4：
Which two statements are true about the B-tree Index?
A. Rows with a NULL value in key columns also have entries in the Index.
B. The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.
C. The leaf blocks in the index are doubly linked.
D. The leaf node stores a bitmap for each key value.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two statements are true about listeners?
A. Listeners use only the TCP/IP protocol.
B. Multiple listener processes can run simultaneously on a host.
C. Multiple database instances can be registered with a single listener,
D. Only one database instance can be registered with a single listener at any time.
E. Listener-related errors can be traced only at the administrative level.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two statements are true about SCOTT's session in this scenario?
A. The session is rolled back after receiving the error and JIM can continue with his transaction.
B. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
C. SCOTT has to re-execute the last command in the transaction after he commits the transaction.
D. The session is terminated after receiving the error and JIM can continue with his transaction.
正解：B,C

質問 7：
Which three statements represent the benefits of multitenant architecture for database consolidation?
A. You can consolidate shared database memory by combining multiple PDBs in a single CD
B. Consolidating separate databases into a single CDB requires the same amount of storage allocation.
C. Patching individual PDBs requires the same amount of time as patching individual databases.
D. In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.
E. You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.
正解：A,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which two statements about Automatic Data Optimization (ADO) are true?
A. ADO is not dependent on Heat Map, and works even if Heat Map is disabled.
B. You can compress at row level only for QUERY LOW.
C. You cannot compress at block level, but you can compress at segment level.
D. ADO policies can automatically compress data when it qualifies.
E. ADO policies can automatically move segments when necessary.
正解：D,E

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