-
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
-
In which of the following scenarios is a tablespace recovery required?()
A . when recovering a lost read-only tablespace from a read-only tablespace backup
B . when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in ARCHIVELOG mode
C . when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
D . when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file, the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement, and this statement was issued when the tablespace was read-only
-
In which scenario do you use the Flashback Database feature?()
A . when a table is dropped and you restore it from the Recycle Bin
B . when a user’s schema is dropped and you recover the user’s schema
C . when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
D . when a row of a table is updated frequently and committed, and you view all the versions of the row within a specific duratio
-
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.
-
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario?()
A . The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B . The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C . Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
D . The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
-
In which scenario would TOP N analysis be the best solution? ()
A . You want to identify the most senior employee in the company.
B . You want to find the manager supervising the largest number of employees.
C . You want to identify the person who makes the highest salary for all employees.
D . You want to rank the top three sales representatives who have sold the maximum number of products.
-
You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario?()
A . You must ensure that the SALES database is mounted or open.
B . You must restore a backup control file to perform a block media recovery.
C . You must take the tools01.dbf data file offline before you start a block media recovery.
D . You must put the database in NOARCHIVELOG mode to perform a block media recovery.
E . You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.
-
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
-
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
-
In an L2TP voluntary tunneling scenario, the VPDN tunnel is terminated between:()
A . The client and the NAS.
B . The NAS andthe LNS.
C . The NAS and the LAC.
D . The client and the LNS.
-
Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?()
A . Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
B . Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
C . Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
D . Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
-
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 scenario will you use the Flashback Transaction Query feature?()
A . when you want to restore an important table that is dropped from the Recycle Bin
B . when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
C . when you want to restore a dropped user’s schema
D . when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
-
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 will you issue the following command?() SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 : 12:09:08’ USING BACKUP CONTROLFILE;
A . when all the control files are missing and only a binary backup of the current control file exists
B . when a multiplexed copy of the current control file is missing
C . when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
D . when the SPFILE is missing
-
You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN. Which two statements are correct in this scenario?()
A . You must ensure that the SALES database is mounted or open.
B . You must restore a backup control file to perform a block media recovery.
C . You must take the tools01.dbf data file offline before you start a block media recovery.
D . You must put the database in NOARCHIVELOG mode to perform a block media recovery.
E . You can perform only a complete media recovery of individual blocks; point-in-time recovery of individual data blocks is not supported.
-
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 scenario, will you issue the following command?() RMAN> REPORT NEED BACKUP DAYS 7;
A . to configure RMAN to maintain backup information in the RMAN repository for seven days
B . to configure RMAN to maintain backup information in the control file for at least seven days
C . to display the list of files that have not been backed up for the last seven days
D . to display the list of files that must be backed up within seven day
-
In which scenario will you use the Flashback Version Query feature?()
A . when you want to restore a table that has been dropped from the Recycle Bin
B . when you want to identify the transaction ID of the transaction that deleted some important records from a table
C . when you want to recover the schema of a dropped user
D . when you want to restore a dropped tablespace
-
In which of the scenarios will the DBA perform recovery()
A . The alert log file is corrupted.
B . A tablespace is accidentally dropped.
C . One of the redo log members is corrupted.
D . A database user terminates the session abnormally.
E . The hard disk on which the data file is stored is corrupted.
-
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.
-
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
-
Public transit. In North America, public transportation has been the major casualty of the commitment to the automobile. Ridership on public transportation declined in the United States from 23 billion per year in the late 1940s to 7 billion in the early 1990s. At the end of World War I, U.S. cities had 50,000 kilometers of street railways and trolleys that carried 14 billion passengers a year, but only a few hundred kilometers of track remain. The number of U. S. and Canadian cities with trolley service declined from about fifty in 1950 to eight in the 1960s: Boston, Cleveland, New York, New Orleans, Philadelphia, Pittsburgh, San Francisco, and Toronto.
Buses offered a more flexible service than trolleys, because they were not restricted to operating only on fixed tracks. General Motors acquired many of the privately owned streetcar companies and replaced the trolleys with buses that the company made. But bus ridership has declined from a peak of 11 billion riders per year in the late 1940s to 5 million in the 1990s. Commuter railroad service, like trolleys and buses, has also been drastically reduced in most U.S. cities.
The one exception to the downward trend in public transportation in the United States is the subway, now known to transportation planners as fixed heavy rail. Cities such as Boston and Chicago have attracted new passengers through construction of new lines and modernization of existing service. Chicago has been a pioneer in the construction of heavy rail rapid transit lines in the median strip of expressways. Entirely new subway systems have been built in recent years in a number of U.S. cities, including Atlanta, Baltimore, Miami, San Francisco, and Washington, D.C.
Public transportation is particularly suited to bringing a large number of people into a small area in a short period of time. Consequently, its use is increasingly confined in the United States to rush-hour commuting by workers in the central business district. A bus can accommodate thirty people in the amount of space occupied by one automobile, while a double-track rapid transit line can transport the same number of people as sixteen lanes of urban freeway.
Despite modest recent successes, most public transportation systems are caught in a vicious circle, because fares do not cover operating costs. As patronage declines and expenses rise, the fares are increased, which drives away passengers and leads to service reductions and still higher fares. Public expenditures to subsidize construction and operating costs have increased, but public officials in the United States do not consider that public transportation is a vital utility deserving subsidy to the degree long assumed by European governments.
In contrast, even in the relatively developed Western European countries and Japan, where automobile ownership rates are high, extensive networks of bus, tram, and subway lines have been maintained, and funds for new construction have been provided in recent years. Since the late 1960s, London has opened 27 kilometers of subways, including two new lines, plus 18 kilometers in light rail transit lines to serve the docklands area. During the same period, Paris has built 65 kilometers of new subway lines, including a new system, known as the Reseau Express Regional (R. E. R.) to serve outer suburbs.
Smaller cities have shared the construction boom. In France alone, new subway lines have been built since the 1970s in Lille, Lyon, and Marseille, and hundreds of kilometers of entirely new tracks have been laid between the country's major cities to operate a high-speed train known as the TGV.
Which of the following is NOT true of the public transportation systems in the developed countries?
A.Commuter railroad service, trolleys and buses have been reduced in the U. S.
B.Subways have largely been maintained.
C.Fares usually can not cover operating costs.
D.U.S. officials think it worthwhile to subsidize public transportation.