You updated the resource plan directive for the resource consumer group， DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement： SQLEXEC DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE （PLAN = ’DSS_PLAN’， GROUP_OR_SUBPLAN = ’DSS_USERS’， NEW_CPU_P1 = 80， NEW_SWITCH_GROUP = ’CANCEL_SQL’， NEW_SWITCH_ESTIMATE = TRUE， NEW_SWITCH_TIME = 600）； A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds？（） A、 The session is killed before starting the operation.B、 The session generates an error before starting the operation.C、 The session switches to the CANCEL_SQL resource consumer group before starting the operation.D、 The session hangs before starting the operation.
You updated the resource plan directive for the resource consumer group， DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement： SQL>EXEC DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE （PLAN => ’DSS_PLAN’， GROUP_OR_SUBPLAN => ’DSS_USERS’， NEW_CPU_P1 => 80， NEW_SWITCH_GROUP => ’CANCEL_SQL’， NEW_SWITCH_ESTIMATE => TRUE， NEW_SWITCH_TIME => 600）； A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds？（）
- A、 The session is killed before starting the operation.
- B、 The session generates an error before starting the operation.
- C、 The session switches to the CANCEL_SQL resource consumer group before starting the operation.
- D、 The session hangs before starting the operation.
相关考题：
You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）A. MERGEB. INSERTC. UPDATED. ADDE. ENTERF. You cannot enter the phone numbers for the existing employee records.
Which two statements are true about the rescue configuration file?() A. It must include a root password.B. It is rollback file number 50, and you can recover it by issuing rollback 50.C. It is created by issuing request system configuration rescue save.D. It is updated automatically when you commit.
You run Windows Defender on your computer and receive the following warning message: Windows Defender Definitions haven’t been updated.You need to ensure that Windows Defender definition files are updated.What should you do?（）A.AB.BC.CD.D
You install Windows Vista on a new computer by using the retail installation media.You install a new hardware device. You are not prompted for any drivers and the installation completes successfully.You discover that an updated driver is available for the hardware device.You need to install the updated driver.What should you do?（）A.AB.BC.CD.D
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named SellingHelp. There isthe Products table in the SellingHelp database. Now according to the company requirement, the Products table has to be replicated to the SQL Server instances installed in laptopscomputers. You have to create a Replication topology to perform this. The Products table is updated from Instance01 when the laptops reconnect to the corporate network. The Products table on Instance01 is frequently updated between reconnections. You must make sure that you can implement the Replication topology along with the Subscription type successfully and meanwhile reduce the bandwidth usage to the least. So what action should you perform to achieve this goal?（） A、You should implement the Snapshot Replication topology along with a Push Subscription. B、You should implement the Merge Replication topology along with a Pull Subscription. C、You should implement the Snapshot Replication topology along with a Pull Subscription. D、You should implement the Transactional Replication topology along with a Pull Subscription
Which two statements are true about the rescue configuration file?（）A、It gets updated automatically when you commit.B、You need to create it by issuing request system configuration rescue save.C、It is rollback file number 50 and you can recover it by issuing rollback 50.D、You can load it by entering rollback rescue.
When you use the Oracle Net Configuration Assistant to specify the naming method， which file is updated？（）A、INIT.ORAB、SQLNET.ORAC、LISTENER.ORAD、TNSNAMES.ORA
You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）A、MERGEB、INSERTC、UPDATED、ADDE、ENTERF、You cannot enter the phone numbers for the existing employee records.
Which two statements are true about the rescue configuration file?（）A、It must include a root passwordB、It is roll back file number 50, and you can recover it by issuing rollback 50C、It is created by issuing request system configuration rescue saveD、It is updated automatically when you commit
In which scenario do you use the Flashback Database feature？（）A、 when a table is dropped and you restore it from the Recycle BinB、 when a user’s schema is dropped and you recover the user’s schemaC、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration
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 BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 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
If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）A、 The next time you back up the database when you are also connected to the recovery catalog and the target databaseB、 The next time you are connected to the target database and the recovery catalog database and issue the resync commandC、 The next time you connect RMAN to just the recovery catalogD、 The next time you connect to the recovery catalog and the target database with RMANE、 Connecting to the recovery catalog and issuing the resync all databases command
You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）A、A leaf will be marked as invalid.B、An update in a leaf row takes place.C、The index will be updated automatically at commit.D、A leaf row in the index will be deleted and inserted.E、The index becomes invalid when you make any updates
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）A、The index remains invisible.B、The index is not updated by the DML statements on the indexed table.C、The index automatically becomes visible in order to have it updated by DML on the table.D、The index becomes unusable but the table is updated by the DML.E、The index is updated by the DML on the table.
You run Windows Defender on your computer and receive the following warning message： "Windows Defender Definitions havent been updated." You need to ensure that Windows Defender definition files are updated. What should you do？（）A、Restart the Windows Defender service.B、Repair the Microsoft Location Finder program.C、Download and install the appropriate files from Microsoft Windows Update.D、Download and install the latest Windows Defender application from the Microsoft Web site.
Your network contains an Active Directory Rights Management Services （AD RMS） cluster. You have several custom policy templates. The custom policy templates are updated frequently. Some users report that it takes as many as 30 days to receive the updated policy templates. You need to ensure that users receive the updated custom policy templates within seven days. What should you do（）A、Modify the registry on the AD RMS servers.B、Modify the registry on the users computers.C、Change the schedule of the AD RMS Rights Policy Template Management （Manual） scheduled task.D、Change the schedule of the AD RMS Rights Policy Template Management （Automated） scheduled task.
You are the desktop administrator for your company's sales department. Katrin is a user in the sales department. You need to upgrade Katrin's Windows 2000 Professional computer to Windows XP Professional. Philippe is the network administrator. He previously downloaded updated Setup files and placed them on a server named Server1, in a shared folder named Updates. Philippe has successfully installed computers by using these updated Setup files. You want to ensure that these updated Setup files are automatically installed on Katrin's computer during the upgrade. Which command should you run to start Setup?（） A、Winnt32. exe /dushare://server1/updatesB、Winnt32. exe /copydir://server1/updatesC、Winnt32. exe /duprepare://server1/updatesD、Winnt32. exe /copysource://server1/updates
单选题You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）AA leaf will be marked as invalid.BAn update in a leaf row takes place.CThe index will be updated automatically at commit.DA leaf row in the index will be deleted and inserted.EThe index becomes invalid when you make any updates
单选题In which scenario do you use the Flashback Database feature？（）A when a table is dropped and you restore it from the Recycle BinB when a user’s schema is dropped and you recover the user’s schemaC when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration
单选题You work as an application developer at Certkiller .com. You are currently in the process of creating a shared assembly. You are required to perform many integration tests to make sure the assembly works properly with multiple applications. You want to avoid constantly updating each application’s reference when the assembly is updated. You have set the DEVPATH environmental variable to the default build location for the shared assembly. You need to ensure that the Common Language Runtime （CLR） uses DEVPATH to locate the shared assembly. What should you do？（）A AB BC CD D
多选题Which two statements are true about the rescue configuration file?（）AIt gets updated automatically when you commit.BYou need to create it by issuing request system configuration rescue save.CIt is rollback file number 50 and you can recover it by issuing rollback 50.DYou can load it by entering rollback rescue.
多选题If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）AThe next time you back up the database when you are also connected to the recovery catalog and the target databaseBThe next time you are connected to the target database and the recovery catalog database and issue the resync commandCThe next time you connect RMAN to just the recovery catalogDThe next time you connect to the recovery catalog and the target database with RMANEConnecting to the recovery catalog and issuing the resync all databases command
单选题As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）AA leaf will be marked as invalid.BAn update in a leaf row takes place.CThe index will be updated automatically at commit.DA leaf row in the index will be deleted and inserted.EThe index becomes invalid when you make any updates.
单选题When you use the Oracle Net Configuration Assistant to specify the naming method， which file is updated？（）AINIT.ORABSQLNET.ORACLISTENER.ORADTNSNAMES.ORA
多选题Which two statements are true about the rescue configuration file?（）AIt must include a root passwordBIt is roll back file number 50, and you can recover it by issuing rollback 50CIt is created by issuing request system configuration rescue saveDIt is updated automatically when you commit
多选题Which two statements are true about the rescue configuration file?（）AIt must include a root password.BIt is roll back file number 50, and you can recover it by issuing rollback 50.CIt is created by issuing request system configuration rescue save.DIt is updated automatically when you commit
多选题You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）AThe index remains invisible.BThe index is not updated by the DML statements on the indexed table.CThe index automatically becomes visible in order to have it updated by DML on the table.DThe index becomes unusable but the table is updated by the DML.EThe index is updated by the DML on the table.
单选题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 BinB when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionCwhen you want to restore a dropped user’s schemaD 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