Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader (11-20)

QUESTION 11
According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?

A.    The backup is similar to image copy.
B.    The backup contains all used data blocks.
C.    The backup contains only unused data blocks.
D.    The backup contains all data blocks changed since the last incremental level 1 backup.

Answer: B

QUESTION 12
Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?

A.    The user must be granted the database administrator (DBA) privilege.
B.    The user must be listed in the password file for the authentication.
C.    No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
D.    Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant the webDba role to the user.

Answer: D

QUESTION 13
Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end?

A.    current redo log and inactive redo log
B.    checkpoint position to end of redo log
C.    beginning of redo log to end of redo log
D.    all redo logs before the point of last commit
E.    beginning of redo log to checkpoint position

Answer: B

QUESTION 14
Which two statements are true regarding the database in ARCHIVELOG mode? (Choose two.)

A.    You have to shut down the database to perform the backups.
B.    Archiving information is written to the data files and redo log files.
C.    You can perform complete database backups without closing the database.
D.    Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
E.    All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

Answer: CE

QUESTION 15
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?

A.    Uses undo data for roll forward
B.    Uses Flashback Log for recovery
C.    Uses online redo logs to roll back
D.    Uses undo data to roll back the transaction
E.    Uses Recovery Manager (RMAN) to roll back
F.    Uses the System Monitor (SMON) background process to perform instance recovery

Answer: D

QUESTION 16
You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table?

A.    Monitor thealert.logfile
B.    Enable server-side SQL tracing for user sessions
C.    Enable fine-grained auditing for the customer table
D.    Enable Fine-Grained Access Control (FGAC) for the customer table
E.    Write a database trigger on the customer table on the SELECT event

Answer: D

QUESTION 17
Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this?

A.    Enable instance failover
B.    Configure shared server
C.    Enable database failover
D.    Enable connect-time failover
E.    Enable Transparent Application Failover (TAF)

Answer: D

QUESTION 18
Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

A.    PMON
B.    SMON
C.    MMNL
D.    MMAN
E.    MMON

Answer: D

QUESTION 19
Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choose three.)

A.    The corresponding indexes for the table are also truncated.
B.    Delete triggers on the table are fired during the execution of the TRUNCATE command.
C.    Very little or no undo data is generated during the execution of the TRUNCATE command.
D.    The child table is truncated when the TRUNCATE command is applied on the parent table.
E.    The high-water mark (HWM) is set to point to the first useable data block in the table segment.

Answer: ACE

QUESTION 20
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario? (Choose two.)

A.    The instance aborts.
B.    The database cannot be recovered.
C.    The database can be recovered by restoring the control files from the backup.
D.    The database remains opened and you have to shut it down with the ABORT option.
E.    The database can be restored till the point of the last closed whole database backup.

Answer: AE

Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader