出自:Oracle认证

View the Exhibit and examine the properties of the TT tablespace.  Using Database Control， you have scheduled a job to shrink the TRANS table residing on the TT tablespace. The job would run at 5：00 p.m. every Friday.  When you examine the space usage of the table after the completion of the job， you find that the table has not been shrunk.  What could have been the reason for this？（）
A:The tablespace that contains the TRANS table is online.
B:The tablespace that contains the TRANS table is permanent.
C:The tablespace that contains the TRANS table is locally managed.
D:The segment space management of the tablespace that contains the TRANS table is manual in nature.
Records from the data dictionary information are stored in which of the following database memory areas?（）
A:Library cache 
B:Row cache 
C:Session UGA 
D:Buffer cache
ORACLE9i数据库服务器不能在下列哪个OS平台上安装运行（）
A:Windows NT
B:Windows 2000
C:Windows 98
D:SCO UNIX
E:Redhat Linux
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）
A:It updates the existing SQL profiles with current statistics
B:It makes the statistics information available to GATHER_STATS_JOB
C:It initiates the statistics collection process by running GATHER_STATS_JOB
D:It logs a warning message in the alert log so that the DBA can perform statistics collection manually
Given two files, GrizzlyBear.java and Salmon.java: If both classes are in the correct directories for their packages, and the Mammal class correctly defines the findSalmon（　） method, which change allows this code to compile?（）
A:add import animals.mammals.*; at line 2 in Salmon.java
B:add import animals.fish.*; at line 2 in GrizzlyBear.java
C:add import animals.fish.Salmon.*; at line 2 in GrizzlyBear.java
D:add import animals.mammals.GrizzlyBear.*; at line 2 in Salmon.java
Your archive-log destination directory runs out of space. What is the impact of this on the database？（）  
A: None. The database will switch over to the stand-by archive-log destination directory.
B: A warning message will be written to the alert log of the database，but no adverse impacts to the database will be experienced.
C: The database will shut down，and will not restart until you correct the out-of-space situation.
D: The database will continue to try to write to the archive-log destination directory for one hour. After one hour，the database will shut down normally.
E: Once Oracle has cycled through all online redo logs，it will stop processing any DML or DDL until the out-of-space condition is corrected.
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）
A:Change in the Oracle Database version
B:Change in your network infrastructure
C:Change in the hardware configuration of the database server
D:Migration of database storage from non-ASM to ASM storage
E:Database and operating system upgrade
写出日志文件的种类，并说出各自的工作方式。
Which two of the following are the imposed restrictions to production redeployment in WebLogic Server ？（）
A: Can’t cahnge application’s deployment targets
B: Can’t cahnge application’s security model
C: Can’t cahnge application’s node manager
D: Can’t cahnge application’s persistent store settings
在iBatis框架中，SQL Map使用（）统一配置不同的属性，包括DataSource的详细配置信息，SQLMap和其他可选属性，如线程管理等。
A:XML配置文件
B:映射文件
C:持久化对象
D:初始化文件
User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.Which SQL statement can Mary use to accomplish that task?（）
A:CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu
B:CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);
C:CREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;
D:CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;
E:CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu
F:CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;
You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）
A: ONLINE
B: REVERSE
C: PARALLEL
D: COMPRESS
E: NOLOGGING
F: COMPUTE STATISTICS
Given: 11. public void go(int x) { Which statement is true?（）
A:All of the assert statements are used appropriately.
B:Only the assert statement on line 12 is used appropriately.
C:Only the assert statement on line 15 is used appropriately.
D:Only the assert statement on line 18 is used appropriately.
E:Only the assert statements on lines 12 and 15 are used appropriately.
F:Only the assert statements on lines 12 and 18 are used appropriately.
G:Only the assert statements on lines 15 and 18 are used appropriately.
In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）
A: when all the online redo log groups are multiplexed and one of the members of a group is missing
B: when all the online redo log groups are not multiplexed and one log group is missing
C: when all the control files are missing
D: when some important tables are deleted from the database and purged from the Recycle Bin
Which statement is true about FLUSH LOGS command?（）
A:It requires the RELOAD, FILE, and DROP privileges
B:It closes and reopens all log files
C:It closes and sends binary log files to slave servers
D:It flushes dirty pages in the buffer pool to the REDO logs
Which server stack communication layer corresponds to the client application layer in a distributed environment？（）
A:RDBMS
B:Application
C:Oracle Net foundation
D:Network Protocol
E:Presentation
Using Oracle Scheduler you have scheduled two jobs， JOB_A and JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）
A: A window must have been created with the WEEKEND_PLAN resource plan.
B: A program must have been created with the WEEKEND_PLAN resource plan.
C: A job class must have been created with the WEEKEND_PLAN resource plan.
D: A windows group must have been created with the WEEKEND_PLAN resource plan.
You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old  In which situation would you receive such an error？（）
A:You performed rollback after commit.
B:If a log switch occurs in your database.
C:Thearchiverfails to generate an archived log file.
D:Instance recovery fails to find one of the redo log files.
E:A long-running query is unable to get read-consistent image.
F:If you perform manual undo management operations in auto mode.
Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower？（）  
A: Differential incremental backup
B: Different incremental backup
C: Cumulative backup
D: Cumulative incremental backup
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 on to 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.
You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）
A:The database automatically determines the extent-sizing policy for the tablespace.
B:The segments are automatically shrunk when the contents are removed from them.
C:The allocation of extents within the tablespace is managed through the dictionary tables.
D:The space utilization description of the data blocks in segments is recorded in bitmap blocks.
E:The space utilization description of the data blocks in segments is managed through free lists.
You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to？（）
A: FREQ = MONTHLY； BYDAY = 2FRI；
B: FREQ = MONTHLY； BYDAY = FRI（2）；
C: FREQ = MONTHLY； BYDAY = FRI2；
D: FREQ = MONTHLY； BYDAY = -2FRI；
Given: What is the result？（）
A:The file will compile without error.
B:Compilation fails. Only line 7 contains an error.
C:Compilation fails. Only line 12 contains an error.
D:Compilation fails. Only line 13 contains an error.
E:Compilation fails. Only lines 7 and 12 contain errors.
Given: What is the result?（）
A:B
B:B, followed by an Exception.
C:Compilation fails due to an error on line 9.
D:Compilation fails due to an error on line 14.
E:An Exception is thrown with no other output.
You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）
A:ALTER TABLE commercials MODIFY (description CHAR2(2000));
B:ALTER TABLE commercials CHANGE (description CHAR2(2000));
C:ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));
D:ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));
E:You cannot increase the size of a column if the table has rows.
You used the IMMEDIATE option to shut down your database instance. Consider the steps that  mayoccur when a database instance is started and database is opened：  1：SGA is allocated.  2：Control file is read.  3：Redo log files are opened.  4：Instance recovery is started.  5：Background processes are started.  6：Data file headers are checked for consistency.  7：Server parameter file or the initialization parameter file is read.  Which option has the correct order in which these steps occur（）
A:7，1，5，2，3，6，4
B:1，5，7，2，3，6；step 4 is not required
C:7，1，5，2，3，6；step 4 is not required
D:1，2，3，5，6，4；step 7 is not required
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)
A:To store the backup information of multiple database
B:To restrict the amount of space that is used by the backups
C:To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
D:To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: Which statement ensures that a value is displayed in the calculated columns for all employees?（）
A:SELECT last_name, 12*salary* commission_pct FROM emp;
B:SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
C:SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
D:SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
下面不属于Oracle数据库状态的是（）。
A:OPEN
B:MOUNT
C:CLOSE
D:READY
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）
A:The database is in mount state.
B:One of the tablespaces is offline.
C:One of the tablespaces is read only.
D:The database operates in ARCHIEVELOG mode. 
E:The database operates in NOARCHIEVELOG mode.
首页 <上一页 10 11 12 13 14 下一页> 尾页