出自:Oracle认证

You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason？（）
A:None of the SYSAUX occupants can be relocated.
B:The USERS tablespace is a bigfile tablespace （BFT）.
C:The united Job Scheduler occupant cannot be relocated.
D:The SYSAUX occupants can be relocated to the SYSTEM tablespace only.
In which scenario would an 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.
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATEDATABASE” statement?（）
A:It will create a multitenant container database (CDB) with only the root opened.
B:It will create a CDB with root opened and seed read only.
C:It will create a CDB with root and seed opened and one PDB mounted.
D:It will create a CDB that must be plugged into an existing cdb.
E:It will create a CDB with root opened and seed mounted.
下列哪个锁模式不属于Oracle？（）
A:共享锁
B:排他锁
C:行级共享锁
D:死锁
You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
A:Average row size
B:Last analyzed date
C:Size of table in bytes
D:Size of table in database blocks
E:Number of free blocks in the free list
F:Number of extents present in the table.
You execute the following command to change the status of the SALES tablespace：  SQL> ALTER TABLESPACE sales OFFLINE；  Which statements describe the effect of the command（）
A:The tablespace would require recovery to go back online.
B:A checkpoint is taken on all data files that are associated with the SALES tablespace.
C:The sessions that subsequently try to access the objects in the SALES tablespace receive an error.
D:The new status of the SALES tablespace is recorded in the control file when the database instance is closed.
View the Exhibit and examine the data in the PRODUCT INFORMATION table. Which two tasks would require subqueries？ （）
A: displaying the minimum list price for each product status
B: displaying all supplier IDs whose average list price is more than 500
C: displaying the number of products whose list prices are more than the average list price
D: displaying all the products whose minimum list prices are more than the average list price of products having the product status orderable
E: displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE
Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）
A:Data files
B:Control files
C:Parameter file
D:Online redo log files
E:Server parameter file
表空间默认的PCTINCREASE参数值为下列哪一个（）
A:0
B:10
C:20
D:50
E:100
Given: What is the result?（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:[608, 610, 612, 629] [608, 610]
D:[608, 610, 612, 629] [608, 610, 629]
E:[606, 608, 610, 612, 629] [608, 610]
F:[606, 608, 610, 612, 629] [608, 610, 629]
You manually create an additional listener process，L1，for databases PROD，  PAYDB and FINDB. While starting up the listener process，you get the following error message： LSNRCTL> start l1  Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr： please wait...  TNSLSNR for Linux： Version 10.1.0.2.0 - Production  System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on： （ADDRESS=（PROTOCOL=TCP）（HOST=144.23.230.185）（port=8899））  TNS-12542： TNS：address already in use TNS-12560：  TNS：protocol adapter error TNS-00512： Address already in use  Linux Error： 98： Address already in use  Listener failed to start. See the error message（s） above...  What action would you take to overcome this error without disrupting any existing database communications？（）
A:stop and restart the listener process
B:set the TNS_ADMIN environmental variable
C:stop all running listener processes and restart the listener process
D:change the port number to an unused port number and restart the listener process
E:change the IP address to host machine name in the LISTENER.ORA file and restart the listener process
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）
A:’SQL ALTER DATABASE OPEN’；
B:SQL ALTER DATABASE ’OPEN’；
C:OPEN DATABASE；
D:DATABASE OPEN
Which of these formats represents the correct hierarchy for the ADR？（）   
A:A
B:B
C:C
D:D
You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table，you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（） 
A:use the ROLLBACK command with SCN 663571
B:perform Flashback Transaction Query with SCN 663571
C:execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
D:execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
Given： What is the result？（）
A:Compilation fails due to an error in line 23.
B:Compilation fails due to an error in line 29.
C:A ClassCastException occurs in line 29.
D:A ClassCastException occurs in line 31.
E:The value of all four objects prints in natural order.
The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file？（）
A: Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.
B: Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.
C: Issue the SERVICES command at the LSNRCTL> prompt.
D: Issue the STATUS command at the LSNRCTL> prompt.
Evaluate this SQL statement: What will happen if you remove all the parentheses from the calculation?（）
A:The value displayed in the CALC_VALUE column will be lower.
B:The value displayed in the CALC_VALUE column will be higher.
C:There will be no difference in the value displayed in the CALC_VALUE column.
D:An error will be reported.
Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?（）
A:CYCLE 
B:ITERATE
C:NO_REPEAT 
D:REUSE
Which two kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist（）
A:failure when no standby database is configured
B:failure because a data file is renamed accidentally
C:failure that requires no archive logs to be applied for recovery
D:failure due to loss of connectivity-for example， an unplugged disk cable
You have just performed a FLASHBACK TABLE operation using the following command：   flashback table employees to scn 123456；   The employees table has triggers associated with it.  Which of the following statements is true regarding the state of the triggers during the Flashback Table operation？（）  
A: All the triggers are disabled.
B: All the triggers are enabled by default.
C: Enabled triggers remain enabled and disabled triggers remain disabled.
D: Triggers are deleted when a Flashback Table operation is performed.
以下关于包（Package）的说法，正确的是（）
A:包是由包头（Specification）和包体（Package Body）两部分组成的，在包体中引用的变量均要在包头部分进行定义。
B:在编译包头时，包体也同时被自动编译，但是编译包体时，包头不会被编译
C:包头是不能脱离包体单独存在的，但是可以对包头单独进行编译
D:包头和包体都是可以单独存在的，也是可以单独进行编译的
E:删除包头，包体也将被自动删除
Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）：  CREATE TABLESPACE user_tbsp  DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M；  What would be the result of this command？（）
A:It would result in an error because the template cannot be used along with the disk group.
B:It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
C:It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.
D:It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.
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
You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）
A: Oracle Enterprise Manager
B: The V$LOG view
C: The V$LOGFILE view
D: The V$FLASHBACK_DATABASE_LOGS view
A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work.  ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）
A:Modify the profile assigned to the user.
B:Modify the roles assigned to the users.
C:Modify the object privileges assigned to the user.
D:Modify the system privileges assigned to the users.
E:Modify the value for the RESOURCE_LIMIT parameter in the parameter file.
说明Oracle 10g数据库文本初始化参数文件与服务器初始化参数文件的区别。
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）
A: statistics recommendations
B: SQL profile recommendations
C: index-related recommendations
D: restructuring of SQL recommendations
Oracle Server由哪两个部分组成？（）
A:INSTANCE和DATABASE
B:SGA和PGA
C:SGA和DATABASE
D:Server process和Background process
E:SGA和Background process
Which three statements are true about the stages of database startup？（）
A:Data files and redo log files can be renamed at the MOUNT stage.
B:Control files are read at the OPEN stage for the location of data files.
C:Control files are required to bring the database to the NOMOUNT stage.
D:Data files and redo log files are made available to users at the OPEN stage.
E:Data files and online redo log files are checked for consistency while opening the database
分组查询是在查询语句中使用（）子句，对查询结果执行分组操作。
A:ORDER BY
B:GROUP BY
C:JOIN
D:COUNT
首页 <上一页 82 83 84 85 86 下一页> 尾页