出自:Oracle认证

In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql＞ TRUNCATE t1;
A:$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
B:Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
C:$ mysql – u root – p – h localhost test ＜ /tmp/t1.sql
D:Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
E:$ mysqlinport – u root – p – h localhost test /tmp/t1.sql
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）
A:A backup of the target database when it is mounted
B:A backup of online redo log files when the database is open
C:A backup of only used data blocks in the file beingbeingbackup up
D:A backup of online， read/write data files when the database is open
E:A backup of only those data blocks that have changed since a previous backup
F:A backup of online， read/write data files when the database is in the NOMOUNT state.
Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)
A:The user has dropped an important table that needs to be recovered.
B:The database files are corrupted when the database is open.
C:You are not able to start up the database instance because the required database files are missing.
D:The archived log files are missing for which backup is not available.
Examine the following command that is executed for the TRANSPORT table in the SH schema: Which statement describes the significance of this command?（）
A:It collects statistics into the pending area in the data dictionary
B:It creates a virtual hidden column in the CUSTOMERS_OBE table
C:It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT
D:It creates a histogram to hold skewed information about the data in the columns
Which four are correct guidelines for naming database tables?（）
A:Must begin with either a number or a letter.
B:Must be 1-30 characters long.
C:Should not be an Oracle Server reserved word.
D:Must contain only A-Z, a-z, 0-+, _, *, and #.
E:Must contain only A-Z, a-z, 0-9, _, $, and #.
F:Must begin with a letter.
When setting up the Flashback Data Archive， which of these key parameters are required？（）
A: Tablespace name
B: Storage quota
C: Retention
D: Table name
E: Create a default archive
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup， you issued the following RMAN command：   RMAN> BACKUP SECTION SIZE 300M TABLESPACE users；   Which two statements are true regarding the execution of the above command？（）
A: The RMAN parallelizes the backup although the parallelism is not set for a channel.
B: The backup piece size will be limited to 300 MB.
C: The operation is accomplished using the default channel available.
D: Three channels for the tape drive must be configured by setting the parallelism to three.
Oracle提供了（）的能力，以免损坏实例的联机重做日志文件，LGWR将同一个重做日志同时写到多个同样的联机重做日志文件中。
A:双向联机重做日志文件
B:单向联机重做日志文件
C:切换联机重做日志文件
D:多路复用联机重做日志文件
有如下三步操作,并且均成功执行,请选择结果（） delete from emp; alter table emp add(addr varchar2(40)); rollback;
A:emp表中数据处于回滚段中
B:emp表中的数据被永久删除
C:emp表中的数据没有变化
D:原来的emp表中的数据被添加到新emp表中
E:以上所述都不正确
Given： If class Donkey is invoked twice， the first time without assertions enabled，and the second time with assertions enabled， what are the results？（）
A:no output
B:no outputassert is on
C:assert is on
D:no outputAn AssertionError is thrown.
E:assert is onAn AssertionError is thrown.
Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; 
A:to undo the changes made to the EMP table since the specified time
B:to restore the EMP table that was wrongly dropped from the database
C:to view the transactions that have modified the EMP table since the specified time
D:to view the changes made to the EMP table for one or more rows since the specified time
E:to recover the EMP table to a point in time in the past by restoring the most recent backup
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
A:The EMPLOYEES table will be changed to read-only mode during the shrink operation.
B:The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
C:The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
D:Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
You work as a database administrator for Certkiller .com. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， Certkiller， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）
A:Use a flashback query to retrieve the rows that were deleted
B:Useconventialincremental export and then import the affected object
C:Shutdown the database inNORMALmode and restart the database instance
D:Use DBMS_META package to reconstruct the object using undo segments
E:UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data
F:Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
Which component of the SGA stores parsed SQL statements is used for process sharing?（）
A:Buffer cache 
B:Redo log buffer 
C:Private SQL area 
D:Library cache 
E:Row cache 
Given: What is the result when the go（　） method is invoked?（）
A:00
B:0001
C:000120
D:00012021
E:Compilation fails.
F:An exception is thrown at runtime.
View the Exhibit.  You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS;  Which type of backup would this command perform？（）
A:backup set
B:image copy
C:incremental backup
D:None; the user receives an error indicating that the backup type must be specified.
The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement?（）
A:The SQL statement displays the desired results.
B:The column in the WHERE clause should be changed to display the desired results.
C:The operator in the WHERE clause should be changed to display the desired results.
D:The WHERE clause should be changed to use an outer join to display the desired results.
You work as a database administrator for Certkiller .com. In your organization， you have four databases， Certkiller DB01， Certkiller DB02， Certkiller DB03， and Certkiller 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
Which iSQL*Plus feature can be used to replace values in the WHERE clause?（）
A:substitution variables
B:replacement variables
C:prompt variables
D:instead-of variables
E:This feature cannot be implemented through iSQL*Plus.
The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers? （）
A:SELECT TOTAL(*) FROM customer;
B:SELECT COUNT(*) FROM customer;
C:SELECT TOTAL(customer_id) FROM customer;
D:SELECT COUNT(customer_id) FROM customer;
E:SELECT COUNT(customers) FROM customer;
F:SELECT TOTAL(customer_name) FROM customer;
The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?（）
A:DISPATCHER 
B:USER 
C:SERVER 
D:LGWR 
E: DBW0
The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）
A:fixed views
B:the alert log file
C:the parameter file
D:the server parameter file
E:dynamic performance views
Given： What is the result？（）
A:Hello
B:Hello World
C:Compilation fails.
D:Hello World 5
E:The code runs with no output.
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）
A:When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
B:When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
C:When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
D:When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
You find today’s performance of your production database to be the best ever.  Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）
A:A
B:B
C:C
D:D
E:E
Case-insensitive sorts are always accent insensitive by default.（）
A:True
B:False
下列动态视图中，（）是从控制文件中得到的所有表空间的名称和数量。
A:V$INSTANCE
B:V$DATABASE
C:V$TABLESPACE
D:V$DATAFILES
在SQL*PLUS中，显示执行时长的命令是（）
A:set time on
B:set timing on
C:set long
D:set timelong on
E:set sqlprompt
Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery？（）
A:Online backups.
B:Skipping unused block. 
C:Partial database backups.
D:Incremental block-level backup.
E:Detection of corrupted blocks during backup.
 You created a custom menu for the Order Entry application. Which step do you perform before attaching the menu module to the form module?（）
A:Select file-->Administration-->Convert 
B:Select file-->Administration-->Execute 
C:Select file-->Administration-->Compile File
D:No further step is necessary. 
首页 <上一页 147 148 149 150 151 下一页> 尾页