出自:Oracle认证

Given： What is the result？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:doStuff x = 6 main x = 6
D:doStuff x = 6 main x = 7
E:doStuff x = 7 main x = 6
You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）
A: Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.
B: Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.
C: Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.
D: Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.
You are installing Oracle Database 11g on a machine. When you run the installer， the Oracle Universal Installer（OUI） shows the message that says one of the product-specific prerequisite checks has failed：Checking available swap space requirements ...Expected result： 1512MBActual Result： 1018MB Check complete. The overall result of this check is： Failed <<<< Problem： The system does not have therequired swap space. What happens to the installation in this situation（）
A:It can be continued.
B:It resizes the swap space automatically when you proceed further.
C:It can be continued， but the instance cannot be started without increasing the swap space.
D:It shows a message saying one or more prerequisite checks have failed and the installation cannot proceed
You issued the RMAN>SHOW ALL； command. The output of this command is as follows： After analyzing the output， which conclusion will you draw？（）
A: The current control file is not automatically backed up every time you perform a backup.
B: The backups save space on the storage media.
C: While performing backups across a network， the network bandwidth is reduced.
D: The backups consist of backup pieces.
What is true of using group functions on columns that contain NULL values?（）
A:Group functions on columns ignore NULL values.
B:Group functions on columns returning dates include NULL values.
C:Group functions on columns returning numbers include NULL values.
D:Group functions on columns cannot be accurately used on columns that contain NULL values.
E:Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.
What does the FORCE option for creating a view do? （）
A:creates a view with constraints
B:creates a view even if the underlying parent table has constraints
C:creates a view in another schema even if you don't have privileges
D:creates a view regardless of whether or not the base tables exist
通过SQL*PLUS等数据库访问工具登录数据库服务器时，所需的数据库连接串是在以下哪个文件中定义的（）
A:tnsnames.ora
B:sqlnet.ora
C:listener.ora
D:init.ora
E:以上所述都不正确
Which can appropriately be thrown by a programmer using Java SE technology to create a desktop application？（）
A:ClassCastException
B:NullPointerException
C:NoClassDefFoundError
D:NumberFormatException
E:ArrayIndexOutOfBoundsException
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）
A:Only 1
B:Only 2
C:Only 3
D:3 and 1
E:1 and 2
You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）
A:ALTER TABLE commercials   MODIFY (description CHAR2(2000));
B:ALTER TABLE commercials   CHANGE (description CHAR2(2000));
C:ALTER TABLE commercials   CHANGE (description VARCHAR2(2000));
D:ALTER TABLE commercials   MODIFY (description VARCHAR2(2000));
E:You cannot increase the size of a column if the table has rows.
You have configured the ASM instance for the PROD database of iPod Corporation. You have specified the following parameter values in the initialization parameter file：   DB_CREATE_FILE_DEST=’devices/grp1/P’   DB_CREATE_ONLINE_LOG_DEST_1=’devices/d_grp2/Q’        DB_CREATE_ONLINE_LOG_DEST_2=’devices/d_grp3/R’        BACKGROUND_DUMP_DEST=’devices/d_grp1/S’   You have added a new redo log group that contains two redo log members. Where are the redo log members stored？（）
A: Both the members will be stored in the ’devices/grp1/P’ directory.
B: Both the members will be stored in the ’devices/d_grp2/Q’ directory.
C: Both the members will be stored in the ’devices/d_grp3/R’ directory.
D: One member will be stored in the ’devices/d_grp2/Q’ directory and the other in the ’devices/d_grp3/R’ directory.
Examine the following RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?（）
A:Provide a password for the encryption
B:Set up an Oracle wallet for the encryption
C:No setup is required as it is a default encryption method
D:Both Oracle wallet and password must be set up for the encryption
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing. Which two variables would likely fix this issue?（）
A:Table_open_cache
B:Table_open_cache_instancs
C:Table_definition_cache
D:Tmp_table_size
E:Max_heap_table_size
F:Max_tmp_tables
Given： If class Donkey is invoked twice， the first time without assertions enabled， and the second time with assertions enabled， what are the results？（）
A:no output
B:no outputassert is on
C:assert is on
D:no outputAn AssertionError is thrown.
E:assert is onAn AssertionError is thrown.
介绍日志的种类，各种日志的运行机制，各有什么优缺点？
What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation？（）  
A: The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.
B: The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.
C: The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.
D: There is no ASM_POWER_LIMIT setting used in ASM.
E: None of the above.
Which two statements regarding the Policy Framework in Enterprise Manager (EM) are correct?（）
A:Policy violations are prioritized as High, Medium, or Informational by category 
B:Policies can be disabled completely, or flagged as ignored, for the specified target 
C:Policies can be flagged as ignored, but never completely disabled, for the specified target
D:Policy violations must be corrected, otherwise the database will shut down until corrective action occurs
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point?（）
A:No privileges.
B:Only the SELECT privilege.
C:Only the CONNECT privilege.
D:All the privileges of a default user.
In your production database， data manipulation language （DML） operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track users， actions taken， and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information.  Whataction would you take to achieve this task（）
A:Apply fine-grained auditing.
B:Implement value-based auditing.
C:Impose standard database auditing to audit object privileges.
D:Impose standard database auditing to audit SQL statements.
Following is the list of locations in random order where oranfstab can be placed. 1./etc/mtab 2.$ORACLE_HOME/dbs/oranfstab 3./etc/oranfstab What is the sequence in which Direct NFS will search the locations?（）
A:1, 2, 3
B:3, 2, 1
C:2, 3, 1
D:1, 3, 2
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.ora
B:names.ora
C:spfile.ora
D:sqlnet.ora
E:listener.ora
F:tnsnames.ora
oracle服务器包括哪两个部分？各个部分又是由什么组成的？
From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.
A:Updating
B:Viewing
C:Deleting
D:Inserting
E:Truncating
在iBatis框架中，持久化对象之间一对一的关联关系是通过（）元素定义的。
A:one-to-one
B:1-to-1
C:only one
D:one
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）
A:fixed tables
B:heap tables
C:external tables
D:temporary tables
E:Index-Organized Tables (IOTs)
You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog？（）
A: synch catalog
B: resync catalog
C: replicate catalog
D: update catalog
E: restore catalog
What is the name of the WebLogic specific deployment descriptor of Java Enterprise Application?（）
A:application.xml
B:weblogic.xml
C:web.xml
D:weblogic-application.xml
E:config.xml
当需要创建用户时，可以使用如下（）语句来完成。
A:CREATE USER
B:CREATE ROLE
C:CREATE PROCESS
D:CREATE LOGIN
Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（） 
A: DB_CACHE_SIZE
B: SHARED_POOL_SIZE
C: LARGE_POOL_SIZE
D: JAVA_POOL_SIZE
E: SGA_MAX_SIZE
F: SORT_AREA_SIZE
Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH；  What would be the outcome of this command（）
A:The command succeeds only if Automatic Memory Management is not enabled.
B:The command succeeds， but you need to restart the database for changes to take effect.
C:The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D:The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.
首页 <上一页 22 23 24 25 26 下一页> 尾页