网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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？（）A
use automatic extent allocationB
disable threshold for the tablespaceC
use freelists to manage the free spaceD
use automatic segment space managementE
create the tablespace as a bigfile tablespaceF
use the RESIZE clause while creating the tablespaceG
enable 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？（）A
Information about each Oracle Net connection.B
Information about each entry in theLinstener.orafileC
Information about the changed done in the databaseD
Information about the different listeners in your systemE
Information 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.（）A
2，3，5B
1，2，4C
1，2，4，5D
1, 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？（）A
configure the database to run in ARCHIVELOG modeB
configure the Flash Recovery Area to enable automatic database backupC
schedule the database backup using DBMS_JOB package after creating the databaseD
schedule the database backup using Recovery Manager （RMAN）commands after creating the databaseE
schedule 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?（）A
DBMS_STATS B
DBMS_ALERT C
DBMS_SPACE D
DBMS_MONITOR E
DBMS_SERVER_ALERTF
DBMS_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？（）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.
考题
单选题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.
热门标签
最新试卷