Oracle认证 - 自考题库

出自:Oracle认证

Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）
A:ADDM
B:AWR
C:Cursor Cache
D:SQL Tuning Sets
E:Flash Recovery Area

When your Solaris system is booted， a startup script initializes the rpcbind service. Which script is it？（）
A: /lib/svc/method/net-physical
B: /etc/rcS.d/S30network
C: svc：/network/rpc/bind：default
D: /lib/svc/method/rpc-bind

When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue. /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found. Which two environment variables do you need to set appropriately to avoid such errors，and start the Database Control successfully？（）
A:NLS_LANG
B:ORACLE_SID
C:ORACLE_HOME
D:ORACLE_BASE
E:LD_LIBRARY_PATH

Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space，you issued the following command： ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS； What would be the outcome of this command？（）
A: It produces an error because data already exists in the table.
B: It produces an error because compression can be enabled at table creation only.
C: It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
D: It immediately compresses all existing data as well as new data， resulting from either fresh additions or modifications to existing data.

如果需要在侦听器命令行环境中查看关于数据库服务以及服务处理器的运行状态等详细信息，可以使用（）命令。
A:server
B:service
C:svr
D:help

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database. Which SQL statement can Mary use to accomplish that task?（）
A:CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu
B:CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);
C:CREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;
D:CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;
E:CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu
F:CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;

下列关于PL/SQL的说法正确的是（）
A:PL/SQL是应用于各种数据库上的通用语言
B:PL/SQL是过程化的SQL语言
C:PL/SQL是只能在SQL*PLUS中运行
D:在PL/SQL可以直接执行所有的SQL操作

Which two statements are true about variable extent size support for large ASM files?（）
A:The metadata used to track extents in SGA is reduced.
B:Rebalance operations are completed faster than with a fixed extent size
C:An ASM Instance automatically allocates an appropriate extent size.
D:Resync operations are completed faster when a disk comes online after being taken offline.
E:Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

You plan to execute the following command to perform a Flashback Database operation in your database： SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）
A: The database must have multiplexed redo log files
B: The database must be in the MOUNT state to execute the command
C: The database must be in the NOMOUNT state to execute the command
D: The database must be opened in RESTRICTED mode before this operation
E: The database must be opened with the RESETLOGS option after the flashback operation

You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）
A:table
B:transactional trigger
C:stored procedure
D:FROM clause query

The listener uses dynamic information about the database and instance it has received through service registration before using information statically configured. Some services such as heterogeneous services and external procedures require the use of information statically configured within listener.ora. In order to support this， which tool could be used to configure the listener statically？（）
A:Oracle Net Manager
B:Listener Control Utility
C:Oracle Net Control Utility
D:Oracle Net Configuration Assistant

Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）
A: Automatic PGA Memory Management
B: Automatic SGA Memory Management
C: Automatic Shared Memory Management
D: Automatic Memory Management
E: Manual SGA Memory Management
F: None of the above

The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide? （）
A:All of the desired results
B:Two of the desired results
C:One of the desired results
D:An error statement

In your database， UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true？（）
A:Undo data is retained until the next full database backup.
B:No committed undo data will be overwritten for 10 minutes.
C:Committed undo data will be kept forever if not overwritten within 600 seconds.
D:Guarantees that requested undo information are available until the instance is shut down.

登陆OMS所使用的用户名和密码分别为什么？如果登陆时，系统提示找不到服务，你应该如何处理？

Which are DML statements? （）
A:COMMIT
B:MERGE
C:UPDATE
D:DELETE
E:CREATE
F:DROP...

Which statement is true regarding Oracle Shared Server architecture？（）
A:A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher.
B:Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.
C:Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher.
D:Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.

What methods are available to recover lost control files？（）
A: Backup control file.
B: Emergency control file.
C: The create controlfile command.
D: The restore controlfile SQL*Plus command.
E: No backup is required. The database will re-create the control file when it is discovered to be lost.

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
A:The SKD user cannot log in to the database instance.
B:The objects owned by the SKD user are not accessible to any user.
C:The other users can access the objects owned by the SKD user， on which they have access.
D:The password for the SKD user expires and the user is forced to change the password at the next log in

Which statements are true regarding SecureFile LOBs?（）
A:The amount of undo retained is user controlled.
B:SecureFile LOBs can be used only for nonpartitioned tables.
C:Fragmentation is minimized by using variable-sized chunks dynamically.
D:SecureFile encryption allows for random reads and writes of the encrypted data.
E:It automatically detects duplicate LOB data and conserves space by storing only one copy.

如何强制执行日志切换（）
A:ALTER SYSTEM CHECKPOINT;
B:ALTER SYSTEM CHECKPOINT FORCE;
C:ALTER SYSTEM SWITCH LOGFILE;
D:ALTER SYSTEM SWITCH LOGFILE FORCE;
E:ALTER DATABASE LOG SWITCH;

Which three statements are true about logical structures of the Oracle database（）
A:Each segment contains one or more extents.
B:Multiple tablespaces can share a single data file.
C:A data block is the smallest unit of input/output （I/O） in data files.
D:It is possible to have tablespaces of different block sizes in a database.
E:Each data block in the database always corresponds to one operating system block.

Which four are correct guidelines for naming database tables? （）
A:Must begin with either a number or a letter.
B:Must be 1-30 characters long.
C:Should not be an Oracle Server reserved word.
D:Must contain only A-Z, a-z, 0-+, _, *, and #.
E:Must contain only A-Z, a-z, 0-9, _, $, and #.
F:Must begin with a letter.

A user named Arren is executing this query： select table_name，operation，undo_sql from flashback_transaction_query t，（select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123） e where t.xid = e.xid； When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem. Which of the following SQL statements will correct this problem？（）
A: GRANT SELECT ANY TRANSACTION TO ARREN
B: GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN
C: GRANT SELECT_ANY_TRANSACTION TO ARREN
D: GRANT FLASHBACK TO ARREN
E: GRANT SELECT ANY VIEW TO ARREN

You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）
A:The Automatic Memory Manager (AMM)
B:The SQL Tuning Advisor
C:The Segment Advisor
D:The SQL Access Advisor

A team of programmers is reviewing a proposed API for a new utility class. After some discussion,they realize that they can reduce the number of methods in the API without losing any functionality.If they implement the new design, which two OO principles will they be promoting?（）
A:Looser coupling
B:Tighter coupling
C:Lower cohesion
D:Higher cohesion
E:Weaker encapsulation
F:Stronger encapsulation

Which one is a system privilege? （）
A:SELECT
B:DELETE
C:EXECUTE
D:ALTER TABLE
E:CREATE TABLE

Given：

What is the result？（）
A:hi hi
B:hi world
C:world world
D:Compilation fails.
E:An exception is thrown at runtime.

通常情况下，Oracle的本地命令方式使用（）文件来保存服务名的映射信息，建议使用Oracle Net Configuration Assistant等工具对其进行修改。
A:listner.ora
B:tnsnames.ora
C:net.ora
D:init.ora

首页 <上一页 92 93 94 95 96 下一页> 尾页