出自:Oracle认证

You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays， to tape.  Which two statements are true about differential incremental backups（）
A:The backup performed on Sundays contains all the blocks that have ever been used in the database.
B:The backup performed on Sundays contains all the blocks that have changed since the last level 1backup. 
C:The backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup.
D:The backup performed on Monday contains all the blocks that have changed since the level 0 backup，and every other working day contains all the blocks that have changed since the level 1 backup.
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）
A:Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
B:Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
C:Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
D:Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.  What would be your next step to improve performance（）
A:Run the SQL Access Advisor.
B:Run the Memory Advisor for the sga
C:Run the Memory Advisor for the pga.
D:Run the Memory Advisor for the shared pool.
E:Run the Memory Advisor for the buffer cache
当对数据库进程调整时，要求除DBA用户外的其它用户都不能访问数据库，这时可以用以下哪种数据库启动方式（）
A:STARTUP NOMOUNT
B:STARTUP MOUNT
C:STARTUP RESTRICT
D:STARTUP DBA
E:STARTUP FORCE
Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）
A:Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
B:Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
C:Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
D:Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
E:Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
Which three statements are true concerning the multitenant architecture?（）
A:Each pluggable database (PDB) has its own set of background processes.
B:A PDB can have a private temp tablespace.
C:PDBs can share the sysaux tablespace.
D:Log switches occur only at the multitenant container database (CDB) level.
E:Different PDBs can have different default block sizes.
F:PDBs share a common system tablespace.
G:Instance recovery is always performed at the CDB level.
如果要查询数据库中所有表的信息，应当使用下列哪种数据字典视图？（）
A:DBA视图
B:ALL视图
C:USER视图
D:动态性能视图
Given： Which three code fragments， inserted independently at line 6， will compile？（）
A:list.add（"foo"）；
B:Object o = list；
C:String s = list.get（0）；
D:list = new ArrayList（）；
Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"? （）
A:No change is required to achieve the desired results.
B:SELECT ename, sal, 12* (sal+100) FROM emp;
C:SELECT ename, sal, (12* sal)+100 FROM emp;
D:SELECT ename, sal +100,*12 FROM emp;
WebLogic 12c, the Maven plug-in has been enhanced with which Maven goal?（）
A:wls:unzip, wls:install-domain, wls:start-domain, wls:wlst, wls:appc
B:wls:install, wls:install-domain, wls:start-domain, wls:wlst, wls:appc
C:wls:unzip, wls:create-domain, wls:start-domain, wls:wlst, wls:appc
D:wls:install, wls:create-domain, wls:start-server, wls:wlst, wls:appc
Which two statements are true regarding the starting of the database instance using the following command？（） SQL>STARTUP UPGRADE  
A: It enables all system triggers.
B: It allows only SYSDBA connections.
C: It ensures that all job queues remain active during the upgrade process.
D: It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）  
A: Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.
B: Just back up the database datafiles without shutting down the database.
C: You will have to wait until you can shut down the database to perform the backup.
D: Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
E: Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）
A:The database will open, and the tablespace automatically comes out of the backup mode.
B:The database will be mounted, and recovery must be performed on the USERS tablespace.
C:The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
D:The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）
A:It must be executed from the Oracle Database 11g environment.
B:It must be executed only after the SYSAUX tablespace has been created.
C:It must be executed from the environment of the database that is being upgraded.
D:It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E:It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
Given： What is the result?（）
A:Afoo Afoo
B:Afoo Bfoo
C:Bfoo Afoo
D:Bfoo Bfoo
E:Compilation fails.
F:An exception is thrown at runtime.
Which is an iSQL*Plus command? （）
A:INSERT
B:UPDATE
C:SELECT
D:DESCRIBE
E:DELETE
F:RENAME
If you CROSSCHECK the backup piece that was previously marked as EXPIRED but is now available， what would the status of this backup piece be in the RMAN repository？（）
A:EXPIRED
B:AVAILABLE
C:UNAVAILABLE
D:ACCESSIBLE
Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）
A: Disable SQL tracing for the APPS tablespace.
B: Disable logging attributes for the APPS tablespace.
C: Modify the tablespace to be a dictionary-managed tablespace.
D: Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.
E: Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.
从本质上来看，（）就是命名的PL/SQL程序块，它可以被赋予参数，存储在数据库中，然后由另外一个应用或PL/SQL例程调用。
A:异常
B:过程
C:表
D:视图
ORDER BY的作用是（）。
A:查询输出分组
B:设置查询条件
C:对记录排序
D:限制查询返回的数据行
RMAN automatically propagate information about the database structure， archived redo logs， backup sets， and data file copies into the recovery catalog from the target database’s control file. This information can also be propagated to the catalog manually by using the （）command.
A:LIST
B:SWITCH
C:VALIDATE
D:CONFIGURE
E:RESYNC CATALOG
F:UPGRADE CATALOG
Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically， and to perform a switch to a low priority consumer group before they are initiated？（）
A:SWITCH_TIME
B:SWITCH_GROUP
C:MAX_SESS_POOL
D:SWITCH_ESTIMATE
From the V$SESSION_LONGOPS view， you find that some of the database users have long/x7frunning queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries.  You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）
A:set the CPU time per call in the users profile
B:set the CPU time per session in the users profiles
C:set the CPU levels for the users’ group using Resource Manager
D:set the TIMED_STATISTICS parameter to TRUE in the parameter file
You installed WebLogic, SOA Suite, and Oracle Service Bus on a machine and want to use the  WebLogic Node Manger to start servers for each product. Which statement is true?（）
A:You need to install a separate node manager for each Middleware Home that has a unique  major and minor WebLogic Version Number.
B:You need to install and configure only one instance of Node Manager for all products,  regardless of the WebLogic version number.
C:You need to install and configure a separate Node Manager for each domain of each product  you want to run on the machine.
D:You need to install one Node Manager but use separate SSL certificates for each product when  searching the network communication to the machine
Click the Exhibit button.   Given： ClassA a = new ClassA（）；   a.methodA（）；   What is the result？（）
A: The code runs with no output.
B: Compilation fails.
C: An exception is thrown at runtime.
D: ClassC is displayed.
Given: What is the result?（）
A:r，t，t，
B:r，e，o，
C:Compilation fails.
D:An exception is thrown at runtime.
Which is not a valid locale definition file type?（）
A:Language
B:Linguistic sort
C:Calendar
D:Territory
E:Character set
What is the result of this command？（） RMAN> Report need backup days 3；
A: Lists all datafiles created in the last three days that are not backed up.
B: Lists all datafiles not recoverable based on the current retention criteria.
C: Lists all datafiles not backed up in the last three days. The datafile is not recoverable. 
D: Lists all datafiles that need to be backed up due to unrecoverable operations.
E: Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.
To determine the space allocated for temporary segments, the DBA can access which of the following views? （）
A:DBA_TABLESPACES 
B:DBA_TABLES 
C:DBA_SEGMENTS 
D:DBA_FREE_SPACE
Your database operates in ARCHIVELOG mode and user/x7fmanaged 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 archivelog 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
首页 <上一页 63 64 65 66 67 下一页> 尾页