出自:Oracle认证

Examine the description of the STUDENTS table: STD_ID NUMBER(4) COURSE_ID VARCHAR2(10) START_DATE DATE END_DATE DATE Which two aggregate functions are valid on the START_DATE column? （）
A:SUM(start_date)
B:AVG(start_date)
C:COUNT(start_date)
D:AVG(start_date, end_date)
E:MIN(start_date)
F:MAXIMUM(start_date)
Which two statements are true about InnoDB auto-increment locking?（）
A:The auto-increment lock can be a table-level lock
B:InnoDB never uses table-level locks
C:Some settings for innodb_autoinc_lock_mode can help reduce locking
D:InnoDB always protects auto-increment updates with a table-level lock
The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）
A: LOG_BUFFER
B: DB_CACHE_SIZE
C: JAVA_POOL_SIZE
D: LARGE_POOL_SIZE
E: SHARED_POOL_SIZE
F: STREAMS_POOL_SIZE
Given： What is the result？（）
A:Afoo Afoo
B:Afoo Bfoo
C:Bfoo Afoo
D:Bfoo Bfoo
E:Compilation fails
You want to capture WebLogic internal events correlated with JVM events for viewing offline. What three actions must you take to enable this within WebLogic?（）
A:Run WebLogic in a JRockit JVM and ensure the Flight Recorder is enabled.
B:Configure the WebLogic Diagnostic Framework Event Volume to Low, Medium, or High  depending on the type of events you want to capture.
C:Configure the WebLogic Diagnostic Framework bridge to send events to the JRockit Flight  Recording. 
D:Take a dump from the default recording or create a new recording for the time period you want  to capture.
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQ EMP_NAME and JOB_ID: As specified by the user during run time, through substitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）
A:INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
B:INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did IN (20,50));
C:INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES  (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
D:INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
E:INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
Given: Which two methods, inserted independently at line 17, correctly complete the Sales class?（）
A:double getSalesAmount() { return 1230.45; }
B:public double getSalesAmount() { return 1230.45; }
C:private double getSalesAmount() { return 1230.45; }
D:protected double getSalesAmount() { return 1230.45; }
Observe the following warning in an RMAN session of your database instance：   WARNING:// new failures were found since last LIST FAILURE command   Which statement describes the scenario that must have produced this warning？（）
A: The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository（ADR）
B: The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR）
C: The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE
D: The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE command was executed
You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this? （）
A:Implement job classes 
B:Implement Scheduler windows
C:Implement the mapping rule for the consumer groups 
D:Set the SWITCH_TIME resource plan directive for both the resource plans
Note the points about data dictionary views and dynamic performance views：  1.These are stored in the SYSTEM tablespace.  2.These are the based on the virtual tables.  3.These are owned by the SYSuser.  4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE.  5.V$FIXED_TABLE view can be queried to list the names of these views.  Which statements listed describe the data dictionary views（）
A:1 and 3
B:2，3，and 5
C:1，2，and 3
D:2，3，4，and 5
（）语句可以使用户设置事务处理的各种属性，例如它的隔离层次、它是只读的还是可以进行读写的、是否需要使用特定的回滚段等。
A:set savepoint
B:set rollback
C:set transaction
D:set commit
iBatis框架中提供了一套独有的（）来封装持久层的操作，同时支持事务处理。
A:持久化对象
B:DAO框架
C:映射文件
D:配置文件
What is true regarding the role Oracle Net provides in a client server connection with no middle tier？（）
A:A
B:B
C:C
D:D
You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）
A:the XML script
B:the PL/SQL script
C:the DBMS_SCHEDULER package
D:Enterprise Manager to schedule the backup
以下（）是数据库冷备份的优点。
A:只需拷贝文件即可，是非常快速的备份方式
B:与数据库归档的模式相结合可以使数据库很好地恢复
C:维护量相对较少，安安全性确相对较高
D:备份时数据库仍然可用
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)
A:Alert log file
B:Archived redo log files
C:Control file autobackups
D:Server Parameter file (SPFILE)
E:Recovery Manager (RMAN) backup piece
Examine this syntax which allocates channels during a parallel image copy：   RMAN> CONFIGURE DEVICE TYPE disk parallelism 4：  2> COPY  3> datafile 1 TO ‘/BACKUP/datafile1.dbf’，  4> datafile 2 TO ‘/BACKUP/datafile2.dbf’，  5> datafile 3 TO ‘/BACKUP/datafile3.dbf；  RMAN>COPY  2> datafile 4 TO ‘/BACKUP/datafile4.dbf’；   How many channels are used？（）
A:0
B:1
C:3
D:4
Which three built-ins can you use to navigate between forms invoked with the OPEN_FORM built-in? （）
A:CLOSE_FORM 
B:NEXT_FORM 
C:GO_FORM 
D:PREVIOUS_FORM
Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.
A:1，3，6，7
B:2，3，6，8
C:1，2，3，6，7
D:1，2，3，6，，7，8
E:2，3，6，5，7
Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup?（）
A:Configure backup optimization
B:Configure the channel to increase MAXOPENFILES
C:Configure the channel to increase the capacity with the RATE parameter
D:Configure the channel to adjust the tape buffer size with the BLKSIZE option
Which feature/offering of Oracle Application Grid makes it particularly easy to significantly increase the performance of Web-based applications with no code change ？ （）
A: ActiveCache
B: Store-and-Forward
C: Messaging Bridge
D: MetaCache
下面的各选项中哪一个正确描述了Oracle数据库的逻辑存储结构？（）
A:表空间由段组成，段由盘区组成，盘区由数据块组成
B:段由表空间组成，表空间由盘区组成，盘区由数据块组成
C:盘区由数据块组成，数据块由段组成，段由表空间组成
D:数据块由段组成，段由盘区组成，盘区由表空间组成
The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column.  Which type of index would you suggest to improve the query performance？（）
A:B­tree
B:bitmap
C:reverse key
D:function based
View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason?（）
A:The pending area is automatically submitted after the plan creation
B:The procedure must be executed before creating the resources plan directive
C:The SYS_GROUP resource consumer group is not included in the resource plan directive
D:The OTHER_GROUPS resources consumer group is not included in the resource plan directive
In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）
A:When the data file of the undo tablespace is autoextensible
B:When there are more than one undo tablespaces available in the database
C:When the undo tablespace is of a fixed size and retention guarantee is not enabled
D:When the undo tablespace is autoextensible and retention guarantee is not enabled
You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?（） (Choose two).
A:The backup as copy can only be taken to disk
B:The backup as copy can only be taken to tape
C:Backup can be performed only when the instance is shutdown
D:Backup will constitute all used and unused blocks in the database
Examine the following parameter settings from an initialization （init.ora） file：   DB_CREATE_FILE_DEST =’/u01/oradata/’  DB_CREATE_ONLINE_LOG_DEST_1 =’/u02/oradata/’  DB_CREATE_ONLINE_LOG_DEST_2 =’/u03/oradata/’   If you create an Oracle Managed Files （OMF） database using these settings， what is the result？（）
A:A
B:B
C:C
D:D
You issued the following command: An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? （）
A:It stores only the temporary table but not its indexes.
B:It stores both the temporary table as well as its indexes.
C:It must be a nondefault temporary tablespace for the database.
D:It can be a default or nondefault temporary tablespace for the database.
E:It must be the default temporary tablespace of the user who issues the command.
In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level.  You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.  How do you achieve this objective？（）
A:by setting the SQL_TRACE parameter to FALSE in the parameter file
B:by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
C:by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
D:by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
Given: Which statement is true?（）
A:The code will compile without changes.
B:The code will compile if public Tree() { Plant(); } is added to the Tree class.
C:The code will compile if public Plant() { Tree(); } is added to the Plant class.
D:The code will compile if public Plant() { this("fern"); } is added to the Plant class.
E:The code will compile if public Plant() { Plant("fern"); } is added to the Plant class.
首页 <上一页 105 106 107 108 109 下一页> 尾页