出自:Oracle认证

Which three elements can a job chain process involve?（）
A:an event
B:a schedule
C:a program
D:another chain
E:a lightweight job
Which two statements are true about Oracle JRockit Mission Control （JRMC） ？ （）
A: JRMC is platform neutral. It supports mosr JVMs in market
B: JRMC is used for Deep visibility and analisys of single JVMs
C: JRMC comes with custom in-memory agents and is supported by standard APIs （JVMT1）
D: JRMC is bundled with the WebLogic Suite and WebLogic Server EE
Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）
A:It is ignored by the query optimizer.
B:It is not used while the index is being rebuilt.
C:The index cannot be rebuilt， and has to be re-created.
D:The index is automatically rebuilt when used the next time
You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）
A:One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
B:One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
C:Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
D:None of the tables are recovered from the Recycle Bin, and the statement returns an error.
Given： What is the result？（）
A:b 3
B:b 8
C:b 13
D:f 3
下列哪项后台服务进程不是ORACLE例程必须要启动的（）
A:DBWn
B:LGWR
C:SMON
D:PMON
E:ARCn
In your database， the users SYS and SYSTEM have been assigned the profiles， ADMIN_PROF1 and ADMIN_PROF2， respectively. The rest of the database administrators are assigned the profile ADMIN_PROF3. You create a profile， USER_PROF， and assign it to the application user， Adams. After a week you realize that the profile is no longer required and you decide to drop it. What will Adam’s profile be after the USER_PROF profile has been dropped？（）
A:no profiles
B:the default profile
C:same as the profile of SYS user
D:same as the profile of SYSTEM user
You completed the development of a new application and want to create a new domain in a new environment for functional testing. You want to have the same settings for your new domain as your old domain, with the option of changing the configuration in the new target environment. Which two actions should you execute?（）
A:Use the introspect () command in WLST to gather the configuration information from the  original domain.
B:Use pack/unpack to transfer the domain from one machine to another.
C:Create a domain template from the original domain using the Domain Template Builder and use  the Configuration Wizard to create a new domain from the template.
D:Use the Admin Console of the original domain to create a domain template from the original  domain and use the Configuration Wizard to create a new domain from the template.
Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?（）
A:Mysqlaccess
B:Mysqldump
C:Mysqlshow
D:Mysqlslow
E:Mysqldumpslow
Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（）   a. restore database  b. recover database  c. shutdown immediate  d. startup  e. restore archivelog all f. alter database open 
A: a， b， c， d， e， f
B: c， b， a， d， e， f
C: c， b， a， d， f
D: c， a， b， d
E: c， a， e， b， d， f
You have configured the following：  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’； new RMAN configuration parameters：  CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’； new RMAN configuration parameters are successfully stored RMAN> SHOW DEVICE TYPE； RMAN configuration parameters are： CONFIGURE DEVICE TYPE SBT PARALLELISM 1； # CONFIGURE DEVICE TYPE DISK PARALLELISM 1； #  RMAN> CONFIGURE DEVICE TYPE SET PARALLELISM 5；  RMAN> SHOW DEVICE TYPE； RMAN configuration parameters are： CONFIGURE DEVICE TYPE SBT PARALLELISM 5； CONFIGURE DEVICE TYPE DISK PARALLELISM 1； #  How many channels are allocated to SBT？（）
A:0， because channels have not been defined.
B:3， as indicated by the degree of parallelism.
C:1， the default value when device is configured.
D:5， as indicated by the last parallelism command.
Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）
A: The USERS.DBF datafile is corrupted and cannot be restored by RMAN.
B: The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
C: The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
D: The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to， in order to determine the appropriate indexes？（）
A:Memory Advisors
B:Segment Advisors
C:SQL Tuning and Access Advisors
D:Automated Workload Repository （AWR）
E:Automatic Database Diagnostic Monitor （ADDM）
View the Exhibit and examine the attributes of an undo tablespace.    In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hourthat performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives thefollowing error:  ORA-01555: snapshot too old  What could be the reason for this error（） 
A:The query is unable to get a read-consistent image.
B:There is not enough space in Flash Recovery Area.
C:There is not enough free space in the flashback archive.
D:The query is unable to place data blocks in undo tablespace
A team of programmers is involved in reviewing a proposed design for a new utility class. After some discussion， they realize that the current design allows other classes to access methods in the utility class that should be accessible only to methods within the utility class itself. What design issue has the team discovered？（）
A:Tight coupling
B:Low cohesion
C:High cohesion
D:Loose coupling
E:Weak encapsulation
F:Strong encapsulation
You issue this RMAN command：   RMAN> create script Level0Backup {   backup   incremental level 0   format ‘/u01/db01/backup/%d_%_Sp’   fileperset 5   （database include current controlfile）；   sql ‘alter database archive log current’；   }  Which three statements are true about the Level0Backup script you just created？（）
A:The script is stored only in the control file.
B:The script is stored only in the recover catalog.
C:The script can be executed only by using the RMAN RUN command.
D:The commands of the script can be displayed with the LIST command.
E:The commands of the script can be displayed with the PRINT command.
F:The commands of the script can be displayed with the REPORT command.
Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）
A:2，4，3
B:1，4，3，2
C:2，5，4，3，6
D:5，2，4，3，6
E:1，5，4，3，6，2
How would you default the layout of a parameter form? （）
A:Use the default layout tool in the parameter form editor. 
B:Select menu item tool->parameter form builder. 
C:Open the parameter form editor and select menu items tool->default layout. 
D:You cannot default the layout of the parameters.
Which two statements are true regarding Health Monitor checks in Oracle Database 11g？（）  
A: Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
B: Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible，corrupt or inconsistent.
C: Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
D: Health Monitor checks are always initiated manually when there is some critical error.
You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）
A:Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
B:Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
C:Data is never redacted for the EMP_V.SAL column.
D:Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
E:Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
在Oracle中，（）是一个基于Web的SQL*Plus工具，能够在网页中执行SQL*Plus命令。
A:SQL*Plus
B:iSQL*Plus
C:PL*SQL
D:iPL*SQL
View the Exhibit. You are creating an additional database by using the Database Configuration Assistant（DBCA）. You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled.  What could be the reason for this（）
A:You have chosen the File System option as the storage option.
B:You have chosen the Automatic Storage Management （ASM） as the storage option.
C:The data block size can be increased only when DBCA is invoked from Oracle Universal Installer （OUI）.
D:You are using General Purpose template and not the Custom Database template to create the database
Given：   What is the result？（）
A: If you define D e = new E（）， then e.bMethod（） invokes the version of bMethod（） defined in Line 5.
B: If you define D e = （D）（new E（））， then e.bMethod（） invokes the version of bMethod（） defined in Line 5.
C: Compilation fails because of an error in line 9.
D: If you define D e = （D）（new E（））， then e.bMethod（） invokes the version of bMethod（） defined in Line 9.
E: Compilation fails because of an error in line 3.
F: Compilation fails because of an error in line 7.
The following are the details of your database：Instance name：test  Host name ： tech1.us.oracle.com IP address：145.33.230.186 Enterprise Manager Console HTTP Port number：5500  You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser.  Which two URLs would you use to access the Database Control？（）
A:http：//145.33.230.186：5500/em
B:http：//www.145.33.230.186：5500/em
C:http：//tech1.us.oracle.com：5500/em
D:http：//test.145.33.230.186：5500/em
E:http：//test.tech1.us.oracle.com：5500
F:http：//www.tech1.us.oracle.com：5500/em
G:http：//test.tech1.us.oracle.com：5500/em
Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）
A:No change is required to achieve the desired results.
B:SELECT ename, sal, 12* (sal+100) FROM emp;
C:SELECT ename, sal, (12* sal)+100 FROM emp;
D:SELECT ename, sal +100,*12 FROM emp;
You executed the following command to create a tablespace called SALES_DATA：  > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；  Which two statements are true about the SALES_DATA tablespace （）
A:The database automatically determines the extent-sizing policy for the tablespace.
B:The segments are automatically shrunk when the contents are removed from them.
C:The allocation of extents within the tablespace is managed through the dictionary tables.
D:The space utilization description of the data blocks in segments is recorded inbitmapblocks.
E:The space utilization description of the data blocks in segments is managed through free lists.MANUAL
After a number of days set by the parameter CONTROL_FILE_RECORD_KEEP_TIME， the information in the control file is overwritten by RMAN. What is this parameter’s default value？（）
A:1 day
B:5 days
C:7 days
D:31 days
在SQL*PLUS中显示当前用户的命令是（）
A:show account
B:show accountname
C:show user
D:show username
E:以上所述都不正确
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）
A: SYSDATE should not be used with TIMESTAMP.
B: The database must have multiplexed redo log files.
C: The database must be in the MOUNT state to execute the command.
D: The database must be opened with the RESETLOGS option after the flashback operation.
E: The entire database needs to be restored from the most recent backup before the flashback operation.
Which Man class properly represents the relationship "Man has a best friend who is a Dog"?（）
A:class Man extends Dog { }
B:class Man implements Dog { }
C:class Man { private BestFriend dog; }
D:class Man { private Dog bestFriend; }
E:class Man { private Dog; }
F:class Man { private BestFriend; }
首页 <上一页 60 61 62 63 64 下一页> 尾页