出自:Oracle认证

You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user；  Which statement describes the result（）
A:The command produces an error.
B:The profile is dropped and current user sessions use the DEFAULT profile immediately.
C:The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
D:The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）
A:It is NOT possible to switch unless no active transaction exist in UNDO1. 
B:It is possible to switch to UNDO2； but current active transactions will abort. 
C:It is possible to switch to UNDO2； current active transactions will be automatically migrated to UNDO2. 
D:It is possible to switch to UNDO2； only current active transactions will continue to execute inside UNDO1.
假设需要从CUSTOMER客户表中检索数据，可以使用如下（）语句。
A:SELECT*FROM CUSTOMER
B:SELECT*CUSTOMER
C:MODIFY*FROM CUSTOMER
D:UPDATE*FROM CUSTOMER
You have a very large table that your users access frequently.  Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）  
A: The Automatic Memory Manager （AMM）
B: The SQL Tuning Advisor
C: The Segment Advisor
D: The SQL Access Advisor
Which initialization parameter must you set to enable automatic archiving？ （）
A:LOG_ARCHIVE_DEST
B:LOG_ARCHIVE_START
C:LOG_ARCHIVE_FORMAT
D:LOG_ARCHIVE_MAX_PROCESSES
Which two activities are NOT supported by the Data Recovery Advisor DRA（）
A:Recover from failures in the RAC environment.
B:Diagnose and repair a data file corruption online.
C:Diagnose and repair a data file corruption offline.
D:Diagnose and repair failures on a standby database
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）
A:ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
B:ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ;
C:ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ;
D:ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
You execute the following command to enable a session in resumable mode：  SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60；  What is the impact of a timeout on the statements being suspended？（） 
A:The statements remain suspended for at least 60 seconds.
B:The statements are suspended for 60 seconds and then they are executed.
C:The suspended statements error out if the problem is not rectified within 60 seconds.
D:The statements are automatically suspended 60 seconds after an error is received， and then attempt toexecute normally again.
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
A: the RMAN LIST command
B: the DBNEWID utility
C: the RMAN REPORT command
D: the RMAN BLOCKRECOVER command
E: the RMAN CROSSCHECK command
F: the ANALYZE command
AUM has been retaining about 15 minutes worth of undo. You want to double the retentionperiod， but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However， AUM still retains only about 15 minutes worth of undo.  What is the problem？ （） 
A: You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.
B: You need to increase the size of the undo tablespace.
C: The undo tablespace is not set to auto-extend.
D: You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.
你正在你的组织紧急事件处置演习中。几乎没有时间通报用户，你就需要尽快地停止数据库进程。下列命令哪个是你需要要执行的？（）
A:shutdown abort
B:shutdown transactional
C:shutdown
D:shutdown immediate
Which two statements are true regarding the MRKT tablespace（）
A:No more data files can be added to the tablespace.
B:Segment space is managed by free lists in the tablespace.
C:A user created without being assigned a default tablespace uses this tablespace.
D:The tablespace can be dropped with the current setting with segments present in it.
If two windows overlap， which window attribute will determine whether one should be chosen over the other？（）  
A: WINDOW_PRIORITY
B: PRIORITY
C: PRIORITY_LEVEL
D: WINDOW_PRIORITY_LEVEL
E: OVERLAP_RULE
In which case would you use a FULL OUTER JOIN?（）
A:Both tables have NULL values.
B:You want all unmatched data from one table.
C:You want all matched data from both tables.
D:You want all unmatched data from both tables.
E:One of the tables has more data than the other.
F:You want all matched and unmatched data from only one table.
You issue these LSNRCTL commands：  LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02  What is the result of issuing these commands？（）
A:A listener named LISTENER is started.
B:A listener named LISTENER01 is started.
C:A listener named LISTENER02 is started.
D:The START command fails and no listener is started.
Given: What is the result?（）
A:81
B:82
C:91
D:92
E:Compilation fails.
F:An exception is thrown at runtime.
如果想查看视图中哪些字段是可以更新的，应当查询哪一个数据字典视图？（）
A:DBA_VIEWS
B:DBA_OBJECTS
C:DBA_CLU_COLUMNS
D:DBA_UPDATABLE_COLUMNS
Which background process reads the redo log buffer and writes it to a file？（）
A:ARCn
B:DBWn
C:CKPT
D:LGWR
E:PMON
F:SMON
What information does the report schema command not provide？（） 
A: Size of the datafiles
B: Size of the tempfiles
C: Date of last backup for datafiles and tempfiles
D: Filenames for each datafile
E: Checkpoint SCN associated with the last RMAN backup
Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?（）
A:SELECT &1, "&2" FROM &3 WHERE last_name = '&8';
B:SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';
C:SELECT &1, &2 FROM &3 WHERE last_name = '&8';
D:SELECT &1, '&2' FROM EMP WHERE last_name = '&8';
You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）
A:enable index monitoring and query the DBA_OBJECTS view
B:enable index monitoring and query the DBA_INDEXES view
C:enable index monitoring and query the V$OBJECT_USAGE view
D:enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
Which method could be utilized to identify both DML operations and the SQL statements needed to undo those operations for a specific schema owner？（）
A:A
B:B
C:C
D:D
To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?（）
A:It results in an error because these parameter settings are invalid.
B:One 64G flash cache file will be used.
C:Two 64G flash cache files will be used.
D:Two 32G flash cache files will be used.
Which three statements are correct about temporary tables？（）
A:Indexes and views can be created on temporary tables.
B:Both the data and the structure of temporary tables can be exported.
C:Temporary tables are always created in a user’s temporary tablespace.
D:The data inserted into a temporary table in a session is available to other sessions.
E:Data manipulation language （DML） locks are never acquired on the data of temporary tables.
Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).（）(Choose two.)
A:You can use RMAN stored scripts
B:Recovery is faster if data is stored in catalog in addition to the control file
C:You can store backup information of all registered databases in one place
D:Database backups are automatically deleted when they are older than the specified time period
You established access to menu modules using roles. While testing the application, you need access to all the menus in the SALES form module for all the roles. Which method will override the Menu Module Roles property to allow you to access all the menu items?（）
A:Disable the values for the Menu Module Roles property. 
B:Set the Use Security value in the form module Property Palette to 'True'. 
C:Set the Use Security value in the form module Property Palette to 'False'. 
D:Set the Use Security value in the menu module Property Palette to 'True'. 
E:Set the Use Security value in the menu module Property Palette to 'False'. 
Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）
A:restore datafiles until time '09/28/2008:21:03:11'
B:restore database files until time '09/28/2008:18:00:00'
C:restore database until time '09/28/2008:18:00:00'
D:recover database until time '09/28/2008:18:00:00'
E:recover database until timestamp '09/28/2008:18:00:00'
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）
A:Complete Recovery with online redo log
B:Complete Recovery with archived redo log
C:Tablespace Point-in-Time Recovery (TSPITR)
D:Incomplete Recovery with system change number (SCN)
Which type of backup contains only the blocks that have changed since the last level 0 incremental backup？（）  
A: a cumulative level 1 backup
B: a differential level 1 backup
C: a full backup
D: a whole backup
A customer has a critical, performance-sensitive web application that connects to a multinode  Oracle RAC database. Which feature of WebLogic can provide significant performance benefit?（）
A:The Web Session Affinity feature of Active GridLink for RAC
B:WebLogic Clustering  
C:The Transaction Affinity feature of Active GridLink for RAC
D:Coherence*Web Session Replication
首页 <上一页 31 32 33 34 35 下一页> 尾页