-
Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group?()
A . when ASM disk goes offline
B . when one or more ASM files are dropped
C . when some disks in a disk group are offline
D . when some disks in a failure group for a disk group are rebalancing
-
For which database operation would you need the database to be in the MOUNT state()
A . renaming the control files
B . re-creating the control files
C . dropping a user in your database
D . dropping a tablespace in your database
E . configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG mode
-
In which scenarios would you rebuild an index?()
A . when you need to disable the index usage
B . when you need to change storage options
C . when you need to enable index monitoring
D . when you need to move the index to another tablespace
-
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?()
A . The EMPLOYEES table will be changed to read-only mode during the shrink operation.
B . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
C . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
D . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
-
In a VoIP network, which type of interface would an analog fax machine connect to?()
A . Type 1
B . Type 2
C . FXS
D . FXO
E . E&M
-
In which scenario would index be most useful? ()
A . The indexed column is declared as NOT NULL.
B . The indexed columns are used in the FROM clause.
C . The indexed columns are part of an expression.
D . The indexed column contains a wide range of values.
-
Identify three situations in which you would NOT be able to drop a tablespace. ()
A . when the tablespace is online
B . when the tablespace has segments with data in it
C . when the tablespace is a default permanent tablespace for the database
D . when the tablespace contains a table that is currently being used by transactions
E . when the tablespace contains undo data that is needed to rollback an uncommitted transactio
-
You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?()
A . loss of a tempfile
B . loss of a system data file
C . loss of one of the control files
D . loss of one of the tablespaces
E . loss of a member from each redo log group
F . loss of the only member of an unarchived redo log grou
-
Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? ()
A . when ASM disk goes offline
B . when one or more ASM files are dropped
C . when some disks in a disk group are offline
D . when some disks in a failure group for a disk group are rebalancing
-
Which command would an administrator use to list which filesystems are in volume group datavg?()
A . lspv datavg
B . lslv -a datavg
C . lsfs -v datavg
D . lsvg -l datavg
-
You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?()
A . loss of one of the tablespaces
B . loss of a system data file
C . loss of one of the control files
D . loss of a tempfile
E . loss of the only member of an unarchived redo log group
F . loss of a member from each redo log grou
-
A web application allows the HTML title banner to be set using a servlet context initialization parametercalled titleStr. Which two properly set the title in this scenario?()
A . <title>${titleStr}</title>
B . <title>${initParam.titleStr}</title>
C . <title>${params[0].titleStr}</title>
D . <title>${paramValues.titleStr}</title>
E . <title>${initParam[’titleStr’]}</title>
-
In which two scenarios should you issue the following command?() FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE;
A . when the schema of the user, SCOTT, was deleted by mistake 15 minutes ago
B . when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
C . when some rows of the table, EMP, in the SCOTT schema were deleted by mistake 15 minutes ago
D . when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
E . never, because FLASHBACK TABLE is not a valid command in Oracle 10g.
-
In which of the areas listed would you expect to find the highest salt concentration in a flash evaporator?()
A . Distiller air ejector cooling medium
B . Saltwater heater discharge
C . First-stage internal feed box
D . Second-stage internal feed box
-
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()
A . You must shut down the database instance to perform the backups.
B . You must configure the Flash Recovery Area (FRA) for the database.
C . You can perform complete database backups without closing the database.
D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
-
In which scenario is a Database Administrator NOT required to perform an incomplete recovery?()
A . when all the online redo log groups are multiplexed and one of the members of a group is missing
B . when all the online redo log groups are not multiplexed and one log group is missing
C . when all the control files are missing
D . when some important tables are deleted from the database and purged from the Recycle Bi
-
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?()
A . The data in the segment will be compacted but the high water mark will not be adjusted
B . The EMPLOYEES table will be changed to read-only mode during the shrink operation
C . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over
D . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation
E . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operatio
-
In which case would you use the Flashback Database feature to perform a recovery?()
A . to recover a dropped tablespace
B . to recover data from a truncated table
C . to recover a data file that has been shrunk
D . to recover a database to the state that existed before the RESETLOGS operatio
-
User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to?()
A . null lock on the row being updated
B . null lock on the table containing the row
C . ROW SHARE lock for the row being updated
D . ROW EXCLUSIVE lock for the row being updated
E . shared row-exclusive lock for the row being updated
F . a shareable table lock for the table containing the row
G . exclusive table-level lock for the table containing the row
-
In which of the following scenarios would the "show cdp neighbors detail"command be an appropriate troubleshooting tool?()
A . Two switches are connected via a trunk. Both switches have been assigned an IP address, subnet mask, and default gateway. A ping is successful between the two switches. However, VLAN information is not passed from one switch to the other switch.
B . A router and a switch have been assigned an IP address, a subnet mask, and a default gateway. They are directly connected, but a ping between the two devices fails.
C . A router connects to another router through a serial interface. Both routers have been assigned an IP address, subnet mask, and default gateway. The routers are running RIP and the networks directly connected to the first router do not pass to the second router. However, a ping from one router to the serial interface of the directly connected neighboring router is successful.
D . A router connects to another router via a switch. Both routers and the switch have been assigned an IP address, subnet mask, and default gateway. Neither the routers nor the switch are able to ping one of the hosts that is directly to the switch.
-
Which switch would STP choose to become the root bridge in the selection process?()
A . 32768: 11-22-33-44-55-66
B . 32768: 22-33-44-55-66-77
C . 32769: 11-22-33-44-55-65
D . 32769: 22-33-44-55-66-78
-
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.()
A . Change in the Oracle Database version
B . Change in your network infrastructure
C . Change in the hardware configuration of the database server
D . Migration of database storage from non-ASM to ASM storage
E . Database and operating system upgrade
-
You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario()
A . You must shut down the database instance to perform the backups.
B . You must configure the Flash Recovery Area (FRA) for the database.
C . You can perform complete database backups without closing the database.
D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
-
In which of the following situations would you prefer to be making a loan?