出自:Oracle认证

You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error：  ORA-01555： snapshot too old  How would you prevent such an error in the future？（）
A:guarantee undo retention
B:add one more redo log group
C:size the redo log files appropriately
D:size the UNDO tablespace appropriately
E:size the SYSTEM tablespace appropriately
F:configure an appropriate undo retention interval
G:change automatic undo management to manual
Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?（）
A:The database must be running in ARCHIVELOG mode.
B:No special setup is required, and the feature is enabled by default.
C:The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
D:The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
E:Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.
The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.  What action is required for the dependent objects when you perform online redefinition on the table？（）
A: The materialized view should have a complete refresh performed after the online table redefinition is completed.
B: The materialized view should have a fast refresh performed after the online table redefinition is completed.
C: The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.
D: The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
Given： What is the result？（）
A:three
B:other
C:An exception is thrown at runtime.
D:Compilation fails because of an error on line 12.
E:Compilation fails because of an error on line13.
Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？（）
A:current redo log and inactive redo log
B:checkpoint position to end of redo log
C:beginning of redo log to end of redo log
D:all redo logs before the point of last commit
E:beginning of redo log to checkpoint position
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task?（）
A:Enable supplemental logging for the database.
B:Specify undo retention guarantee for the database
C:Create Flashback Data Archive in the tablespace where the tables are stored.
D:Create Flashback Data Archive and enable Flashback Data Archive for specific tables
（）是为了加速对特定表数据的访问而创建的数据段。
A:视图
B:索引
C:存储过程
D:触发器
You are developing a Hotel Booking application for a travel company. The users request a wizard-style interface for this application. How could you satisfy this requirement?（）
A:Reference the Object Iron packages in your form module. 
B:Write an HTML interface, and invoke it from your form module. 
C:Include the Wizard class reusable component in your application. 
D:Build a customized wizard using tab canvases and a horizontal toolbar canvas.
The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement：       SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’；  What will be the outcome of this statement？（）  
A: The statement will deactivate DAY_PLAN.
B: The statement will activate DAY_PLAN as the top plan.
C: The statement will activate MANAGERS_PLAN as the top plan.
D: The statement will return an error because MANAGERS_PLAN is not the top plan.
Given: When the doSomething method is called, after which line does the Object created in line 5 become available for garbage collection?（）
A:Line 5
B:Line 6
C:Line 7
D:Line 8
E:Line 9
F:Line 10
建立数据库时，“专用服务器模式”和“共享服务器模式”的区别是什么？
You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）
A: Enable the flash recovery area and specify it as the archived redo log destination.
B: Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
C: Enable the flash recovery area but do not specify it as the archived redo log destination. 
D: Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）
A:The database is in mount state.
B:One of the tablespaces is offline.
C:One of the tablespaces is read only.
D:The database operates in ARCHIEVELOG mode.
E:The database operates in NOARCHIEVELOG mode.
The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege.  What would you achieve by the above process（）
A:The database user OPS$SKD will be able to administer the database.
B:The authentication detail for the database user OPS$SKD is recorded in the password file.
C:The local operating system user SKD will be able to access the database instance without specifying theusername and password.
D:The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
Given： 12.Date date = new Date（）； 13.df.setLocale（Locale.ITALY）； 14.String s = df.format（date）； The variable df is an object of type DateFormat that has been initialized in line 11. What is the result if this code is run on December 14， 2000？（）
A:The value of s is 14-dic-2000.
B:The value of s is Dec 14， 2000.
C:An exception is thrown at runtime.
D:Compilation fails because of an error in line 13.
You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）
A:Uses undo data for roll forward
B:Uses Flashback Log for recovery
C:Uses online redo logs to roll back
D:Uses undo data to roll back the transaction
E:Uses Recovery Manager （RMAN） to roll back
F:Uses the System Monitor （SMON） background process to perform instance recovery
You performed an incomplete recovery on your Oracle Database 10g database using the following command：  SQL> RECOVER DATABASE  2 UNTIL TIME ’2004/x7f08/x7f05：12：10：03’  3 USING BACKUP CONTROLFILE;  In which situation would the above recovery be required？（）
A:A user table was lost at the specified time.
B:A redo log file was lost at the specified time.
C:The backup control file is on a faster disk than the current one.
D:The current control file has a different path compared with the intended time of recovery.
E:The current control file does not match the physical structure of the database at the intended time of recovery.
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?（）
A:By default, EM express is available for a database after database creation.
B:You can use EM express to manage multiple databases running on the same server.
C:You can perform basic administrative tasks for pluggable databases by using the EM express interface.
D:You cannot start up or shut down a database Instance by using EM express.
E:You can create and configure pluggable databases by using EM express.
You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?（） (Choose two)
A:The KEEP option overrides the configured retention policy
B:The KEEP option is an attribute of an individual backup piece
C:The backup contains only data files and archived redo log files
D:The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled
Given: What is the result?（）
A:Compilation fails.
B:atom granite
C:granite granite
D:atom granite granite
E:An exception is thrown at runtime.
F:atom granite atom granite
You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）
A:a table name which has 100s of records
B:a table name which has 10s of records
C:a table name which has empty records
D:a table name which has 1000s of records
E:never use a table name
Examine the following RMAN command：   RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON； RMAN> BACKUP DATABASE PLUS ARCHIVELOG；   Which prerequisite must be met before accomplishing the backup？（）
A: Provide a password for the encryption
B: Set up an Oracle wallet for the encryption
C: No setup is required as it is a default encryption method
D: Both Oracle wallet and password must be set up for the encryption
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）
A:no privileges
B:only the SELECT privilege
C:only the CONNECT privilege
D:all the privileges of a default user
What is the maximum number of ARCn processes that can be defined using the initialization parameter LOG_ARCHIVE_MAX_PROCESSES？（）
A:1
B:5
C:10
D:15
E:Depends on system memory resources
Which of these recommendations should be followed before capturing a workload？（）
A: Make sure your replay database has the same structure as the capture database， except without data.
B: Make sure the replay and capture databases are similar in data content.
C: Perform a clean shutdown and restart of the capture database before beginning a workload capture.
D: Start the capture database in UNRESTRICTED mode， then start the capture.
E: Define inclusion and exclusion filters.
You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）  
A: RATIO
B: EMPHASIS
C: ACTIVE_SESS_POOL_MTH
D: RESOURCE_DEGREE_LIMIT_ABSOLUTE
ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.  Which is the most effectivemethod to access this data in your database（）
A:Use the database link.
B:Use the SQL*Loader utility.
C:Use the Oracle Data Pump utility.
D:Create an external table and leave the data in the flat file
使用（）命令，可以在屏幕上输出一行数据，这种输出方式，非常有组于在存储的脚本文件中向用户传递相应的信息。
A:help
B:desc
C:prompt
D:spool
94 What are three characteristics of the CALL_FORM built-in?（）
A:It is an unrestricted procedure.
B:It is valid in Enter Query mode.
C:It invokes a form in a modal window.
D:It can only invoke a form in Query Only mode.
E:It enables you to start a new database session.
F:It enables free navigation between all opened form sin an application.
在创建Oracle数据库时，会自动创建用户SYS，它的默认密码为（）。
A:CHANGE_ON_INSTALL
B:SYS
C:SYSPWD
D:123456
首页 <上一页 149 150 151 152 153 下一页> 尾页