出自:Oracle认证

In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（）  
A: The datafiles have an ONLINE status.
B: The datafiles have an OFFLINE status.
C: The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.
D: The datafiles have an OFFLINE status and are in hot backup mode for an online backup.
E: The datafiles are in STANDBY mode.
You want to set the following Initialization parameters for your database Instance   LOG_ARCHIVE_DEBT_1 = ，，LOCATION=/disk1/arch LOG_ARCHIVE_DBST_2 = ，，LOCATION=/disk2/arch LOC_ARCHIVB DBST_3 = ，，LOCATION=/disk3/arch LOG_ARCHIVE DBST_ = ，，LOCATION=/disk3/arch   Identify the statement that correctly describes this setting.（）  
A: The MANDATORY location must be a flash recovery area.
B: The optional destinations may not use the flash recovery area.
C: This setting is not allowed because the first destination is not set as MANDATORY.
D: The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.
Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings？（）  
A: CREATE_MAPPING_PRIORITY
B: SET_MAPPING_PRIORITY
C: SET_MAPPING_ORDER
D: PRIORITIZE_MAPPING_ORDER
E: This functionality is not available through the DBMS_RESOURCE_MANAGER package.
By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） the necessary SQL statements to undo the erroneous changes  Which option would you choose？（）
A:RMAN only
B:Flashback Table only
C:Flashback Versions Query only
D:Flashback Database and Flashback Transaction Query
E:Flashback Versions Query and Flashback Transaction Query
What are two reasons to create synonyms?（）
A:You have too many tables.
B:Your tables are too long.
C:Your tables have difficult names.
D:You want to work on your own tables.
E:You want to use another schema's tables.
F:You have too many columns in your tables.
You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?（）
A:The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
B:The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
C:The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
D:Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）
A:Add a data file to the SMD tablespace.
B:Add a data file to the temporary tablespace associated with the user HR.
C:Resize the data file associated with the SMD tablespace to make it larger.
D:Alter the data file associated with the SMD tablespace to grow automatically.
E:Change the segment space management for the SMD tablespace to automatic
Given: Which statement is true?（）
A:The code will compile without changes.
B:The code will compile if public Tree() { Plant(); } is added to the Tree class.
C:The code will compile if public Plant() { Tree(); } is added to the Plant class.
D:The code will compile if public Plant() { this("fern"); } is added to the Plant class.
E:The code will compile if public Plant() { Plant("fern"); } is added to the Plant class.
Given： What is the result？（）
A:Compilation succeeds.
B:Exactly one class does NOT compile.
C:Exactly two classes do NOT compile.
D:Exactly four classes do NOT compile.
E:Exactly three classes do NOT compile.
从某字符串中截取一部分子串，可以用以下哪个函数实现（）
A:TRUNC
B:TRIM
C:LPAD
D:INSTR
E:SUBSTR
在Oracle中，当从SQL表达式调用函数时，下列描述不正确的是（）。
A:从SELECT语句调用的函数均不能修改数据库表
B:函数可以带有IN、OUT等模式的参数
C:函数的返回值必须是数据库类型，不得使用PL/SQL类型
D:形式参数必须使用数据库类型，不得使用PL/SQL类型
In which three cases does a checkpoint occur？ （）
A:Every three minutes.
B:When a log switch occurs.
C:When forces by an administrator.
D:When a tablespace is taken offline normal.
E:When the redo buffer is one-third full.
You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.  The data should be spread across two data files.  A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）
A:set PCTFREE and PCTUSED to 50
B:specify extent allocation as Uniform
C:specify extent allocation as Automatic
D:create the tablespace as bigfile tablespace
E:create the tablespace as smallfile tablespace
F:set segment space management to Automatic
G:use the RESIZE clause while creating the tablespace
（）is a collection of components managed by Fusion Middleware Control. It can contain Oracle WebLogic Server domains， one Administration Server， one or more Managed Servers， clusters， and the Oracle Fusion Middleware components that are installed， configured， and running in the domain
A: farm
B: bean
C: unit
D: node
Examine the structure of the EMPLOYEES table: You issue these statements: At the end of this transaction, what is true?（）
A:You have no rows in the table.
B:You have an employee with the name of James.
C:You cannot roll back to the same savepoint more than once.
D:Your last update fails to update any rows because employee ID 180 was already eleted.
A client/server application has been configured to use local naming. The client and server run on separate machines. When the client tries to connect， it receives a TNS error. By carefully examining the environment， a tnsnames.ora is found only on the Oracle server machine， among other things. After copying this tnsnames.ora onto the client machine， the client is able to connect to the server.  Which statement is true？（）
A:tnsnames.ora must be on the client machine for local naming. 
B:tnsnames.ora must be removed from the server for the connection to work. 
C:tnsnames.ora must be on both the client and server machines for local naming. 
D:tnsnames.ora is not required for local naming; the problem was not fixed by copying the file to the client.
What is an obsolete backup set？（）  
A: A backup set that is missing one or more backup set pieces
B: A backup that has exceeded the retention criteria and is no longer needed
C: A backup set that does not include archived redo logs
D: A backup set that can not be recovered due to corruption
E: A backup set superceded by a datafile copy
You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）
A: SQL Tuning Advisor
B: SQL Access Advisor
C: Undo Advisor
D: Segment Advisor
Which two statements regarding the Flashback Table feature are correct？（）
A: Flashback Table can be performed on system tables.
B: Flashback Table operation does not shrink the segments.
C: Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
D: Flashback Table operation acquires exclusive data manipulation language （DML） locks.
You issued the following statement to monitor the usage of the index：        SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE；   Which view will you query to ensure that the index is being monitored？（）  
A: INDEX_STATS
B: DBA_INDEXES
C: DBA_IND_COLUMNS
D: V$OBJECT_USAGE
View the Exhibit for the object interdependency diagram. How does this impact the status of the dependent objects?（）
A:All dependent objects remain valid.
B:Only the procedure and function become invalid and must be recompiled.
C:Only the view becomes invalid and gets automatically revalidated the next time it is used.
D:Only the procedure and function become invalid and get automatically revalidated the next time they are called.
Which  statements are correct about temporary tables（）
A:Indexes and views can be created on temporary tables.
B:Both the data and the structure of temporary tables can be exported.
C:Temporary tables are always created in a user’s temporary tablespace.
D:The data inserted into a temporary table in a session is available to other sessions.
E:Data manipulation language （DML） locks are never acquired on the data of temporary tables
You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）
A: DB_RECOVERY_FILE_DEST only
B: DB_FLASHBACK_RETENTION_TARGET only
C: DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST only
D: DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET only
E: DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST and
F: DB_FLASHBACK_RETENTION_TARGET
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.Which action should you take?（）
A:Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
B:Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
C:Use compression when performing tape backups
D:Configure multiple SBT channels
Which is an example of a dynamic SELECT statement? （）
A:A query whose object names change during its execution. 
B:A query whose object names are not known until run time. 
C:A query whose bind variables values change during execution. 
D:A query whose bind variable values are not known until run time.
A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith/smith  Connected.  SQL> SELECT * FROM v$session；  SELECT * FROM v$session *  ERROR at line 1：  ORA-00942： table or view does not exist  Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）
A:granting SELECT privilege to SMITH on V$SESSION
B:granting SELECT privilege to SMITH on V_$SESSION
C:asking the user SMITH to run the catalog.sql script
D:granting SELECT privilege to SMITH on V$FIXED_TABLES
E:setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
F:creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command：  LSNRCTL> STOP  What would happen 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 active transactions are rolled back and the sessions get terminated.
D:The sessions are not allowed to perform any operations till the listener is started.
While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）
A:the CREATE TABLE .. command
B:sorting of the SYSTEM tablespace’s data
C:sorting of data required by recursive SQL statements
D:the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
E:sorting of data if the users have not been allocated temporary tablespace explicitly
F:sorting of data if the users have been allocated temporary tablespace explicitly
为了启动Oracle数据库实例，Oracle必须读取一个（）文件，该文件保存了实例和数据库的配置参数列表。
A:控制文件
B:数据文件
C:参数文件
D:初始化文件
View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you recommend?（）
A:90 MB
B:272 MB
C:362 MB
D:1,440 MB
首页 <上一页 21 22 23 24 25 下一页> 尾页