1z0-034 試験問題を無料オンラインアクセス

Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?

• A.It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.
• B.It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.
• C.It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer for queries, but not for data manipulation language (DML) operations.
• D.It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.

You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation?

• A.The online redo log files and archived redo log files are required to accomplish the recovery
• B.The DBA has to perform the recovery on the database to recover the uncommitted transaction
• C.The uncommitted transaction will be committed at the next startup of the database instance
• D.The uncommitted transaction is rolled back automatically at the next opening of the database

Which three elements can a job chain process involve? (Choose three)

• A.a program
• B.an event
• C.a schedule
• D.a lightweight job
• E.another chain

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance.
Which statement is true while performing a tape backup in an RMAN session?

• A.The tape buffer is allocated from the System Global Area (SGA)
• B.The tape I/O performed is asynchronous
• C.The tape buffer is allocated from the Program Global Area (PGA)
• D.Oracle I/O uses an interrupt mechanism to determine when each I/O completes

Which data dictionary view would you query to find the name of the default permanent tablespace of the database?

• A.DBA_TABLESPACE_GROUPS
• B.DATABASE_PROPERTIES
• C.DICTIONARY
• D.DBA_TABLESPACES
• E.DBA_DIRECTORIES
• F.DBA_STORED_SETTINGS