出自:Oracle认证

When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）
A: The SYSTEM tablespace.
B: The UNDO tablespace.
C: All tablespaces with tables.
D: All tablespaces with indexes.
E: No tablespaces are automatically restored.
Which tablespaces are mandatory in an Oracle database for it to be operational（）
A:Undo tablespace
B:USERS tablespace
C:SYSAUX tablespace
D:SYSTEM tablespace
E:Temporary tablespace
User A executes the following command to update the TRANS table）  SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’；  Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table：   SQl> ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））；  What would happen in this scenario？（）
A:The transaction for user A is rolled back.
B:The ALTER TABLE command modifies the column successfully.
C:The ALTER TABLE command fails due to the resource being busy.
D:The ALTER TABLE command waits until user A ends the transaction.
Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）
A:An update in a leaf row takes place.
B:The index becomes invalid after the update.
C:The leaf block containing the row to be updated is marked as invalid.
D:A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）
A:Configure Java Pool to cache the java objects.
B:Configure Streams Pool to enable parallel processing.
C:Increase Shared Pool size to cache more PL/SQL objects.
D:Increase Database Buffer Cache size to increase cache hits.
E:Configure Large Pool to be used by RMAN and shared server.
F:Increase the total System Global Area （SGA） size to increase memory hits.
The database instance is currently using SPFILE. View the Exhibit and examine the error that you receivedwhile running the DB Structure Integrity check. Given below are the steps to recover from the error in randomorder： 1.Shut down the instance， if not already done. 2.Copy one of the remaining control files to a new location. 3.Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of thecontrol files. 4.Start up the database instance to the NOMOUNT stage. 5.Recover the database to the point of failure of the control file. 6.Open the database.  Identify the correct sequence of steps（）
A:1，2，4，3，5，6
B:2，4，3，5，6；1 not required
C:4，5，6，2，3；1 not required
D:5，2，3，4；1 and 6 not required
Which three functions are performed by the SQL Tuning Advisor? （）
A:Building the SQL profile
B:Recommending optimization of materialized views
C:Checking query objects for missing and stale statistics
D:Recommending bitmap, function-based, and B-tree indexes
E:Recommending restructuring SQL queries that are using bad plans
Exhibit. Which two options are used to enable the connect-time failover feature？（）
A:Use only the first address.
B:Try one address， selected at random.
C:Try each address， in order， until one succeeds.
D:Try each address， randomly， until one succeeds.
E:Use each address in order until destination reached.
You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
A: loss of one of the tablespaces
B: loss of a system data file
C: loss of one of the control files
D: loss of a tempfile
E: loss of the only member of an unarchived redo log group
F: loss of a member from each redo log group
For which action can you use the TO_DATE function?（）
A:Convert any date literal to a date
B:Convert any numeric literal to a date
C:Convert any character literal to a date
D:Convert any date to a character literal
E:Format '10-JAN-99' to 'January 10 1999'
You need to rename a data file of a tablespace. How would you perform this？（）
A:A
B:B
C:C
D:D
Which six files are maintained in the Flash Recovery Area？（）
A: control file
B: RMAN files
C: password file
D: parameter file
E: flashback logs
F: data file copies
G: core dump files
H: archived log files
I: RMAN recovery scripts
J: control file autobackpus
Observe the information in the columns： 1. The SGA                 a. Text and parsed forms of all SQL statements 2. The cursor state       b. Run-time memory values for the SQL statement， such as rows retrieved 3. User-session data    c. Security and resource usage information 4. The stack space      d. Local variables for the process  Which option has the correct match between the memory areas and their contents（）
A:1-c， 2-b， 3-d， 4-a
B:1-b， 2-c， 3-d， 4-a
C:1-a， 2-b， 3-c， 4-d
D:1-a， 2-b， 3-d， 4-c
You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）
A:Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. 
B:Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. 
C:Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. 
D:Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. 
E:Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.
Consider the following scenario： You have a directory， data， under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA  ADD ALIAS ’+tdgroupA/data/datafile.dbf’  FOR ’+tdgroupA.231.45678’；  Which task would be accomplished by the command？（）
A:The command drops the file +tdgroupA·231.45678.
B:The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
C:The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
D:The command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.
E:The command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.
Which two options best describe how the Maven Plugin for WebLogic enables WebLogic to be effectively used in a Continuous Integration environment?（）
A:execution of unit and integration tests
B:management of the life cycle of a WebLogic domain including creation, configuration, and server life-cycle management
C:deployment and undeployment of applications
D:Java profiling
The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）
A: The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.
B: The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
C: The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.
D: The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.
E: The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent.
You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.  Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）
A:perform point­in­time recovery
B:perform a Flashback Table operation to restore the table to the state it was in two days ago 
C:perform a Flashback Database operation to restore the database to the state it was in two days ago
D:perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）
A:Rebuild the index using the online option. 
B:Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 
C:Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 
D:Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
Given： What is the result？（）
A:1
B:2
C:12
D:Compilation fails.
E:No output is produced.
F:An exception is thrown at runtime.
Which two statements are correct about database transportation? （）
A:The source and target platforms must be the same
B:Redo logs, control files and temp files are also transported
C:The transported database must have the same database identifier (DBID) as the source database and cannot be changed
D:The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
E:Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
DRAG DROP Click the Task button.
In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）
A:The modified blocks would be written to the data files.
B:The modified blocks would be written to the temp files.
C:The modified blocks would be written to the control file.
D:The modified blocks would be written to the redo log files.
E:The modified blocks would be written to the archived redo log files.
F:The modified blocks would be retained in the database buffer cache.
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command：LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance（）
A:The sessions are able to perform only queries.
B:The sessions are not affected and continue to function normally.
C:The sessions are terminated and the active transactions are rolled back.
D:The sessions are not allowed to perform any operations till the listener is started
Given： What is the result？（）
A:s 14
B:s 16
C:s 10
D:Compilation fails.
Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）
A:Java pool
B:Large pool
C:Shared pool
D:Streams pool
E:Library cache
F:Redo log buffer
G:Data dictionary cache
H:Database buffer cache
描述数据的三个范式是什么？
In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）
A:The optimizer statistics are collected automatically.
B:Only the timed operating system （OS） statistics and plan execution statistics are collected.
C:The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D:The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. 
E:Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
Note the following points describing various utilities in Oracle Database 11g：  1：It enables the high-speed transfer of data from one database to another.  2：It provides a complete solution for the backup， restoration， and recovery needs of the entire database.  3：It enables the loading of data from an external file into an Oracle database.  4：It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）
A:1
B:2
C:3
D:4
E:1，2，and 4
F:1，2，3，and 4
When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）
A:At the end of every RUN block. 
B:After every SET CONTROLFILE AUTOBACKUP FORMAT command. 
C:After every BACKUP or COPY command issued at the RMAN prompt. 
D:At the end of every RUN block if the last command in the block was either BACKUP or COPY. 
E:Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY. 
F:After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.
首页 <上一页 152 153 154 155 156 下一页> 尾页