出自:Oracle认证

Which modifier is used to change listener parameters in the Listener Control utility environment？（）
A:SET
B:ALTER
C:CHANGE
D:UPDATE
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）
A:Hot backup
B:Online backup
C:consistent backup
D:incremental backup
E:inconsistent backup
The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）.
A:user tables
B:view segment
C:table segment
D:data dictionary
E:object segment
F:performance tables
当创建了过程，可以在SQL*Plus中使用（）执行之。
A:exec函数
B:SET
C:COMMIT
D:TAKE
You work as a database administrator for Certkiller .com. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）
A:The trace file
B:The fixed views
C:The data dictionary views
D:The operating system log fields
E:The dynamic performance views.
Which two statements are true about Oracle Weblogic Clustering ？ （）
A: WLS instances must be in a Cluster for In-Memory HTTP Session Replication to function  
B: WLS supports only hardware load balancing to ensure HA access for HTTP/Web clients
C: The servers must be running on the same port number
D: Make sure your Admin Server configuration and related files reside on a HA file system or some other backup/recovery strategy is in place 
You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database：  SET UNTIL TIME = ’2000-12-09：11：44：00’；  RESTORE DATABASE； RECOVER DATABASE；  How should the commands be executed？ （）
A:Only the SET command must be within a RUN block.
B:All commands should be executed at the RMAN prompt.
C:All three commands must be within a single RUN block.
D:Only the RESTORE and RECOVER commands must be within a single RUN block.
Which two roles or privileges must you have to export tables owned by another user？（）
A:CREATE USER
B:CREATE SESSION
C:CREATE ANY TABLE
D:IMP_FULL_DATABASE
E:EXP_FULL_DATABASE
For which action can you use the TO_DATE function? （）
A:Convert any date literal to a date
B:Convert any numeric literal to a date
C:Convert any character literal to a date
D:Convert any date to a character literal
E:Format '10-JAN-99' to 'January 10 1999'
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（）
A:You obtain the results retrieved from the public synonym HR created by the database administrator.
B:You obtain the results retrieved from the HR table that belongs to your schema.
C:You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D:You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E:You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday.  How will you recover the dropped table， SCOTT.EMPLOYEE？（）
A: by using the Flashback Table feature
B: by using the Flashback Database feature
C: by performing incomplete recovery using RMAN utility
D: by performing incomplete recovery using user-managed recovery
You have applications that have frequently executed queries, and produce small and static result sets.You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter. What is the purpose of this configuration?（）
A:to avoid round trips to the server by enabling caching of query results in client memory
B:to improve performance by storing a copy of the data from the private SQL area of the PGA
C:to enhance the query performance by creating a cache in the client memory for sorting operations
D:to avoid the storing of query plans and results in the server by creating a cache in the client memory
You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format？（） 
A:to uniquely identify the archived log files with the restore operation
B:to uniquely identify the archived log files with the redo log group number
C:to uniquely identify the archived log files for each incarnation of the database
D:to uniquely identify the archived log files with the number of recovery operations performed
On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin.  Which statement is correct？（） 
A:You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
B:You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
C:You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
D:You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of  the recycle bin are purged every 12 hours by default.
You have applications that have frequently executed queries， and produce small and static result sets.  You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.  What is the purpose of this configuration？（）  
A: to avoid round trips to the server by enabling caching of query results in client memory
B: to improve performance by storing a copy of the data from the private SQL area of the PGA
C: to enhance the query performance by creating a cache in the client memory for sorting operations
D: to avoid the storing of query plans and results in the server by creating a cache in the client memory
You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session：   ALTER SESSION ENABLE RESUMABLE；   Which command could you issue to enable the resumable space allocation feature at the session level？（）  
A: ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5；
B: ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5；
C: ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300；
D: ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300；
Given： Which change can you make to Target without affecting Client？（）
A:Line 4 of class Target can be changed to return i++；
B:Line 2 of class Target can be changed to private int i = 1；
C:Line 3 of class Target can be changed to private int addOne（）{
D:Line 2 of class Target can be changed to private Integer i = 0；
When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）  
A: log_file_name_convert
B: convert_log_file_name
C: file_name_convert_log
D: redo_log_file_name_convert
E: logfile_convert_directory
You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；  What will be the result of issuing this command？（）
A: The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.
B: The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.
C: The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.
D: The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed   that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.  Identify the two events that can occur in the event of a log switch？（）  
A: An entry is created in the alert log file and the database instance continues to function normally
B: The log switch hangs occur for transactions until free space is available in the flash recovery area
C: The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
D: The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
Which two statements are true about the Application Grid ？（）
A: Application Grid computing brings key industry-leading technologies like MS IIS and Grade WebLogic Server together.
B: Application Grid computing promotes well architectured sharing of resources.
C: Application Grid computing based on Oracle’s RAC technology.
D: Application Grid computing results in more predictable behavior through better instrumentation and more optimal allocation of resources.
Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（） (Choose three.)
A:Both source and target database must be the same character set
B:Both source and target database must have the same endian format
C:The COMPATIBLE parameter must be the same in the source and target databases.
D:The minimum compatibility level for both the source and target database must be 10.0.0.
E:All read-only and offline data files that belong to the tablespace to be transported must be platform aware.
在Oracle中，一个用户拥有的所有数据库对象统称为（）。
A:数据库
B:模式
C:表空间
D:实例
The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?（）
A:A primary key must exist for creation of a clustered index
B:A clustered index allows fulltext searching within InnoDB
C:The first unique index is always used as a clustered index and not a primary key
D:A clustered index provides direct access to a page containing row data
E:If no indexes exist, a hidden clustered index is generated based on row IDs
F:A primary key is used as a clustered index
G:A clustered index is a grouping of indexes from different tables into a global index for faster searching
在PL/SQL环境中，以下说法正确的是（）
A:字符串是用单引号加以界定的
B:字符串是用双引号加以界定的
C:对于单行注释可以用双斜线//开始
D:多行注释是以大括号{}加以界定的
E:每条语句以句点。做为结束符
A WebLogic team is developing an enterprise application from their desktop WebLogic environment. All development systems are connected to the same eight data sources for testing. As a WebLogic Administrator supporting this team, which two actions should you perform to free the developers from creating and configuring all the data sources on their desktop WebLogic environment?（）
A:Provide the team with a WebLogic domain template with the testing data sources configured.
B:Provide the development team with a preconfigured domain archive file.
C:Provide the development team with the [datasource] -jdbc.xml file to overwrite their local copy.
D:Create the data sources on behalf each of the developer.
E:Provide the development team with WLST scripts to create and configure the testing data  sources.
Given: What is the result？（）
A:1 2 3
B:Compilation fails because of an error in line 12.
C:Compilation fails because of an error in line 13.
D:Compilation fails because of an error in line 14.
E:A ClassCastException is thrown at runtime.
You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?（）
A:Parallel compilation of only the stored PL/SQL code
B:Sequential recompilation of only the stored PL/SQL code
C:Parallel recompilation of any stored PL/SQL code
D:Sequential recompilation of any stored PL/SQL code
E:Parallel recompilation of Java code
F:Sequential recompilation of Java code
You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG；  Where is the information that the database is now in ARCHIVELOG mode stored？（）
A:SPFILE
B:archive log
C:control file
D:system tablespace
Which two statements are true about the Oracle Direct Network File system (DNFS)?（）
A:It utilizes the OS file system cache.
B:A traditional NFS mount is not required when using Direct NFS.
C:Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
D:Direct NFS is available only in UNIX platforms.
E:Direct NFS can load-balance I/O traffic across multiple network adapters.
首页 <上一页 139 140 141 142 143 下一页> 尾页