出自:Oracle认证

You are maintaining the SALES database of TeleStar Corporation. The online redo log configuration of the database is as follows：   One of the redo log members， redo3b， is lost due to disk failure.   How will you recover the redo log member redo3b？（）
A: by performing an incomplete recovery from the last backup
B: by performing an import operation
C: by performing a complete database recovery
D: by dropping the lost member and adding a new redo log member
如果各类元组在表的主键上取值为空值，那么它违反了关系的（）完整性约束。
A:实体完整性
B:引用完整性
C:域完整性
D:用户
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?（）
A:All the instances, including the ASM instance, are shut down in the ABORT mode
B:The ASM instance is shut down, but the other instances are still running 
C:The ASM instance is still functional, but the other instances are shut down 
D:All the instances, including the ASM instance, are shut down in the IMMEDIATE mode. 
E:HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode 
F:HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode
In WebLogic 10.3.6 and 12c, transaction logs can optionally write to a JDBC store instead of a file store on the file system. Identify the three benefits as a result of this capability.（） 
A:simplified disaster recovery architecture and efforts
B:better performance than writing logs to a file store
C:common storage of transaction logs with application data
D:common replication of transaction logs with application data
E:higher transaction throughput
When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）
A:Size of typical transactions 
B:Concurrent transactions 
C:Size of rows in table most frequently changed 
D:Number of anticipated disk sorts
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：  RMAN> REPORT NEED BACKUP days 3;  What would be the output of this command？（） 
A:a list of files that require a backup within three days
B:a list of files that have not been backed up for three days
C:a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
D:a list of files for which a backup has already been performed and may need a backup after three days
How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed？（）  
A: Issue the ALTER DISKGROUP ... ADD DISK command.
B: Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.
C: Issue the ALTER DISKGROU
D: Retrieve the disk from the Recycle Bin after the operation completes.
What are the two advantages of RMAN Block Media Recovery （BMR） over file-level recovery？（）
A: BMR lowers the mean time to recover （MTTR）.
B: BMR supports point-in-time recovery of individual data blocks.
C: BMR enables you to use incremental backups for block recovery.
D: BMR enables recovery even when the database is not mounted or open.
E: BMR enables you to use proxy backups to perform block media recovery.
F: BMR enables increased availability of data during recovery because the data file requires a recovery can remain online.
下列选项中，哪一部分不是Oracle实例的组成部分？（）
A:系统全局区SGA
B:PMON后台进程
C:控制文件
D:Dnnn调度进程
Which three methods will show the storage engine for the Country table?（）
A:A
B:B
C:C
D:D
E:E
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
A:The backup status will be marked expired in RMAN recovery catalog.
B:The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
C:The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
D:The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
E:The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.
Which three statements are characteristic of the MEMORY storage engine?（）
A:It can support transactions
B:Table contents are not saved if the server is restarted
C:It cannot contain text or BLOB columns
D:It can support foreign keys
E:Each table is represented on disk as an.frm file
F:Each table has a corresponding.MYI and .MYD file
When scaling Coherence from one to two cache servers， it will not show the same scalability as two to four. Why？（）
A: Coherence uses a more efficient TCMP algorithm going from two to four cache servers
B: When going from one to two cache servers， object backups are copied across servers so work is doubled，but going from two to four is a fixed amount of work
C: Near cache is enabled with a larger quorum thus performance is improved
D: all of the above
（）是Hibernate为应用程序操纵数据库提供了的核心接口，支持对数据库执行保存、更新、删除操作。
A:Configuration接口
B:Session接口
C:HibernateException接口
D:SessionFactory接口
You need to create a partitioned table to store historical data and you issued the following command: What is the outcome of the above command?（）
A:It returns an error because the range partitions P1 and P2 should be of the same range.
B:It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
C:It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of one month each.
D:It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2) specified.
You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）
A: Restore the lost data file from the backup， and then flash back the database.
B: Restore the data file pertaining to index tablespace， and then recover the tablespace.
C: Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
D: Restore all the data files， and then perform an incomplete recovery using the backup control file.
E: Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.
Which two are the prerequisites to enable Flashback Data Archive？（）
A: Database must be running in archivelog mode.
B: Automatic undo management must be enabled.
C: Undo retention guarantee must be enabled.
D: The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment  Space Management （ASSM）.
Which of the following files can be used to configure connection pooling in the shared server environment？（）
A:INIT.ORA
B:SQLNET.ORA
C:TNSNAMES.ORA
D:SERVICES.ORA
E:LISTENER.ORA
Given: What is the result？（）
A:2
B:3
C:12
D:23
You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users’ passwords？（）  
A: All passwords automatically become case-sensitive.
B: All passwords remain non-case-sensitive till they are changed.
C: All passwords remain non-case-sensitive and cannot be changed.
D: All passwords remain non-case-sensitive until their password attribute in the profile is altered.
Which is the correct description of a pinned buffer in the database buffer cache（）
A:The buffer is currently being accessed.
B:The buffer is empty and has not been used.
C:The contents of the buffer have changed and must be flushed to the disk by the DBWn process. 
D:The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.
While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows:（） 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.
A:2, 3, 5
B:1, 2, 4
C:1, 2, 4, 5
D:1, 2, 3, 4, 5
tablespace point-in-time recovery is possible only with RMAN.（）
A: True
B: False
Given： Which two can be results？（）
A:java.lang.RuntimeException： Problem
B:run.java.lang.RuntimeException： Problem
C:End of method.java.lang.RuntimeException： Problem
D:End of method.run.java.lang.RuntimeException： Problem
E:run.java.lang.RuntimeException： ProblemEnd of method
在Oracle中，（）操作符允许引用现有的行对象。
A:CAST
B:REF
C:MULTISET
D:MAP
Which two are the uses of the ASM metadata backup and restore （AMBR） feature？（）
A: It can be used to back up all data on ASM disks.
B: It can be used to recover the damaged ASM disk group along with the data.
C: It can be used to gather information about a preexisting ASM disk group with disk paths，disk name，failure groups，attributes templates，and alias directory structure.
D: It can be used to re-create the ASM disk group with its attributes.
Ml Managed Servers in a domain must run the of the OrcleWebLogic Server software（）
A: same version 
B: different versions
C: same patch set
D: most recent patch set
You developing a form module, and you would like to make an indicated window visible in a new display position. Which built-in can you use to accomplish this task?（）
A:SHOW_WINDOW 
B:RESIZE_WINDOW 
C:DISPLAY_WINDOW 
D:MOVE_WINDOW_X_Y 
E:WINDOW_VISIBLE_X_Y
当需要更改视图的时候，可以使用（）语句，显式重新编译视图。
A:UPDATE VIEW
B:ALTER VIEW
C:DROP VIEW
D:MODIFY VIEW
What will be the result of the following configuration？（）   Log_archive_dest_1=location=c：/oracle/arch/mydb Log_archive_dest_2=location=z：/oracle/arch/mydb  
A: An error will occur during database startup because the second parameter is not valid.
B: An error will occur during database startup since you are trying to create archived redo logs in two different locations.
C: Archived redo logs will be created in two different locations by the ARCH process.
D: Archived redo logs will be created in two different locations by the LGWR process.
E: Neither parameter setting is valid， so the database will not start up.
首页 <上一页 121 122 123 124 125 下一页> 尾页