出自:Oracle认证

You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? （）
A:CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);
B:CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C:CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D:CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);
E:CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;
Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）
A:Oracle Managed Files are used for this instance.
B:The USER_DATA tablespace is managed using FET$/UET$ tables.
C:The COMPATIBLE initialization parameter must be 9.0.0 or higher.
D:Space within segments in the USER_DATA tablespace is managed with freelists.
Examine these two statements:Which three are true about the MRKT tablespace?（）
A:The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
B:The MRKT tablespace may be dropped if it has no contents.
C:Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
D:No more data files can be added to the tablespace.
E:The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
Which two capabilities are granted with the SUPER privilege?（）
A:Allowing a client to kill other client connections
B:Allowing a client to shut down the server
C:Allowing change of the server runtime configuration
D:Allowing client accounts to take over the account of another user
By default, checkpoints happen at least as often as（）.
A:Redo log switches. 
B:UPDATE statements are issued against the database. 
C:The SYSTEM tablespace is accessed. 
D:SMON coalesces free space in a tablespase.
Which RMAN command is used to verify the status of a backup or copy， and also updates the repository when files have been deleted using operating system commands？（）
A:CHANGE
B:RESYNC
C:CATALOG
D:CROSSCHECK
From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users.   Which method would you use to achieve this objective？（）
A:create a plan directive in the SYS_GROUP
B:create the pending area for the consumer group
C:activate the provided SYSTEM_PLAN in Resource Manager
D:set the TIMED_STATISTICS parameter to TRUE in the parameter file
E:set the execution time limit for all users， except SYS and SYSTEM， in their profiles
DRAG DROP Click the Task button.
You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）
A:The database must have multiplexed redo log files
B:The database must be in the MOUNT state to execute the command
C:The database must be in the NOMOUNT state to execute the command
D:The database must be opened in RESTRICTED mode before this operation
E:The database must be opened with the RESETLOGS option after the flashback operation
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）
A:The tuned plan is not added to the SQL plan baseline.
B:The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
C:The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
D:The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
You want to migrate an application that was developed for OAS/OC4J to WebLogic. The application uses Oracle Streams Advanced Queuing (AQ). You configured a Foreign JMS Server and Data Source but you are not able to send messages to the AQ destination and see them reach the database. Which two things are missing in this configuration?（）
A:nothing, there may be a network connection issue
B:a Foreign JMS Connection Factory
C:a JMS Bridge to map the JNDI of the Local JMS Destination to the remote AQ destination
D:a mapping of the Foreign JMS Connection Factory to the Data Source where AQ is configured and installed
E:Oracle AQ Java EE Shared Libraries not deployed and referenced by your application
Identify the two options that can be used to patch WebLogic Server without Incurring application downtime.（）
A:automated process using the Admin Server
B:automated using JDeveloper
C:manual process with or without Smart Update
D:scripted with WLST
E:automated process using Enterprise Manager 12c
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）
A:Use the external table population.
B:Use the Oracle Data Pump export and import utility.
C:Use the conventional path data load of the SQL*Loader utility.
D:Use the INSERT INTO...SELECT command to load the data
If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）
A: recover lost blocks
B: recover corrupt blocks
C: recover media corrupt blocks from list
D: recover corrupt blocks from list
E: recover corruption list
If you create your database using Oracle Managed Files （OMF）， what is true？（）
A:You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
B:You must define directories for two online redo log groups and three copies of the control file. 
C:If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
D:You must use only OMF data files when adding new tablespaces or data files to your database in the future.
Which statements are true regarding the creation of an incident package file by using the EM Workbench Support？（）
A: You can add or remove the trace files to the package.
B: You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
C: You can add SQL test cases to the incident package.
D: You cannot create an incremental incident package when the physical files are purged rom the ADR.
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g？（）
A: It does not allow you to change the moving window size.
B: Adaptive threshold functionalities use it by default to compute statistics.
C: It is created by default with the window size being equal to the AWR retention time.
D: It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）.
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）
A: You can use RMAN stored scripts
B: Recovery is faster if data is stored in catalog in addition to the control file
C: You can store backup information of all registered databases in one place
D: Database backups are automatically deleted when they are older than the specified time period
A customer wants to improve the availability of a web application and provide more predictable scalability when scaling out the application.    Which Feature of WebLogic should you recommend to help solve this problem?（）
A:Oracle Web Grid
B:ActiveCache
C:Coherence Grid Edition
D:WebLogic Session Replication
E:Coherence Web Edition
View the Exhibit and examine the properties of the USERS tablespace.  You execute the following statement to shrink the TRANS table existing on the USERS tablespace：  SQL> ALTER TABLE trans SHRINK SPACE CASCADE;  Which objects would be affected by this command？ （）
A:the TRANS table
B:the B*Tree indexes on the TRANS table
C:the materialized views log of the TRANS table
D:the materialized views based on the TRANS table
E:the large object （LOB） segments of the TRANS table
You executed the following commands：   SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）；   Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）
A: The statistics are stored in the pending statistics table in the data dictionary.
B: The statistics are treated as the current statistics by the optimizer for all sessions.
C: The statistics are treated as the current statistics by the optimizer for the current sessions only.
D: The statistics are temporary and used by the optimizer for all sessions until this session terminates.
The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）
A:set DB_FLASHBACK_RETENTION_TARGET=10800  
B:create a new scheduler window for the time period of 24 hours and use the optimizer statistics 
C:modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings 
D:specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations
关于程序包中的游标说法正确的有（）。
A:可定义为％ROWTYPE类型
B:Return子句是可选的
C:在包的实现体部分必须给出游标的完整声明
D:不可以定义Ref游标
You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed？（）
A:back up the control file to trace
B:bring database to the MOUNT state
C:open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
D:set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
What command would you issue to enable automated backups of control files？（）  
A: alter database controlfile autobackup on
B: alter system controlfile autobackup on
C: configure controlfile autobackup on
D: enable controlfile autobackup
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）
A: You do not need to restore all the data files.
B: You do not need to open the database with the RESETLOGS operation
C: You do not need to perform a full backup after the RESETLOGS operation.
D: You do not need to recover all the data files to the same system change number （SCN）.
In which situation would you use static database registration for a listener（）
A:when multiple databases are to be registered with the listener
B:when DBAs need to connect remotely to start up the database instance
C:when users need to connect the database instance using the host naming method
D:when the database instance that is to be registered with the listener is configured in shared server mode
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this: Choose the correct sequence.（）
A:4, 1, 3, 2, 5
B:4, 3, 1, 2, 5
C:2, 4, 3, 5, 1
D:4, 2, 5, 3, 1
You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use?（）
A:
B:
C:
D:
You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database：  INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB  DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD？（） 
A:DB_BLOCK_SIZE
B:CONTROL_FILES
C:LARGE_POOL_SIZE
D:LOG_ARCHIVE_DEST
E:LOG_ARCHIVE_FORMAT
F:DB_CREATE_FILE_DEST
首页 <上一页 126 127 128 129 130 下一页> 尾页