Oracle认证 - 自考题库

出自:Oracle认证

Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)
A:Creating the control file for the duplicate database
B:Restoring the target data files to the duplicate database
C:Performing complete recovery using all available backups
D:Generating a new, unique DBID for the duplicate database
E:Copying the online redo log files from the target database to the duplicate database

You discover that a disk failure occurred on DISK3 where the data file belonging to the USER_DATA tablespace is stored. The database is currently open and you need to recover the data file. You will restore the data file from the backup on DISK5 to DISK2. What is the correct sequence of commands to restore and recover the data file？（）

A:A
B:B
C:C
D:D

You issue the following code： EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP （’SCOTT’ ’GRP1’， TRUE）； What will be the result of executing the above code？（）
A: The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.
B: The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.
C: The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.
D:The code will execute successfully but no privilege will be granted to the user， Scott.

当需要返回当前用户的名字，可以执行如下（）SQL语句。
A:SELECT user FROM V$DBA
B:SELECT user FROM dual
C:SELECT name FROM dual
D:SELECT name FROM V$DBA

Which statement is true regarding subqueries?（）
A:The LIKE operator cannot be used with single-row subqueries
B:The NOT IN operator is equivalent to IS NULL with single-row subqueries
C:=ANY and =ALL operators have the same functionality in multiple-row subqueries
D:The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries

As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database. Using ASM， you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data （you do not have advanced SAN mirroring technology available to you， unfortunately）. Which of the following commands would create a disk group that would offer the maximum in data redundancy？（）

A:A
B:B
C:C
D:D
E:E

Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary Key STUDENT_NAME VARCHAR2(30) COURSE_ID VARCHAR2(10) NOT NULL MARKS NUMBER START_DATE DATE FINISH_DATE DATE You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task?（）
A:SELECT student_ id, marks, ROWNUM "Rank" FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99 AND course_id = 'INT_SQL' ORDER BY mark DESC;
B:SELECT student_id, marks, ROWID "Rank" FROM students WHERE ROWID <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY mark;
C:SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC- 99' AND course_id = 'INT_SQL' ORDER BY mark DESC;
D:SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC) WHERE ROWNUM <= 10;
E:SELECT student id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM <= 10 AND finish date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id 'INT_SQL';

emp表是雇员信息表，以下哪个变量可以存放emp表中的一条记录（）
A:v_record emp%type;
B:v_record emp%recordtype;
C:v_record emp%record_type;
D:v_record emp%rowtype;
E:v_record emp%row_type;

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?（）
A:The valid time columns employee_time_start and employee_time_end are automatically created.
B:The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
C:The valid time columns are not populated by the Oracle Server automatically.
D:The valid time columns are visible by default when the table is described.
E:Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio

Which statement is true while creating subplans using Resource Manager？（）
A: The subplan must belong to the consumer group， SYS_GROUP.
B: The total CPU usage at any given level must be less than 100%.
C: The subplans can be used to restrict the degree of parallelism for a user.
D: You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.

You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）
A:One tablespace has only one datafile
B:Many tablespaces can share one datafile
C:One tablespace can have many datafiles
D:One datafile can contain many tablespaces

The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？（）
A:set the SESSIONS to 1 in the parameter file
B:grant SINGLE SESSION privilege to all of the users
C:set the SESSIONS_PER_USER to 1 in the users’ profile
D:grant RESTRICTED SESSION privilege to all of the database users
E:create a role with SINGLE SESSION privilege and assign the role to the users

Which is the correct WebLogic Server distribution version to download if you want to install WebLogic Server 12c to run in 64 bit mode on a 64 bit Linux X86?（）
A:Linux x86 with 64 bit JVM
B:ZIP distribution for Linux
C:Linux x86 with 32 bit JVM
D:Generic distribution
E:Network installer

A customer has a critical, performance-sensitive web application that connects to a multimode Oracle RAC database. Which feature of WebLogic can provide signification benefit?（）
A:The Web Session Affinity feature of Active GridLink for RAC
B:WebLogic Clustering
C:The Transaction Affinity feature of Active GridLink for RAC
D:Coherence*Web Session Replication

You are working as a DBA in a company. The datafiles in the database are as follows：

On Monday， you tried to start up the database but failed because all the control files were missing. You recreated the control file using the script you have created by issuing the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command. What is the prerequisite for recreating the control file？（）
A: All the datafiles should be listed in the CREATE CONTROLFILE statement.
B: The DATA2.dbf and DATA3.dbf datafiles should be listed in the CREATE CONTROLFILE statement.
C: The SYSTEM01.dbf datafile should be listed in the CREATE CONTROLFILE statement.
D: The SYSAUX01.dbf datafile should be listed in the CREATE CONTROLFILE statement.

The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? （）
A:SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
B:SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
C:SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
D:SELECT student_id, gpa FROM student_grades ORDER BY gpa;
E:SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
F:SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）
A:LOG_BUFFER
B:SORT_AREA_SIZE
C:JAVA_POOL_SIZE
D:STREAMS_POOL_SIZE
E:DB_16K_CACHE_SZIE
F:DB_KEEP_CACHE_SIZE

In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）
A:using only the RMAN SWITCH command to set the new location for the data file
B:placing the database in the MOUNT state for the restore and recovery operations.
C:using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
D:configuring two channels: one for the restore operation and the other for the recovery operation

Which technology does WebLogic Server use to look up a WebLogic JMS resource?（）
A:HTTP
B:JNI
C:JNDI
D:T3
E:LDAP

Given a method that must ensure that its parameter is not null： 11. public void someMethod（Object value） { 12. // check for null value ... 20. System.out.println（value.getClass（））； 21. } What inserted at line 12， is the appropriate way to handle a null value？（）
A:assert value == null；
B:assert value != null， "value is null"；
C:if （value == null） { throw new AssertionException（"value is null"）； }
D:if （value == null） { throw new IllegalArgumentException（"value is null"）； }

From SQL*Plus, you issue this SELECT statement:

You use this statement to retrieve data from a data table for（）。
A:Updating
B:Viewing
C:Deleting
D:Inserting
E:Truncating

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）
A:Open the database in NORMAL mode
B:Open the database in read-only mode
C:Open the database in RESTRICTED mode
D:Open the database with the RESETLOGS option

Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement： SQL>ALTER TABLSPACE temp OFFLINE NORMAL； What is the result of this statement？（）
A: The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.
B: The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.
C: The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.
D: The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.

Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）
A:Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current
B:Using the statement RESET PERFORMANCE CACHE
C:Using the statement FLUSH PERFORMANCE CACHE
D:Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current
E:Disabling and re-enabling all instruments
F:Restarting Mysql

You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（） a. Shut down the database. b. Restore a control-file copy from backup media. c. Use the create control file command to create a new control file. d. Copy the backup control file into place. e. Create a new copy of the control file from one of the surviving control files. f. Recover the database using the recover database using backup control file command. g. Start up the database.
A:a， b， f， g
B:c， f， g
C:a， d， f， g
D:a， f， g
E:a， e， g

Which are the three levels at which the Segment Advisor generates advice?（）
A:block level
B:object level
C:schema level
D:segment level
E:tablespace level

You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）
A:Restore the backup control file and open the database with RESETLOGS option.
B:Perform point-in-time recovery because flashback cannot be performed again on this table
C:Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
D:Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

在PL/SQL中预定义了所要查询的数据没有找到例外，它是（）
A:NO DATA FOUND
B:DATA_NOT_FOUND
C:NO_DATA_FOUND
D:DATA_NO_FOUND

Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）
A:SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
B:SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
C:SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
D:SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
E:SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;

You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： $ rman target / What would be the effect of this command？（）
A:RMAN would use the current operating system location to place the backup.
B:RMAN would use the control file of the target database to maintain the backup.
C:RMAN would use the recovery catalog of the target database to maintain the backup.
D:RMAN would use the control file of the target database to maintain the backup metadata.
E:RMAN would use the recovery catalog of the target database to maintain the backup metadata.

首页 <上一页 113 114 115 116 117 下一页> 尾页