出自:Oracle认证

以下关于数据库后台服务进程叙述正确是的（）
A:DBWn负责从数据文件中读取数据到内存，并且负责将数据从内存回写到数据文件中
B:LGWR负责从重做日志文件中读取信息到内存，并且负责将日志信息从内存回写到重做日志文件中
C:SMON负责定时启动数据库并做相应的恢复和清理工作
D:CKPT负责向数据库发出检查点，用于同步数据库的所有数据文件、控制文件和重做日志文件
E:PMON负责定时回收所有进程所占用的数据库资源
The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?（）
A:ALTER USER DEFAULT ROLE ALL
B:ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1
C:ALTER USER DEFAULT ROLE NONE
D:ALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）
A:You cannot roll back this statement.
B:All pending transactions are committed.
C:All views based on the DEPT table are deleted.
D:All indexes based on the DEPT table are dropped.
E:All data in the table is deleted, and the table structure is also deleted.
F:All data in the table is deleted, but the structure of the table is retained.
G:All synonyms based on the DEPT table are deleted.
Given： Which two statements are true？（）
A:The output could be 8-1 7-2 8-2 7-1
B:The output could be 7-1 7-2 8-1 6-1
C:The output could be 8-1 7-1 7-2 8-2
D:The output could be 8-1 8-2 7-1 7-2
You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks.   To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   After creating the password file， you remove the operating system authentication and change the value of the  REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（）  
A: CONNECT / AS SYSDBA
B: CONNECT sys/admin AS SYSDBA
C: CONNECT sys/admin@mynewdb AS SYSDBA
D: CONNECT sys/change_on_install AS SYSDBA
Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATECHANNEL commands in RMAN（） (choose all that apply)
A:Limiting the input/output (I/O) bandwidth consumption
B:Specifying the size of backup sets and backup pieces
C:Specifying vendor-specific information for a media manager
D:Specifying the parallelism for backup and restore operations
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
A:All data along with the table structure is deleted 
B:The pending transaction in the session is committed 
C:All indexes on the table will remain but they are invalidated 
D:All views and synonyms will remain but they are invalidated 
E:All data in the table are deleted but the table structure will remain
Which view shows all valid values for the NLS_LANGUAGE， NLS_SORT， NLS_TERRITORY， and NLS_CHARACTERSET parameters？（）
A: V$VALID_NLS_VALUES
B: NLS_VALID_VALUES
C: NLS_VALUE_OPTIONS
D: V$NLS_VALUE_OPTIONS
E: V$NLS_VALID_VALUES
Which three statements are true about Automatic Workload Repository (AWR)?（）
A:All AWR tables belong to the SYSTEM schema.
B:The AWR data is stored in memory and in the database.
C:The snapshots collected by AWR are used by the self-tuning components in the database
D:AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
E:AWR contains system wide tracing and logging information.
Which clause should you use to exclude group results?（）
A:WHERE
B:HAVING
C:RESTRICT
D:GROUP BY
E:ORDER BY
You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday.  Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（） 
A: SYSTEM
B: SYSAUX
C: UNDO
D: USERS
E: TEMP
F: This restore is not possible
Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）
A:It cancels all pending disk drops within the disk group
B:It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C:It mounts disks in the disk group for which the drop-disk operation has already been completed
D:It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E:It adds previously dropped disks back into the disk group
View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN> BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?（）
A:Because the progress is reported for each data file
B:Because the progress is reported for each backup set
C:Because other RMAN sessions have issued the same BACKUP command
D:Because new data files have been added to the database while the RMAN backup is in progress
Which two statements are true regarding the starting of the database instance using the following command?（） SQL>STARTUP UPGRADE
A:It enables all system triggers.
B:It allows only SYSDBA connections.
C:It ensures that all job queues remain active during the upgrade process.
D:It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
You work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）
A:It degrades the run time and compiler performance.
B:It provides better run time and compiler performance.
C:It provides better optimization of the statement during parse time.
D:It forces the rule based optimizer to be used for statement optimization.
E:It provides better run time performance but slightly degraded compiler performance. 
F:It provides better run time performance but slightly degraded run time performance.
In which two cases would you perform only consistent backup？（）
A:You are working on a database where downtime is not tolerated.
B:You are working on a database where downtime can be tolerated.
C:You are working on a database that operates in ARCHIVELOG mode.
D:You are working on a database that operates in NOARCHIVELOG mode.
E:You are working on a database where all the tablespaces are locally managed.
F:You are working on a database where control files and redo log files are multiplexed.
G:You are working on a database where control files and redo log files are not multiplexed.
When performing an incomplete recover of the whole database， which data files must you restore？ （）
A:Only the damaged or lost data files.
B:All of the data files of the database.
C:Only the data files belonging to the SYSTEM tablespace.
D:The data files belonging to the SYSTEM tablespace and the damaged or lost data files.
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）
A: Enable flashback logging.
B: Start the database in the ARCHIVELOG mode.
C: Issue the ALTER DATABASE FLASHBACK ON； command.
D: Set the FAST_START_MTTR_TARGET initialization parameter.
You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）
A:Use the external table population.
B:Use the Oracle Data Pump export and import utility.
C:Use the conventional path data load of the SQL*Loader utility.
D:Use the INSERT INTO...SELECT command to load the data.
Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee：  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this statement have on the database？（）
A:The extents in undo tablespace retain data until the next full database backup.
B:The extents containing committed data in the undo tablespace are never overwritten.
C:The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.
D:The extents containing committed data in the undo tablespace are not overwritten until the instance  is shut down.
假定以手动方式管理数据块，PCTFREE=20，PCTUSED=40以下关于数据块的说法正确的是（）
A:块将一直保留20%的可用空间，以防数据存储过满期
B:向块内插入数据，不能超过块可用空间的40%
C:对块内的数据删除，使块的使用率下降，当块的已用空间降到80%以下，则又可以向块中插入数据了
D:对块内的数据删除，使块的使用率下降，但使用率在40%到80%之间时，是不能再向块中插入数据的
E:当块的已用空间超过到80%，则不能再向块中插入数据，也不能执行使块的已用空间超过80%的UPDATE操作
当用户进程失败时，由（）执行恢复操作，负责清除缓存和进程使用的空闲资源。
A:SMON
B:PMON
C:ARCn
D:RECO
Which statement accomplish this? （）
A:CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
B:CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
C:CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
D:CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
E:CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
F:CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);
You executed the following code：   SQL> CERATE TABLE COUNTRY   （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL，   COUNTRY_NAME VARCHAR2（20），   CURRENCY_NAME VARCHAR2（20），   CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID））   ORGANIZATION INDEX；   Which types of tables will be created automatically？（）
A: journal table
B: clustered table
C: mapping table
D: partitioned table
Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）
A:The table created by SKD is not accessible and SKD cannot create new tables.
B:The tables created by SKD and HR remain， but both cannot create new tables.
C:The table created by HR remains and HR still has the CREATE TABLE system privilege.
D:The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
Which statement is true when Automatic Workload Repository （AWR） baselines are created using baseline templates？（）  
A: AWR baselines are always created as repeating baselines.
B: AWR baselines can be created on the basis of two time values.
C: AWR baselines are always created with infinite expiration duration.
D: AWR baselines are always created using the Automatic Workload Repository （AWR） retention period as expiration duration.
You want to create a WebLogic domain in a production environment. Which three actions should  you perform?（）
A:Use a multinode WebLogic domain.
B:Use a single-node WebLogic domain. 
C:Use clusters.  
D:Refrain from using clusters.  
E:Install WeLogic in production mode with CA signed certificates.
Given： What is the result？（）
A:true true
B:false true
C:true false
D:false false
Given： Which command-line invocations will compile？（）
A:javac Mule.java
B:javac -source 1.3 Mule.java
C:javac -source 1.4 Mule.java
D:javac -source 1.5 Mule.java
In Oracle 11g， which recommendations does the SQL Access Advisor generate？（）  
A: partitioning recommendations
B: statistics collection recommendations
C: index creation recommendations
D: materialized view recommendations
E: materialized view log recommendations
首页 <上一页 93 94 95 96 97 下一页> 尾页