出自:Oracle认证

Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）
A: undo tablespace
B: index tablespace
C: read-only tablespace
D: temporary tablespace
You are developing a bonus report for the payroll application to calculate and display the bonus issue to each envelope. Employees with a salary of less than 50000$ earn a bonus of 15% and the employees who earn 50000$ or more earn out 10% bonus. Which type of trigger would you use to conditionally assign a bonus percentage?（）
A:Report level trigger. 
B:Group filter. 
C:Format trigger. 
D:None of the above.
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message： Which is the recommended sequence of operations you need to perform for the query successfully？（）
A: Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.
B: Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.
C: Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.
D: Put the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode.
Which statements are true regarding the creation of an incident package file by using the EM WorkbenchSupport（）
A:You can add SQL test cases to the incident package.
B:You can add or remove the trace files to the package.
C:You cannot create an incremental incident package when the physical files are purged from the ADR.
D:You can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.
Consider the following command to add a new disk group called "tdgroupA" with two failover groups： CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK ’/devices/A1’，  ’/devices/A2’，  ’/devices/A3’  FAILOVERGROUP control02 DISK ’/devices/B1’，  ’/devices/B2’，  ’/devices/B3’m  The disk "/devices/A1" is currently a member disk of a disk group by the name "tdgroup1".  Which task would be accomplished by the command？（）
A: This command would result in an error because a disk group can have only one failover group.
B: This command would result in an error because the /devices/A1 disk is a member of another disk group tdgroup1.
C: A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will get reattached to the new disk group without being detached from the existing one.
D: A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will be ignored for the new disk group because it is a member of an existing disk group tdgroup1.
E: A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk gets detached from the existing disk group tdgroup1 and attached to the new disk group tdgroupA
Examine the following command used to perform incremental level 0 backup：   RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE；   To enable the block change tracking， after the incremental level 0 backup you issued the following command：   SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command：   RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which two statements are true in the above situation？（）
A: The block change tracking data will be used only from the next incremental 0 backup.
B: The incremental backup will use change tracking data for accomplishing the backup.
C: The incremental backup will not use change tracking data for accomplishing the backup.
D: The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
In which scenario would index be most useful? （）
A:The indexed column is declared as NOT NULL.
B:The indexed columns are used in the FROM clause.
C:The indexed columns are part of an expression.
D:The indexed column contains a wide range of values.
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query?（）
A:You obtain the results retrieved from the public synonym HR created by the database administrator.
B:You obtain the results retrieved from the HR table that belongs to your schema.
C:You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D:You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E:You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
下列选项中，不能直接嵌入PL/SQL块中的语句有（）。
A:SELECT
B:INSERT
C:CREATE TABLE
D:GRANT
E:COMMIT
Which three actions are required to configure the Flashback Database? （）
A:set Flash Recovery Area
B:enable Flashback logging
C:create FLASHBACK tablespace
D:start the database in the ARCHIVELOG mode
E:start the database in the NOARCHIVELOG mode
You have discovered that a disk failure occurred on DISK1 where the data files belonging to the SYSTEM and USER_DATA tablespaces is stored. The database is currently open and you need to recover the data files. You will restore the data files to DISK2. What is the correct sequence of RMAN commands to restore and recover the data files？（）
A:A
B:B
C:C
D:D
建立ORACLE数据库后，系统自带的2个用户是什么？相应的密码是什么？他们的身份是什么？
Which two client requests are captured during database replay Capture？（）
A: Flashback queries
B: Shared server requests
C: Login and logoff activities of sessions
D: Direct path load of data from external files by using utilities such as SQL *loader
E: Data definition language （DDL） and data manipulation language （DML） operations
Which three are DATETIME data types that can be used when specifying column definitions?（）
A:TIMESTAMP
B:INTERVAL MONTH TO DAY
C:INTERVAL DAY TO SECOND
D:INTERVAL YEAR TO MONTH
E:TIMESTAMP WITH DATABASE TIMEZONE
关于PL/SQL块的说法正确的是（）
A:执行部分是必须的，因此声明部分也可以放到执行部分中来
B:PL/SQL块在执行时，是统一传输给数据库服务器进行执行的
C:在PL/SQL中SELECT的语句的用法与在SQL*PLUS中完全一致
D:匿名PL/SQL块的执行效率要高于命名PL/SQL块
Which two statements about creating constraints are true? （）
A:Constraint names must start with SYS_C
B:All constraints must be defines at the column level
C:Constraints can be created after the table is created
D:Constraints can be created at the same time the table is created
E:Information about constraints is found in the VIEW_CONSTRAINTS dictionary view
You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）
A: The location used for control files.
B: The location used for redo log files.
C: The location set by using $ORACLE_BASE
D: The location set by using $ORACLE_HOME
E: The location set by using CORE_DUMP_DEST
F: The location set by using BACKGROUND_DUMP_DEST
Given: What is the result?（）
A:B
B:The code runs with no output.
C:Compilation fails because of an error in line 12.
D:Compilation fails because of an error in line 15.
E:Compilation fails because of an error in line 18.
You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The FlashRecovery Area is specified as the destination for the archived redo log files. You notice this warning in thealert log file：  ORA-19815： WARNING:// db_recovery_file_dest_size of 3221225472 bytes is 100.00% used， and has 0remaining bytes available.  What would you do to reclaim the used space in the Flash Recovery Area（）
A:Back up the Flash Recovery Area.
B:Decrease the retention time for the database backup and flashback log files.
C:Manually delete all the archived log files from the Flash Recovery Area by using operating system （OS）commands.
D:Manually delete all the expired backup sets from the Flash Recovery Area by using operating system（OS） commands.
（）可以用于备份联机重做日志文件，以便在文件中充满日志或者发生日志切换时存储档案。
A:ARCn
B:RECO
C:SMON
D:PMON
You received this error message because Oracle Net Services cannot locate the connect descriptor specified in the tnsnames.ora configuration file：   ORA_12154： TNS：could not resolve service name Which three actions would be appropriate in helping to resolve the error？（）
A:A
B:B
C:C
D:D
E:E
F:F
View the Exhibit and identify the component marked with a question mark. （）
A:Checkpoint （CKPT）
B:Process Monitor （PMON）
C:Archiver Processes （ARCn）
D:Recoverer Process （RECO）
E:Memory Manager process （MMAN）
In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（） 
A:recovery catalog
B:Oracle Enterprise Manager Repository
C:Automatic Workload Repository （AWR）
D:Oracle 10g Enterprise Manager Grid Control
E:Automatic Database Diagnostic Monitor （ADDM）
What will be the end result of this set of RMAN commands？（）   shutdown abort startup mount  restore datafile 4 until time ，，09/30/2008：15：00：00；  recover datafile 4 until time ，，09/29/2008：15：00：00；  alter database open resetlogs；
A: Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.
B: The restore command will fail.
C: The recover command will fail.
D: The alter database open resetlogs command will fail.
E: All these commands will fail because they must be in the confines of a run block.
Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?（）
A:Create new indexes.
B:Modify existing indexes.
C:Implement partitioning on a nonpartitioned table.
D:Create materialized views.
E:All of the above
In your production database， data manipulation language （DML） operations are executed on theSALES table. You have noticed some dubious values in the SALES table during the last few days. Youare able to track users， actions taken， and the time of the action for this particular period but the changesin data are not tracked. You decide to keep track of both the old data and new data in the table along withthe user information.  What action would you take to achieve this task（）
A:Apply fine-grained auditing.
B:Implement value-based auditing.
C:Impose standard database auditing to auditobject privileges.
D:Impose standard databaseauditing to audit SQL statements.
Given that the current directory is empty, and that the user has read and write permissions, and the following: Which statement is true?（）
A:Compilation fails.
B:The file system has a new empty directory named dir.
C:The file system has a new empty directory named newDir.
D:The file system has a directory named dir, containing a file f1.txt.
E:The file system has a directory named newDir, containing a file f1.txt.
You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）  
A: EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；
B: EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；
C: EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；
D: EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；
Which two statements are true regarding an Automatic Storage Management （ASM） instance？（）
A: As ASM instance mounts an ASM control file
B: An ASM instance uses the ASMB process for rebalancing of disks within a disk group
C: Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET  parameter is not set explicitly
D: An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）
A: Cursor cache
B: Stored outline
C: SQL Tuning Set
D: Automatic Workload Repository （AWR） snapshots
首页 <上一页 75 76 77 78 79 下一页> 尾页