出自:Oracle认证

Consider the query: Mysql＞ SET @run = 15; Mysql＞ EXPLAIN SELECT objective, stage, COUNT (stage) FROM iteminformation WHERE run=@run AND objective=’7.1’ GROUP BY objective,stage ORDER BY stage; The iteminformation table has the following indexes; Mysql＞ SHOW INDEXES FROM iteminformation: This query is run several times in an application with different values in the WHERE clause in a growing data set. What is the primary improvement that can be made for this scenario?（）
A:Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes
B:Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations
C:Drop the run_2 index because it has caused a conflict in the choice of key for this query
D:Execute the run_2 index because it has caused a conflict in the choice of key for this query
E:Add a composite index on (run,objective,stage) to allow the query to fully utilize an index
In which scenario will you perform a user-managed incomplete recovery？（）
A: when a table is dropped and stored in the Recycle Bin
B:when a table is dropped and purged from the Recycle Bin
C: when you are required to recover an existing table to its previous state
D: when you are required to view all the versions of a row of an existing table between a specific time period
View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands: SQL> CREATE TABLE emp (empno NUMBER(3), ename VARCHAR2(20), sal NUMBER(8,2)); SQL> INSERT INTO emp(empno,ename) VALUES(1,'JAMES'); At this moment, a second user also logs in to the HR schema and issues the following command: SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2); What happens in the above scenario?（）
A:The second user's session immediately produces the resource busy error.
B:The second user's command executes successfully.
C:The second user's session waits for a time period before producing the resource busy error.
D:A deadlock is created.
View the Exhibit to examine the error that occurred during the database startup. You opened an RMAN session for the database. To repair the failure， you executed the followingcommand as the first RMAN command：  RMAN>REPAIR FAILURE；  Which statement describes the consequence of this command（）
A:The command performs the recovery and closes the failure.
B:The command only displays the advice and the RMAN script required for recovery.
C:The command executes the RMAN script to repair the failure and remove the entry from the Automatic Diagnostic Repository （ADR）.
D:The command produces an error because the ADVISE FAILURE command was not executed beforethe REPAIR FAILURE command.
View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation：   RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； }   What is the multiplexing level in the preceding backup process？（）
A: 4
B: 8
C: 7
D: 0
oracle系统进程主要有哪些？
You execute the following block of code：   SQL>BEGIN   DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN   （ SIMPLE_PLAN => ’DEPARTMENTS’，   CONSUMER_GROUP1 => ’PAYROLLL’，   GROUP1_CPU => 50，   CONSUMER_GROUP2 => ’SALES’，   GROUP2_CPU => 25，   CONSUMER_GROUP3 => ’MARKETING’，   GROUP3_CPU => 25）；   END；   SQL>/   What is a prerequisite for using the simple resource plan created by executing the above code？（）
A: You must assign users to consumer groups.
B: You must grant the switch privilege to the users.
C: You must create a resource plan directive.
D: You must specify the complex resource plan.
Using the reports server how would you force the orders report in the orders entry application to run every six hours?（）
A:Schedule the report's execution in the queue manager. 
B:Schedule the reports execution using the R30RQM command line with scheduled parameter. 
C:Create a trigger in the application to execute the report every six hours. 
D:You cannot schedule a reports execution.
Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service （IPS） to MetaLink？（）
A: The database must be running in ARCHIVELOG mode.
B: No special setup is required， and the feature is enabled by default.
C: The path for the Automatic Diagnostic Repository （ADR） must be configured with the  DIAGNOSTIC_DEST initialization parameter.
D: The Enterprise Manager Support Workbench can be enabled only if the background process manage ability monitor （MMON） is configured.
E: Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software， provide valid MetaLink credentials and select  license agreement.
在Oracle中，（）数据字典表可以用来查看抽象数据类型的实际结构。
A:USER_TYPE_ATTRS
B:USER_TABLES
C:USER_TYPE_TABS
D:USER_TAB_COLUMNS
The user SYS creates a job by using the following command: Which two statements are true about the job that was created by the preceding command?（）
A:The job is enabled by default after creation
B:The job is automatically dropped after the end date
C:The job executes with the privileges of the user SYS
D:
As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）  
A: Shut down the database
B: Clear the online redo log
C: Back up the database
D: Checkpoint the database
E: Call Oracle support
SQL*PLUS在ORACLE数据库系统中的作用，以下叙述正确的是（）
A:是ORACLE数据库服务器的主要组成部分，是服务器运行的基础构件
B:是ORACLE数据库系统底层网络通信协议，为所有的ORACLE应用程序提供一个公共的通信平台
C:是ORACLE客户端访问服务器的一个工具，通过它可以向服务器发送SQL命令
D:是ORACLE客户端到客户端的点对点的通信工具，用来传递各个客户端的数据
E:以上所述都不正确
Choose two correct role definitions for Grid Control in context of WebLogic server（）
A: Grid Control allows administrative changes to be made to WebLogic domain
B: Grid Control enables multi-domain monitoring and management of WebLogic Server 
C: Grid Control provides service/system dashbord， and topology views for WebLogic Domains 
D: Grid Control allows creating and configuring WebLogic Domains
You executed the following PL/SQL block successfully：   VARIABLE tname VARCHAR2（20）  BEGIN dbms_addm.insert_finding_directive （NULL， DIR_NAME=>’Detail CPU Usage’， FINDING_NAME=>’CPU Usage’， MIN_ACTIVE_SESSIONS=>0， MIN_PERC_IMPACT=>90）；  ：tname ：= ’database ADDM task4’； dbms_addm.analyze_db（：tname， 150， 162）；  END； /    Then you executed the following command：   SQL> SELECT dbms_addm.get_report（：tname） FROM DUAL；   The above command produces Automatic Database Diagnostic Monitor （ADDM） analysis（）
A: with the CPU Usage finding if it is less than 90
B: without the CPU Usage finding if it is less than 90
C: with the CPU Usage finding for snapshots below 90
D: with the CPU Usage finding for snapshots not between 150 and 162
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）
A:It updates the existing SQL profiles with current statistics.
B:It makes the statistics information available to GATHER_STATS_JOB
C:It initiates the statistics collection process by running GATHER_STATS_JOB
D:It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）
A:16 
B:100 
C:160 
D:200 
E:150
Which four actions can you perform using the WebLogic Admin Console?（）
A:Stop and start Managed Servers using the Node Manager.
B:Stop and start Coherence Servers using the Node Manager.
C:Create a WebLogic Domain Template.
D:Create and target JDBC connection pools.
E:Create and target WebLogic Diagnostic Framework Diagnostic Modules.
F:Change Java command-line parameters at run time.
Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？ （）
A:current redo log and inactive redo log
B:checkpoint position to end of redo log
C:beginning of redo log to end of redo log
D:all redo logs before the point of last commit
E:beginning of redo log to checkpoint position
A user sends you an email with the following error message： create table idtable（id number） * ERROR at line  1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error：  2： No such file or directory Additional information：  3 You can choose from the following steps： a. Restore the missing database datafiles.  b. Take the missing datafile offline.  c. Shut down the database.  d. Issue the recover tablespace USERS command.  e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online.  g. Issue the alter database open command.  Which is the correct order of these steps in this case？（）
A:b， a， d， f
B:c， a， e， b， d， f， g
C:c， e， d， g
D:b， d， f 
E:e， d， g
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedureto many database users： CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgrNUMBER， v_loc NUMBER）BEGIN INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END； The users having permission to execute the procedure are able to insert records into the DEPARTMENTS tableeven though they do not have the INSERT privilege on the table. You want only those users who haveprivileges on the DEPARTMENTS table to be able to execute the procedure successfully.  What would yousuggest to the PL/SQL developers to achieve this（）
A:Create the procedure with definer’s right.
B:Create the procedure with invoker’s right.
C:Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
D:Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package toselected users
Which statement explicitly names a constraint?（）
A:ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students (student_id);
B:ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
C:ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
D:ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
E:ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）
A:cannot be used in RMAN
B:by starting up the database again
C:by using the CATALOG command of RMAN
D:by using the RECOVER CATALOG command in RMAN
E:by re-creating the target control file to rebuild the RMAN repository
Examine the data from the EMP table: EMP_ID DEPT_ID COMMISSION 1 10 500 2 20 1000 3 10 4 10 600 5 30 800 6 30 200 7 10 8 20 300 The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to perform in a single step? （）
A:Deleting the records of employees who do not earn commission.
B:Increasing the commission of employee 3 by the average commission earned in department 20.
C:Finding the number of employees who do NOT earn commission and are working for department 20.
D:Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.
E:Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.
F:Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.
These are the details about V$FLASHBACK_DATABASE_STAT：  SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null？ Type  ------------- -------- --------------  BEGIN_TIME DATE END_TIME DATE  FLASHBACK_DATA NUMBER  DB_DATA NUMBER REDO_DATA NUMBER  ESTIMATED_FLASHBACK_SIZE NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true？ （）
A:BEGIN_TIME is the time at which Flashback logging is enabled.
B:END_TIME is the time at which the query is executed on the view.
C:REDO_DATA is the number of bytes of redo data written during the interval.
D:This view contains information about flashback data pertaining to the last 24 hours.
E:FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY， what is its effect？ （）
A:The Advisory is on and will capture both CPU and memory overhead.
B:The Advisory is on but the memory for the Advisory is not allocated.
C:The Advisory is off and the memory for the Advisory is not allocated.
D:The Advisory is off but the memory for the Advisory remains allocated.
Which of the following statements best describes Flashback Versions Query？（）  
A: Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.
B: Flashback Versions Query is used to view all version changes on rows that existed between the time  the query was executed and a point in time in the past.
C: Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
D: Flashback Versions Query is used to view all version changes on rows that existed between two  points in time.
Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation？（）  
A: ADD DIRECTORY
B: DROP DISK
C: RESIZE DISK
D: REBALANCE
E: ADD FAILGROUP
You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）
A:The baseline， once created， cannot be removed.
B:Disable the baseline metrics in the Database Control Manage Metrics page.
C:The baseline will be automatically removed once the database performance has been optimized.
D:Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
In which scenario will you create a sorted hash cluster？ （）
A: if the application uses queries joining tables only occasionally
B: if the full table scan is executed often on only one table of the clustered tables
C: if the data for all the rows of a cluster key value exceeds one or two Oracle blocks
D: when you want the data to be returned automatically in the chronological order
首页 <上一页 74 75 76 77 78 下一页> 尾页