Oracle认证 - 自考题库

出自:Oracle认证

在PL/SQL中定义一个名为v_name长度为60个字符的变长字符串类型的变量，以下正确的是（）
A:v_namechar（60）；
B:v_namestring（60）；
C:v_namevarchar2（60）；
D:v_namevarchar2（61）；

You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database:

Which three are the prerequisites for the successful execution of the above command?（）
A:The source database should be open
B:The target database should be in ARCHIVELOG mode if it is open
C:RMAN should be connected to both the instances as SYSDBA
D:The target database backups should be copied to the source database backup directories
E:The password file must exist for the source database and have the same SYS user password as the target

You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command？（）
A: UNTIL SEQUENCE
B: UNTIL SCN
C: UNTIL CHANGE
D: UNTIL CANCEL

Which statement is true regarding this setting?（）
A:It drops the connection after the specified number of login attempts fail for any user.
B:It is enforced only if the password profile is enabled for the user.
C:It locks the user account after the specified number of attempts.
D:It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.

You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed? （）
A:The main query executes with the first value returned by the subquery.
B:The main query executes with the last value returned by the subquery.
C:The main query executes with all the values returned by the subquery.
D:The main query fails because the multiple-row subquery cannot be used with the comparison operator.
E:You cannot define a multiple-row subquery in the WHERE clause of a SQL query.

You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）
A: LARGE_POOL_SIZE
B: DB_CREATE_FILE_DEST
C: LOG_ARCHIVE_DEST
D: CONTROL_FILES
E: LOG_ARCHIVE_FORMAT
F: DB_BLOCK_SIZE

You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （）
A:You get an error because of a primary key violation.
B:The data and structure of the EMPLOYEES table are deleted.
C:The data in the EMPLOYEES table is deleted but not the structure.
D:You get an error because the statement is not syntactically correct.

You performed an incremental level 0 backup of a database: RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?（）
A:Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
B:The change tracking file must always be backed up when you perform a full database backup.
C:Block change tracking will always reduce I/O performed during cumulative incremental backups.
D:More than one database block may be read by an incremental backup for a change made to a single block.
E:The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？（）
A:data files
B:backup sets
C:control files
D:archived redo log files

You issued the following statement： SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（）
A: The control file will be multiplexed.
B: The control file will be recreated.
C:The script containing the CREATE CONTROLFILE statement will be created.
D: The binary backup of the control file will be created.

You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）
A:the alert.log file
B:the DBA_ALERTS view
C:the Database Control Home page
D:the Database Control performance page
E:the Database Control Maintenance page

You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）
A:by using the ANALYZE utility
B:by using the DBVERIFY utility
C:by using the DB_BLOCK_CHECKING parameter
D:by using the DBMS_REPAIR package

Click the Exhibit button. Which three code fragments, added individually at line 29, produce the output 100?（）

A:n = 100;
B:i.setX( 100 );
C:o.getY().setX( 100 );
D:i = new Inner(); i.setX( 100 );
E:o.setY( i ); i = new Inner(); i.setX( 100 );
F:i = new Inner(); i.setX( 100 ); o.setY( i );

Examine the section of the Health Check report given below:

Which two statements are true regarding the Health Check report?（）
A:Health Check was performed manually.
B:Health Check was performed to check the disk image block corruptions.
C:Health Check was performed to check interblock and intersegment corruption.
D:Health Check was performed to verify the integrity of database files and report failures.
E:Health Check was performed by the Health Monitor automatically in response to a critical error.

You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： ERROR at Line 1： ORA-10635： Invalid segment or tablespace type What could be the reason？（）
A:The table is partitioned
B:The table name is wrong.
C:It is an index-Organized table （IOT）
D:The table is stored in locally managedtablespace.
E:The table is stored in atablespacewhere segment space is managed manually.

You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?（）
A:Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files
B:Execute the PURGE BINARY LOGE NOT USED command
C:Remove all of the binary log files that have a modification date earlier than today
D:Edit the .index file to remove the files you want to delete
E:Ensure that none of the attached slaves are using any of the binary logs you want to delete

下列哪类命令在未提交前可以通过ROLLBACK命令进行回退（）
A:DCL
B:DDL
C:DML
D:DQL
E:以上所述都不正确

根据不同的需要，可对数据库服务器进行相应的启动方式，当以STARTUP MOUNT方式启动时，以下说法正确的是（）
A:仅仅创建一个数据库实例
B:创建了数据库实例并且挂载了数据库
C:创建了数据库实例，同时也创建了数据库
D:打开了数据库，但只能供系统用户访问
E:创建了数据库实例，并且以只读方式打开了数据库

Which object is added to a form module when you copy the reusable calender class?（）
A:List icon
B:Object group
C:PL/SQL library
D:Key-Listval trigger

Which statement correctly describes the change tracking writer （CTWR） background process？（）
A: It keeps track of changes in the background processes.
B: It records the system change number （SCN） in the control file.
C: It writes audit records for user changes to the change tracking file.
D: It records any changes to the listened configuration in the listener.ora file.
E: It records any changes to the database parameters in the change tracking file.
F: It records the physical location of all the changes that are made to the database in the change tracking file.

Which two are regarding automatic space management segments？（）

A:A
B:B
C:C
D:D

How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yetcompleted?（）
A:Issue the ALTER DISKGROUP ... ADD DISK command.
B:Issue the ALTER DISKGROUP ... UNDROP DISKS command.
C:Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.
D:Retrieve the disk from the Recycle Bin after the operation completes.

在Oracle中，关于锁，下列描述不正确的是（）。
A:锁用于在用户之间控制对数据的并发访问
B:可以将锁归类为行级锁和表级锁
C:insert、update、delete语句自动获得行级锁
D:同一时间只能有一个用户锁定一个特定的表

A company that makes Computer Assisted Design （CAD） software has， within its application， some utilityclasses that are used to perform 3D rendering tasks. The company’s chief scientist has just improved theperformance of one of the utility classes’ key rendering algorithms， and has assigned a programmer toreplace the old algorithm with the new algorithm. When the programmer begins researching the utilityclasses， she is happy to discover that the algorithm to be replaced exists in only one class. The programmer reviews that class’s API， and replaces the old algorithm with the new algorithm， being carefulthat her changes adhere strictly to the class’s API. Once testing has begun， the programmer discovers thatother classes that use the class she changed are no longer working properly. What design flaw is mostlikely the cause of these new bugs？（）
A:Inheritance
B:Tight coupling
C:Low cohesion
D:High cohesion
E:Loose coupling

You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）; Which two statements are true？（）
A:SYSDATE should not be used with TIMESTAMP.
B:The database must have multiplexed redo log files.
C:The database must be in the MOUNT state to execute the command.
D:The database must be opened with the RESETLOGS option after the flashback operation.
E:The entire database needs to be restored from the most recent backup before the flashback operation.

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）
A:The EVENT parameter was not set.
B:The SQL_TRACE parameter is set to FALSE
C:The Enterprise Manager Grid Control is not used.
D:The STATISTICS_LEVEL parameter is set to BASIC
E:The TIMED_STATISTICS parameter is set to FALSE

You have performed an incomplete recovery because some important user’s schema is dropped and purged from the Recycle Bin. The current logs are sequenced 1005 and 1006. After performing the recovery， you issued the following statement： SQL>ALTER DATABASE OPEN RESETLOGS； What will be the resultant log sequence numbers？（）
A: 0 and 1
B: 1 and 2
C: 1005 and 1006
D: 1006 and 1007

You have created a resource plan， DAY. You execute the following code： SQL> BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE （ PLAN => ’DAY’， COMMENT => ’DEPARTMENTS PLAN’， GROUP_OR_SUBPLAN => ’DEPARTMENTS’， CPU_P1=0）； END； Then， you issue the following code： SQL> BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE （ PLAN => ’DAY’， COMMENT => ’DEPARTMENTS PLAN’， GROUP_OR_SUBPLAN => ’DEVELOPERS’， CPU_P2=100）； END； What will be the impact of executing the above code？（）
A: The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.
B: The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.
C: The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.
D: The second code will not execute because one resource plan cannot be used by more than one subplan.

Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?（）
A:SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);
B:SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);
C:SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);
D:SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);
E:SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);
F:SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl < b. maxsal; What is the result of the statement? （）
A:The statement produces an error at line 1.
B:The statement produces an error at line 3.
C:The statement produces an error at line 6.
D:The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.
E:The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.

首页 <上一页 57 58 59 60 61 下一页> 尾页