出自:Oracle认证

What is the purpose of importing from an export，and specifying that no rows be imported and that the output goes to a log file？（）
A:To verify space requirements in the target database before importing.
B:To generate the SQL for the DDL operations that would occur during import.
C:To check character set compatibility between the export file and the target database.
D:To check for integrity constraint violations that would occur in the target database.
SQ L*Loader is a utility that can perform which two tasks？（）
A:Load data from a disk， tape， or named pipes.
B:Load data into an Oracle database using DML statements.
C:Extract， reorganize， and insert data within an Oracle database.
D:Load data from external files into tables in an Oracle database.
E:Load data into an Oracle database using operating system commands.
F:Load data directly from a non-Oracle database to an Oracle database.
What is the impact of the results of the output of the following command？（）   RMAN> report unrecoverable database；  Report of files that need backup due to unrecoverable operations  File Type of Backup Required Name  4 full or incremental C:///ORACLE/ORADATA/ORCL/USERS01.DBF  
A: There are no backup sets with any backups of the users01.dbf datafile.
B: The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.
C: The users01.dbf datafile is corrupted.
D: The users01.dbf datafile backup exceeds the retention criteria.
E: The last backup of the users01.dbf datafile failed and must be rerun.
Which two elements of the Java Enterprise Application Archive are required?（）
A:EJB Archive  
B:Deployment Descriptor
C:META-INF sub directory
D:Resource Adapter archive
E:Java library
Given： What is the result？（）
A:0
B:1
C:2
D:3
E:4
Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）
A:No change is required to achieve the desired results.
B:SELECT ename, sal, 12*(sal+100) FROM emp;
C:SELECT ename, sal, (12*sal)+100 FROM emp;
D:SELECT ename, sal+100,*12 FROM emp;
In a Database Replay workload capture， what client request information is gathered？（）
A: SQL text
B: Shared server requests （Oracle MTS）
C: Bind variable values
D: Information about transactions
E: Remote DESCRIBE and COMMIT operations
When a check point occurs the （）. （）. and （） are synchronized.
A:data files
B:control files
C:redo log files
D:parameter files
E:archive log files
Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace space usage metrics is set to 70%.  To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do？（）
A:disable SQL tracing for theAPPS tablespace
B:disable logging attribute for the APPS tablespace
C:modify the tablespace to be a dictionary­managed tablespace
D:increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace
E:increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace
Given: What is the result?（）
A:6
B:7
C:10
D:11
E:Compilation fails.
F:An exception is thrown at runtime.
You would like to display the system date in the format "Monday, 01 June, 2001".Which SELECT statement should you use?（）
A:SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
B:SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;
C:SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
D:SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
E:SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
Which of these are valid Flashback Database recovery point parameters？（） 
A: SCN
B: Timestamp
C: Named recovery point
D: Transaction ID
E: Session ID
You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）
A:The database performance would be enhanced.
B:The redo log files would be get filled more frequently.
C:The overall database performance would be degraded.
D:The mean time to recover （MTTR） would be increased.
假设创建了一个侦听器listner1，在侦听器命令行工具中将其设置为当前侦听器，可以使用如下（）命令。
A:set listner listner1
B:set current_listner listner1
C:alter current_listner listner1
D:alter system current_listner listner1
Which two statements are true about encrypting RMAN backup？（）
A: The transparent encryption of backups uses the encryption wallet
B: The database uses the same encryption key for every encrypted backup
C: The password encryption of backups only uses the password while creating and restoring backup
D: If transparent encryption is configured， you cannot use the SET ENCRYPTION BY PASSWORD  command to make password-protected backups
Which statements are true regarding table compression? （）(Choose all that apply.)
A:It saves disk space and reduces memory usage.
B:It saves disk space but has no effect on memory usage.
C:It incurs extra CPU overhead during DML as well as direct loading operations.
D:It incurs extra CPU overhead during DML but not direct loading operations.
E:It requires uncompress operation during I/O.
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）
A:User process
B:Server process
C:System Monitor (SMON)
D:Process Monitor (PMON)
E:Checkpoint process (CKPT)
下列哪个函数可以把一个列中的所有值相加求和？（）
A:MAX
B:SUM
C:COUNT
D:AVG
ABC Corp. is installing 11i Oracle Applications on two nodes A and B. On Node A, it hasinstalled the Forms server, Web server, and Administration server. On Node B, it has installed theConcurrent Processing server. By default, on which node would the Reports server be installed?（）
A:Node A
B:Node B
C:neither of the nodes
D:both Node A and Node B
You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？ （）
A:SQL script
B:PL/SQL script
C:Operating System （OS） script
D:Enterprise Manager （EM） script
E:Recovery Manager （RMAN） script
What is the danger associated with stopping a running job by using the STOP_JOB procedure?（）
A:The job will need to be reenabled before it will execute again.
B:The job may hold locks on objects referenced within it.
C:All jobs within the job group will also be stopped.
D:The job may leave data in an inconsistent state.
E:There is no danger in using the STOP_JOB procedure.
What is the default value for the ENABLED attribute of a job or program when it is created？（）
A: TRUE
B: FALSE
C: There is no default. It must be defined at creation time.
D: PENDING
E: NULL
Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）
A:Specify the break order on the gemp group Property palette. 
B:Specify a break order on the dept_name and job columns property palettes. 
C:Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 
D:Change the position of the dept_name and the job columns within the gemp group.
ote the following structures in your database server： 1：Extents 2：OS Blocks 3：Tablespace  4：Segments  5：Oracle Data Block  Which option has the correct arrangement of these structures from the smallest to the largest（）
A:2， 5， 1， 4， 3
B:1， 2， 3， 4， 5
C:5， 2， 1， 3， 4
D:2， 1， 5， 4， 3
The SPFILE for the PROD database specifies the following initialization parameter values：   SGA_TARGET = 2G   DB_8K_CACHE_SIZE = 128M   You create a tablespace named HR with the non-standard block size of 8K. Four database users are running queries on a table in the HR tablespace. These users complain that the queries are taking longer than usual to complete. While investigating the reasons for this delay， you discover that the database encounters extensive cache misses on the database buffer cache with the block size of 8K. You issue the following statement to increase the value of the DB_8K_CACHE_SIZE initialization parameter to 256M：   SQL>ALTER SYSTEM SET DB_8K_CACHE_SIZE=256M SCOPE = BOTH；   What is the result of this statement？（）  
A: The statement fails because you cannot set the memory components manually if the SGA_TARGET initialization parameter is set to a nonzero value.
B: The statement fails because the DB_8K_CACHE_SIZE initialization parameter is not a dynamic parameter.
C: The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and extracts an additional 128M of memory from the automatically sized memory components.
D: The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and reallocates an additional 128M memory from the memory components that are not auto-tuned.
Which of the following are prerequisite steps to transport a database？（） 
A: Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the intended destination is listed.
B: Verify that there are no restrictions or limitations that the source or destination database may encounter.
C: Verify that the source and destination have the same Oracle version critical updates，patch-set version，and patch- set exceptions.
D: Determine if you will perform the conversion on the source or destination platform. 
E: None of the above.
Which statement describes the significance of the CHANGE FAILURE command in RMAN？（）
A: It is used to change failure priority only for HIGH or LOW priorities.
B: It is used to execute the advised repair script.
C: It is used to change failure priority only for the CRITICAL priority.
D: It is used to explicitly close the open failures.
E: It is used to inform the database about the repair after the repair script executes.
Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?（）
A:a cumulative level 1 backup
B:a differential level 1 backup
C:a full backup
D:a whole backup
View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session: RMAN> REPAIR FAILURE; Which statement describes the consequence of the command?（）
A:The command performs the recovery and closes the failures.
B:The command only displays the advice and the RMAN script required for repair.
C:The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.
D:The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
What is the purpose of the catalog command？（）  
A: To review RMAN control file and recovery catalog metadata and ensure that its correct
B: To delete RMAN backup-related metadata from the recovery catalog
C: To create metadata in the control file and the recovery catalog related to backup set pieces 
D: To create a report that lists database backups
E: To rebuild the recovery catalog
首页 <上一页 17 18 19 20 21 下一页> 尾页