出自:Oracle认证

Given that the current directory is empty， and that the user has read and write privileges to the currentdirectory， and the following： Which statement is true？（）
A:Compilation fails.
B:Nothing is added to the file system.
C:Only a new file is created on the file system.
D:Only a new directory is created on the file system.
E:Both a new file and a new directory are created on the file system.
Which two statements about Automatic Storage Management （ASM） are true？（）
A:ASM provides mirroring on file by file basis.
B:ASM provides automatic load balancing across all ASM disks.
C:ASM supports the Oracle database and operating system files.
D:ASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?（）
A:SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;
B:SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
C:SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;
D:SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;
E:SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
Given two different character sets （A and B）， which of the following must be true for A to be considered a strict superset of B？（）
A: A must contain all of the characters defined in B
B: A must be Unicode
C: The encoded values in A must match the encoded values in B for all characters defined in B 
D: A must be a multibyte character set
E: The encoded values in A must match the encoded values in B for all numeric and alphabetic character
You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb  Which three statements are correct regarding the connection string？（）
A:mydb is a service name.
B:test.us.oracle.com is a database name.
C:1521 is the listener port number.
D:mydb is a host name.
E:test.us.oracle.com is a net service name.
F:hr is a username.
G:test.us.oracle.com is an instance name.
You are operating your database in the manual archiving mode. Currently， your database is configured with the following online redo log groups and members：    You tried to drop Group 1 from the database but received the following errors：        ORA-01623： log 1 is current log for thread 1 cannot drop        ORA-00312： online log 1 thread 1：   ’D:///ORACLE/ORADATA/TESTDB/REDO01a.LOG’   What might be the reason for these errors？（）  
A: Group 1 is an active or current online redo log group.
B: Group 1 is an inactive online redo group that has not been archived yet.
C: The members of the Group 1 are temporarily asymmetric with the members of other groups.
D: The size of the online redo log members of Group 1 is different from the size of the members in other groups.
对于ORACLE PL/SQL标识符（Identifier）的有效长度是（）
A:16位
B:18位
C:24位
D:30位
E:32位
In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；
A: to configure RMAN to maintain backup information in the RMAN repository for seven days
B: to configure RMAN to maintain backup information in the control file for at least seven days
C: to display the list of files that have not been backed up for the last seven days
D: to display the list of files that must be backed up within seven days
查询出当前的数据库系统时间，精确到秒（）
A:select to_date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
B:select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
C:select date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
D:select chr(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
Hibernate的二级缓存是由（）维护的。
A:SessionFactory实例
B:Session实例
C:Query接口实例
D:Configuration实例
A bitmap join index is defined as（）.
A:An index used to join two bitmap indexes on a table.
B:A bitmap index created for the join of two or more tables.
C:A bitmap index created on the join of two or more indexes.
D:A bitmap index created on the join of two or more indexed-organized tables.
In which scenario will you use the Flashback Transaction Query feature？（）
A: when you want to restore an important table that is dropped from the Recycle Bin
B: when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
C:when you want to restore a dropped user’s schema
D: when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？ （）
A:increase the size of the redo log buffer
B:increase the number of redo log groups
C:increase the number of log writer processes
D:increase the number of ARCn processes
E:change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
Which two statements are true regarding the SQL Repair Advisor?（）
A:The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
B:The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
C:The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
D:The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
对于以下SQL语句说法正确的是（） SELECT ename FROM emp WHERE sal IN (SELECT MAX(sal) FROM emp GROUP BY deptno);
A:这个语句是符合语法的
B:这个语句是不能执行的,因为缺少HAVING子句
C:这个语句是不能执行的,因为分组的条件列不在SELECT列表中
D:这个语句是不能执行的,因为GROUP BY子句应该在主查询中,而不是在子查询中
E:在主查询的WHERE条件中,不应该用IN,而应该用等号
（）是有自己的系统全局区和与其相关数据库文件的Oracle服务器进程集，都要用称为SID（SystemIdentifier，系统标识符）的标识符来标识。
A:Oracle数据库
B:Oracle进程
C:Oracle实例
D:Oracle服务
You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）
A:They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
B:They are created only in the Fast Recovery Area.
C:They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
D:They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.
Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（） 
A: Generate reports on data failure such as data file failures.
B: You can track the Service Request （SR） and implement repairs.
C: You can package and upload diagnostic data to Oracle Support.
D: You can manually run health checks to gather diagnostic data for a problem.
With regard to the drivers behind Application Grid based computing， consider the following statements and indicate which is TRUE:// （）  I. data center complexity leads to lack of predictability making it difficult if not impossible to guarantee quality of service  II. data centers must do more with less and find a way to better utilize existing capacity  III. growth means added complexity
A: I and II
B: I and III
C: II and III
D: I， II and III
You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）
A:Increase the value of table_definition_cache
B:Increase the value of table_open_cache_instances
C:Decrease the value of table_open_cache_instances
D:Increase the value of table_open_cache
E:Decrease the value of table_definition_cache
F:Decrease the value of table_open_cache
在PL/SQL中用以下哪个运算符或函数，可以将两个字符串连接起来（）
A:strcat
B:+
C:∣∣
D:stradd
E:connect
You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）
A:Mount the database
B:Open the database in NORMAL mode
C:Open the database in RESTRICTED mode
D:Open the database with the RESETLOGS option
The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）
A:REF cursor. 
B:Instead Of trigger. 
C:Stored procedure that returns object values. 
D:The underlying view cannot be modified because DML on a view is not supported.
View the Exhibit and examine the output of the query.  What do you infer from this（）
A:The SGA_TARGET is a static parameter.
B:The instance is started， but the database is not yet open.
C:The server parameter file （SPFILE） was used to start the instance.
D:The SGA_TARGET parameter does not have any effect on the database instance until theSGA_MAX_SIZE parameter is specified
On which three can you use Recovery Manager （RMAN） to perform incremental backup？（）
A:data files
B:control files
C:tablespaces
D:password file
E:parameter file
F:whole database
G:flashback log file
H:archived log files
I:change tracking file
以下哪类表空间中不能建立数据对象（表，索引）（）
A:SYSTEM表空间和非SYSTEM表空间
B:UNDO表空间和Temporary表空间
C:SYSTEM表空间和Temporary表空间
D:SYSTEM表空间和UNDO表空间
E:SYSTEM表空间，UNDO表空间和Temporary表空间
You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）
A:RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE
B:RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE
C:RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE 
D:RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE
Which statements are true regarding system-partitioned tables?（）
A:Only a single partitioning key column can be specified.
B:All DML statements must use partition-extended syntax.
C:The same physical attributes must be specified for each partition.
D:Unique local indexes cannot be created on a system-partitioned table.
E:Traditional partition pruning and partitionwise joins are not supported on these tables.
You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， SupportCenter， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）
A:Use a flashback query to retrieve the rows that were deleted
B:Useconventialincremental export and then import the affected object
C:Shutdown the database inNORMALmode and restart the database instance
D:Use DBMS_META package to reconstruct the object using undo segments
E:UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data
F:Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
Examine the following steps performed on a database instance：  1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2：The SKD usercreates a table.  3：The SKD user grants theCREATETABLE system privilege to the HR user.  4：The HR user creates a table.  5：The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed（）
A:The table created by SKD isnot accessibleand SKD cannot create new tables.
B:The tables created by SKD and HR remain， but both cannot create new tables.
C:The table created by HR remains and HR still has the CREATE TABLE system privilege.
D:The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
首页 <上一页 118 119 120 121 122 下一页> 尾页