出自:Oracle认证

You issued the RMAN>SHOW ALL； command. The output of the command is as follows：     After analyzing this output， what conclusion can you draw？ （）
A: If you perform a backup across a network， then the backup will reduce the bandwidth.
B: If you perform a backup of a datafile， then the backup will be the same as the operating system copy of the datafile.
C: If you perform a backup of a single datafile， then the control file will not be backed up. 
D: The maximum size of each backup set is 10MB
E: The backups will be performed on the disk.
Which statements listed below describe the data dictionary views（） 1） These are stored in the SYSTEM tablespace. 2） These are the based on the virtual tables. 3） These are owned by the SYS user. 4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5） The V$FIXED_TABLE view can be queried to list the names of these views.
A:1 and 3
B:2， 3， and 5
C:1， 2， and 3
D:2， 3， 4， and 5
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
When your WebLogic Server solution needs to be scaled out with additional capacity and you  Don’t want to add additional hardware, which three techniques should you us?（）
A:Assign more than one managed server to a physical hardware that allows better CPU  utilization
B:Assign more than one application to one managed server to better utilize threads within a single JVM process
C:Assign the same application to more than one managed server to load balance requests  between servers
D:Assign the same heap size to the managed server across the cluster for easier control of  memory footprint  
E:Create a virtualized environment with hypervisor for an easier solution
select count（*） from student和select count（id） from student之间的区别是什么？
Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）
A:None of the data definition language (DDL) statements are logged in the trace file.
B:Only DDL commands that resulted in errors are logged in the alert log file.
C:A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
D:Only DDL commands that resulted in the creation of new database files are logged.
Which type of backup must be performed first with an incremental backup？（）
A: Level 1
B: Level 0
C: Level 2
D: Level 3
逻辑备份时，备份文件的扩展名一般是（）扩展名。
A:Sql
B:Bak
C:Dump
D:Dmp
Which two statements about the background process of thedatabase writerare true（） 
A:It is possible to have multiple database writers in an Oracle instance.
B:It writes dirty buffers， if any， to data files whenever a checkpoint occurs.
C:It writes dirty buffers， if any， to data files whenever a transaction commits.
D:It writes dirty buffers， if any， to data files before the log writer （LGWR） writes.
The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER (4) NOT NULL CUSTOMER_NAME VARCHAR2 (100) NOT NULL STREET_ADDRESS VARCHAR2 (150) CITY_ADDRESS VARHCAR2 (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. You need to determine how dispersed your customer base is. Which expression finds the number of different countries represented in the CUSTOMERS table?（）
A:COUNT(UPPER(country_address))
B:COUNT(DIFF(UPPER(country_address)))
C:COUNT(UNIQUE(UPPER(country_address)))
D:COUNT DISTINTC UPPER(country_address)
E:COUNT(DISTINTC (UPPER(country_address)))
The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter（s） should be configured to perform a transportable tablespace import？（）
A: DB_4K_CACHE_SIZE only
B: DB_8K_CACHE_SIZE only
C: DB_BLOCK_SIZE and DB_4K_CACHE_SIZE
D: DB_BLOCK_SIZE and DB_8K_CACHE_SIZE
E: SGA_TARGET and DB_4K_CACHE_SIZE
F: DB_CACHE_SIZE only
Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?（）
A:It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B:It will be successful only if the memory is available from the auto tuned components
C:It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
D:It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
Which statements are true about logical structures of the Oracle database（）
A:Each segment contains one or more extents.
B:Multiple tablespaces can share a single data file
C:A data block is the smallest unit of input/output （I/O） in 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 operating system block
A highly available WebLogic cluster in UNIX is configured for automatic server migration. Node Managed is configured on both machines to start managed servers. How should you simulate a managed server failure to test whether automatic server migration is working?（）
A:Shut down the managed server from the WebLogic console.
B:Shut down the managed server using the WLST command through Node Manager.
C:Run "kill -9" once to kill the managed server process.
D:Run "kill -9" to kill the managed server process, and run "kill -9" one more time if the managed  server is restarting.
Which two prerequisites are needed for performing workload capture and replay？（）
A:Close all sessions performing queries using database links
B:running the database in shared server mode
C:The database on which the workload is replayed has to be a restore of the original database to a specific SCN
D:setting up the directory to capture the workload
Case 1：  1. Shut down the database and perform a backup.  2. Restore all the data files.  3. Mount the database.  4. Recover the database.  5. Without applying all the redo log files， open the database using the RESETLOGS option.  6. Back up the database.  Case 2：  1. Shut down the database and perform a backup.  2. Restore only the data files of the tablespace where user error damaged the data.  3. Mount the database. 4. Recover the database.  5. Open the database with the RESETLOGS option.  6. Back up the database.  Case 3：  1. Shut down the database.  2. Restore the data files.  3. Open the database.  4. Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）
A: Only case 1
B: Only case 2
C: Only case 3
D: Case 1 and 2
E: Case 2 and 3
F: Case 1 and 3
G: All cases， case 1， case 2， case 3
According to your backup strategy， you performed an incremental level 0 backup of yourdatabase. Which statement regarding this backup is true？（）
A:The backup is similar to image copy.
B:The backup contains all used data blocks.
C:The backup contains only unused data blocks.
D:The backup contains all data blocks changed since the last incremental level 1 backup.
You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）
A:ALTER DATABASE 
B:SET TRANSACTION 
C:ALTER ROLLBACK SEGMENT 
D:ALTER TABLE
在Oracle中，DBMS_LOB程序包的（）过程用于删除指定的BLOB或CLOB。
A:delete
B:erase
C:remove
D:empty_lob
在设置撤消表空间的自动管理功能时，DBA通过使用相关的初始化参数对自动撤消表空间进行配置。下面的4个参数中，哪一个不是与自动撤消管理功能相关的参数？（）
A:UNDO_MANAGEMENT
B:UNDO_TABLESPACE
C:UNDO_RETENTION
D:TRANSACTIONS
You want to migrate your database to ASM， so you have done a clean shutdown， made a closed backup of the entire You wa database， noted the location of your control files and online redo log files， and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion.  Using the following steps，what is the correct order in which the following RMAN commands should be executed？（）   1. STARTUP NOMOUNT  2. ALTER DATABASE OPEN RESETLOGS  3. SQL "ALTER DATABASE RENAME ，，logfile1 path TO ，，+dgrp4 ，，" # plus all other logfiles  4. SWITCH DATABASE TO COPY  5. BACKUP AS COPY DATABASE FORMAT ，，+dgrp4 6. ALTER DATABASE MOUNT  7. RESTORE CONTROLFILE FROM ，，controlfile_location
A: 2， 5， 3， 1， 7， 6， 4
B: 1， 7， 6， 5， 4， 3， 2
C: 5， 1， 2， 7， 4， 6， 3
D: 7， 3， 1， 5， 6， 2， 4
To use Active Cache features in WebLogic 12C, which three libraries are needed from the WebLogic Server installation to be deployed in WebLogic Server?（）
A:coherence-work.jar
B:coherence.jar
C:active-cache-1.0.jar
D:coherence-web-spi.war
下面（）不是Oracle事务控制语句。
A:commit
B:rollback
C:savepoint
D:GoTo
Which two are examples of a mouse event?（）
A:The user clicks the mouse. 
B:The user moves the mouse into an item. 
C:The cursor style changes from default to busy. 
D:The user moves the mouse into the window title bar.
You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema. You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table: SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP; What would be the outcome of the precedent statement?（）
A:It retrieves the latest version of the table from the recycle bin
B:It retrieves the oldest version of the table from the recycle bin
C:It retrieves the version of the table for which undo information is available
D:It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
View the Exhibit and examine the Flashback SCNs.  A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery， you chose 2004343 as the Flashback SCN.  Which two statements are correct in this scenario？（）
A:Only the row with DEPARTMENT_ID 290 would be flashed back.
B:The rows with DEPARTMENT_ID 290 and 300 would be flashed back.
C:The rows with DEPARTMENT_ID 290 and 280 would be flashed back.
D:You would have taken the USERS tablespace offline before starting the Flashback Table operation.
E:You would have enabled row movement for the DEPT3 table before starting the Flashback Table operation.
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users：  CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgr NUMBER， v_loc NUMBER） BEGIN  INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END；  The users having permission to execute the procedure are able to insert records into the  DEPARTMENTStable even though they do not have the INSERT privilege on the table. You want only those users whohave privileges on the DEPARTMENTS table to be able to execute the procedure successfully.  What would you suggest to the PL/SQL developers to achieve this（）
A:Create the procedure with definer’s right.
B:Create the procedure with invoker’s right.
C:Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
D:Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users
There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）
A:Only bring the tablespace back online.
B:Only recover the tablespace and then bring the tablespace back online.
C:Shut down the database， recover the data file and then start up the database.
D:Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
E:Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement：   SQL> DROP TABLE SCOTT.EMP PURGE；   After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）
A: the datafiles associated with the SYSTEM tablespace
B: the datafiles associated to the DATA1 tablespace
C: the datafiles associated to the SYSTEM and DATA1 tablespaces
D: all the datafiles in the database
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）
A:statistics recommendations
B:SQL Profile recommendations
C:Index-related recommendations
D:restructuring of SQL recommendations
首页 <上一页 89 90 91 92 93 下一页> 尾页