出自:Oracle认证

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?（）
A:GRANT select ON dept TO ALL_ USER;
B:GRANT select ON dept TO ALL;
C:GRANT QUERY ON dept TO ALL_USERS
D:GRANT select ON dept TO PUBLIC;
Given: What is the result？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:[608， 610， 612， 629] [608， 610]
D:[608， 610， 612， 629] [608， 610， 629]
E:[606， 608， 610， 612， 629] [608， 610]
You are working on the Certkiller database.  What is the default name of the alert log file in this database？（）
A:alert_ Certkiller .log
B:alertlog_ Certkiller .log
C:alert_log_ Certkiller .log
D:Certkiller _alert_log.log
E:log_alert_： Certkiller .log
F:trace_alert_ Certkiller .log
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)
A:Backup compression should be enabled
B:Parallelism for the channel should be set to 2
C:All the files must be backed up as backup sets
D:The backup may be stored either on disk or on media with media manager
What is the net effect of the following command？（）   alter diskgroup dgroup1 drop disk abc；
A: The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.
B: The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.
C: The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.
D: This command will fail because you cannot drop a specific disk in an ASM disk group.
E: The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.
You need to change the text of a pop-up menu that appears when a user right clicks the mouse in the EMP_DATA data block. Where could you find the node for the pop-up menu in the Object Navigator?（）
A:Built-in Packages 
B:Menus 
C:PL/SQL Libraries 
D:Object Libraries 
E:Form Module
Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ？（）
A: If you select a non-XA JDBC driver， you can use WebLogic AQ JMS in both local & global transactions
B: Oracle WebLogic Server requires a JDBC driver to communicate with the Oracle AQ JMS
C: Oracle WebLogic AQ JMS stand-alone client automatically participate in global transactions managed by Oracle WebLogic Server
D: If you select an XA JDBC driver， you can use WebLogic AQ JMS in both local and global transactions
A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command？（）
A:It fails if any existing row violates the constraint.
B:It does not validate the existing data in the table.
C:It enables the constraint to be enforced at the end of each transaction.
D:It prevents insert， update， and delete operations on the table while the constraint is in the process of being enabled.
You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）
A:The database must be opened in restricted mode.
B:The database must be configured to run in ARCHIVELOG mode.
C:The tablespaces are required to be in backup mode before taking the backup.
D:The tablespaces are required to be in read-only mode before taking the backup
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？（）
A:Transactions are rolled back using redo log files.
B:Transactions are rolled forward using redo log files.
C:Transactions are rolled back using redo log files and archived log files.
D:Transactions are rolled forward using redo log files and rolled back using redo log files.
The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file？（）
A:The data file cannot be recovered.
B:The date file can be restored from the SYSTEM auto backup.
C:Take thetablespaceoffline，drop，kand re-create it.
D:Recovery Manager （RMAN） is used to recover the data file.
E:The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）
A:Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
B:Run the Automatic Workload Repository Monitor (ADDM).
C:Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
D:Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
在数据库中，（）使数据库程序无须对整个表进行扫描，就可以在其中找到所需数据。作为独立的结构，需要存储空间的支持。
A:视图
B:索引
C:主键
D:过程
在Oracle中，INSTEAD OF触发器主要用于（）。
A:表
B:表和视图
C:基于单个表的视图
D:基于多个表的视图
In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrees when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）
A: Export and import the mapping table.
B: Drop and re-create the mapping table.
C: Truncate the mapping table and reinsert the values.
D: Use the ALTER TABLE .. REBUILD command to defragment the mapping table.
Given： What is the result？（）
A:w-f
B:f-p w-f
C:w-f b-f
D:f-p w-f b-f
Your boss at Certkiller .com wants you to clarify Oracle 10g. What statement about the Shared Server configuration is valid？（）
A:A
B:B
C:C
D:D
You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）
A: The batch operation started by the user， SCOTT， terminates with an error.
B: The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
C: The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
D: The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
E: The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.
Examine the output of the query that you executed to list the objects in the recycle bin: You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin: SQL> PURGE TABLE sales_tab; What would be the outcome of this command?（）
A:All three tables in the recycle bin are purged
B:Only the table with the oldest DROPSCN is purged
C:The command returns an error because multiple entries with the same name exist in the recycle bin
D:Only the table with the latest DROPSCN is purged
You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?（）
A:The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.
B:The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.
C:The file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.
D:The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.
View the Exhibit and examine the characteristics of the USERS tablespace.  You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented.  Which advisory component would you refer to， in order to find information about table fragmentation？（）
A:Memory Advisor
B:Segment Advisor
C:SQL Tuning Advisor
D:SQL Access Advisor
E:Automatic Database Diagnostic Monitor （ADDM）
In your database， the Log Writer （LGWR）  process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）
A:The database instance aborts.
B:The database operation temporarily halts till the member becomes available.
C:Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
D:The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E:The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
You want to create a pie-style chart using the Chart Wizard. What must be you do to determine the fields available for use in this chart? （）
A:Select the block that contains the data to appear in the pie chart. 
B:Select the table that contains the data to appear in the pie chart. 
C:Select the view that contains the data to appear in the pie chart. 
D:Nothing. The wizard will automatically create the pie chart based on the highlighted data.
You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.  How does the loss of a redo log member affect the instance of the database that is currently running？（）
A:The instance would normally abort.
B:The instance would not be affected.
C:The instance would be invalid， so would have to be aborted.
D:The instance would remain open， but the LGWR process would fail.
E:The instance would remain open and would automatically create the missing file
Given: Which command-line invocations will compile?（）
A:javac Mule.java
B:javac -source 1.3 Mule.java
C:javac -source 1.4 Mule.java
D:javac -source 1.5 Mule.java
Which two file types must be included in a closed database backup taken with operating system commands？（）
A:data files
B:control file
C:password file
D:online redo log files
E:initialization parameter file
当误删除某数据，可以执行（）操作，恢复被删除的数据。
A:闪回查询
B:事务控制
C:子查询
D:合并查询
Youe just configured the network interface on You？e just configured the network interface on systemA and the following information is displayed pertaining to systemA’s network interface： You have been instructed to change the name of this system to systemB.  Which four files need to be modified to change the name of this system from systemA to systemB？ （）
A: /etc/nodename
B: /etc/hostname.rtls0
C: /etc/hostname
D: /etc/inet/hosts
E: /etc/domainname
F: /etc/inet/ipnodes
G: /etc/inetd.conf
Which three statements about direct path exports are true？（）
A:A
B:B
C:C
D:D
E:E
F:F
Given： 11.String test = "a1b2c3"； 12.String[] tokens = test.split（"//d"）； 13.for（String s： tokens） System.out.print（s + " "）； What is the result？（）
A:a b c
B:1 2 3
C:a1b2c3
D:a1 b2 c3
首页 <上一页 112 113 114 115 116 下一页> 尾页