出自:Oracle认证

Which operation requires that you create an auxiliary instance manually before executing the operation？（）
A: Backup-based database duplication.
B: Active database duplication.
C: Tablespace point-in-time recovery.
D: No operation requires the creation of an auxiliary instance.
Which of the following files cannot be backed up by RMAN？（）
A: Database datafiles
B: Control files
C: Online redo logs
D: Database pfiles
E: Archived redo logs
The user SCOTT executes the following command successfully to increase the salary values in one of his sessions：  SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20；  Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）
A:because of redo data from redo log file
B:because of data from database buffer cache
C:because of data from a temporary tablespace
D:because of undo data from the undo tablespace
ABC Corp. is implementing 11i Oracle Applications. The company has two local administrators in separate locations. They need to ensure that only a relevant set of users is visible to each of these local administrators. Which action will meet the requirement?（）
A:create a separate role for each local administrator
B:specify user administration privileges in Oracle User Management
C:use Data Security to provide relevant access to each local administrator
D:use Function Security to provide relevant access to each local administrator
Integration between （） multidata sources and （） is defined as the Grid Link for RAC.
A:Oracle WebLogic Server; Oracle Database
B:Oracle WebLogic Server clusters; Oracle Database
C:Oracle WebLogic Server clusters; Oracle Database RAC
D:Oracle OC4J; Oracle Database RAC
E:Oracle WebLogic Server; Oracle OC4J
You work as a database administrator for Certkiller .com. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of atablespace. Which statement is true in this scenario？（）
A:A
B:B
C:C
D:D
E:E
Exhibit You work as a database administrator for Supportcenter.cn. While creating a new user or changing the password for existing users， the password must adhere to the restrictions specified in the exhibit. Which option would you use to achieve this objective？（）
A:Use a trigger to validate the password
B:Use a user defined PL/SQL block to validate the password
C:Use a profile to include the password verify function to validate the password
D:Use Oracle’s default password verification procedure to validate the password
E:Use a procedure name in the CREATE USER command to validate the password
In an Oracle 10g database， the in/x7fmemory statistics are gathered at regular intervals and used to perform growth/x7ftrend analysis and capacity planning of the database. Which component stores these statistics？（）
A:recovery catalog
B:Oracle Enterprise Manager Repository
C:Automatic Workload Repository （AWR）
D:Oracle 10g Enterprise Manager Grid Control
E:Automatic Database Diagnostic Monitor （ADDM）
User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the followingerror after the INSERT statement is issued and few rows are inserted：INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） *ERROR at line 1： ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions eitherof which will help you resolve this problem. （）
A:Grant the RESOURCE role to SCOTT.
B:Add data files to the USERS tablespace.
C:Grant the CREATE ANY TABLE privilege to SCOTT.
D:Increase the space for SCOTT on the USERS tablespace.
E:Increase the size of the data file associated with the USERS tablespace
Which  statements regarding the server parameter file （SPFILE） are true（）
A:An SPFILE is a binary file.
B:An SPFILE cannot reside on a client.
C:An SPFILE cannot contain static parameters.
D:An SPFILE can store changes persistently across instance restarts.
E:An SPFILE can be read by the database server， but it is not written to by the server.
F:An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database
Initially， for the Automatic Workload Repository （AWR） statistics，the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However，when you observe the Memory Advisor on a Friday，you find that the statistics are available only for two days， Thursday and Friday，of that week. What would have caused the statistics to be removed？（）
A:On Wednesday， the statistics have been purged.
B:On Wednesday， the retention period has been set to zero.
C:On Wednesday， the collection interval has been set to zero.
D:On Wednesday， the collection level has been changed to All.
E:On Wednesday， the retention period has been set to one day.
F:On Wednesday， the retention period has been set to two days
G:On Wednesday, the collection level has been changed to Typical.
H:On Wednesday, the collection interval has been set to 1440 minutes.
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 Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)
A:The backup piece size will be limited to 300 MB
B:The RMAN uses multiplexing to perform backup
C:The operation is accomplished using the default channel available
D:The RMAN parallelizes the backup although the parallelism is not set for a channel
Click the Exhibit button. Given： ClassA a = new ClassA（）；a.methodA（）； What is the result？（）
A:Compilation fails.
B:ClassC is displayed.
C:The code runs with no output.
D:An exception is thrown at runtime.
Which tool can be used to create and configure listeners to receive client connections？（）
A:Oracle Net Manager
B:Oracle Net Control Utility
C:Oracle Net Configuration Assistant
DRAG DROP Click the Task button.
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)
A:The databases configured to use the ASM instance are mounted
B:The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
C:ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
D:ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
Which statement is true regarding virtual private catalogs?（）
A:A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
B:The virtual private catalog owner cannot create and modify the stored scripts.
C:The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
D:To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database
用二维表结构表达实体集的模型是（）。
A:概念模型
B:层次模型
C:网状模型
D:关系模型
Exhibit： View the Exhibit to see the information on existing tablespaces of the PROD database.  You observe that a large volume of INSERTs and DELETEs are happening on the TRANS table residing in the USERS tablespace， and you suspect that the TRANS table is fragmented. Which advisory component would you refer to， in order to find the information about table fragmentation？（）
A:Memory Advisor
B:Segment Advisor
C:SQL Tuning and Access Advisors
D:Automatic Workload Repository （AWR）
E:Automatic Database Diagnostic Monitor （ADDM）
To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）
A: DB_CACHE_SIZE
B: SHARED_POOL_SIZE
C: LARGE_POOL_SIZE
D: JAVA_POOL_SIZE
E: SGA_MAX_SIZE
F: SORT_AREA_SIZE
Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? （）
A:CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
B:CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
C:CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
D:CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));
Which dynamic view displays the status of block-change tracking?（）
A:V$BLOCK_CHANGE 
B:V$BLOCK_CHANGE_TRACKING 
C:V$BLOCKCHANGE 
D:V$BLOCK_TRACKING
Which two are true about aggregate functions? （）
A:You can use aggregate functions in any clause of a SELECT statement.
B:You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
C:You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
D:You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
E:You can use aggregate functions on a table, only by grouping the whole table as one single group.
F:You cannot group the rows of a table by more than one column while using aggregate functions.
Which of the following datatypes store time-zone information in the database?（）
A:TIMESTAMP
B:DATE
C:TIMESTAMP WITH TIME ZONE
D:TIMESTAMP WITH LOCAL TIME ZONE
E:DATETIME
Click the Exhibit button. What is the result？（）
A:Compilation of class A fails.
B:Line 28 prints the value 3 to System.out.
C:Line 28 prints the value 1 to System.out.
D:A runtime error occurs when line 25 executes.
E:Compilation fails because of an error on line 28.
Given： What is the result？（）
A:12
B:The code runs with no output.
C:An exception is thrown at runtime.
D:Compilation fails because of an error in line 21.
E:Compilation fails because of an error in line 22.
F:Compilation fails because of an error in line 31.
In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.  Which method must you use to recover the lost data？（）  
A: Complete Recovery with online redo log
B: Complete Recovery with archived redo log
C: Tablespace Point-in-Time Recovery （TSPITR）
D: Incomplete Recovery with system change number （SCN）
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）
A: log buffer
B: Java pool
C: Large pool
D: Fixed SGA
E: Shared pool
F: Streams pool
G: Keep buffer cache
H: Database buffer cache
当失败的实例再次启动时，（）可以执行紧急恢复操作。
A:LGWR
B:DBWn
C:CKPT
D:SMON
You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). The following are the possible steps to accomplish this task: 1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility. 5. Copy the associated data files and export the dump file to the desired location in the target database. 6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.（）
A:2，1，3，4，5，6
B:1，3，4，5，6，7
C:1，4，3，5，6，7
D:2，1，3，4，5，6，7
E:1，5，6，4，3，2
首页 <上一页 29 30 31 32 33 下一页> 尾页