You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements about resumable space allocation are true? ()
A . Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
B . A resumable statement is suspended only if an out of space error occurs. (Out of space condition Maximum extents reached condition,Space quota exceeded condition)
C . When a resumable statement is suspended, the transaction that contains the statement is also suspended.
D . A resumable statement can only be suspended and resumed once during the execution of the statement.
E . You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.
-
You have configured the "config network webmode enable" command on a Cisco device. What is the purpose of this command? ()
A . To allow HTTP access to the WLAN controller
B . To allow SSH access to the CLI of the WLAN controller
C . To allow SSL access to the CLI of the WLAN controller
D . To allow HTTPS access to the WLAN controller
E . None of the other alternatives apply
-
You execute the following command to enable a session in resumable mode: SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being suspended?()
A . The statements remain suspended for at least 60 seconds.
B . The statements are suspended for 60 seconds and then they are executed.
C . The suspended statements error out if the problem is not rectified within 60 seconds.
D . The statements are automatically suspended 60 seconds after an error is received, and then attempt to execute normally again.
-
You issued the following statement: SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n; What will be the result of issuing the above statement?()
A . The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
B . The command will not execute successfully because resumable space allocation is enabled at the session level.
C . The command will execute successfully and resumable space will be allocated at the session level.
D . The command will execute successfully and resumable space will be allocated at the instance level.
-
You have enabled backup optimization for the RMAN environment.Identify two criteria on which RMAN will skip the file, if it has already been backed up.()
A . The data file backup is done with multiple channels
B . The data files is in the read-write mode after being backed up in the read only mode
C . The backup was taken after the data files was taken offline-normal or is in the read only mode
D . The data file backup complies with the back retention policy and the backup duplexing feature
-
You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?()
A . The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled
B . Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
C . Backup optimization is permanently disabled
D . Backup optimization is temporarily disabled because a redundancy-based retention policy is specified
-
You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? ()(Choose three.)
A . Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
B . A resumable statement is suspended only if an out of space error occurs.
C . When a resumable statement is suspended, the transaction that contains the statement is also suspended.
D . A resumable statement can only be suspended and resumed once during the execution of the statement.
E . You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a sessio
-
You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()
A . The location used for control files.
B . The location used for redo log files.
C . The location set by using $ORACLE_BASE
D . The location set by using $ORACLE_HOME
E . The location set by using CORE_DUMP_DEST
F . The location set by using BACKGROUND_DUMP_DEST
-
You issued the following statement in your SQL*Plus session: SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600; Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()
A . creating a table in your schema and you exceed your allocated space quota on the tablespace
B . executing a long query that involves a sort operation and the statement runs out of temporary space
C . loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
D . creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
-
You have a FAT32-formatted volume.You need to enable file-level security on the volume. The solution must maintain all files on the volume. What should you do?()
A . Run the sfc.exe command-line tool.
B . Run the convert.exe command-line tool.
C . From Disk Management, format the volume and select the NTFS file system.
D . From Disk Management, upgrade the disk that contains the volume to a dynamic disk.
-
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; statement to enable the block change tracking feature. What information will be written in the change tracking file?()
A . the system change number
B . the locations of the redo log files
C . the locations of the datafiles
D . the physical location of all the database change
-
You have a computer that runs Windows 7. The computer has System Protection enabled. You need toretain only the last System Protection snapshot of the computer. All other snapshots must be deleted. Whatshould you do?()
A . Run Disk Cleanup for Programs and Features.
B . Run Disk Cleanup for System Restore and Shadow Copies.
C . From the System Protection Restore settings, select Turn off System Restore.
D . From the System Protection Restore settings, select Only restore previous versions of files.
-
You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?()
A . issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
B . issuing the ALTER SESSION ENABLE RESUMABLE; statement
C . modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
D . issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement
-
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
A . Database Datafiles
B . Database Control Files
C . Online redo logs
D . Archived redo logs
E . The database SPFILE
F . None of the above,all these files are backed u
-
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
A . Database Datafiles
B . Database Control Files
C . Online redo logs
D . Archived redo logs
E . The database SPFILE
F . None of the above, all these files are backed up.&e
-
You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?()
A . The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled
B . Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
C . Backup optimization is permanently disabled
D . Backup optimization is temporarily disabled because a redundancy-based retention policy is specified
-
You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?()
A . log01.log
B . logORCL01.log
C . 1_2.logALTER ROLLBACK SEGMENT
D . ora_1_asdf1234.log
-
You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()
A . the location used for control files
B . the location used for redo log files
C . the location set by using $ORACLE_BASE
D . the location set by using $ORACLE_HOME
E . the location set by using CORE_DUMP_DEST
F . the location set by using BACKGROUND_DUMP_DEST
-
You have a computer that runs Windows 7 Professional. A USB disk is attached to the computer. You needto ensure that you can enable BitLocker To Go on the USB disk. What should you do?()
A . Enable Encrypting File System (EFS).
B . Upgrade the computer to Windows 7 Enterprise.
C . Initialize the Trusted Platform Module (TPM) hardware.
D . Obtain a client certificate from an enterprise certification authority (CA).
-
You execute the following command to enable a session in resumable mode: SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being suspended?()
A . The statements remain suspended for at least 60 seconds.
B . The statements are suspended for 60 seconds and then they are executed.
C . The suspended statements error out if the problem is not rectified within 60 seconds.
D . The statements are automatically suspended 60 seconds after an error is received, and then attempt to execute normally again.
-
You execute the following command to enable a session in resumable mode: SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being suspended?()
A . The statements remain suspended for at least 60 seconds.
B . The statements are suspended for 60 seconds and then they are executed.
C . The suspended statements error out if the problem is not rectified within 60 seconds.
D . The statements are automatically suspended 60 seconds after an error is received, and then attempt toexecute normally again.
-
You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? ()(Choose two.)
A . issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
B . issuing the ALTER SESSION ENABLE RESUMABLE; statement
C . modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
D . issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=
-
You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level?()
A . issuing the ALTER SYSTEM ENABLE RESUMABLE;statement
B . issuing the ALTER SESSION ENABLE RESUMABLE;statement
C . modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
D . issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=
-
Your vessel is taking on fuel oil when a small leak develops in the hose and you have ordered the pumping stoppedBefore resuming pumping,you should().
A . notify the terminal superintendent
B . place a large drip pan under the leak and ping the scuppers
C . repair the hose with a patch
D . replace the hose
-
When applying for a job, you have to prepare a resume and a cover letter.