Oracle认证 - 自考题库

出自:Oracle认证

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.

Identify three situations in which you would NOT be able to drop a tablespace. （）
A:when the tablespace is online
B:when the tablespace has segments with data in it
C:when the tablespace is a default permanent tablespace for the database
D:when the tablespace contains a table that is currently being used by transactions
E:when the tablespace contains undo data that is needed to rollback an uncommitted transaction

The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）
A:statistics recommendations
B:SQL profile recommendations
C:index-related recommendations
D:restructuring of SQL recommendations

Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?（）
A:A DBA can check specific tables with the DMU
B:The database to be migrated must be opened read-only.
C:The release of the database to be converted can be any release since 9.2.0.8.
D:The DMU can report columns that are too long in the converted characterset.
E:The DMU can report columns that are not represented in the converted characterset.

Which of the following statements are true regarding the Recycle Bin？（）
A: The Recycle Bin is a physical storage area for dropped objects.
B: The Recycle Bin is a logical container for dropped objects.
C: The Recycle Bin stores the results of a Flashback Drop operation.
D: The objects in the Recycle Bin are stored in the tablespace in which they were created.

Given：

Which statement is true？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:Synchronizing the run（） method would make the class thread-safe.
D:The data in variable "x" are protected from concurrent access problems.
E:Declaring the doThings（） method as static would make the class thread-safe.

When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?（）
A:SET_JOB_ARGUMENT_VALUE
B:SET_JOB_VALUE_ANYDATA
C:SET_JOB_ANYDATA_VALUE
D:SET_SPECIAL_JOB_VALUE
E:SET_JOB_ANYTYPE_VALUE

You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALESwith CPU_P1as 60 and DEGREE_OF_PARALLELISMas 4. Consumer group MARKETwith CPU_P1as 20. Consumer group DEVwith CPU_P1as 20. Consumer groupOTHERSwith CPU_P1as 0 and CPU_P2as 100. Which two statements are correct in this scenario？（）
A: The maximum degree of parallelism for the members of the consumer groups is 4.
B: The CPU allocation will always be equal for the consumer groups MARKET and DEV.
C: The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.
D: The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.
E: The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.

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) Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）
A:SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;
B:SELECT customer_id, customer_name FROM customers WHER postal_code = ' ___________';
C:SELECT customer_id, customer_name FROM customers WHERE postal _ code IS NULL;
D:SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;
E:SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;

How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has alreadycompleted?（）
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

Given：

What is the result？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:[608， 609， 610， 612] [608， 610]
D:[608， 609， 610， 612] [608， 609， 610]
E:[606， 608， 609， 610， 612] [608， 610]
F:[606， 608， 609， 610， 612] [608， 609， 610]

You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）
A:Set the UNDO_RETENTION parameter to AUTO.
B:Create an initial undo segment in undotablespace.
C:Set the UNDO_RETENTION parameter to 900 or more
D:Set the initialization parameter UNDO_MANAGEMENT to AUTO
E:Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

Which dependent object will get invalidated even if it is not affected by the table edefinition？（）
A: packages
B: triggers
C: synonyms
D: views

A user executes a query on the EMP table， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal; SELECT ename FROM emp WHERE deptno=10 ORDER BY sal * ERROR at line 1： ORA/x7f01157： cannot identify/lock data file 201 /x7f see DBWR trace file ORA/x7f01110： data file 201： ’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason？（）
A:The tempfile belonging to the default temporary tablespace is missing.
B:The database is opened in restricted mode， so queries are not allowed.
C:The default temporary tablespace required to execute the query is offline.
D:The default temporary tablespace required to execute the query is dropped.
E:The default temporary tablespace required to execute the query is readonly.

Given：

Which statement is true？（）
A:Compilation fails because the hashCode method is not overridden.
B:A HashSet could contain multiple Person objects with the same name.
C:All Person objects will have the same hash code because the hashCode method is not overridden.
D:If a HashSet contains more than one Person object with name="Fred"， then removing another Person，also with name="Fred"， will remove them all.

How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）
A:Include an SPFILE parameter in each instance-specified initialization file.
B:Create an SPFILE copy on each client from which the instance will be started.
C:Store the SPFILE in a raw partition with a vendor-specifies location and name.
D:Use a single client to start the instances and create the SPFILE on this client.

You want to enforce a company’s business policy on several objects by using a singlepolicy function. Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective？（）
A:DBMS_RLS.STATIC
B:DBMS_RLS.DYNAMIC
C:DBMS_RLS.SHARED_STATIC
D:DBMS_RLS.CONTEXT_SENSITIVE
E:DBMS_RLS.SHARED_CONTEXT_SENSITIVE

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS; What is the outcome of this command?（）
A:The command produces an error because the retention period cannot be reduced
B:All historical data older than 3 years is purged from the flashback archive FLA1
C:All historical data is retained but the subsequent flashback data archives are maintained for only 3 years
D:All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time

When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（） a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command.
A: a， b， c， d， e， f
B: c， d， a， b， f
C: d， c， a， b， f
D: d， b， d， c， e
E: d， c， a， b， e

View the Exhibit.

You are creating an additional database by using the Database Configuration Assistant （DBCA）. Youopted to create a General Purpose database and during the database creation realize that the Block Sizefield is not enabled. What could be the reason for this（）
A:You have chosen the File System option as the storage option.
B:You have chosen the Automatic Storage Management （ASM） as the storage option.
C:The data block size can be increased only when DBCA is invoked from Oracle Universal Installer （OUI）.
D:You are using General Purpose template and not the Custom Database template to create the database.

When should you create a role? （）
A:To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.
B:To grant a group of related privileges to a user.
C:When the number of people using the database is very high.
D:To simplify the process of granting and revoking privileges.
E:To simplify profile maintenance for a user who is constantly traveling.

William is creating a job class. William specifies the LOGGING_FULL setting for the LOGGING_LEVEL attribute at the time of job class creation. What is the impact of using this setting？（）
A: Detailed information regarding the first run of each job in the class will be written in the job log， and every operation performed on the job class will be logged.
B: Detailed information regarding each run of only the first job in the class will be written in the job log， and every operation performed on the job class will be logged.
C: Detailed information regarding each run of each job in the class will be written in the job log， and every operation performed on the job class will be logged.
D: Detailed information regarding each run of each job in the class will be written in the job log， but operations performed on the job class will not be logged.

You have created a password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3 Which of the following is true about this password file？（）
A: If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.
B: If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.
C: If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is
D: If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.

You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）
A:to enable operating system authentication for a remote client
B:to restrict the scope of administration to identical operating systems
C:to allow the start up and shut down of the database from a remote client
D:to enable the administration of the operating system from a remote client
E:to disable the administration of the operating system from a remote client

Which DBMS_SCHEDULER procedures can be used to enable a program?（）
A:ENABLE启用
B:ENABLE_PROGRAM
C:VALIDATE_PROGRAM
D:SET_ATTRIBUTE设置属性
E:SET_ENABLED

You have created a resource plan， PROD_DB_PLAN， that uses the RATIO policy. The following consumer groups and their respective plan directives have been assigned to this resource plan： Consumer group HIGH_CG with CPU_P1 as 10. Consumer group MEDIUM_CG with CPU_P1 as 5. Consumer group LOW_CG with CPU_P1 as 2. Consumer group OTHER_GROUPS with CPU_P1 as 1. Which statement is correct in this scenario？（）
A:The plan PROD_DB_PLAN can have subplans.
B:The members of the HIGH_CG consumer group would get 10% of the CPU.
C:The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.
D:The CPU allocation would be equal between the HIGH_CG and MEDIUM_CG consumer groups if there are no sessions existing for the LOW_CG and OTHER_GROUPS consumer groups.

Which three statements are true about SQL plan directives?（）
A:They are tied to a specific statement or SQL id.
B:They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
C:They are used to gather only missing statistics.
D:They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
E:They instruct the optimizer to create only column group statistics.
F:Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

Which statement describes the ROWID data type?（）
A:Binary data up to 4 gigabytes.
B:Character data up to 4 gigabytes.
C:Raw binary data of variable length up to 2 gigabytes.
D:Binary data stored in an external file, up to 4 gigabytes.
E:A hexadecimal string representing the unique address of a row in its table.

You work as a database administrator for Supportcenter.cn. You are using three database， SupportCenter DB01， SupportCenter DB02， and SupportCenter DB03， on different host machines in your development environment. The database server configuration， such as IP address and listener port number， change frequently due to development requirements， and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）
A:Host naming
B:Local naming
C:Easy Connect
D:External naming
E:directory naming

Your database runs in ARCHIVELOG mode， and is backed up every Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database. How can you do this？（）

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

首页 <上一页 69 70 71 72 73 下一页> 尾页