出自:Oracle认证

简述Oracle数据库角色的种类、作用，以及如何利用角色为用户授权。
While creating a scheduler window using the DBMS_SCHEDULER package， a user logged in as DBMGR gets the error message insufficient privileges.  Which two commands would you use to resolve this error？（）
A:GRANT dba TO dbmgr;
B:GRANT connect TO dbmgr;
C:GRANT resource TO dbmgr;
D:GRANT hs_admin_role TO dbmgr;
E:GRANT manage scheduler TO dbmgr;
In your database， the users SYS and SYSTEM have been assigned the profiles， ADMIN_PROF1 and ADMIN_PROF2， respectively. The rest of the database administrators are assigned the profile ADMIN_PROF3.  You create a profile， USER_PROF， and assign it to the application user， Adams. After a week you realize that the profile is no longer required and you decide to drop it.  What will Adam’s profile be after the USER_PROF profile has been dropped？（）
A:no profiles
B:the default profile
C:same as the profile of SYS user
D:same as the profile of SYSTEM user
Which two code fragments are most likely to cause a StackOverflowError?（）
A:
B:
C:
D:
E:
F:
Which two statements about sequences are true? （）
A:You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
B:You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
C:You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
D:You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
E:If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
F:You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
下列哪一项是Oracle数据库中最小的存储分配单元？（）
A:表空间
B:段
C:盘区
D:数据块
You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）
A:Image of the control file
B:Location of the control file
C:Contents of the control file in text format
D:SQL command to re-create the database
E:SQL command to re-create the control file
F:Contents of the control file in binary format
An RMAN backup job fails， displaying the following error message：  ORA/x7f19809： limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full. What would you do to resolve the error？（）
A:increase the value of UNDO_RETENTION
B:change the value of WORKAREA_SIZE_POLICY to AUTO
C:increase the value of DB_RECOVERY_FILE_DEST_SIZE
D:increase the value of CONTROL_FILE_RECORD_KEEP_TIME
Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined？（）
A:TARGET_REDO_BLKS
B:FAST_START_IO_TARGET
C:LOG_CHECKPOINT_TIMEOUT
D:RECOVERY_ESTIMATED_IOS
E:LOG_FILE_SIZE_REDO_BLKS
F:LOG_CHECKPOINT_INTERVAL
使用（）命令，可以获得有关SQL*Plus的环境设置、创建PL/SQL代码的错误消息和init.ora参数等。
A:help
B:show
C:prompt
D:spool
You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（）  
A: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；
B: ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；
C: ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；
D: ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；
Which of the following are valid program types for a lightweight job？（）
A: PLSQL_BLOCK
B: EXECUTABLE
C: JAVA_STORED_PROCEDURE
D: STORED_PROCEDURE
E: EXTERNAL
When you are allowing RMAN to backup your archived redo log files，how does RMAN know which archived redo logs to back up from your archive log destination？（）
A:RMAN keeps a list of archive logs in a text file.
B:The DBA must manually tell RMAN which archive logs to backup.
C:RMAN has access to target control file and/or catalog information.
D:RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.
In the absence of shared storage between cluster nodes, which two actions can you take to configure a High Availability architecture?（）
A:Move domain logs to a highly available database.
B:Move server logs to a highly available database.
C:Move transaction logs to a highly available database. 
D:Move JMS persistent stores to a highly available database.
E:Move error logs to a highly available database.
Examine the following ALTER command：   SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS；   What is the purpose of the command？（）  
A: It cancels all pending disk drops within the disk group.
B: It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C: It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D: It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E: It adds previously dropped disks back into the disk group
在恢复操作中，使用的最重要的结构是（），包括两个或者更多预先分配好的文件，存储了对数据库所做的修改。
A:联机重做日志文件
B:归档日志文件
C:归档数据文件
D:联机数据文件
The following databases are registered in the base recovery catalog： PROD1， PROD2， and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this：   1.SQL> GRANT recovery_catalog_owner TO vpc1； 2.RMAN> CONNECT CATALOG vpc1/password@catdb；  3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1； 4.RMAN> CONNECT CATALOG catowner/password@catdb；  5.RMAN> CREATE VIRTUAL CATALOG；   What is the correct sequence in which the commands have to be executed？（）  
A: 1，4，5，2，3
B: 1，4，3，2，5
C: 4，5，2，3，1
D: 2，3，4，5，1
E: 1，4，2，3，5
You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?（）
A:Shell＞ mysqladmin –u root –p shutdown
B:Shell＞ nmc mysql shutdown
C:Mysql＞ STOP PROCESS mysqld
D:Shell＞ /etc/init.d/mysql stop
E:Shell＞ service mysql safe_exit
F:Shell＞ pkill –u mysql mysqld_safe
G:Shell＞ net stop mysql
Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database？ （）
A:SYNC or ASYNC to identify the network transmission mode. 
B:LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby. 
C:AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously. 
D:PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.
Given the script   create script db_backup_datafile_script  {backup datafile and 1， and2 plus archivelog delete input；} Run {execute script db_backup_datafile_script using 2；}   What is the result of running this command？（）  
A: The script will fail since you instructed RMAN to back up only one datafile rather than two
B: The script will successfully back up datafile 3 without error
C: The script will fail since it uses a substitution variable which is not supported
D: The execute script command will prompt for the value of and2 since it’s not included in the command
E: The script will fail because you cannot use the plus archivelog command when backing up
Which of the following is not a valid linguistic sort element？（）
A: Accent expansion
B: Canonical equivalence
C: Reverse secondary sorting
D: Ignorable characters
E: Character rearrangement
当创建列表分区时，必须指定（）。
A:分区方法：列表
B:分区列
C:分区描述
D:列表分区的多个列值
You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager（RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）
A:RMAN would relocate all the database files to an ASM disk group.
B:RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
C:RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
D:RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
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
Given: Which code fragment, inserted at line 24, outputs "123abc 123abc"?（）
A:sb1.append("abc"); s1.append("abc");
B:sb1.append("abc"); s1.concat("abc");
C:sb1.concat("abc"); s1.append("abc");
D:sb1.concat("abc"); s1.concat("abc");
E:sb1.append("abc"); s1 = s1.concat("abc");
F:sb1.concat("abc"); s1 = s1.concat("abc");
G:sb1.append("abc"); s1 = s1 + s1.concat("abc");
H:sb1.concat("abc"); s1 = s1 + s1.concat("abc");
The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（） 
A: The database will hang.
B: The database will be crashed.
C: The database will be shut down.
D: The LGWR process writes redo log entries to the other redo log member of the Group2 group
Name three attributes used to configure a multi-data source in Oracle WebLogic （）
A: Statement Cache Type
B: Logging Last Resource
C: Algorithm Type
D: Failover Request if Busy
E: JNDI Name
You issued the following command：   CREATE GLOBAL TEMPORARY TABLE admin_work_area   （startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1；   An index is then created on the ADMIN_WORK_AREA temporary table.  Which two statements are true regarding the TBS_T1 tablespace in the above command？（） 
A: It stores only the temporary table but not its indexes.
B: It stores both the temporary table as well as its indexes.
C: It must be a nondefault temporary tablespace for the database.
D: It can be a default or nondefault temporary tablespace for the database.
E: It must be the default temporary tablespace of the user who issues the command.
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）
A:You find that one of the redo log members in each redo log group is lost.
B:You find that a data file that belongs to the USERS tablespace is damaged.
C:You find that a data file that belongs to the SYSTEM tablespace is damaged.
D:You find that the current redo log group is damaged and is not available for recovery.
E:You realized while performing a recovery that an archived redo log file needed for recovery is lost.
以下关于NET8的叙述正确的是（）
A:NET8是ORACLE网络客户端程序的集合
B:NET8是ORACLE网络服务器端程序的集合
C:NET8是ORACLE对TCP/IP等网络协议的改进
D:NET8是在TCP/IP等网络协议间进行数据格式转换
E:以上所述都不正确
首页 <上一页 37 38 39 40 41 下一页> 尾页