出自:Oracle认证

在CREATE TABLE语句中，指定某列不接受空值，可以使用哪个关键字（）。
A:NOT EMPTY
B:NOT NULL
C:IS EMPTY
D:IS NULL
Click the Exhibit button. Which statement is true about the classes and interfaces in the exhibit？（）
A:Compilation will succeed for all classes and interfaces.
B:Compilation of class C will fail because of an error in line 2.
C:Compilation of class C will fail because of an error in line 6.
D:Compilation of class AImpl will fail because of an error in line 2.
Which view provides information on the backup status of the datafiles in the database?（）
A:V$BACKUP
B:V$BACKUP_STATUS 
C:V$BACKUP_DATAFILE 
D:V$DATAFILE_BACKUP 
E:V$TABLESPCE_BACKUP
Given: What is the result?（）
A:w-f
B:f-p w-f
C:w-f b-f
D:f-p w-f b-f
E:Compilation fails.
F:An exception is thrown at runtime.
You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch.  What do you do？（）  
A: Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed，bring the disk group online again.
B: Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced，reset the parameter to  its original value.
C: You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced， add the disk back into the disk group and allow ASM to rebuild it.
D: If you are using any setting other than REDUNDANCY EXTERNAL for your disk group，you will have to recover any data on that disk from a backup. The database will be unavailable until you can  correct the problem and perform recovery.
E: Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
What RMAN command must you use before you can back up a database using the recovery catalog？（）
A: create catalog
B: install database
C: catalog database
D: merge Catalog with database
E: register database
You have created a database link， devdb.us.oracle.com， between the databases PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from thedevelopment database， DEVDB， to the production database， PRODDB. You execute the following command on the target database server：  $impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr  flashback_time = 2004-02-03 09：00  The command fails， displaying the following error： ORA-39001： invalid argument value  ORA-39000： bad dump file specification  ORA-31640： unable to open dump file “/home/oracle/schema/schemas.dat” for read ORA-27037： unable to obtain file status What would you do to overcome the error（）
A:remove the dumpfile option in the command
B:remove the flashback_time option in the command
C:remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the command（Replace thedumpfile option with the network_link = devdb.us.oracle.com）
D:add the user， SYSTEM， to the schemas option in the command
E:remove the schemas option and add the network_link = devdb.us.oracle.com option in the command 
F:add network_link = devdb.us.oracle.com option in the command
You deploy two different applications to the WebLogic container. One application use Xerces parser version A and the other application uses Xerces parser version B. Both these versions are different from the parser version that the WebLogic server uses internally. You want to use the Filtering Classloader feature to solve this problem. What action would you take to generate proper filtering Classloader entries?（） 
A:Modify the applications to use the same version that WebLogic uses internally.
B:Based on available examples of Filtering Classloader entries, try to modify get the proper  entries.
C:Deploy and use the Classloader Analyzing Tool to resolve all conflicts with conflicting libraries.  This tool will generate all proper entries.
D:Split the application into separate WebLogic containers and use different WLS versions of  Xerces but identical that applications require.
E:Look for a WebLogic release that uses the same version of Xerces that the applications use.
What two are the prerequisites for enabling Flashback Database?（）
A:The database must be in ARCHIVELOG mode
B:The database must be in MOUNT EXCLUSIVE mode
C:The database must be opened in RESTRICTED mode
D:The database instance must be started in the NOMOUNT state
E:The database instance must have the keep buffer pool defined
You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）
A:use enterprise manager
B:use DBMS_SQL package
C:use DBMS_AWR package
D:use PRVT_WORKLOAD package
E:query the AWR snapshot repository objects
F:use DBMS_WORKLOAD_REPOSITORY package
Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）
A:Until last commit
B:Until the time you perform recovery
C:Until the time the date file got corrupted
D:Until the point where the last transaction begun
E:You cannot recover the SYSTEMtablespaceand must re-create the database.
You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）
A:The advisory memory has been turned off.
B:The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
C:The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
D:The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
E:The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
Which built-in copies values from a list item into a record group? （）
A:RETRIEVE_LIST 
B:RETRIEVE_GROUP 
C:RETRIEVE_LIST_ITEM 
D:RETRIEVE_GROUP_FROM_LIST 
E:RETRIEVE_GROUP_FROM_LIST_ITEM 
What is the solution for the "maximum socket buffer size" warnings in Oracle Coherence version 3.1 to 3.3 ？ （）
A: configure the OS allow for larger buffers
B: upgrade the Coherence version
C: configure the OS allow for small buffers
D: configure the OS allow for small buffers and upgrade the Coherence version
在Hibernate框架中，在执行可编程配置方式时，可以使用（）的实例，将整个应用的Java类型映射为SQL数据库的完整集合。
A:org.hibernate.SessionFactory
B:org.hibernate.cfg.Configuration
C:org.hibernate.HibernateUtil
D:org.hibernate.Util
If you are going to run a TSPITR recovery， which view will help you to determine which objects will be lost during the TSPITR？（）
A: TS_OBJECTS_TO_BE_DROPPED
B: TS_PTTR_OBJECT_DROPPED
C: TS_PITR_OBJECTS_TO_BE_DROPPED
D: TS_OBJECTS_DROPPED
E: TS_DROPPED_OBJECTS
以下数据类型中，（）是固定长度的数据类型。
A:CHAR
B:VARCHAR2
C:LONG
D:VARCHAR
SQL语句的编译和执行是在SGA的哪一部分中进行的（）
A:Database Buffer Cache
B:Redo Log Buffer
C:Shared Pool
D:Large Pool
E:Java Pool
Why would you use the following FLASHBACK TABLE command？（）  FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； 
A:to undo the changes made to the EMP table since the specified time
B:to restore the EMP table that was wrongly dropped from the database
C:to view the transactions that have modified the EMP table since the specified time
D:to view the changes made to the EMP table for one or more rows since the specified time
E:to recover the EMP table to a point in time in the past by restoring the most recent backup
You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）
A:User session data
B:Stack space
C:Private SQL area
D:Location of the runtime area for DML and DDL Statements
E:Location of a part of the runtime area for SELECT statements
You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）
A: .SQL 
B: .PLL 
C: .PLD
D: .PRT
You plan to set up the Automatic Workload Repository （AWR） baseline metric thresholds for a moving window baseline. Which action would you take before performing this task？（）  
A: Compute the baseline statistics.
B: Take an immediate AWR snapshot.
C: Decrease the window size for the baseline.
D: Decrease the expiration time for the baseline.
Identify two situations in which you can use Data Recovery Advisor for recovery.（） 
A: The user has dropped an important table that needs to be recovered.
B: The database files are corrupted when the database is open.
C: You are not able to start up the database instance because the required database files are missing.
D: The archived log files are missing for which backup is not available.
A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）
A: The database allows only queries； no other statements are allowed.
B: The database re-creates the missing redo log files automatically.
C: The database continues to function normally with the existing files.
D: The database returns an error and the database instance shuts down.
E: The user sessions that generate redo logs are terminated automatically.
The system analysts have requested heavy use of object features. The database design makes use of PL/SQL8 object types, methods, and LOB types. How do you work with these features on the client?（）
A:Write client-side subprograms containing the PL/SQL8 constructs, and move them into an object group. 
B:Write server-side subprograms, and call the subprograms from the form application. 
C:Store the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form muddle in your application.
Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified？（）  
A: only the control file， the current SPFILE， and data files
B: only the current SPFILE and data files if autobackup is disabled
C: only the data files and the archived redo logs
D: the control file，current SPFILE file，data files，and archived redo logs
表空间和数据文件在物理存储上是（）的关系。
A:一对多
B:多对一
C:一对一
D:多对多
View the Exhibit and examine the undo tablespace attributes.    Your database instance is experiencing a large volume of transactions from non-DBA users in the last onehour. The undo tablespace UNDOTBS1 is full with transactions and no transaction was committed morethan one hour ago. The database has two more undo tablespaces.  What happens to the new DML operations in this scenario（）
A:The DML commands will fail.
B:The undo data generated by the DML is stored in one of the two other undo tablespaces.
C:The undo data generated by the DML will overwrite the extents that contain committed undo data. 
D:The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM
查询出EMP表中COMM字段为空的记录（）
A:select * from emp where comm='';
B:select * from emp where comm=null;
C:select * from emp where nvl(comm)=0;
D:select * from emp where comm is null;
E:select * from emp where nvl(comm,0)=0;
In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance.   Which option would you use to defragment the mapping table without affecting the original table data？（） 
A:export and import the mapping table
B:drop and re-create the mapping table
C:truncate the mapping table and reinsert the values
D:use the ALTER TABLE···REBUILD command to defragment the mapping table
首页 <上一页 40 41 42 43 44 下一页> 尾页