出自:Oracle认证

Examine the data in the EMPLOYEES table. On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column. Evaluate this DELETE statement: Why does the DELETE statement fail when you execute it?（）
A:There is no row with dept_id 90 in the EMPLOYEES table.
B:You cannot delete the JOB_ID column because it is a NOT NULL column.
C:You cannot specify column names in the DELETE clause of the DELETE statement.
D:You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.
Which two statements about the background process of the database writer are true（）
A:It is possible to have multiple database writers in an Oracle instance.
B:It writes dirty buffers， if any， to data files whenever a checkpoint occurs.
C:It writes dirty buffers， if any， to data files whenever a transaction commits.
D:It writes dirty buffers， if any， to data files before the log writer （LGWR） writes
Which two statements regarding a SQL profile are true？（）
A: It is built by Automatic Tuning Optimizer.
B: It cannot be stored persistently in the data dictionary.
C: It can be used by the query optimizer automatically.
D: It can be created manually by using the CREATE PROFILE command.
If a backup set is expired， what can you do to correct the problem？（）  
A: Change the retention criteria.
B: Make the lost backup set pieces available to RMAN again.
C: Run the crosscheck command to correct the location for the backup set piece contained in the metadata.
D: Nothing. The backup set piece is lost forever.
E: Call Oracle support，their assistance is required.
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）
A: The log sequence is reset to 0.
B: All the online redo logs are deleted.
C: All the archived redo logs from a previous incarnation become useless.
D: The full database backup taken from a previous incarnation can be used in future.
E: Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
（）进程以循环方式填写联机重做日志文件。
A:ARCn
B:LGWR
C:PMON
D:SMON
The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）
A:Undo data becomes obsolete after 1，000 seconds.
B:Undo data gets refreshed after every 1，000 seconds.
C:Undo data will be stored permanently after 1，000 seconds.
D:Committed undo data would be retained for 1，000 seconds if free undo space is available.
E:Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.
You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）
A:Create both jobs by using events raised by the scheduler
B:Create both jobs by using events raised by the application
C:Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
D:Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application
You create a multiple form application- Which built-in must you use to invoke the form modules to enable you to programmatically control navigation between the multiple forms in your application?（）
A:NEW_FORM 
B:OPEN_FORM 
C:CALL_FORM 
D:CLOSE_FORM
Which of the following are included in a transportable tablespace set？（）  
A: The datafiles that make up a self-contained group of tablespaces required for copy
B: The system tablespace
C: An export of the tablespace metadata
D: The spfile
E: All of the above
Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage？（）
A: It returns space usage of only BasicFile LOB chunks.
B: It returns space usage of only SecureFile LOB chunks.
C: It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D: It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
The following are the details of your database：   Instance name：test   Host name：tech1.us.oracle.com   IP address：145.33.230.186  Enterprise Manager Console HTTP Port number：5500   You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control？（）
A:http：//145.33.230.186：5500/em
B:http：//www.145.33.230.186：5500/em
C:http：//tech1.us.oracle.com：5500/em
D:http：//test.145.33.230.186：5500/em
E:http：//test.tech1.us.oracle.com：5500
F:http：//www.tech1.us.oracle.com：5500/em
G:http：//test.tech1.us.oracle.com：5500/em
Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;  What would be the outcome of this command？（）
A:The command would return an error because LOG_BUFFER is a static parameter.
B:The parameter value would be changed and it would come into effect immediately.
C:You need to restart the database so that parameter changes can come into effect.
D:The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?（）
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
Which of the following parameters must be specified to define the number of dispatchers that need to be started？（）
A:MAX_DISPATCHERS
B:DISPATCHERS
C:MIN_DISPATCHERS
D:SHARED_SERVERS
Examine the following set of RMAN commands: Which statement is true when the RMAN RUN block Is executed?（）
A:The execution of the script fails because multiple channels cannot coexist.
B:The script is executed and both the channels are used for the script execution.
C:The new channel, CHI, is Ignored because a channel has been configured already.
D:ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.
While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software， you are prompted to run orainstRoot.sh script. What does this script accomplish？（）
A:It creates the pointer file.
B:It creates the base directory.
C:It creates the Inventory pointer file.
D:It creates the Oracle user for installation.
E:It modifies the Unix kernel parameters to match Oracle’s requirement.
如果允许用户对视图进行更新和插入操作，但是又要防止用户将不符合视图约束条件的记录添加到视图，应当在定义视图时指定下列哪一个子句？（）
A:WITH GRANT OPTION
B:WITH READ ONLY
C:WITH CHECK OPTION
D:WITH CHECK ONLY
Given： Which code fragment， inserted at the end of line 12， produces the output p is 420？（）
A:p.setWeight（420）；
B:p.changePayload（420）；
C:p = new Payload（420）；
D:Payload.setWeight（420）；
E:p = Payload.setWeight（420）；
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below: Which statement is true regarding what this command accomplishes?（）
A:All archived redo log files backed up at least twice to tape are deleted.
B:All archived redo log files backed up at least once to tape are eligible for deletion.
C:All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
D:All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.
Which of the following Scheduler elements encourage object reuse？（）
A: Schedule objects
B: Program arguments
C: Job classes
D: Job arguments
E: All of the above
假定某非本机数据库的全局数据库名为ORCL.COM，数据库实例的SID为ORCL，定义的这个数据库的连接串为ORCLDB，数据库的用户名为scott，口令为tiger.那么以下哪个命令可以登录这个数据库（）
A:sqlplus scott/tiger
B:sqlplus scott/tiger@ORCL.COM
C:sqlplus scott/tiger@ORCL
D:sqlplus scott/tiger@ORCLDB
E:以上所述都不正确
You want to create a temporary table while executing a procedure in a form. Which statement is true?（）
A:You cannot create a table form within Forms. 
B:You must use the FORMS_DDL built-in to create the table. 
C:You must use the DBMS_DYNAMIC_DDL package to create the table. 
D:You can write the CREATE TABLE statement directly into the trigger.
If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）  
A: Complete database recovery.
B: Incomplete database recovery.
C: Approximate database recovery.
D: Archived database recovery.
E: The database could not be recovered with RMAN.
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 log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）
A: the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
B: the column of the V$INSTANCE_RECOVERY view
C: the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
D: the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view
You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL> SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582（）
A:Because 4194304 is the granule size
B:Because 4194304 is the standard block size
C:Because 4194304 is the largest nonstandard block size defined in the database
D:Because 4194304 is the total size of data already available in the database buffer cache
Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）
A:It releases the storage space used by the table.
B:It does not release the storage space used by the table.
C:You can roll back the deletion of rows after the statement executes.
D:You can NOT roll back the deletion of rows after the statement executes.
E:An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
F:You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
Select ‘accp’ from dual后运行结果是（）。
A:null
B:0
C:accp
D:编译出错
Click the Exhibit button. Which graph represents the correct directory structure for a JAR file from which those classes can be used by the compiler and JVM？（）
A:Jar A
B:Jar B
C:Jar C
D:Jar D
E:Jar E
You issue the following command on the RMAN prompt.   RMAN> REPORT NEED BACKUP DAYS = 5 DATABASE；   Which statement is true about executing this command？（）
A: It will display a list of files that need incremental backup.
B: It will display a list of files that need backup after five days.
C: It will display a list of files that were backed up in the last five days.
D: It will display a list of files that have not been backed up in the last five days.
E: It will apply the current retention policy to determine the files that need to be backed up.
首页 <上一页 132 133 134 135 136 下一页> 尾页