Oracle认证 - 自考题库

出自:Oracle认证

One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）
A:LOST
B:INVALID
C:EXPIRED
D:DELETED
E:CORRUPT
F:UNKNOWN
G:OBSOLETE

如果需要同时执行多个语句，可是使用（）命令定义一组要执行的语句。
A:BAT
B:GROUP
C:RUN
D:EXECUTE

Which two statements are TRUE regarding Coherence Indexes ？（）
A: indexes are maintained by cache entry ownes
B: an application should not suggest an index that another aplication had suggested
C: indexes cannot be sorted
D: each application using Coherence may suggest the same set of indexes when it starts

Which two statements are correct regarding the Flashback Versions Query feature？（）
A: You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
B: You can use this feature to identify the versions of V$ views.
C: You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
D: You can use this feature for a table only if row movement is enabled for the table.
E: You can use this feature to identify the versions of external and fixed tables.

Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）
A:Bind Variable Peeking
B:SQL Plan Baselines
C:Adaptive Cursor Sharing
D:Bind variable used in a SQL statement
E:Literals in a SQL statement

You are granted the CREATE VIEW privilege. What does this allow you to do? （）
A:Create a table view.
B:Create a view in any schema.
C:Create a view in your schema.
D:Create a sequence view in any schema.
E:Create a view that is accessible by everyone.
F:Create a view only of it is based on tables that you created.

For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？（）
A: RMAN image copies.
B: RMAN database backups.
C: RMAN tablespace backups.
D: User-managed backups placed in the flash recovery area.
E: User-managed backups that have been cataloged with RMAN.
F: User-managed data file backups for which the pull path name is specified.

You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?（）
A:It is a list of remote database links stored in the XML file that are available to the users of the database.
B:It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.
C:It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
D:It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressedmode for an installation（）
A:Run the root.sh script.
B:Create the oraInst.loc file.
C:Create the tnsnames.ora file.
D:Run the oraintRoot.sh script.

What is true about updates through a view? （）
A:You cannot update a view with group functions.
B:When you update a view group functions are automatically computed.
C:When you update a view only the constraints on the underlying table will be in effect.
D:When you update a view the constraints on the views always override the constraints on the underlying tables.

当需要查询段的详细信息，可以使用如下（）数据字典视图。
A:DBA_SEGMENTS
B:ALL_SEGMENTS
C:USER_SEGMENTS

（）是Oracle服务器在启动期间用来标识物理文件和数据库结构的二进制文件。
A:控制文件
B:参数文件
C:数据文件
D:日志文件

On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup.Which flashback feature would you use？（）
A: Flashback Drop
B: Flashback Table
C: Flashback Database
D: Flashback Version Query
E: Flashback Transaction Query

For which two situations would you use functionality provided by the Resource Manager?（）
A:setting idle timeout limits on resource plans
B:saving storage space by using compressed backup sets
C:creating jobs that will run automatically at a scheduled time
D:assigning priorities to jobs to manage access to system resources
E:creating alerts to perform notification when tablespaces are low on available space resources

View the Exhibit to examine the parameters set for your database instance.You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:

Which statement describes the consequence?（）

A:The command produces an error.
B:The calibration process runs successfully and populates all the bind variables.
C:The calibration process runs successfully but the latency time is not computed.
D:The calibration process runs successfully but only the latency time is computed.Only users with the SYSDBA privilege can run this procedure. Qualified users must also turn on timed_statistics, and ensure asynch_io is enabled for datafiles.

View the Exhibit to examine the details for an incident. Which statement is true regarding the status of theincident（）

A:The DBA is working on the incident and prefers that the incident be kept in the ADR.
B:The incident is now in the Done state and the ADR can select the incident to be purged.
C:The incident has been newly created and is in the process of collecting diagnostic information.
D:The data collection for the incident is complete and the incident can be packaged and sent to OracleSupport

数据字典信息被存放在哪类文件中（）
A:数据文件
B:控制文件
C:重做日志文件
D:归档日志文件
E:初始化参考文件

You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）
A:DB_BLOCK_SIZE
B:CONTROL_FILES
C:LARGE_POOL_SIZE
D:LOG_ARCHIVE_DEST
E:LOG_ARCHIVE_FORMAT
F:DB_CREATE_FILE_DEST

Identify a performance impact when using the Performance Schema.（）
A:There is no impact on performance
B:The overhead depends on the settings of the Performance Schema
C:There is an overhead for querying the Performance Schema but not for having it enabled
D:There is a constant overhead regardless of settings and workload

Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）
A: Restore all the datafiles from the backup.
B: Restore only the lost datafile from the backup.
C: Restore all the datafiles for the lost tablespace from the backup.
D: Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.

View the Exhibit and examine the privileges granted to the SL_REP user.

The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr; Which statement describes the outcome of the command（）
A:The command executes successfully.
B:The command produces an error because the EMP table is owned by SCOTT.
C:The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE withoutADMIN_OPTION.
D:The command produces an error because SL_REP does not have the SELECT privilege withGRANT_OPTION on the EMP table.

Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）
A:MANAGER must be a role.
B:It allows the MANAGER to pass the specified privileges on to other users.
C:It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
D:It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
E:It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
F:It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）
A: functions
B: package
C: procedure
D: database trigger
E: anonymous PL/SQL block

Which two statements are true regarding views?（）
A:A subquery that defines a view cannot include the GROUP BY clause
B:A view that is created with the subquery having the DISTINCT keyword can be updated
C:A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated
D:A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

When defining a function activity, what is true about the Result Type?（） (Choose two.)
A:Result Type is optional.
B:Result Type is mandatory.
C:Result Type can be changed after it is assigned to the function activity.
D:Result Type should belong to the same item type as the function activity

Which three elements can a job chain process involve？（）
A: an event
B: a schedule
C: a program
D: another chain
E: a lightweight job

Note the following structures in your database server： 1.Extents 2.OS Blocks 3.Tablespace 4.Segments 5.Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest（）
A:2，5，1，4，3
B:1，2，3，4，5
C:5，2，1，3，4
D:2，1，5，4，3

Identify three valid methods of opening, pluggable databases (PDBs).（）
A:ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
B:ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdb
C:ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed
D:ALTER DATABASE PDB OPEN issued from the root
E:ALTER DATABASE OPEN issued from that pdb
F:ALTER PLUGGABLE DATABASE PDB OPEN issued from another pdb
G:ALTER PLUGGABLE DATABASE OPEN issued from that pdb

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）.
A:add data files to the tablespace
B:identify the segments that you should shrink
C:modify the storage parameters for the tablespace
D:automatically shrink the segments with unused space
E:check the alerts generated for the tablespace that is running low on space

首页 <上一页 66 67 68 69 70 下一页> 尾页