出自:Oracle认证

All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.  SQL> DELETE FROM persons WHERE exp=’Y’； 3 rows deleted.  The SYS user opens a new session after HR executed the above commands.  Which sessions can seethe effect of the UPDATE and DELETE commands （）
A:all sessions of the HR user only
B:all sessions of the HR user and the SYS user
C:the session of the HR user that executed the commands
D:all the sessions for which the database users have access privilege to the PERSONS table
The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA，based on the amount of memory available on the system？（）
A: 20% SGA  80% PGA
B: 25% SGA  75% PGA
C: 50% SGA  50% PGA
D: 75% SGA  25% PGA
E: 80% SGA  20% PGA
Which two statements about Recovery Manager （RMAN） backups are true？ （）
A:Online redo log files can be backed up.
B:Archived redo log files are backed up.
C:Only used data blocks can be backed up as backup sets.
D:Only consistent database backups can be performed.
E:RMAN backup can be taken only if the database is configured in ARCHIVELOG mode.
Examine the statement： DROP TABLESPACE IND2  INCLUDING CONTENTS  AND DATAFILES；   What is the result of the statement？（）
A:A
B:B
C:C
D:D
You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）
A:SQL*Plus
B:iSQL*Plus
C:Management Server
D:Management Repository
E:Oracle Enterprise Manager 10g Database Control
如果经常执行类似于下面的查询语句SELECT * FROM STUDENT where substr(sname,0,2)=’陈’，应该为STUDENT表的SNAME列创建（）索引。
A:B树唯一索引
B:B树不唯一索引
C:基于函数的索引
D:位图索引
You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）
A: Rebuild the index.
B: Coalesce the index.
C: Drop and re-create the index in the new tablespace.
D: Relocate the index using the ALTER INDEX...MOVE statement.
View the Exhibit and examine the details of the EMPLOYEES table.  The query was written to format the PHONE_NUMBER for the employees.   Which option would be the correct format in the output？（）
A: xxx-xxx-xxxx
B: （xxx） xxxxxxx
C: （xxx） xxx-xxxx
D: xxx-（xxx）-xxxx
Which statement is true regarding remote archive log file destinations？（）
A:Only two destinations per remote database can be specified.
B:Destination is an Oracle Net alias specified by using the SERVICE keyword.
C:The REOPEN attribute must be used when using remote archive log file destinations.
D:The service name is resolved by searching sqlnet.ora file for the remote database name.
假设on delete cascade选项没有被定义约束，什么是潜在的外部键约束影响在delete声明？（）
A:外部键约束能防止删除行如果删除行违反外部键中定义的关系的话
B:外部键约束确保在删除行之前对数据表有正确的权限
C:如果只有一行的被删除，该外部键约束将被忽略
D:外部键对删除表述没有影响
You have included the following parameter settings in your SPFILE://    SGA_MAX_SIZE=8G   SGA_TARGET=6G   DB_CACHE_SIZE=2G   SHARED_POOL_SIZE=1G   LOG_BUFFER=64M   DB_KEEP_CACHE_SIZE=960M   Which statement is true if you modify the SGA_TARGET initialization parameter？（）
A:The SGA_TARGET initialization parameter cannot be set to a value greater than 8G
B: The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G
C: The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G
D: The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M 
E: The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M
Given： What is the result of calling search with a valid List implementation？ （）
A: 0
B: The result is undefined.
C: a
D: 2
E: 1
F: c
G: b
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? （）(Choose two.)
A:Multiple change tracking files can be created for a database.
B:The change tracking file must be created after the first level 0 backup.
C:RMAN does not support backup and recovery of the change tracking file.
D:The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
At a run time， each Oracle Weblogic Server instance in a given domain creates an in-memory representation of the configuration described in this document（）
A: mds-mbeans.xml
B: config.xml
C: policy.xml
D: data.xml
You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）
A: The command generates an error.
B: The command backs up the tablespace and creates a backup set of size 200 MB
C: The command backs up the tablespace and creates two backup sets of size 100 MB each.
D: The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.
You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）
A:grant CONNECT role to all of the three users
B:grant RESOURCE role to all of the three users
C:grant both CONNECT and RESOURCE role to all of the three users
D:execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
E:create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users
假设需要导出某个表table1，只导出表结构，不导出数据，可以使用如下（）命令。
A:EXP user/pwd tables=（name,table1）file=export.dmp Rows=y
B:EXP user1/pwd table table1 file=extable1.dmp
C:EXP user/pwd tables=（name,table1）file=export.dmp Rows=n
D:EXP user1/pwd table=table1 file=extable1.dmp Rows=n
Given a valid DateFormat object named df，and 16.Date d = new Date（0L）； 17.String ds = "December 15， 2004"； 18.//insert code here What updates d’s value with the date represented by ds？（）
A:18. d = df.parse（ds）；
B:18. d = df.getDate（ds）；
C:18. try {19. d = df.parse（ds）；20. } catch（ParseException e） { }；
D:18. try {19. d = df.getDate（ds）；20. } catch（ParseException e） { }；
Which two stand-alone products are also parts of Oracle WebLogic Enterprise Edition offering ？（）
A: Oracle WebLogic Real Time
B: Oracle Internet Application Server
C: Oracle Application Development Framework （ADF）
D: Oracle Enterprise Pack for Eclipse
Given： 22.StringBuilder sb1 = new StringBuilder（"123"）； 23.String s1 = "123"； 24.// insert code here 25.System.out.println（sb1 + " " + s1）； Which code fragment， inserted at line 24， outputs "123abc 123abc"？（）
A:sb1.append（"abc"）； s1.append（"abc"）；
B:sb1.append（"abc"）； s1.concat（"abc"）；
C:sb1.concat（"abc"）； s1.append（"abc"）；
D:sb1.concat（"abc"）； s1.concat（"abc"）；
E:sb1.append（"abc"）； s1 = s1.concat（"abc"）；
You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE 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 and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）
A: Use ROLLBACK command with SCN 663571.
B: Perform Flashback Transaction Query with SCN 663571.
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.
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language （DML） statements on the encrypted data in the tables？（）  
A: The data is decrypted during SORT and JOIN operations.
B: The data remains encrypted when it is read into memory.
C: The data remains encrypted when it is stored in the redo logs.
D: The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
Which statement creates a new user?（）
A:CREATIVE USER susan;
B:CREATIVE OR REPLACE USER susan;
C:CREATE NEW USER susan DEFAULT
D:CREATE USER susan IDENTIFIED BY blue;
E:CREATE NEW USER susan IDENTIFIED BY blue;
F:CREATE OR REPLACE USER susan IDENTIFIED BY blue;
Examine the following RMAN command：   BACKUP DATABASE TAG TESTDB  KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06；   Which two statements are true regarding the backup taken by using the above RMAN command？（）  
A: Only data files and the control file are backed up.
B: Archived redo logs are backed up only if the database is open during the backup.
C: The backup is deleted after one day，regardless of the default retention policy settings. 
D: The backup becomes obsolete after one day，regardless of the default retention policy settings.
如果一个数据库举例（instance）失败，但是没有停止运行，你必须使用哪个命令使实例恢复能被执行？（）
A:startup nomount
B:shutdown immediate;start force
C:startup mount
D:shutdown abort;startup
In which scenario will you issue the following command？（）      SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING        BACKUP CONTROLFILE；
A: when all the control files are missing and only a binary backup of the current control file exists
B: when a multiplexed copy of the current control file is missing
C:when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
D: when the SPFILE is missing
A data manipulation language statement （）.
A:completes a transaction on a table
B:modifies the structure and data in a table
C:modifies the data but not the structure of a table
D:modifies the structure but not the data of a table
I guide users through the process of creating or extending a domain for their target environment： Identify me（）
A: Pack Tool
B: Configuration Wizard
C: Auditing Provider
D: Node Manager
Which best describes an inline view?（）
A:a schema object
B:a subquery that can contain an ORDER BY clause
C:another name for a view that contains group functions
D:a subquery that is part of the FROM clause of another query
Which components are needed for successful and most efficient recovery.（）  
A: The backup RB3 and the current online redo log files
B: the backup RB2 and the archived redo log files after the log sequence number 15622
C: Backup R81 and the archived redo log hies after the log sequence number 12871
D: The backup RB3 and the archived redo log files after the log sequence number 16721
首页 <上一页 30 31 32 33 34 下一页> 尾页