搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

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；

查看正确答案
更多“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？（）”相关的问题
第1题
[单选题] What is a primary differentiator between pSeries eWLM (Enterprise Workload Manager) and WLM (Workload Manager)?（）

A、pSeries eWLM can create classes while pSeries WLM can create tiers.  B、pSeries eWLM can create tiers while pSeries WLM can create classes.  C、pSeries eWLM is implemented over multiple O/S images while pSeries WLM is implemented within an individual O/S image.  D、pSeries eWLM is implemented within an individual O/S image while pSeries WLM is implemented over multiple O/S images.  

点击查看答案
第2题
[单选题] 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.  

点击查看答案
第3题
[单选题] While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

A、A primary key must have been created.  B、A mapping table must have been created.  C、An overflow tablespace must have been specified.  D、The PCTTHRESHOLD option must have been specified.  

点击查看答案
第4题
[] While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（） 

A、A.A primary key must have been created.  B、B.A mapping table must have been created.  C、C.An overflow tablespace must have been specified.  D、D.The PCTTHRESHOLD option must have been specified.  

点击查看答案
第5题
[] While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

A、A. A primary key must have been created.  B、B. A mapping table must have been created.  C、C. An overflow tablespace must have been specified.  D、D. The PCTTHRESHOLD option must have been specified.  

点击查看答案
第6题
[单选题] While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software， you are prompted to run orainstRoot.sh script. What does this script accomplish？（）

A、It creates the pointer file.  B、It creates the base directory.  C、It creates the Inventory pointer file.  D、It creates the Oracle user for installation.  E、It modifies the Unix kernel parameters to match Oracle’s requirement.  

点击查看答案
第7题
[] You want to create a temporary table while executing a procedure in a form. Which statement is true?（）

A、A.You cannot create a table form within Forms.   B、B.You must use the FORMS_DDL built-in to create the table.   C、C.You must use the DBMS_DYNAMIC_DDL package to create the table.   D、D.You can write the CREATE TABLE statement directly into the trigger.  

点击查看答案
第8题
[单选题] You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files.   B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.   C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option.   D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.   E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.  

点击查看答案
第9题
[单选题] 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 mode  B、configure the Flash Recovery Area to enable automatic database backup  C、schedule the database backup using DBMS_JOB package after creating the database  D、schedule the database backup using Recovery Manager （RMAN）commands after creating the database  E、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database  

点击查看答案
第10题
[单选题] You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）

A、 redo log files  B、 password file  C、 control file  D、 change tracking file  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服