出自:Oracle认证

The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（）
A:An update in a leaf row takes place.
B:The index becomes invalid after the update.
C:The leaf block containing the row to be updated is marked as invalid.
D:A row in the leaf block of the index for the key value is deleted and inserted.
Which describes the default behavior when you create a table? （）
A:The table is accessible to all users.
B:Tables are created in the public schema.
C:Tables are created in your schema.
D:Tables are created in the DBA schema.
E:You must specify the schema when the table is created.
You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）
A:Create both jobs by using events raised by the scheduler
B:Create both jobs by using events raised by the application
C:Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
D:Create a job to rebuild indexes by using events arised by the Scheduler and then create another job to perform bulk load by using events raised by the application
The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）
A:SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%'ESCAPE'/';
B:SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
C:SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_'ESCAPE'/';
D:SELECT employee_id, last_name, job_id FROM employees WHERE job_id '%SA_';
假设需要回收为用户test授予的CREATE ANY TABLE系统权限，可以使用如下（）语句。
A:TAKE BACK CREATE ANY TABLE FROM test
B:REVOKE CREATE ANY TABLE FROM test
C:REVOKE CREATE ANY TABLE test
D:TAKE BACK CREATE ANY TABLE test
While working on the database， you receive the following error：        01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）
A: Block Media Recovery must be used with RMAN.
B: You must perform complete recovery of individual blocks.
C: You must have a full RMAN backup， not an incremental backup.
D: You must use the DBVERIFY utility before using the Block Media Recovery feature.
Choose the two correct statements regarding Oracle WebLogic Server（）
A: a server instance can be associated with multiple machines
B: a machine can be associated with multiple server instance 
C: a server instance can be associated with only a single machine 
D: a machine can be associated with only one server instance
You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）
A:One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
B:One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
C:Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
D:None of the tables are recovered from the Recycle Bin, and the statement returns an error.
Which two statements are true about the Automatic Diagnostic Repository （ADR）？（） 
A: The ADR base keeps all diagnostic information in binary format
B: SQL*Plus provides the ADRI script， which can be used to work with ADR
C: The ADR can be used for problem diagnosis only when the database is open
D: The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
E: The ADR can be used for problem diagnosis even when the database instance is down
F: The ADR base is shared across multiple instances
Which two are attributes of /SQL*Plus? （）
A:/SQL*Plus commands cannot be abbreviated.
B:/SQL*Plus commands are accesses from a browser.
C:/SQL*Plus commands are used to manipulate data in tables.
D:/SQL*Plus commands manipulate table definitions in the database.
E:/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
Before a Flashback Table operation，you execute the following command：   ALTER TABLE employees ENABLE ROW MOVEMENT；   Why would you need this to be executed？（）  
A: Because row IDs may change during the flashback operation
B: Because the object number changes after the flashback operation
C: Because the rows are retrieved from the recycle bin during the flashback operation
D: Because the table is moved forward and back to a temporary during the flashback opertion
当数据库运行在归档模式下时，如果发生日志切换，为了保证不覆盖旧的日志信息，系统将启动哪个进程？（）
A:DBWR
B:LGWR
C:SMON
D:ARCH
Click the Exhibit button. Given： ClassA a = new ClassA（）；a.methodA（）； What is the result？（）
A:Compilation fails.
B:ClassC is displayed.
C:The code runs with no output.
D:An exception is thrown at runtime.
Which two statements are true about encrypting RMAN backup?（） (Choose two.)
A:The transparent encryption of backups uses the encryption wallet
B:The database uses the same encryption key for every encrypted backup
C:The password encryption of backups only uses the password while creating and restoring backup
D:If transparent encryption is configured, you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups.
What should you look at first to compute the number of undo blocks written per second to disk？ （）
A:V$UNDOSTAT
B:V$TRANSACTION
C:V$ROLLSTAT
D:DBA_UNDO_EXTENTS
E:DBA_ROLLBACK_SEGS
You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged.  With reference to this scenario， up to what point in time can the data be recovered？（）
A:until Thursday morning
B:until last Sunday’s backup
C:until Wednesday evening
D:until that point in time when the database is opened
E:until that point in time when the recovery is performed
F:until that point in time when the table is dropped and purged
Which statement is true regarding the VALIDATE DATABASE command?（）
A:It checks the database for intrablock corruptions only.
B:It checks for block corruption in the valid backups of the database.
C:It checks the database for both intrablock and interblock corruptions.
D:It checks for only those corrupted blocks that are associated with data files.
EMPLOYEES and DEPARTMENTS data: EMPLOYEES DEMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_I 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Admin 20 Education 30 IT 40 Human Resources On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID. On the DEPARTMENTS table DEPARTMENT_ID is the primary key. Evaluate this UPDATE statement. UPDATE employees SET mgr_id = (SELECT mgr_id FROM employees WHERE dept_id= (SELECT department_id FROM departments WHERE department_name = 'Administration')), Salary = (SELECT salary FROM employees WHERE emp_name = 'Smith') WHERE job_id = 'IT_ADMIN'; What happens when the statement is executed?（）
A:The statement executes successfully, leaves the manager ID as the existing value, and changes the salary to 4000 for the employees with ID 103 and 105.
B:The statement executes successfully, changes the manager ID to NULL, and changes the salary to 4000 for the employees with ID 103 and 105.
C:The statement executes successfully, changes the manager ID to NULL, and changes the salary to 3000 for the employees with ID 103 and 105.
D:The statement fails because there is more than one row matching the employee name Smith.
E:The statement fails because there is more than one row matching the IT_ADMIN job ID in the EMPLOYEES table.
F:The statement fails because there is no 'Administration' department in the DEPARTMENTS table.
在CREATE DATABASE语句中，使用（）参数，可以为每个数据库指定联机重做日志文件的最大组数。
A:MAXFILES
B:MAXLOGFILE
C:MAXLOGFILES
D:LOGFILES
The record group in the EMP form is populated using a SELECT statement that is constructed programmatically at runtime. Five employee records are displayed at one time, and a user chooses item two from the record group. Which built-in would you use to determine which rows were flagged in the record group?（）
A:GET_GROUP_ROW_COUNT 
B:GET_GROUP_SELECTION_COUNT 
C:GET_GROUP_SELECTION 
D:FIND_GROUP 
E:FIND_COLUMN 
F:ADD_GROUP_ROW 
Which two functional areas does Oracle Application Grid provide ？（）
A: Processing Capacity
B: Programming IDE
C: Management network
D: Storage Capacity
What two are the prerequisites for enabling Flashback Database?（） (Choose two)
A:The database must be in ARCHIVELOG mode
B:The database must be in MOUNT EXCLUSIVE mode
C:The database must be opened in RESTRICTED mode
D:The database instance must be started in the NOMOUNT state
E:The database instance must have the keep buffer pool defined
You are having problems with connections from a specific host (192.168.1.15) not closing down correctly. You want to find the state of the threads from that host check for long-running queries. Which statement will accomplish this?（）
A:A
B:B
C:C
D:D
回滚段的PCTINCREASE参数值为下列哪一个（）
A:0
B:10
C:20
D:50
E:100
Which of the following files cannot be backed up by RMAN? （）(Choose all that apply.）
A:Database datafiles
B:Control files
C:Online redo logs
D:Database pfiles
E:Archived redo logs
如果一个进程意外终止，ORACLE使用下列哪一个后台进程来释放它所占用的资源（）
A:DBWn
B:LGWR
C:SMON
D:PMON
E:RECO
You issued the following command：   ALTER TABLE SCOTT.EMP SHRINK SPACE；   The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties：   DATA1 is a read/write tablespace.   DATA1 is not autoextensible to an unlimited size.  DATA1 is online.   Segment space management for the DATA1 tablespace is manual.   You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error：   ORA-10635： Invalid segment or tablespace type    What could be the reason for the failure of the command？（）
A: The tablespace， DATA1， is not read-only.
B: The tablespace， DATA1， is not autoextensible.
C: The tablespace， DATA1， is not offline.
D: The segment space management for the tablespace， DATA1， is manual.
Examine the following PL/SQL block：   DECLARE   my_plans pls_integer； BEGIN  my_plans ：= DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE （sql_id=> ？9twu5t2dn5xd？； END；   Which statement is true about the plan being loaded into the SQL plan baseline by the above command？（）
A: It is loaded with the FIXED status.
B: It is loaded with the ACCEPTED status.
C: It is not loaded with the ENABLED status.
D: It is not loaded with the ACCEPTED status.
Which three of the following are consirered Fixed Asset Deprecation Rule Components ？（）
A: International Deprecation Methods
B: Header
C: Annual Rules
D: Rule Conventions
E: Predefined Deprecation Methods
You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）
A:The ASM compatibility attribute controls the format of the disk group metadata.
B:RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
C:The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
D:The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
E:The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.
首页 <上一页 76 77 78 79 80 下一页> 尾页