出自:Oracle认证

You work as a database administrator for Supportcenter.cn. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this？（）
A:The DBMS_JOB package
B:The BACKUP_JOB package
C:The DBMS_BACKUP_RESTORE package
D:The calendar tool in the Operating System （OS）
E:The backup scheduler in Enterprise Manager （EM）
F:The DBMS_BACKUP_SCHEDULER packager inline mode
Which of the following RMAN structures can data from a datafile span？（）
A: RMAN backup-set pieces spanning backup sets
B: RMAN backup-set pieces within a given backup set
C: RMAN backups
D: RMAN channels
E: None of the above
You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non/x7fASM 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
You execute the following command to create two consumer groups， FIN_GROUP1 and PAY_GROUP1 for a plan， PROD_PLAN：  BEGIN  DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （SIMPLE_PLAN =>’prod_plan’，  CONSUMER_GROUP1 => ’fin_group1’，  GROUP1_CPU => 80，  CONSUMER_GROUP2 => ’pay_group1’，  GROUP2_CPU => 20）；  END；  Which three statements are true？ （）
A: SYS_GROUP gets 100% CPU resources at level 1.
B: FIN_GROUP1 gets 80% CPU resources at level 1.
C: FIN_GROUP1 gets 80% CPU resources at level 2.
D: PAY_GROUP1 gets 20% CPU resources at level 1.
E: PAY_GROUP1 gets 20% CPU resources at level 2.
F: OTHER_GROUP gets 100% CPU resources at level 1.
G: OTHER_GROUP gets 100% CPU resources at level 2.
写出数据库默认的两个用户的名称和密码。
Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file？（）
A:Log file
B:Discard file
C:Parameter file
D:Bad file
Oracle数据库被划分为（）的逻辑存储单元，该逻辑存储单元本身由操作系统磁盘文件和原始分区组成。
A:表空间
B:联机重做日志文件
C:归档重做日志文件
D:回滚段
Which of these appropriately describes the results of a manual SQL Tuning Advisor task？（）  
A: A list of SQL statements and recommendations for tuning
B: A list of SQL statements that have been tuned by the Advisor，with before and after metrics 
C: Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
D: All of the above
You want to check the details of few errors that users have reported. You search for the alert log fileand execute few commands to find the location of the alert log file. View the Exhibit and check the commands executed. What is the location of the alert_orcl.log file（）
A:ORACLE_HOME/dbs
B:ORACLE_HOME/rdbms
C:/u01/app/oracle/admin/orcl/adump
D:/u01/app/oracle/flash_recovery_area
E:ORACLE_BASE/diag/rdbms/orcl/orcl/alert
F:ORACLE_BASE/diag/rdbms/orcl/orcl/trace
You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）
A:run a procedure to check the tablespace space usage
B:define the warning threshold for the tablespace at 75% in Database Control
C:create a trigger to be executed when tablespace space usage reaches 75%
D:submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
E:define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
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
以下关于ORACLE的说法正确的是（）
A:ORACLE是一项数据存储技术，利用这项技术可以有效地提高磁盘的空间利用率
B:ORACLE是一家IT公司，以提供高效能的数据库硬件及配套软件产品而著称
C:ORACLE是一套数据库行业标准，所有SQL都要符合此标准
D:ORACLE是美国的一家软件公司，以提供同名的数据库产品而著称
E:以上所述都不正确
Given： What is the result？（）
A: An exception is thrown at runtime.
B: r， e， o，
C: Compilation fails.
D: r， t， t，
Which two code fragments are most likely to cause a StackOverflowError？（）
A:int []x = {1，2，3，4，5}；for（int y = 0； y < 6； y++）    System.out.println（x[y]）；
B:static int[] x = {7，6，5，4}；static { x[1] = 8；x[4] = 3； }
C:for（int y = 10； y < 10； y++）doStuff（y）；
D:void doOne（int x） { doTwo（x）； }void doTwo（int y） { doThree（y）； }void doThree（int z） { doTwo（z）； }
E:for（int x = 0； x < 1000000000； x++） doStuff（x）；
F:void counter（int i） { counter（++i）； }
取小于或等于变量V_NUM的最大整数，应该用以下哪项操作（）
A:CEIL（V_NUM）
B:FLOOR（V_NUM）
C:TRUNC（V_NUM）
D:ROUND（V_NUM）
在Oracle中，用户（）拥有所有内置的程序包。
A:SYS
B:SYSTEM
C:PUBLIC
D:DEFAULT
You are creating a sales data template and need to add a picture to the margin. What is the best way to add this margin?（）
A:Choose the margin code in the object navigator and select file->import->image. 
B:Choose the margin node in the object navigator and use the tool bar button. 
C:Click the margin button in the layout model and select file->import->image. 
D:Click the margin button in the layout model and use the tool bar button.
只能存储一个值的变量是哪种变量？（）
A:游标
B:标量变量
C:游标变量
D:记录变量
（）函数不能用于日期/时间类型。
A:MAX
B:MIN
C:COUNT
D:TO_CHAR
（）参数用于确定是否要导入整个导出文件。
A:constranints
B:tables
C:full
D:file
When exporting metadata for the transportable tablespaces， what is the correct next step after confirming endian format？（）
A: Export the tablespaces using data pump.
B: Determine if the transportable set is self-contained.
C: Convert the datafiles using RMAN.
D: Copy the datafiles from source to destination.
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）
A:Restore and recover the datafile. 
B:Restore and recover the tablespace. 
C:Restore and recover the database. 
D:Restore and recover the control file. 
E:Restore and recover the parameter file.
These are the details about V$FLASHBACK_DATABASE_STAT： SQL> DESC v$FLASHBACK_DATABASE_STAT  Name                    Null？              Type  ------------- -------- --------------  BEGIN_TIME                               DATE  END_TIME                                 DATE  FLASHBACK_DATA                        NUMBER  DB_DATA                                  NUMBER  REDO_DATA                               NUMBER  ESTIMATED_FLASHBACK_SIZE             NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue？ （）
A: BEGIN_TIME is the time at which Flashback logging is enabled.
B: END_TIME is the time at which the query is executed on the view.
C: REDO_DATA is the number of bytes of redo data written during the interval.
D: This view contains information about flashback data pertaining to the last 24 hours.
E: FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?（）
A:The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled
B:Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
C:Backup optimization is permanently disabled
D:Backup optimization is temporarily disabled because a redundancy-based retention policy is specified
If a backup is expired， which of the following is true？（）  
A: It can never be used for a restore/recover operation.
B: Oracle will remove the backup set pieces from the flash recovery area.
C: The backup has been used at least once to restore and recover the database.
D: The backup is no longer valid because of a resetlogs operation.
E: The physical backup set pieces are missing from the media.
Which statement is true about the Manageability Monitor （MMON） background proces（）
A:It transfers statistics from memory to disk at regular intervals.
B:It coordinates the rebalance activity for disk groups when ASM is used.
C:It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.
D:It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.
In which four clauses can a subquery be used? （）
A:in the INTO clause of an INSERT statement
B:in the FROM clause of a SELECT statement
C:in the GROUP BY clause of a SELECT statement
D:in the WHERE clause of a SELECT statement
E:in the SET clause of an UPDATE statement
F:in the VALUES clause of an INSERT statement
Click the Exhibit button.Given: What is the result?（）
A:Line 26 prints "a" to System.out.
B:Line 26 prints "b" to System.out.
C:An exception is thrown at line 26 at runtime.
D:Compilation of class A will fail due to an error in line 6.
Examine the data in the EMPLOYEES table: Which three subqueries work? （）
A:SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
B:SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
C:SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
D:SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
E:SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
F:SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
You work as a database administrator for Certkiller .com. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）
A:The instance would hang.
B:The instance needs to be shut down.
C:The instance would be in the open state.
D:The instance would abort in such cases.
E:The instance would be in the open and invalid state.
F:The instance would in the open state， but all the background processes will be restarted.
首页 <上一页 78 79 80 81 82 下一页> 尾页