出自:Oracle认证

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?（）
A:The plan baselines can be evolved over time to produce better performance.
B:The newly generated plans are directly placed into the SQL plan baseline without being verified.
C:The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
D:The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.   Which two statements are correct in this scenario？（）
A:The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B:The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C:Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.
D:The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.
The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?（）
A:randomly
B:ascending by date
C:descending by date
D:ascending alphabetically
E:descending alphabetically
You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）
A:Restart the database instance and run the job
B:Truncate the Certkiller STAFF table and run the job
C:Delete all rows from the Certkiller STAFF table and run the job
D:Increase the size of the USERStablespacethe and run the job
E:Increase the size of the database default permanenttablespaceand run the job
You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: Which SELECT statement accomplishes this task?（）
A:SELECT*   FROM customers;
B:SELECT name, address   FROM customers;
C:SELECT id, name, address, phone   FROM customers;
D:SELECT cust_name, cust_address   FROM customers;
E:SELECT cust_id, cust_name, cust_address, cust_phone   FROM customers;
Oracle Instance由哪两个部分组成？（）
A:Shared pool和Server process
B:Shared pool和Background process
C:SGA和user process
D:PGA和user process
E:SGA和Background process
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）
A: Flashback logs are not archived.
B: Flashback logs are maintained in redo log files.
C: Flashback logs are maintained in the Flash Recovery Area.
D: Flashback logs are used to maintain Flashback Database related errors.
E: Flashback logs need to be cleared manually after you disable Flashback Database.
Oracle允许数据库中有比操作系统规定的限制更多的数据文件，Oracle的（）进程能够打开所有联机的数据文件。
A:LGWR
B:DBWn
C:SMON
D:PMON
emp表是雇员信息表，sal字段存放是的雇员的月薪，以下哪个变量可以存放sal类型的值（）
A:v_sal emp%rowtype;
B:v_sal emp.sal%type;
C:v_sal emp.sal.%type;
D:v_sal %type(emp.sal);
E:v_sal (emp.sal)%type;
You issued the following command on the temporary tablespace LMTEMP in your database：   SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）  
A: The tablespace must be locally managed.
B: The tablespace must have only one temp file.
C: The tablespace must be made nondefault and offline.
D: The tablespace can remain as the default but must have no active sort operations.
You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?（）
A:ASM disk groups with ASM disks consisting of Exadata Grid Disks.
B:ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
C:ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
D:Database files stored in ZFS and accessed using conventional NFS mounts.
E:Database files stored in ZFS and accessed using the Oracle Direct NFS feature
F:Database files stored in any file system and accessed using the Oracle Direct NFS feature
G:ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
Identify three unique integration features of Spring and WebLogic Server.（）
A:ability to automatically convert Spring application to JavaEE 6 framework
B:ability to export the WebLogic Container feature to another Spring enabled JavaEE server
C:ability to extend the WebLogic Server console with some Spring-related pages
D:official support of Spring apps inside WebLogic by Oracle Support
E:support for injection of WebLogic MBeans and Resources into Spring applications
Which three statements about performance analysis by SQL Performance Analyzer are true? （）
A:It detects changes in SQL execution plans.
B:It produces results that can be used to create the SQL plan baseline.
C:The importance of SQL statements is based on the size of the objects accessed.
D:It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E:It shows only the overall impact on workload and not the net SQL impact on workload.
In which scenario would TOP N analysis be the best solution? （）
A:You want to identify the most senior employee in the company.
B:You want to find the manager supervising the largest number of employees.
C:You want to identify the person who makes the highest salary for all employees.
D:You want to rank the top three sales representatives who have sold the maximum number of products.
You execute the following command to create two consumer groups， FIN_GROUP1 and PAY_GROUP1， for a plan，PROD_PLAN：  BEGIN  DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （SIMPLE_PLAN => ’prod_plan’，  CONSUMER_GROUP1 => ’fin_group1’，  GROUP1_CPU => 80，  CONSUMER_GROUP2 => ’pay_group1’，  GROUP2_CPU => 20）;  END;  Which three statements are true？（）
A:SYS_GROUP gets 100% CPU resources at level 1.
B:FIN_GROUP1 gets 80% CPU resources at level 1.
C:FIN_GROUP1 gets 80% CPU resources at level 2.
D:PAY_GROUP1 gets 20% CPU resources at level 1.
E:PAY_GROUP1 gets 20% CPU resources at level 2.
F:OTHER_GROUP gets 100% CPU resources at level 1.
G:OTHER_GROUP gets 100% CPU resources at level 2.
A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）
A:The keep pool is not configured.
B:Automatic Workarea Management is not configured.
C:Automatic Shared Memory Management is not enabled.
D:The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
E:All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
You have issued the following command：    RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 100 DAYS；   What will be the result of using the above command？（）
A: The backup metadata will be maintained in the control file for 100 days.
B: The backup metadata will be maintained in the recovery catalog for 100 days.
C: The backup metadata will be maintained in the flash recovery area for 100 days.
D: After 100 days， the backup sets and image copies will be deleted from the media.
Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
A:
B:
C:
D:
要重新启动ORACLE数据库服务器，首先要以哪种身份登录数据库（）
A:SYSDBA
B:SYSOPER
C:SYSMAN
D:SUPERMAN
E:SYSTEM/MANAGER
Within a resource-plan definition, what differentiates a top-level plan from a subplan?（）
A:A subplan has the PLAN_SUB parameter value set to SUB
B:A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definition
C:There is no difference in the resource-plan definition
D:A subplan always has the CPU_MTH parameter value set to RATIO
E:The string TOP_LEVEL is appended to the name of top-level resource plans
Which statement is true about loading data using the conventional path of SQL*Loader（）
A:Redo is not generated while performing conventional path loads.
B:Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.
C:No exclusive locks are acquired when the conventional path loads are performed.
D:Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.
E:INSERT triggers are disabled before the conventional path load and reenabled at the end of the load.
创建密码文件的命令是（）。
A:ORAPWD
B:MAKEPWD
C:DROP RIGHT
D:DELETE RIGHT
You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）
A:The advisory memory has been turned off.
B:The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
C:The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
D:The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
E:The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
iBATIS提供了自动化的JDBC事务管理机制。对于传统JDBC连接而言，获得Connection实例之后，需要调用（）设定事务提交模式。
A:Connection.SetAutoCommit
B:Connection.SetCommit
C:Connection.SetROLLBACK
D:Connection.SetAutoROLLBACK
Which statement about recovering from the loss of a redo log group is true?（）
A:If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
B:If the lost redo log group is CURRENT, you must clear the log file.
C:If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
D:If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）
A: Open the database in read-only mode.
B: Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
C: Enable the block change tracking feature.
D: Execute the ALTER DATABASE FLASHBACK ON statement.
You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.Which set of statements accomplishes this?（）
A:CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
B:CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
C:CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3
D:CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;
E:CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;
You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）
A:Database Control
B:Management Server
C:Management Repository
D:Application Server Control
E:Oracle Management Agent
To enable resumable space allocation for the instance， which of the following initialization parameters should you set to a nonzero value？（）
A: RESUMABLE_SPACE_TIME
B: RESUMABLE_SPACE
C: RESUMABLE_TIME
D: RESUMABLE_TIMEOUT
E: TIME_RESUMABLE
Which of the following commands cannot use the functionality assosciated with theNLS_DATE_FORMAT variable？（）
A:RESTORE
B:RECOVER
C:REPORT
D:BACKUP
首页 <上一页 101 102 103 104 105 下一页> 尾页