出自:Oracle认证

在SQL*PLUS环境中，若想通过执行PL/SQL代码来显示指定的字符串，以下哪个方法可行（）
A:用SQL*PLUS环境支持的SHOW命令
B:用DBMS_OUTPUT包的PUT_LINE过程
C:用PRINT命令来输出指定的字符串
D:用DISPLAY命令来输出指定的字符串
E:用DBMS_OUTPUT包的NEW_LINE过程
Click the Exhibit button. What two must the programmer do to correct the compilation errors? （）
A:insert a call to this() in the Car constructor
B:insert a call to this() in the MeGo constructor
C:insert a call to super() in the MeGo constructor
D:insert a call to super(vin) in the MeGo constructor
E:change the wheelCount variable in Car to protected
F:change line 3 in the MeGo class to super.wheelCount = 3;
You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）
A:Drop the table.
B:Partition the table
C:Truncate the table.
D:Add a column to the table.
E:Rename a column in the table.
（）是驻留在客户和Oracle数据库服务器之中的软件层，它负责建立和维护客户应用和服务器之间的连接，并在它们之间进行消息传递。
A:Oracle OCI
B:Oracle瘦驱动程序
C:Oracle Net
D:侦听器
On Monday， you dropped the DEPT table from your schema and then you re/x7fcreated 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 withthe 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 want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）
A:Top SQL
B:snapshots
C:SQL Tuning sets
D:index access path
E:optimizer statistics
F:materialized view logs
What is the proper procedure to recover a lost tempfile?（）
A:Restore the backup copy of the tempfile from the backup media. 
B:Re-create the tempfile with the create tempfile command. 
C:Copy an existing tempfile from another database. 
D:Re-create the tempfile with the create tablespace command. 
E:Re-create the tempfile with the alter tablespace command.
Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?（）
A:It returns space usage of only BasicFile LOB chunks.
B:It returns space usage of only SecureFile LOB chunks.
C:It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D:It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
You work as a database administrator for Supportcenter.cn. 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
For which two situations would you use functionality provided by the Resource Manager? （）(Choose two.)
A:setting idle timeout limits on resource plans
B:saving storage space by using compressed backup sets
C:creating jobs that will run automatically at a scheduled time
D:assigning priorities to jobs to manage access to system resources
E:creating alerts to perform notification when tablespaces are low on available space resources
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）
A:No privileges.
B:Only the SELECT privilege.
C:Only the CONNECT privilege.
D:All the privileges of a default user.
In your database instance， the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users： 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be prompted to change the password at regular intervals. 3. The user may not have more than three simultaneous sessions. 4. The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above（）
A:By assigning profiles for the users
B:By implementing Fine-Grained Auditing （FGA）
C:By granting a secure application role to the users
D:By implementing the Database Resource Manager plan
在Oracle中，在SQL提示符下调用PL/SQL过程的方法是（）。
A:使用CALL语句
B:使用EXECUTE语句
C:使用RUN语句
D:直接使用过程名
In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?（）
A:Syntax when writing queries involving JOINS
B:Memory usage when working with the data 
C:Character set mapping index hash size
D:Disk usage when storing data
Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors：   ORA-00313： open failed for members of log group 1 of thread 1   ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’   You discover that the online redo log file of the current redo group is corrupted.  Which statement should you use to resolve this issue？（）
A: SQL>ALTER DATABASE DROP LOGFILE GROUP 1；
B: SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1；
C: SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；
D: SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；
User SCOTT wants to export his objects using Oracle Data Pump and executes the following command： $ expdp scott/tiger  directory = EXPORT_DIR  dumpfile = scott.dmp include = table  include = view："like ’%DEPARTMENTS%’"  content = DATA_ONLY  Which task would the command accomplish？（）
A:A
B:B
C:C
D:D
E:E
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）
A: This operation resets the SCN for the database.
B: This operation creates a new incarnation of the database.
C: This operation moves all the redo log files to a different location.
D: This operation deletes the old redo log files and creates new redo log files.
E: This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
In a new installation of Oracle Database 11g， you perform these activities：  1：Organize software and data on different subdirectories to avoid poor performance.  2：Use consistent naming conventions for database files.  3：Separate administrative information pertaining to the database in different directories.  Which option corresponds to the type of activities you performed（）
A:Oracle Managed Files
B:Oracle Grid Architecture
C:Optimal Flexible Architecture
D:Oracle database architecture
E:Automatic Storage Management
You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime recovery on the index tablespace. What could be the reason for this？（）
A:The index tablespace contains bitmap indexes.
B:The index tablespace contains more than one data file.
C:The index tablespace supports only complete recovery.
D:The index tablespace is not a dictionary­managed tablespace.
E:There is a dependency relationship between a table and its indexes.
Click the Exhibit button. What is the result？（）
A:go in Goban go in Sente go in Sente
B:go in Sente go in Sente go in Goban
C:go in Sente go in Goban go in Goban
D:go in Goban go in Goban go in Sente
You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）
A:Before parameter form. 
B:After parameter form. 
C:Before report. 
D:After report.
You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk.  -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly.  -Check that ASM metadata directories do not have unreachable allocated blocks.   Which command accomplishes these tasks（）？
A: ALTER DISKGROUP data CHECK
B: ALTER DISKGROUP data CHECK DISK
C: ALTER DISKGROUP data CHECK FILE
D: ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）
A: Heap table
B: Object table
C: External table
D: Clustered table
E: Global temporary table
F: Index-organized table （IOT）
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which DELETE statement is valid?（）
A:DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
B:DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_employees);
C:DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name ='Carrey');
D:DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_name ='Carrey');
Given： What are four valid examples of polymorphic method calls？（）
A:x.a2（）；
B:z.a2（）；
C:z.c1（）；
D:z.a1（）；
E:y.c1（）；
F:x.a1（）；
Given： Which statement is true？（）
A:Compilation succeeds.
B:Class A does not compile.
C:The method declared on line 9 cannot be modified to throw TestException.
D:TestA compiles if line 10 is enclosed in a try/catch block that catches TestException.
In Real Operations Automation， we have Domain Template and WebLogic Scripting Tool for provisioning and configuration respectively.  Which are the other two elements ？（）
A: Weblogic Cluster 
B: Weblogic Cache
C: Weblogic Grid
D: Weblogic Deployment 
在Oracle中，不属于游标属性的是（）。
A:%NOTFOUND
B:%FOUND
C:%ISCLOSE
D:%ISOPEN
Evaluate the following command and its output: Which two statements correctly interpret the output?（）
A:FREE_SPACE indicates only the space that is currently unallocated.
B:ALLOCATED_SPACE indicates only the space currently allocated and in use.
C:FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D:ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.
E:FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
Every resource plan must contain an allocation to which consumer group？（）
A: LOW_GROUP
B: SYS_GROUP
C: DEFAULT_GROUP
D: BASE_GROUP
E: OTHER_GROUPS
首页 <上一页 109 110 111 112 113 下一页> 尾页