出自:Oracle认证

Click the Exhibit button and examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is true?（）
A:The SELECT statement is syntactically accurate.
B:The SELECT statement does not work because there is no HAVING clause.
C:The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D:The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）
A:ALTER DATABASE FLASHBACK ON;
B:GRANT SELECT any transaction TO scott;
C:GRANT EXECUTE ON dbms_flashback TO scott;
D:ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E:ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F:ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
Examine the statement:Create synonym emp for hr. employees;What happens when you issue the statement?（）
A:An error is generated.
B:You will have two identical tables in the HR schema with different names.
C:You create a table called employees in the HR schema based on you EMP table.
D:You create an alternative name for the employees table in the HR schema in your own schema.
In Recovery Manager （RMAN）， you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged， you want to place the data file in a different location while resto ing the file.  Which option must you consider for this task？（）  
A: using only the RMAN SWITCH command to set the new location for the data file
B: placing the database in the MOUNT state for the restore and recovery operations
C: using an RMAN RUN block with the SET NEWNAME and then the SWITCH command
D: configuring two channels： one for the restore operation and the other for the recovery operation
假设在数据库中创建了用户test，需要为其授予CREATE ANY TABLE系统权限，可以使用如下（）语句。
A:GRANT CREATE ANY TABLE test
B:GRANT CREATE ANY TABLE TO test
C:TAKE CREATE ANY TABLE TO test
D:ALTER CREATE ANY TABLE TO test
Active Cache is the integration of Coherence and WebLogic Server. Which component is NOT part of this integration?（）
A:Coherence*Web
B:Coherence*Extend
C:TopLink Grid with Coherence
D:Coherence cluster lifecycle management in WebLogic Server
E:Named cache dependency Injection
The warning level threshold value for a tablespace， DATA1， is set to 60% and the critical level threshold value is set to 80%. The tablespace， DATA1， is infrequently used and is not a part of the production environment. You issued the following command：        SQL> EXECUTE   DBMS_SERVER_ALERT.SET_THRESHOLD        （dbms_server_alert.tablespace_pct_full，        dbms_server_alert.operator_ge，80，        dbms_server_alert.operator_ge，90，        1，1，NULL，   dbms_server_alert.object_type_tablespace，’DATA’）；   What will be the result of the command？（）  
A: The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.
B: The total numbers of alerts that you receive every day will be reduced.
C: The total number of alerts that you receive every day will be increased.
D: No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.
Your database is running in NOARCHIVELOG mode. Every night there is a backup taken using RMAN. During your startup this morning you received en error regarding DISK 3 on your server. This is the location of your data file for the SYSTEM tablespace. Which option is open to you？（）
A:A
B:B
C:C
D:D
While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows: 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.（）
A:2，3，5
B:1，2，4
C:1，2，4，5
D:1, 2, 3, 4, 5
The EMPLOYEES table contains these columns: You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: What does the statement provide?（）
A:All of the desired results
B:Two of the desired results
C:One of the desired results
D:An error statement
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）
A: ALTER DATABASE FLASHBACK ON
B: GRANT SELECT any transaction TO scott
C: GRANT EXECUTE ON dbms_flashback TO scott
D: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
E: ALTER TABLESPACE undots1 RETENTION GUARANTEE
F: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS
You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）
A:Increase the size of redo log files
B:Increase the size of redo log buffer
C:Increase the number of redo log files
D:Place the redo log files on a separate disk
E:Decrease the number of redo log groups to two
F:Increate the number Log Writer （LGWR） process
Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?（）
A:to find the tax percentage for each of the employees
B:to list the name, job_id, and manager name for all the employees
C:to find the name, salary, and the department name of employees who are not working with Smith
D:to find the number of employees working for the Administrative department and earning less than 4000
E:to display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned
You are managing an Oracle Database 11g database. The database is open， and you plan to  performRecovery Manager （RMAN） backups.  Which three statements are true about these backups（）
A:The backups would be consistent. 
B:The backups would be inconsistent.
C:The backups would be possible only if the database is running in ARCHIVELOG mode.
D:The backups would be possible only if the database is running in NOARCHIVELOG mode.
E:The backups need to be restored and the database has to be recovered in case of a media failure.
（）实现了JDBC ResultSet中的所有方法，但与ResultSet不同的是，（）中的数据在Connection关闭后仍然有效。
A:OracleCachedRowSet；OracleCachedRowSet
B:OracleRowSet；OracleRowSet
C:OracleSet；OracleSet
D:CachedRowSet；CachedRowSet
When a repeating timer expires,（）.
A:The When-Timer-Expired trigger resets the timer's iteration parameter. 
B:The When-Custom-Item-Event trigger fires and executes the desired actions. 
C:It is put in a queue of expired timers for processing on a first-in-first-out basis. 
D:The When-Timer-Expired trigger fires instantly regardless of any other processing in the form module. 
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands: Which two statements are true regarding the tasks accomplished with these commands?（）
A:They import all metadata from the RCAT10 catalog.
B:They unregister the database from the RCAT10 catalog.
C:They do not register the databases registered in the RCAT10 catalog.
D:They register all databases registered in the RCAT10 catalog.
什么是联合主键，什么是外键？
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager （RMAN） backup， which is the best option you would consider for the new database？（）  
A: Opening the database in RESTRICTED mode
B: Opening the database with the RESETLOGS option
C: Setting a new DBID for the newly restored database
D: Restoring the server parameter file （SPFILE） to the new host
What is the data type returned by the CREATE_TIMER built-in?（）
A:long
B:timer
C:number
D:varchar2
What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）
A:Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status. 
B:You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually. 
C:Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query. 
D:Global indexes remain intact and available for use by data manipulation language （DML） statements even for sessions that have not enabled the skipping of unusable indexes.
Which statement is true regarding Flashback Version Query？（）
A: It returns versions of rows only within a transaction.
B: It can be used in subqueries contained only in a SELECT statement.
C: It will return an error if the undo retention time is less than the lower bound time or SCN specified.
D: It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.
Identify two tasks of the Application tier in 11i Oracle Applications architecture. （）(Choose two.)
A:process business logic
B:store business logic in the database
C:retrieve business logic from the database
D:manage communication between desktop/client tier and database tier
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 WHERE department_id IN (10,20);
E:CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the  OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements.  What would you do with these SQL statements？（）
A: Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
B: Capture the plans from the previous version using STS and then load them into the stored outline.
C: Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）
D: Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
What is the name of the file that identifies the set of available locale definitions?（）
A:locale.def
B:lxdef.ora
C:lx1boot.nlb
D:lx1boot.ora
E:lang.def
What is true regarding subqueries?（）
A:The inner query always sorts the results of the outer query
B:The outer query always sorts the results of the inner query
C:The outer query must return a value to the outer query
D:The inner query returns a value to the outer query
E:The inner query must always return a value or the outer query will give an error
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands: What are the implications of this command?（）
A:It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.
B:It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
C:It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
D:It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
Which files must be synchronized in order for a database to start？（）
A:temp files
B:online data files
C:offline data files
D:read only data files
You executed the following commands to find the location of the alert log file： Where is the alert log file stored（）
A:in the BACKGROUND_DUMP_DEST location； in text format
B:in the BACKGROUND_DUMP_DEST location； in XML format
C:in the BACKGROUND_DUMP_DEST location； in both text and XML format
D:in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory； in text format
E:in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory； in XML format
F:in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory； in both text and XML format
首页 <上一页 110 111 112 113 114 下一页> 尾页