出自:Oracle认证

You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?（）
A:It produces a warning for new failures before advising for CRITICAL and HIGH failures.
B:It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
C:It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
D:It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.
SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）
A:direct-path load
B:conventional path load
When setting arguments for a job， which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype？（）  
A: SET_JOB_ARGUMENT_VALUE
B: SET_JOB_VALUE_ANYDATA
C: SET_JOB_ANYDATA_VALUE
D: SET_SPECIAL_JOB_VALUE
E: SET_JOB_ANYTYPE_VALUE
Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）
A:USER_TAB_PRIVS_MADE
B:USER_TAB_PRIVS
C:USER_COL_PRIVS_MADE
D:USER_COL_PRIVS
You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent. Which type of backup should you perform?（）
A:standard backup set
B:image copy
C:compressed backup
D:user-managed backup
In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups，DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（） 
A:This command would result in an error because the disk group is not empty.
B:The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.
C:The command would result in the disk group being marked as INVALID because it cannot be dropped.
D:The command would result in the contents being moved to the parent disk group and dropping of the disk group.
E:The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement？（）
A: The ORDERS_MASTER table would contain the ORDERJDs 1 and 2.
B: The ORDERS_MASTER table would contain the ORDERJDs 1， 2 and 3.
C: The ORDERS_MASTER table would contain the ORDERJDs 1， 2 and 4.
D: The ORDERS MASTER table would contain the ORDER IDs 1， 2， 3 and 4.
Which of the following does the recover command not do？（）  
A: Restore archived redo logs.
B: Apply archived redo logs.
C: Restore incremental backups.
D: Apply incremental backups.
E: Restore datafile images.
Click the Exhibit button and examine the diagram.  You are running a database that takes advantage of features provided by Connection Manager， heterogeneous services， and external procedures. The diagram depicts the components used for the naming method you just configured. Which naming method are you using？（）
A:Host naming method.
B:Local naming method.
C:Directory naming method.
D:External naming method.
What are three uses for record groups?（）
A:To pass data to a pop-up menu. 
B:To populate a base table block. 
C:To pass data to other form modules. 
D:To pass data to other Oracle products. 
E:To dynamically construct SELECT statements. 
F:To server as the source for a FROM clause query. 
Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）
A:modify the HASH_AREA_SIZE initialization parameter
B:modify the PGA_AGGREGATE_TARGET initialization parameter
C:modify the WORK_AREASIZE_POLICY initialization parameter
D:increase the value of the SGA_TARGET initialization parameter
E:increase the value of the SGA_MAX_SIZE initialization parameter
F:increase the value of the SORT_AREA_SIZE initialization parameter
Which three will compile and run without exception？（）
A:private synchronized Object o；
B:void go（） {synchronized（） {  }
C:public synchronized void go（） {  }
D:private synchronized（this） void go（） {  }
E:void go（） {synchronized（Object.class） {  }
F:void go（） {Object o = new Object（）；synchronized（o） {  }
Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（） 
A: ALTER SYSTEM KILL SESSION
B: ALTER SYSTEM DISCONNECT SESSION
C: ALTER SYSTEM QUIESCE RESTRICTED
D: ALTER SYSTEM ENABLE RESTRICTED SESSION
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）
A:You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
B:The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
C:The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
D:Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
E:The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
F:The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.
View the Exhibit to examine the output produced by the following query at three different times sincethe database instance started and has experienced workloads of different capacities：  SQL> SELECT substr（component， 0， 10） COMP， current_size CS，user_specified_size USFROM v$memory_dynamic_componentsWHERE current_size!=0；  What do you infer from this（）
A:The database instance is running with manual PGA management.
B:The database instance is running with manual shared memory management.
C:The database instance has the MEMORY_TARGET value set to a nonzero value.
D:All sessions are connected to the database instance in dedicated mode， and no RMAN or parallelquery operations have been performed.
Which of the following file should be configured for dynamic service registration？（）
A:LISTENER.ORA
B:SQLNET.ORA
C:INIT.ORA
D:TNSNAMES.ORA
You are creating a job class. You have issued the following command to create the job class：  SQL> BEGIN   DBMS_SCHEDULER.CREATE_JOB_CLASS（        JOB_CLASS_NAME => ’LOW_PRIORITY_CLASS’，        RESOURCE_CONSUMER_GROUP => ’LOW_GROUP’，        LOGGING_LEVEL => DBMS_SCHEDULER.LOGGING_FULL，        LOG_HISTORY => 1200，   COMMENTS => ’LOW JOB PRIORITY CLASS’）；        END；        SQL> /   What will be the result of the above command？（）
A: The command will be executed successfully.
B: The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
C: The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
D: The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
E: The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
Which two statements are true regarding undo tablespaces（）
A:The database can have more than one undo tablespace.
B:The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
C:Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
D:An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
Which two Oracle products come pre-packaged with Oracle’s JRockit JDK ？（）
A: Oracle WebLogic Server
B: Oracle Coherence
C: Oracle Database
D: Oracle Real Time Operations Control
查看下面语句为（）索引？ CREATE INDEX test_index ON student(sno,sname) TABLESPACE users STORAGE(INITIAL 64k,next 32k)
A:全局分区索引
B:位图索引
C:复合索引
D:基于函数的索引
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90  Critical （%）： 95  Which background process is responsible for issuing alerts when the threshold is crossed（）
A:System monitor （SMON）
B:Process monitor （PMON）
C:Memory manager process （MMAN）
D:Manageability Monitor process （MMON）
You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）
A:restore the tablespace from the backup; there is no need to apply the redo information 
B:restore the full database to recover the data up to the point when you performed the backup 
C:restore the tablespace from the backup， and then perform a recovery using the backup control file
D:restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?（）
A:The RMAN backup fails because the TOOLS tablespace is read-only
B:The RMAN skips the backup of the tablespace because backup optimization is enabled
C:The RMAN makes backup because optimization can be enabled only for backups to disk
D:The RMAN makes the backup because no backup of the tablespace exists within the seven day window
Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?（）
A:46 and 45
B:46 and 45.93
C:50 and 45.93
D:50 and 45.9
E:45 and 45.93
F:45.95 and 45.93
Which command will result in a trace file being created with the create controlfile command contained in it？（）  
A: alter database backup controlfile
B: alter database backup controlfile to trace
C: alter database controlfile backup
D: alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
E: alter database begin controlfile backup
You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）
A:You can perform consistent backups only.
B:You can perform a complete database backup without shutting down the database instance.
C:You can back up data files only when all data files have the same SCN recorded in the control file.
D:You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.
Given: Which method will complete this class?（）
A:public int compareTo(Object o){}
B:public int compareTo(Score other){}
C:public int compare(Score s1,Score s2){}
D:public int compare(Object o1,Object o2){}
Given: Which code, inserted at line 15, allows the class Sprite to compile?（）
A:Foo { public int bar() { return 1; }
B:new Foo { public int bar() { return 1; }
C:new Foo() { public int bar() { return 1; }
D:new class Foo { public int bar() { return 1; }
A SELECT statement can be used to perform these three functions: 1.Choose rows from a table. 2.Choose columns from a table. 3.Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities?（）
A:difference, projection, join
B:selection, projection, join
C:selection, intersection, join
D:intersection, projection, join
E:difference, projection, product
Which hardware storage option, when set up with redundant disks, offers the least stability,availability, and reliability for Mysql data?（）
A:RAID 5
B:iSCSI
C:SAN (Storage Area Network)
D:NFS (Networked File System)
首页 <上一页 111 112 113 114 115 下一页> 尾页