出自:Oracle认证

()可以用于存储4Gb字节的数据。
A:Clob
B:Blob
C:Text
D:Varchar2
What is necessary for your query on an existing view to execute successfully?()
A:The underlying tables must have data.
B:You need SELECT privileges on the view.
C:The underlying tables must be in the same schema.
D:You need SELECT privileges only on the underlying tables.
Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?()  
A: Segment Advisor
B: SQL Access Advisor
C: Undo Advisor
D: SQL Tuning Advisor
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.()
A:Backup retention policy
B:Default backup device type
C:Default destinations for backups
D:Multiple backup device types for single backup
E:Default section size for backups
Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement:   ALTER TABLESPACE data1 BEGIN BACKUP;   While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?()  
A: The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
B: If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.
C: If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.
D: If you restart the database,the database will not be opened.
To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?()  
A: TRUNCATE the archive table.
B: DROP the Flashback Data Archive.
C: Nothing;expired rows are automatically removed.
D: Nothing;expired rows are moved to an archive table.
E: Delete entries from the archive where the metadata date retained is greater than the retention period.
Oracle管理数据库存储空间的最小数据存储单位是()。
A:数据块
B:表空间
C:表
D:区间
Given: When the doSomething method is called, after which line does the Object created in line 5 become available for garbage collection?()
A:Line 5
B:Line 6
C:Line 7
D:Line 8
E:Line 9
Given: What can directly access and change the value of the variable name?()
A:any class
B:only the Target class
C:any class in the test package
D:any class that extends Target
Identify two correct statements about multitenant architectures.()
A:Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
B:Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
C:Multiple CDBs share certain PDB resources.
D:Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
E:Patches are always applied at the CDB level.
F:A PDB can have a private undo tablespace.
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? ()
A:INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
B:INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
C:INSERT INTO employees VALUES ('1000','JOHN','NULL');
D:INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
E:INSERT INTO employees (employee_id) VALUES (1000);
F:INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");
下面不是常用的数据对象权限的是()。
A:DELETE
B:REVOKE
C:INSERT
D:UPDATE
Examine the description of the STUDENTS table: STD_ID NUMBER(4) COURSE_ID VARCHARD2(10) START_DATE DATE END_DATE DATE Which two aggregate functions are valid on the START_DATE column?()
A:SUM(start_date)
B:AVG(start_date)
C:COUNT(start_date)
D:AVG(start_date, end_date)
E:MIN(start_date)
F:MAXIMUM(start_date)
解析后的SQL语句在SGA的哪个区域中进行缓存?()
A:数据缓冲区
B:日志缓冲区
C:共享池
D:大池
You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users.   Which step must be performed before you can start using the resource plan?()
A:assign users to consumer groups
B:set the resource plan for the instance
C:configure a simple resource plan and specify plan directives
D:configure a complex resource plan and specify plan directives
Oracle数据库中,下面()可以作为有效的列名。
A:Column
B:123_NUM
C:NUM_#123
D:#NUM123
You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?()
A:It will create the tablespace TEMP1 in group G1
B:It will create the tablespace TEMP1 in group G3 
C:It will not add the tablespace TEMP1 to any group
D:It will create the tablespace TEMP1 in the default group
E:It will throw an error with message 'specified group is not available
F:It will create a new group with a system-generated name and add the tablespace TEMP1 to it.
Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?()
A:Selection, projection, join
B:Difference, projection, join
C:Selection, intersection, join
D:Intersection, projection, join
E:Difference, projection, product
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client  while connecting to the database instance from a remote machine()
A:host naming method
B:local naming method
C:external naming method
D:directory naming method
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid?()
A:UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
B:UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
C:UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
D:UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario?()
A:The instance aborts.
B:The database cannot be recovered.
C:The database can be recovered by restoring the control files from the backup.
D:The database remains opened and you have to shut it down with the ABORT option.
E:The database can be restored till the point of the last closed whole database backup.
In which scenario would index be most useful?()
A:The indexed column is declared as NOT NULL.
B:The indexed columns are used in the FROM clause.
C:The indexed columns are part of an expression.
D:The indexed column contains a wide range of values.
Which four steps are involved to use Active Cache Dependency Injection in a WebLogic Java EE application?()
A:Deploy Active Cache shared library
B:Declare dependency on the shared library
C:Declare all dependency injection entries
D:Package tangosol-coherence-override.xml in modules classpath
E:Package coherence-cache-config.xml in modules classpath
You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery?()
A:Change the RMAN archived log deletion policy
B:Use the RMAN CROSSCHECK command to reclaim the archived log space
C:Change the RMAN retention policy to retain backups for a shorter period of time
D:Use OS command to move files from the flash recovery area to some other location
You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use?()
A: LogMiner
B: The DBNEWID utility
C: The DBVERIFY utility
D: The ANALYZE command
E: The RMAN REPORT command
F: The RMAN CROSSCHECK command.
G: The RMAN BLOCKRECOVER command.
What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?()  
A: It improves resync operations.
B: This feature enables much faster file opens.
C: It improves performance as fewer extent pointers are needed in the shared pool.
D: It improves performance by reading from a copy of an extent closest to the node.
What view might you use to try to determine how long a particular backup will take?()  
A: V$SESSION_EVENT
B: V$SESSION
C: V$WAITS
D: V$WAITSTAT
E: V$SESSION_LONGOPS
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()
A:Compute the baseline statistics.
B:Take an immediate AWR snapshot.
C:Decrease the window size for the baseline.
D:Decrease the expiration time for the baseline.
You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database?()
A:The database would open normally.
B:The database would not open, and it would stop at mount stage.
C:The database would open after automatically performing instance recovery.
D:The database would not open, and you have to perform database recovery to open it.
Which statement correctly describes SQL and /SQL*Plus? ()
A:Both SQL and /SQL*plus allow manipulation of values in the database.
B:/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
C:/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
D:/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.