Oracle认证 - 自考题库

出自:Oracle认证

Which action cannot be done in a scripted, automated fashion using WLST?（）
A:collecting run-time metrics and sending an email if user-defined thresholds are exceeded
B:configuring Clusters and Managed Servers
C:starting Managed Servers using the Node Manager
D:installing WebLogic binaries on a remote machine using Node Manager
E:configuring a Managed Server on a remote machine where the Node Manager is installed but no other Managed Servers from the domain exist

Which two are true about aggregate functions?（）
A:You can use aggregate functions in any clause of a SELECT statement.
B:You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.
C:You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
D:You can pass column names, expressions, constants, or functions as parameters to an aggregate function.
E:You can use aggregate functions on a table, only by grouping the whole table as one single group.
F:You cannot group the rows of a table by more than one column while using aggregate functions.

You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here： Put the tablespaces in backup mode. Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs. Your colleague asks for you to comment on his plan. Which response would be correct？（）
A: The plan will work as is.
B: The plan needs to be modified to allow for an archive-log switch after step 3.
C: The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.
D: The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.
E: The plan cannot work as presented.

For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)
A:views
B:fixed tables
C:heap tables
D:external tables
E:temporary tables
F:index-organized tables (IOT)

You are installing Oracle Database 11g on your server. During the installation Oracle UniversalInstaller （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify anoperating system group name. Which statement is true in this case（）
A:The ORACLE_BASE parameter is not set.
B:The installation is being performed by the root user.
C:The operating system group that will be specified should have root user as its member.
D:The installation is being performed without the "Create Starter Database" option selected.
E:The operating system group that will be specified must have permission to write to the inventorydirectory.

Evaluate this SQL statement:

In the statement, which capabilities of a SELECT statement are performed?（）
A:Selection, projection, join
B:Difference, projection, join
C:Selection, intersection, join
D:Intersection, projection, join
E:Difference, projection, product

Given：

What is the result？（）
A:2.1.0
B:2.1.1
C:3.2.1
D:3.2.2

Given:

What is the result?（）
A:B
B:The code runs with no output.
C:Compilation fails because of an error in line 12.
D:Compilation fails because of an error in line 15.
E:Compilation fails because of an error in line 18.

A web browser can connect directly to an Oracle server using which two？（）
A:HTTP
B:IIOP
C:TCP/IP
D:Named Pipes
E:TCP/IP with SSL

Which two statements are true about Shared SQL Area and Private SQL Area（）
A:Shared SQL Area will be allocated in the shared pool.
B:Shared SQL Area will be allocated when a session starts.
C:Shared SQL Area will be allocated in the large pool always.
D:Private SQL Area will be allocated in the Program Global Area （PGA） always.
E:Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F:The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

Which three statements are true about persistent configuration?（） (Choose three.)
A:A user cannot set privileges on the persistent lightweight jobs
B:Persistent lightweight jobs generate a large amount of metadata
C:It is possible to create fully self-contained persistent lightweight jobs
D:The use of a template is mandatory to create persistent lightweight jobs
E:Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

You have a read/x7fonly tablespace on read/x7fonly media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read/x7fonly tablespace was read/write when the control file was backed up. What should you consider？（）
A:drop the readonly tablespace and recreate the tablespace after recovery
B:take data files from the readonly tablespace offline before performing a recovery
C:perform a recovery; status of the tablespace in control file will be changed automatically
D:recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database

You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？（）
A:This operation resets the SCN for the database.
B:This operation creates a new incarnation of the database.
C:This operation moves all the redo log files to a different location.
D:This operation deletes the old redo log files and creates new redo log files.
E:This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（）
A:SELECT COUNT (*) FROM employees WHERE last _name='smith';
B:SELECT COUNT (dept_id) FROM employees WHERE last _name='smith';
C:SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';
D:SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';
E:SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';

下列中哪个不是DML命令？（）
A:Insert
B:Create
C:Update
D:Delete

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）
A:Decreasing PCTUSED
B:Decreasing PCTFREE
C:Increasing the number of DBWN process
D:Using Automatic Segment Space Management (ASSM)
E:Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）
A:Shut down the instance， copy the control file to the third location and open the database.
B:Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.
C:Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.
D:Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.
E:Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.

Examine the following RMAN script:

Which statement describes the purpose of the script?（）
A:The data file is checked for physical corruption and backed up if found clean.
B:The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
C:The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
D:The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

Identify the memory component from which memory may be allocated for：（） 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager （RMAN） backup and restore operations
A:Large Pool
B:Redo Log Buffer
C:Database Buffer Cache
D:Program Global Area （PGA）

You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface： SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）； This command errors out displaying the following message： ERROR at line 1： ORA-29371： pending area is not active ORA-06512： at "SYS.DBMS_RMIN"， line 115 ORA-06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1 What action would you take to overcome this error？（）
A: activate the Pending Area before creating the consumer group
B: create the Pending Area before creating the consumer group
C: increase the size of the database buffer cache to accommodate the Pending Area
D: increase the size of the shared pool to accommodate the Pending Area
E: increase the size of the large pool to accommodate the Pending Area

Given：

Which two code fragments， inserted independently at line 5， will compile without warnings？（）
A:public void addStrings(List list) {
B:public void addStrings(List list) {
C:public void addStrings(List list) {
D:public void addStrings(List list) { B,C

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）
A:archival
B:log writer
C:database writer
D:system monitor
E:process monitor
F:change tracking writer

Which two commands never trigger an implicit rebalancing within the disk group?（）
A:ALTER DISKGROUP misc MOUNT;
B:ALTER DISKGROUP misc DROP DISK misc2;
C:ALTER DISKGROUP misc CHECK ALL NOREPAIR;
D:ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
E: ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）
A:To store the backup information of multiple database
B:To restrict the amount of space that is used by the backups
C:To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
D:To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

View the Exhibit exhibit1 to examine the series of SQL commands. View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS. Which statement is true if the SQL query in exhibit1 is executed again when the valueof OPTIMIZER_MODE is set to FIRST_ROWS?（）

A:The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.
B:The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.
C:The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.
D:The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.

View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener（）

A:The ORCL instance is registered dynamically with the listener.
B:The ORCL instance is registered statically in the listener.ora file.
C:The number of current client connections handled by the service handler is two.
D:The total number of client connections handled so far by the service handler is two

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）
A:ALTER TABLE students ADD PRIMARY KEY student_id;
B:ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student _ id);
C:ALTER TABLE students ADD CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);
D:ALTER TABLE students MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);

A general purpose MySQL instance is configured with the following options: —log-slow-queries —long-query-time=,0001 —log-slow-admin-queries —general-log —log-bin —binlog-format=STATEMENT —innodb-flush-log-at-trx-commit=1 Which three statements are true（）。
A:The General Query Log records more data than the Binary Log
B:The binary Log records more data than the General Query Log
C:The Slow Query Log records more data than the General Query Log
D:The General Query Log records more data than the Slow Query Log
E:The Slow Query Log records more data than the Binary Log
F:The Binary Log records more data than the Slow Query Log

Archived redo logs can be copied to more than one destination by Oracle.（）
A: True
B: False

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:

Which statement is true about the outcome?（）
A:Only one channel is allocated and the backup is created in the flash recovery area
B:Only one channel is allocated and the backup is created in the destination specified for channel
C:Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
D:Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

首页 <上一页 148 149 150 151 152 下一页> 尾页