While creating a scheduler window using the DBMS_SCHEDULER package， a user logged in as DBMGR gets the error message insufficient privileges. Which two commands would you use to resolve this error？（）A、GRANT dba TO dbmgr;B、GRANT connect TO dbmgr;C、GRANT resource TO dbmgr;D、GRANT hs_admin_role TO dbmgr;E、GRANT manage scheduler TO dbmgr;
While creating a scheduler window using the DBMS_SCHEDULER package， a user logged in as DBMGR gets the error message insufficient privileges. Which two commands would you use to resolve this error？（）
- A、GRANT dba TO dbmgr;
- B、GRANT connect TO dbmgr;
- C、GRANT resource TO dbmgr;
- D、GRANT hs_admin_role TO dbmgr;
- E、GRANT manage scheduler TO dbmgr;
相关考题：
根据材料回答2~3题：To keep certain information private and secure while providing remote access for employees，many businesses are creating intranets．An intranet is an（ ）organizational intemet that is guarded against outside access by a special feature called a firewall(which can be software，hardware， or a combination of the two)．A．outsideB．externalC．internalD．inside
What are four capabilities of the mysql client program?() A.Creating, dropping, and modifying tables and indexesB.Initiating a binary backup of the database by using the START BACKUP commandC.Displaying replication status informationD.Shutting down the server by using the SHUTDOWN commandE.Creating and dropping databasesF.Creating and administering users
A customer is creating an Event Action Plan to monitor CPU utilization on their SQL server. While creating a Simple Event Filter， the event type "Director.Director Agent.CPU Monitors" option is not available. Which of the following is the most likely source of the problem？（）A、The appropriate Hardware Status monitors have not been set.B、The appropriate Resource Monitor thresholds have not been set.C、The appropriate Windows Performance monitors have not been set.D、The appropriate Process Management thresholds have not been set.
An administrator is creating a comprehensive backup system to backup a single web server. Which of the following is the BEST way to provide full restore？（）A、 Take an image backup nightly while the server is online.B、 Take an incremental backup while the server is offline.C、 Take a monthly snapshot backup while the server is online.D、 Take a differential backup while the server is online.
Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control？（）A、the port used by the listenerB、the protocol used by the listenerC、the server name where the listener runsD、the log file and trace file destination for the listenerE、the database services to be registered with the listener
What are four capabilities of the mysql client program?（）A、Creating, dropping, and modifying tables and indexesB、Initiating a binary backup of the database by using the START BACKUP commandC、Displaying replication status informationD、Shutting down the server by using the SHUTDOWN commandE、Creating and dropping databasesF、Creating and administering users
多选题A customer is developing a custom application that involves a multistep provisioning process for a new account. There is a custom Java client application that is generating multiple JMS messages as part of the process and sending them to the WebLogic tier where they are processed. Which three steps must you take to implement the solution to allow for scalability and parallel processing of multiple simultaneous provisioning requests while ensuring messages for an individual process are not delivered out of order?（）AUpdate the client application that is creating the JMS messages to use Unit of Work.BConfigure a WebLogic Cluster for Distributed JMS.CUpdate the client application that is creating the JMS messages to use Unit of Order.DEnable XA Transactions on the JMS Connection Factory used by the client application.EEnable Load Balancing on the JMS connection factory used by the client application.
单选题You want the size of the tablespace to increase when it is full. Which option would you use？（）Ause automatic extent allocationBdisable threshold for the tablespaceCuse freelists to manage the free spaceDuse automatic segment space managementEcreate the tablespace as a bigfile tablespaceFuse the RESIZE clause while creating the tablespaceGenable AUTOEXTEND for at least one of the data files in the tablespace
多选题While creating a scheduler window using the DBMS_SCHEDULER package， a user logged in as DBMGR gets the error message insufficient privileges. Which two commands would you use to resolve this error？（）AGRANT dba TO dbmgr;BGRANT connect TO dbmgr;CGRANT resource TO dbmgr;DGRANT hs_admin_role TO dbmgr;EGRANT manage scheduler TO dbmgr;
单选题You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）AInformation about each Oracle Net connection.BInformation about each entry in theLinstener.orafileCInformation about the changed done in the databaseDInformation about the different listeners in your systemEInformation about all thenondatabasefiles required to operate the database
多选题While creating a scheduler window using the DBMS_SCHEDULER package， a user logged in as DBMGR gets the error message insufficient privileges？ Which two commands would you use to resolve this error？（）AGRANT dba TO dbmgr；BGRANT connect TO dbmgr；CGRANT resource TO dbmgr；DGRANT hs_admin_role TO dmbgr；EGRANT manage scheduler TO dbmgr；
单选题While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows: 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.（）A2，3，5B1，2，4C1，2，4，5D1, 2, 3, 4, 5
多选题Which two statements are true about encrypting RMAN backup？（）AThe transparent encryption of backups uses the encryption walletBThe database uses the same encryption key for every encrypted backupCThe password encryption of backups only uses the password while creating and restoring backupDIf transparent encryption is configured， you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups
单选题An administrator is creating a comprehensive backup system to backup a single web server. Which of the following is the BEST way to provide full restore？（）A Take an image backup nightly while the server is online.B Take an incremental backup while the server is offline.C Take a monthly snapshot backup while the server is online.D Take a differential backup while the server is online.
单选题While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）Aconfigure the database to run in ARCHIVELOG modeBconfigure the Flash Recovery Area to enable automatic database backupCschedule the database backup using DBMS_JOB package after creating the databaseDschedule the database backup using Recovery Manager （RMAN）commands after creating the databaseEschedule the database backup using Database Configuration Assistant （DBCA）while creating the database
多选题Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control？（）Athe port used by the listenerBthe protocol used by the listenerCthe server name where the listener runsDthe log file and trace file destination for the listenerEthe database services to be registered with the listener
单选题You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）ADBMS_STATS BDBMS_ALERT CDBMS_SPACE DDBMS_MONITOR EDBMS_SERVER_ALERTFDBMS_SPACE_ADMIN
多选题Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）AThis clause is not valid for a temporary or undo tablespace.BIf the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.CThe tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.DThe tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.
单选题A customer is creating an Event Action Plan to monitor CPU utilization on their SQL server. While creating a Simple Event Filter， the event type "Director.Director Agent.CPU Monitors" option is not available. Which of the following is the most likely source of the problem？（）AThe appropriate Hardware Status monitors have not been set.BThe appropriate Resource Monitor thresholds have not been set.CThe appropriate Windows Performance monitors have not been set.DThe appropriate Process Management thresholds have not been set.
单选题Which statement is true while creating subplans using Resource Manager？（）A The subplan must belong to the consumer group， SYS_GROUP.B The total CPU usage at any given level must be less than 100%.C The subplans can be used to restrict the degree of parallelism for a user.D You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.