出自:Oracle认证

Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）
A:One runs faster than the other
B:A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERT
C:A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERT
D:The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE
拥有所有系统级管理权限的角色是（）。
A:ADMIN
B:SYSTEM
C:SYSMAN
D:DBA
In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）
A:The STATISTICS_LEVEL initialization parameter is set to BASIC
B:The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
C:The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
D:The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
E:The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
What are the consequences of executing the SHUTDOWN ABORT command？ （）
A:The database files are synchronized.
B:Uncommitted changes are not rolled back.
C:The database is closed， but the instance is still started.
D:Database buffers and redo buffers are not written to the disk.
E:The database undergoes automatic media recovery during the next startup.
Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）
A:/u01/app/oracle/product/11.1.0/db_1
B:/u01/app/oracle
C:$ORACLE_HOME/bdump
D:$ORACLE_HOME/log
Given classes defined in two different files: What is required at line 5 in class SomeApp to use the process method of BitUtils?（）
A:process(bytes);
B:BitUtils.process(bytes);
C:app.BitUtils.process(bytes);
D:util.BitUtils.process(bytes);
E:import util.BitUtils.*; process(bytes);
F:SomeApp cannot use the process method in BitUtils.
ou need to configure fine-grained access control to external network resources from within your database. You create an access control list （ACL） using the DBMS_NETWORK_ACL_ADMIN package.  Which statement is true regarding the ACL created？（）
A: It is a list of remote database links stored in the XML file that are available to the users of the database.
B: It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.
C: It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
D: It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.
Which three statements are true regarding the logical structure of the Oracle database？（）
A:Each segment contains one or more extents.
B:Multiple tablespaces can share single data file.
C:A data block is the smallest unit of I/O for data files.
D:It is possible to have tablespaces of different block sizes in a database.
E:Each data block in the database always corresponds to one OS block.
In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?（）
A:Immediately after the SELECT clause
B:Before the WHERE clause
C:Before the FROM clause
D:After the ORDER BY clause
E:After the WHERE clause
You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）
A:Segment Advisor 
B:SQL Tuning Advisor 
C:SQL Access Advisor 
D:Segment Resource Estimation 
E:Automatic Database Diagnostic Monitor (ADDM)
（）是驻留在自己计算机上的软件组件，同客户和Oracle服务器相分离，代理数据库服务器的请求。
A:Oracle Net
B:侦听器
C:Oracle连接管理器
D:Oracle数据库驱动程序
In order to perform Flashback Transaction Query operations， which of these steps are required？（）
A: Ensure that database is running with version 10.1 compatibility.
B: Enable Flashback Logging.
C: Enable Supplemental Logging.
D: Ensure that the database is running with version 10.0 compatibility.
E: Ensure that the database is in ARCHIVELOG mode.
Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.  What would be your next step to improve performance？ （）
A:Run the SQL Access Advisor.
B:Run the Memory Advisor for the sga.
C:Run the Memory Advisor for the pga.
D:Run the Memory Advisor for the shared pool.
E:Run the Memory Advisor for the buffer cache.
Your production database is running in archivelog mode and you are using recovery manager （RMAN） with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday， the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.   The steps to recover the damaged data files are follows：   1. Mount the database  2. Open the database  3. Recover the data file  4. Restore the data file  5. Make the data file offline  6. Make the data file online   Which option identifies the correct sequence that you must use to recover the data files？（）
A: 2，4，3
B: 1，4，3，2
C: 2，5，4，3，6
D: 5，2，4，3，6
E: 1，5，4，3，6，2
What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）
A:It can contain parameters with distinct values for each distance.
B:It can contain only parameters with identical values for each instance.
C:It must contain an IFILE parameter for each instance’s individual parameter file.
D:It must be located in the default location for the primary instance’s parameter file.
View the Exhibits and examine lock waits. Users HR and SH complain that their transactions on one of the application tables， EMP， are waiting for response.  Which action would you take to release the lock and enable users HR and SH to continue with theirtransactions（）
A:Kill the session of the user SCOTT with session ID118.
B:Issue manual checkpoint using the ALTER SYSTEM command.
C:Modify the profile used by user SCOTT to reduce the CONNECT_TIME limit.
D:Flush the Shared Pool to remove the SQL statement causing "wait" in memory.
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?（）
A:The data is decrypted during SORT and JOIN operations.
B:The data remains encrypted when it is read into memory.
C:The data remains encrypted when it is stored in the redo logs.
D:The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
在建立ORACLE数据库时选择“事务处理”模版与选用“数据仓库”模版的区别是什么？
What is true regarding InnoDB locking?（）
A:InnoDB uses row and table-level locks, but row locks are not escalates
B:InnoDB locks only those rows that are updated
C:InnoDB only uses row locks, not page or table-level locks
D:InnoDB row locks may be escalated to page or table-level locks
E:InnoDB uses row-level or table-level locks depending on the number of rows affected
A programmer has an algorithm that requires a java.util.List that provides an efficient implementation of add（0， object）， but does NOT need to support quick random access. What supports these requirements？（）
A:java.util.Queue
B:java.util.ArrayList
C:java.util.LinearList
D:java.util.LinkedList
Which three operations require undo data（）
A:committing a transaction
B:flashing back a transaction
C:recovering a failed transaction
D:running a read-consistent query
E:changing a tablespace status from READ ONLY to READ WRITE
Which built-in copies values from a record group into a list item? （）
A:POPULATE_LIST 
B:POPULATE_GROUP 
C:POPULATE_LIST_ITEM 
D:POPULATE_LIST_FROM_GROUP 
E:POPULATE_LIST_ITEM_FROM_GROUP
Which two statements correctly describe the relation between a data file and the logical database structures（）
A:An extent cannot spread across data files.
B:A segment cannot spread across data files.
C:A data file can belong to only one tablespace.
D:A data file can have only one segment created in it.
E:A data block can spread across multiple data files as it can consist of multiple operating system （OS）blocks
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）
A:The FLASHBACK TABLE statement will not be written to the alert log file.
B:The changes made to the EMP table since the specified time will be undone.
C:The EMP table that was dropped by mistake from the database will be restored.
D:The FLASHBACK TABLE statement will be executed within a single transaction.
E:The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table. 
F:The list of transactions that have modified the EMP table since the specified time will be displayed.
Given： Which statement is true？（）
A: The cardID and limit variables break polymorphism.
B: The code demonstrates polymorphism.
C: The ownerName variable breaks encapsulation.
D: The setCardInformation method breaks encapsulation.
E: The class is fully encapsulated.
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）
A:The index remains invisible.
B:The index is not updated by the DML statements on the indexed table.
C:The index automatically becomes visible in order to have it updated by DML on the table.
D:The index becomes unusable but the table is updated by the DML.
E:The index is updated by the DML on the table.
Given: What is the result?（）
A:Compilation fails due to an error in line 23.
B:Compilation fails due to an error in line 29.
C:A ClassCastException occurs in line 29.
D:A ClassCastException occurs in line 31.
E:The value of all four objects prints in natural order.
You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）
A:You performed rollback after commit.
B:If a log switch occurs in your database.
C:Thearchiverfails to generate an archived log file.
D:Instance recovery fails to find one of the redo log files.
E:A long-running query is unable to get read-consistent image.
F:If you perform manual undo management operations in auto mode.
You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）
A: The log sequence for the database will restart from 1.
B: The log sequence number will be written to the control file.
C: The log sequence number will be written to the datafile headers.
D: The log sequence number will be written to the initialization parameter file.
Which are the correct steps， in order， to deal with the loss of an online redo log if the database has not yet crashed？（）   a. Issue a checkpoint.  b. Shut down the database.  c. Issue an alter database open command to open the database.  d. Startup mount the database.  e. Issue an alter database clear logfile command.  f. Recover all database datafiles.
A:a， b， c， d
B:b， d， e， c
C:a， b， d， e， c
D:b， f， d， f， c
E:b， d， a， c
首页 <上一页 52 53 54 55 56 下一页> 尾页