Oracle认证 - 自考题库

出自:Oracle认证

Which of the following parameters would you use to record the errors that might be generated during the import operation？（）
A:LOG
B:HELP
C:BUFFER
D:PARFILE
E:INCTYPE

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?（）
A:ALTER DATABASE DROP LOGFILE GROUP 1;
B:ALTER DATABASE CLEAR LOGFILE GROUP 1;
C:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D:ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG

Which two are true regarding MySQL binary and text backups?（）
A:Binary backups are usually faster than text backups
B:Binary backups are usually slower than text backups
C:Text backups are human-readable while binary backups are not
D:Binary backups are not portable across different operating systems

在ALTER TABLE中，指定某列不可用，可是使用哪个关键字？（）
A:UNUSED
B:SET UNUSED
C:DISABLE
D:NOUSE

Oracle Net Configuration Assistant is a post-installation tool that configures basic network components after installation. Which four components are included in the configuration？（）
A:Directory server
B:Hostname adaptor
C:TCP/IP host file
D:Connection Manager
E:connecting pooling
F:external procedures
G:listener names and protocol addresses
H:Net Service names in a tnsnames.ora file
I:naming methods the client uses to resolve connect identifiers

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）
A:MERGE
B:INSERT
C:UPDATE
D:ADD
E:ENTER
F:You cannot enter the phone numbers for the existing employee records.

Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature？（）
A:SWITCH_TIME
B:SWITCH_GROUP
C:MAX_SESS_POOL
D:SWITCH_ESTIMATE

You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？（）
A: To recover a dropped table.
B: To recover a dropped schema.
C: To recover data from a truncated table.
D: To view changes made by all the transactions during a given period of time.
E: To view changes made by a single transaction during a given period of time.

（）函数返回大于或等于所给数字表达式的最小整数。
A:CEIL
B:ABS
C:FLOOR
D:ROUND

You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）
A: Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.
B: Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
C: Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
D: Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）
A:Displays only the list of default values
B:Displays only the list of all basic parameters
C:Displays the currently in effect parameter values
D:Displays only the list of all advanced parameters
E:Displays the list of all the parameter files of a database
F:Displays the current contents of the server parameter file.

（）参数用于确定是否要将方案导出。
A:FILE
B:SCHEMA
C:OWNER
D:TABLES

在SQL*PLUS中执行刚输入的一条命令用（）
A:正斜杠(/)
B:反斜杠(/)
C:感叹号(!)
D:句号(.)
E:以上所述都不正确

Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, DEPARTMENT_ID NUMBER Primary Key VARCHAR2 DEPARTMENT_NAME |30| References MGR_ID column MGR_ID NUMBER of the EMPLOYEES table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER For which situation would you use a nonequijoin query?（）
A:To find the tax percentage for each of the employees.
B:To list the name, job id, and manager name for all the employees.
C:To find the name, salary, and department name of employees who are not working with Smith.
D:To find the number of employees working for the Administrative department and earning less then 4000.
E:To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.

You work as a database administrator for Supportcenter.cn. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）
A:PMON coordinates media recovery.
B:SMON coordinates instance recovery.
C:PMON coordinates instance recovery.
D:Undo Advisor would roll back all uncommitted transactions.
E:SQL*PLUS reports an error with the message asking you to perform instance recovery.

In your production database， you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct？（）
A:The parallel degree limit for DB_GRP will be the minimum of all the incoming values.
B:The parallel degree limit for DB_GRP will be the maximum of all the incoming values.
C:The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
D:If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.
E:If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

Choose the correct order to package and upload data for an incident to Oracle Support.（）
A: Schedule，create new package，view manifest，view contents
B: Create new package，view manifest，view contents，schedule
C: Schedule，create new package，view contents，view manifest
D: Create new package，view contents，view manifest，schedule
E: None of the above.

You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell＞ mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?（）
A:It exports tables with the most indexes first to assist with import speeds
B:It ensures that unique indexes have no conflicts when the data is dumped
C:It orders by primary key to assist in speeding up importing to InnoDB tables
D:It must be specified so index data is dumped correctly when –on-create-info is used

Which four actions are possible during an Online Data file Move operation?（）
A:Creating and dropping tables in the data file being moved
B:Performing file shrink of the data file being moved
C:Querying tables in the data file being moved
D:Performing Block Media Recovery for a data block in the data file being moved
E:Flashing back the database
F:Executing DML statements on objects stored in the data file being moved

You want to create a template to be used as a standard for all company reports, which are many different styles. How many different templates must you have if you plan to use multiple report styles?（）
A:Two
B:One
C:One per report style
D:One per report style + one more

You execute the following Recovery Manager （RMAN） commands in he following order： BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST； Which two tasks are performed by these commands？（）
A: Repair the corrupted blocks. If any. In the backup created
B: Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
C: Back up the database after checking whether array of the files have corrupted blocks
D: Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
E: Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION

Which option must you choose to configure Node Manager on a machine (server or zone)?（）
A:Configure one Node Manager per domain (for example, if there are two domains on one machine, then you will need to configure two Node Managers).
B:Configure one Node Manager per machine with any number of WebLogic instances running on it.
C:Configure one Node Manager per machine for all WebLogic, OHS, and OEM running on the same machine.
D:Configure one Node Manager for every WebLogic instance.
E:Configure two or more Node Managers for every WebLogic instance.

After running the CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS command， what has been accomplished？（）
A:Retain the data file backup for 7 days.
B:Run the recover process every 7 days.
C:Destroy the physical backup files every 7 days.
D:Destroy the physical backup files older than 7 days.
E:Retain one backup of each data file for at least 7 days.
F:Keep the catalog information in the control file for 7 days.

You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace， you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting？（）
A: configure a default device for RMAN backups
B: temporarily disable the retention policy for RMAN backups
C: configure automatic channel allocation for RMAN backups
D: use the CONFIGURE command to reconfigure the recovery window to 60 days

Identify the three predefined server-generated alerts.（）
A:Drop User
B:Tablespace Space Usage
C:Resumable Session Suspended
D:Recovery Area Low On Free Space
E:SYSTEM Tablespace Size Increment

Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）
A: Create new indexes.
B: Modify existing indexes.
C: Implement partitioning on a nonpartitioned table.
D: Create materialized views.
E: All of the above

You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create？（）
A: Index cluster
B: Hash cluster
C: Sorted Hash cluster
D: Real Application Cluster

假设数据库中创建了一个用户test，状态为锁定状态，需要使用SQL语句解除锁定，可以使用如下（）语句。
A:ALTER USER test ACCOUNT
B:ALTER USER test NOLOCK
C:ALTER USER test ACCOUNT NOLOCK
D:ALTER test ACCOUNT NOLOCK

You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）
A: VERSIONS_STARTSCN
B: VERSIONS_STARTTIME
C: VERSIONS_XID
D: VERSIONS_OPERATION

You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）
A:enable index monitoring and query the DBA_OBJECTS view
B:enable index monitoring and query the DBA_INDEXES view
C:enable index monitoring and query the V$OBJECT_USAGE view
D:enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view

首页 <上一页 127 128 129 130 131 下一页> 尾页