出自:Oracle认证

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task， you enabled Flashback Data Archive with the retention of 5 years. After some time， the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this， you issued the following command：   ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR；   What is the implication of this command？（）
A: The command produces an error because the retention time cannot be reduced.
B: All historical data is retained but the subsequent flashback data archives are maintained for only three years.
C: All historical data is purged and the new flashback data archives are maintained for three years.
D: All historical data older than three years is purged from the flashback archive FLA1.
View the Exhibit1， which shows the options that are selected to create the user SL_REP. Which two statements are true regarding this user（）
A:The user is authenticated by the operating system.
B:The objects created by the user are placed in the USERS tablespace.
C:The user does not require quota on the TEMP tablespace to perform sort operations.
D:The user is forced to change the password at the first login to the database instance.
E:The objects created by the user in future are unlocked to be accessed by all the users in the database by defa
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation？（）
A:recover using Oracle Flashback Database technology
B:restore the data files from backup and perform a complete recovery
C:restore only the corrupted data file and perform tablespace recovery
D:restore the data files from backup and perform cancel­based recovery
E:restore the entire database from the most recent backup and start the instance and open the database
Which two are character manipulation functions?（）
A:TRIM
B:REPLACE
C:TRUNC
D:TO_DATE
E:MOD
F:CASE
When performing an online backup，what is the proper order of the following steps？（）   a. Issue the alter database end backup command. b. Back up the archived redo logs. c. Issue the alter database begin backup command.  d. Back up the database files.  e. Determine the beginning log sequence number. f. Determine the ending log sequence number.  g. Force a log switch with the alter system switch logfile command.
A:a， b， c， d， e， f， g
B:c， d， a， b， e， g， f
C:f， d， b， g， a， c， e
D:e， c， d， a， g， f， b
E:a， f， b， g， e， c， d
User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted： INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） *  ERROR at line 1：  ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.（）
A:Grant the RESOURCE role to SCOTT.
B:Add data files to the USERS tablespace.
C:Grant the CREATE ANY TABLE privilege to SCOTT.
D:Increase the space for SCOTT on the USERS tablespace.
E:Increase the size of the data file associated with the USERS tablespace
You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）
A: ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；
B: ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；
C: ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；
D: ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）
A:shut down and restart the instance
B:add new tempfiles to the temporary tablespaces after recovery
C:perform a media recovery and open the database with the RESETLOGS option
D:perform a media recovery and bring the database to NOARCHIVELOG mode
You work as a database administrator for Supportcenter.cn. In your organization， you have four databases， SupportCenter DB01， SupportCenter DB02， SupportCenter DB03， and SupportCenter DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）. You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）
A:Control file
B:Password file
C:Parameter file
D:Online redo log file
E:Listener controller file
F:Server parameter file
The SPFILE for your database contains the following parameter settings：   SGA_TARGET = 1000M   DB_CACHE_SIZE = 512M   SHARED_POOL_SIZE = 128M   LOG_BUFFER = 10M   DB_8K_CACHE_SIZE = 50M   What is the total memory that can be distributed across the auto-tuned memory components？（）  
A: 940M
B: 990M
C: 690M
D: 1000M
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 also want to deregister them from the catalog after import. You executed the following commands to achieve this：   RMAN> CONNECT CATALOG rco11/password@catdb  RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241，1423242；   What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog？（）
A: The scripts in the RCO11 catalog are overwritten.
B: RMAN renames the local stored scripts in the RCO11 catalog.
C: The RMAN session in which the command is executed aborts.
D: RMAN renames the global scripts that are imported from the RCAT10 catalog.
Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?（）
A:RSTLNE
B:NLSRTL
C:LISTENER
D:NLSSORT
E:Linguistic sorts
Which three features are provided by Oracle Net Services？ （）
A:Data encryption.
B:User authentication.
C:Transparent data conversion
D:Configuration and administration mechanisms.
E:Support for multiple network transport protocols.
使用什么命令可以清除表中所有的内容？（）
A:INSERT
B:UPDATE
C:DELETE
D:TRUNCATE
You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）
A:You must ensure that the SALES database is mounted or open.
B:You must restore a backup control file to perform a block media recovery.
C:You must take the tools01.dbf data file offline before you start a block media recovery.
D:You must put the database in NOARCHIVELOG mode to perform a block media recovery.
E:You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.
Which three statements correctly describe the functions and use of constraints? （）
A:Constraints provide data independence.
B:Constraints make complex queries easy.
C:Constraints enforce rules at the view level.
D:Constraints enforce rules at the table level.
E:Constraints prevent the deletion of a table if there are dependencies.
F:Constraints prevent the deletion of an index if there are dependencies.
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?（）
A:Setting the FAST_START_MTTR_TARGET to set the mean time to recover
B:Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C:Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D:Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）
A:The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
B:The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
C:All the components may be moved into SYSAUX tablespace.
D:All the components may be moved from the SYSAUX tablespace.
A subquery can be used to （）.
A:Create groups of data
B:Sort data in a specific order
C:Convert data to a different format
D:Retrieve data based on an unknown condition
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition.  What happens to the PL/SQL procedure after the online table redefinition？（）
A: It remains valid.
B: It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
C: It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
D: It becomes invalid only if the storage parameters have been modified and it automatically gets  revalidated the next time it is used.
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs. What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?（）
A:The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.
B:The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
C:The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
D:The statement results in an error because there are open PDBs.
Identify three correct statements regarding Oracle E-Business Suite.（） (Choose three.)
A:It can run entirely on the Internet.
B:A minimum of two modules needs to be implemented for an organization.
C:It is engineered to work as an integrated system on a single IT infrastructure.
D:It supports multi-directional flows of business information within an organization.
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
Message attributes must be associated with （）. (Choose all that apply.)
A:a message
B:a notification
C:a response
D:an activity node
You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ /etc/init.d/mysql stop Shell＞ /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?（）
A:–skip-networking, to prohibit access from remote locations
B:–reset-grant-tables, to start the server with only the mysql database accessible
C:–read-only,to set all data to read-only except for super users
D:–old-passwords, to start Mysql to use the old password format while running without the grant tables
Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR， cursors are shared for safe literals only. What is meant by ‘safe literals only’？（） 
A:No literal value is substituted for a shared cursor. 
B:Different execution plans are generated for substituted literal values. 
C:The substitution of a literal value will produce different execution plans. 
D:The substitution of any literal value will produce exactly the same execution plan.
Which three statements are true about memory buffer allocation by a MySQL Server?（）
A:Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed
B:Thread buffers are allocated when a client connects, and are freed when the client disconnects
C:Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends
D:User buffers are allocated at server startup and freed when the user is dropped
E:All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed
You have been tasked with creating Business Events for an E-Business Suite workflow project. Whatwould you use to create your Business Events?（）
A:Oracle Workflow Builder
B:Oracle Workflow Definition Loader
C:Oracle Business Event Definition Loader
D:Workflow Administrator Web page in E-Business Suite
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）  
A: Restore and recover the datafile.
B: Restore and recover the tablespace.
C: Restore and recover the database.
D: Restore and recover the control file.
E: Restore and recover the parameter file.
Given： What can be a result？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:The code executes and prints "StartedComplete".
D:The code executes and prints "StartedComplete0123".
E:The code executes and prints "Started0123Complete".
首页 <上一页 15 16 17 18 19 下一页> 尾页