网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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？（）AGRANT dba TO dbmgr;BGRANT connect TO dbmgr;CGRANT resource TO dbmgr;DGRANT hs_admin_role TO dbmgr;EGRANT manage scheduler TO dbmgr;” 相关考题
考题
Evaluate the following block of code:What is the outcome of the above code?()
A. It produces an error because a fully qualified host name needs to be specified.B. It produces an error because the range of ports associated with the hosts has not been specified.C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
考题
Which information would you find using the CLI help function?()
A. message of the dayB. tip of the dayC. explanation for specific system log error messagesD. explanation for specific traceoptions log messages
考题
A user is trying to use Remote Desktop to connect to another computer on the LAN. Theconnection fails. The technician opens up a command prompt and types the following: telnetcomputernamE. 3389” and also gets the same error message.Which of the following is the MOSTlikely cause of this error, assuming that the OS firewall has been disabled?（）A. The antivirus software is blocking the incoming connection.B. The ISP is blocking Remote Desktop at their end.C. The RDP connection has been configured to use a non-standard port.D. The telnet service has not been installed.
考题
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 job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）A、 Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.B、 Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.C、 Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.D、 Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.
考题
Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M； What would be the result of this command？（）A、It would result in an error because the template cannot be used along with the disk group.B、It would result in an error because the path cannot be specified while creating a tablespace in a disk group.C、It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.D、It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.
考题
A system administrator receives a new server and has booted the system for the first time. The administrator has set up the terminals and users. The user start to log on. Root is logged in on the console. When additional users start to log in, an error is displayed stating that All available login sessions are in use. Which of the following steps should be followed to resolve this problem?（）A、Permissions on /etc/security were changed in error; do a chmod 755 on /etc/security directory.B、Increase the number of licenses; using smit chaili censeC、Change the Maximum number of PROCESSES allowed per user variable; using smit chgsys.D、Change User can logi field from false to true: using smit chuser.
考题
User "twsuser" is logged on to the IBM Tivoli Workload Scheduler Master Domain Manager server using Job Scheduling Console to update calendar. The user receives a message： MODIFY on CALENDAR access not granted. What is the cause of this error？（）A、 Batchman process is down.B、 User password has expired.C、 WebSphere security is damaged.D、 There are insufficient permissions in Security file.
考题
You are creating an error page that provides a user-friendly screen whenever a server exception occurs.You want to hide the stack trace， but you do want to provide the exception’s error message to the user sothe user can provide it to the customer service agent at your company. Which EL code snippet inserts thiserror message into the error page？（）A、Message： b${exception.message}/bB、Message： b${exception.errorMessage}/bC、Message： b${request.exception.message}/bD、Message： b${pageContext.exception.message}/bE、Message： b${request.exception.errorMessage}/b
考题
Which information would you find using the CLI help function?（）A、message of the dayB、tip of the dayC、explanation for specific system log error messagesD、explanation for specific traceoptions log messages
考题
When you try to open your database， you receive the following error： ORA-00205： error in identifying control file Where would you find the details required to resolve this error？（）A、audit trailB、alert log fileC、user trace fileD、online trace fileE、background trace fileF、operating system event viewer
考题
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 dmbgr；E、 GRANT manage scheduler TO dbmgr；
考题
A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work. ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）A、Modify the profile assigned to the user.B、Modify the roles assigned to the users.C、Modify the object privileges assigned to the user.D、Modify the system privileges assigned to the users.E、Modify the value for the RESOURCE_LIMIT parameter in the parameter file.
考题
You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error： ERROR： ORA-12154：TNS：couldnot resolve service name Which network configuration files would you look into to resolve this error？（）A、snmp.oraB、names.oraC、spfile.oraD、sqlnet.oraE、listener.oraF、tnsnames.ora
考题
Your business has departmental reports that are generated every day. Each department must use the same set of queries， but access a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed； currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）A、 By having each user run the report generation procedure at the scheduled time， supplying the necessary input variables.B、 By creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB.C、 By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.D、 By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.E、 By creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER.
考题
Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3 （usder_temp） /user_files/user_tbsp’ SIZE 200M； What would be the result of this command？（）A、 It would result in an error because the template cannot be used along with the disk group.B、 It would result in an error because the path cannot be specified while creating a tablespace in a disk group.C、 It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.D、 It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of two SQL Server 2008 instance. The two instances are respectively named InstanceA and InstanceB. There is a database named Dworks on InstanceA. You move the Dworks database to InstanceB. A user use a SQL Server login named Mary to access the database on InstanceA with the password "Tk@87#34". On InstanceB, you create the same SQL Server login. The user tries to use the SQL Server login Mark to access the Dworks database on InstanceB. But the user gets an error message, according to the indication of the message, the access to the Dworks database has been denied. You must make sure that the user can access the Dworks database on InstanceB successfully. So on InstanceB, which Transact-SQL statements should you execute?（） A、USE AdventureWorks;ALTER USER Mary WITH LOGIN = Mary; B、USE AdventureWorks;ALTER LOGIN Mary ENABLE; C、USE AdventureWorks;ALTER LOGIN Mary WITH PASSWORD = "Tk@87#34" UNLOCK; D、USE AdventureWorks;ALTER LOGIN Mary WITH DEFAULT_DATABASE = AdventureWorks;
考题
单选题Your business has departmental reports that are generated every day. Each department must use the same set of queries， but accesses a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed; currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）A
by having each user run the report generation procedure at the scheduled time， supplying the necessary input variablesB
by creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOBC
by having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the reportD
by having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the reportE
by creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER
考题
多选题User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted： INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） * ERROR at line 1： ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.（）AGrant the RESOURCE role to SCOTT.BAdd data files to the USERS tablespace.CGrant the CREATE ANY TABLE privilege to SCOTT.DIncrease the space for SCOTT on the USERS tablespace.EIncrease the size of the data file associated with the USERS tablespace
考题
单选题While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）A
Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.B
Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.C
Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.D
Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.
考题
单选题User "twsuser" is logged on to the IBM Tivoli Workload Scheduler Master Domain Manager server using Job Scheduling Console to update calendar. The user receives a message： MODIFY on CALENDAR access not granted. What is the cause of this error？（）A
Batchman process is down.B
User password has expired.C
WebSphere security is damaged.D
There are insufficient permissions in Security file.
考题
单选题You are creating an error page that provides a user-friendly screen whenever a server exception occurs.You want to hide the stack trace， but you do want to provide the exception’s error message to the user sothe user can provide it to the customer service agent at your company. Which EL code snippet inserts thiserror message into the error page？（）A
Message： b${exception.message}/bB
Message： b${exception.errorMessage}/bC
Message： b${request.exception.message}/bD
Message： b${pageContext.exception.message}/bE
Message： b${request.exception.errorMessage}/b
考题
单选题A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on to the database to continue his work. ORA-02392： exceeded session limit on CPU usage， you are being logged off Which action would you take to increase the session limit on CPU usage？（）A
Modify the profile assigned to the user.B
Modify the roles assigned to the users.C
Modify the object privileges assigned to the user.D
Modify the system privileges assigned to the users.E
Modify the value for the RESOURCE_LIMIT parameter in the parameter file.
考题
多选题You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error： ERROR： ORA-12154：TNS：couldnot resolve service name Which network configuration files would you look into to resolve this error？（）Asnmp.oraBnames.oraCspfile.oraDsqlnet.oraElistener.oraFtnsnames.ora
考题
多选题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；
考题
多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）Aopen the database with the RESTRICTED optionBopen the database with the RESETLOGS optionCrecover to the required SCN only that data file in which the error occurredDrecover all the data files to the same system change number （SCN）
考题
单选题You want to create a consumer group， GROUP1， and you execute the following command in the command/x7fline interface： SQL EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =’group1’， COMMENT = ’New Group’）; This command errors out displaying the following message： ERROR at line 1： ORA/x7f01031： insufficient privileges ORA/x7f06512： at "SYS.DBMS_RMIN"， line 115 ORA/x7f06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA/x7f06512： at line 1 What action would you take to overcome this error？（）A
grant SYSDBA to the userB
grant SYSOPER to the userC
grant the RESOURCE role to the userD
use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the userE
grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package
考题
多选题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;
热门标签
最新试卷