出自:Oracle认证

下列哪个子句实现对一个结果集进行分组和汇总？（）
A:HAVING
B:ORDER BY
C:WHERE
D:GROUP BY
对于主键的说法错误的是（）。
A:主键字段输入的数据不允许重复
B:主键字段的数据，允许输入空值
C:若主键由多个键组合而成，则某个主键字段可能存在重复值
D:主键字段可以是字符数据类型
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）
A: You must enable the block change tracking feature.
B: You must have enable the flashback feature.
C: You must use the OMF in your database.
D: You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）
A:A syntax error will result as you cannot specify more than one partition in the same statement
B:All data in p1 and p3 partitions are removed and the table definition is changed
C:All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D:Only the first partition (p1) will be dropped as only one can be dropped at any time
Given: What is the result when the programmer attempts to compile the code and run it with the command java Converter 12?（）
A:It is true that j==i.
B:It is false that j==i.
C:An exception is thrown at runtime.
D:Compilation fails because of an error in line 13.
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management （ASM） instance.   SQL> STARTUP；   Which two activities are performed during a successful start up operation？（） 
A: The databases configured to use the ASM instance are mounted
B: The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
C: ASM starts the Oracle Cluster Synchronization Services （CSS） daemon if it is not started 
D: ASM discovers and examines the contents of all files that are in the paths specified in the  ASM_DISKGROUPS initialization parameters
You issue this SQL command to perform an online backup of the USER_DATA tablespace：ALTER TABLESPACE user_data BEGIN BACKUP；Next， you issue an operating system command to back up user_data01.dbf， the file that belongs to the USER_DATA tablespace. You then experience an instance failure.  Which three statements are true？（）
A:A
B:B
C:C
D:D
E:E
You recently added a third-party application to your database and do not have access to the SQL code of this application. Database users are complaining of performance-related issues， such as increased time required to complete a query. While investigating， you discover from the STATSPACK utility that some of the memory structures have low hit ratios. You plan to resize some of the memory structures by using the Memory Advisor. For which memory structure will you fail to obtain optimal settings by using the Memory Advisor？（）   
A: java pool
B: shared pool
C: buffer cache
D: program global area
Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs？（）  
A: It cannot be done in parallel.
B: It can be done at the table level or partition level.
C: It does not require additional storage because the operation is done online.
D: Local and global indexes are maintained automatically during the operation.
What is true regarding subqueries?（）
A:The inner query always sorts the results of the outer query.
B:The outer query always sorts the results of the inner query.
C:The outer query must return a value to the inner query.
D:The inner query returns a value to the outer query.
E:The inner query must always return a value or the outer query will give an error.
The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine.  What kind of information is stored is stored in this file？（）
A:OracleSIDsonly
B:Oracle homes only
C:Oracle install timestamp
D:Oracle inventory pointer files
E:Oracle database creation timestamp
F:OracleSIDsand Oracle homes only
G:OracleSIDs， Oracle homes and flag for auto startup
A corrupted file system is now repaired and back in use. Some， but not all of the files within the file  systems have been deleted. The only backup of this file system is a month-old tar archive. This archive will need to be restored as root.  Which two statements correctly describe the effects of the restore operation？（）
A: Files found in the file system that are also on tape will NOT be overwritten.
B: The missing files， present on the backup tape， are restored to the file system with the data as it was when the backup was taken.
C: The access times are preserved by tar and will reflect the time when a user last accessed the data.
D: The modification time on the files restored by tar will be preserved and will reflect the time the file was last modified before the backup， NOT the time of the restore operation.
Click the Exhibit button. Which three statements are true?（）
A:Compilation fails.
B:The code compiles and the output is 2.
C:If lines 16, 17 and 18 were removed, compilation would fail.
D:If lines 24, 25 and 26 were removed, compilation would fail.
E:If lines 16, 17 and 18 were removed, the code would compile and the output would be 2.
F:If lines 24, 25 and 26 were removed, the code would compile and the output would be 1.
假定表A中有十万条记录，要删除表中的所有数据，但仍要保留表的结构，请问用以下哪个命令效率最高（）
A:delete from a;
B:drop table a;
C:trunc table a;
D:truncate table a;
E:以上所述都不正确
You observed the following output for a user session: What do you infer from the preceding output?（）
A:Resumable set for session with sid 18
B:The user session has entered into a deadlock
C:The database instance is enabled to use asynchronous commit
D:The threshold warning limit is exceeded for the tablespace that is used by the user session
You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page？（）
A: Advisor Central
B: Global Attributes
C: Resource Monitors
D: Memory Parameters
E: Database Usage Statistics
F: All Initialization Parameters
G: Automatic Workload Repository
You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）
A: RESETLOGS
B: TO TIMESTAMP
C: TO BEFORE DROP
D: RENAME TO
E: TO SCN
下列选项中，属于系统全局区（SGA）的是（）。
A:数据缓冲区
B:重做日志缓冲区
C:SQL共享池
D:数据连接池
Given: What is the result?（）
A:test
B:Exception
C:Compilation fails.
D:NullPointerException
Which are DML statements?（）
A:COMMIT
B:MERGE
C:UPDATE
D:DELETE
E:CREATE
F:DROP...
You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）
A: MOUNT mode
B: RESTRICTED mode
C: OPEN mode
D: NOMOUNT mode
In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?（）
A:Setting a metric threshold
B:Implementing Database Resource Manager
C:Enabling resumable timeout for user sessions
D:Decreasing the value of the IDLE_TIME resource limit in the default profile
Which three statements are true regarding the fine-grained auditing （FGA）？（）
A:FGA is possible on SELECT statements only.
B:The audit trail for FGA is stored in the FGA_LOG$ table.
C:The audit trail for FGA is stored in the AUD_LOG$ table.
D:FGA enables a SQL predicate to define when to audit an event.
E:FGA audits DELETE statements only when audit columns are specified.
F:FGA includes the SQL statement used by the user as part of the audit event entry.
You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？（）
A:SQL script
B:PL/SQL script
C:Operating System （OS） script
D:Enterprise Manager （EM） script
E:Recovery Manager （RMAN） script
ou 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 specie 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.
Examine the structures of the EMPLOYEES and TAX tables. You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
A:SELECT employee_id, salary, tax_percent   FROM employees e, tax t   WHERE e.salary BETWEEN t.min_salary AND t.max_salary;
B:SELECT employee_id, salary, tax_percent   FROM employees e, tax t   WHERE e.salary > t.min_salary, tax_percent
C:SELECT employee_id, salary, tax_percent   FROM employees e, tax t   WHERE MIN(e.salary) = t.min_salary   AND MAX(e.salary) = t.max_salary
D:You cannot find the information because there is no common column between the two tables.
You discover that your Recycle Bin contains two tables with the same name， MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement：   FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2；   What will be the result of executing this statement？（）
A: One of the tables is recovered from the Recycle Bin using a First In First Out （FIFO） approach.
B: One of the tables is recovered from the Recycle Bin using a Last In First Out （LIFO） approach.
C: Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
D: None of the tables are recovered from the Recycle Bin， and the statement returns an error.
Given: Which three are true?（）
A:Cat is-a Animal
B:Cat is-a Jumper
C:Dog is-a Animal
D:Dog is-a Jumper
E:Cat has-a Animal
F:Beagle has-a Tail
G:Beagle has-a Jumper
You executed this command to create a temporary table：  SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddate DATE， class CHAR（20））ON COMMIT PRESERVE ROWS；  Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction （）
A:The rows stay in the table only until session termination.
B:The rows stay in the table only until the next transaction starts on the table.
C:The rows are visible to all current sessions after the transaction is committed.
D:The rows stay available for subsequent sessions after the transaction is committed
（）存储了系统表和数据字典。
A:系统表空间
B:字典表空间
C:用户表空间
D:临时表空间
首页 <上一页 122 123 124 125 126 下一页> 尾页