SQL TEST

xanada (㊣流水)
本文发表在 rolia.net/zh 相约加拿大网上社区枫下论坛
1. Which cursor attribute indicates whether the latest read of an explicit cursor has returned results?
A. cursor_name%FOUND
B. SQL%FOUND
C. SQL%ROWCOUNT
D. cursor_name%ROWCOUNT

2. When is the following trigger executed?
CREATE TRIGGER student_trig
AFTER DELETE ON student
BEGIN
null;
END;
A. After each row of the DELETE statement is affected
B. Before each row of the DELETE statement is affected
C. Once after the DELETE statement affects the database
D. Once before the DELETE statement affects the database

3. Which predefined exception is raised when a SELECT INTO returns zero rows?
A. NOT_FOUND
B. %NOTFOUND
C. NO_DATA_FOUND
D. TOO_MANY_ROWS

4. EXCEPTION_INIT:
A. Is used to initialize a predefined exception
B. Is used to associate an exception with an Oracle error
C. Is used to display an exception message
D. Is used to terminate PL/SQL processing base on an exception

5. Which of the following exceptions will be raised when an UPDATE statement causes no rows to be updated?
A. NO_DATA_FOUND
B. TOO_MANY_ROWS
C. No exception is raised
D. VALUE_ERROR

6. The PCTFREE parameter is:
A. Used to allocate storage space for the block header
B. Used to reserve space to be used for updates to existing rows in the block
C. The portion of a block reserved for transaction information
D. Used to reserve space in the block for insertion of new rows

7. The ALL-level data dictionary views contain:
A. Information about all objects in the database
B. Information about all objects owned by a user
C. Information about all objects to which a user has access
D. Information about all objects in the instance

8. To load data using SQL*Loader while the table(s) being loaded are available for other user access, use the ________ load method.
A. Direct path
B. Choose path
C. Conventional path
D. Append path

9. An Oracle-provided utility to read and write operating-system files is:
A. UTL_FILE
B. DBMS_JOB
C. DBMS_OUTPUT
D. UTL_PIPE

10. The command SET TRANSACTION READ ONLY:
A. Provides a consistent view of the data for a transaction
B. Allows the use of UPDATE and/or INSERT
C. Locks a table for read access
D. Locks records of a table for read access

11. EXPLAIN PLAN is used to:
A. View runtime errors of a SQL statement
B. View compile errors of a SQL statement
C. View access paths of a SQL statement
D. View performance statistics of a SQL statement

12. There is an index on student_name column, when will it be used
A. Student_name like ‘VAN%’
B. Student_name like ‘%VAN’
C. rtrim(student_name) = ‘VAN’
D. All of the above

13. There is an index on terminate_date column, when will it be used
A. Terminate_date is not null
B. To_char(terminate_date,’dd-mon-yyyy’) = ‘01-jan-2000’
C. Terminate_date = to_date(‘01-jan-2000’, ’dd-mon-yyyy’)
D. All of the above

14. Which statement is true regarding the use of indexes?
A. An index is always more efficient than a full-table scan
B. A full-table scan may be more efficient than an index
C. There a maximum number of indexes allowed on a single table
D. An optimizer can use more than one index to access a table

15. What is a common usage of the TKPROF utility?
A. To analyze the execution plan of a single SQL statement
B. To analyze the execution of all SQL statements in a database session
C. To analyze the execution of all SQL statements in all database instances running on the same server
D. None of the above

16. Rollback segments should be:
A. Most are small, one or two large ones only if there are big transactions
B. Small, so that all rollback segment can fit in memory
C. Large, so that large transactions can fit in an existing rollback segment
D. Not important, because rollback segments are automatically shrunk

17. The smallest level of storage granularity in an Oracle database is a(n):
A. Segment
B. Extent
C. Tablespace
D. Block

18. To determine whether a table is chained, use:
A. ANALYZE TABLE command
B. COMPUTE STATISTICS command
C. SELECT FROM user_segments
D. TKPROF utility

19. ARCHIVELOG mode allows:
A. All committed data to be recovered
B. Recovery up to the time of the last backup
C. All committed and uncommitted data can be recovered
D. Recovery up to the time of the last incremental export

20. The System Global Area consists of which three primary memory structures?
A. Database buffer cache, redo log, user work area
B. Shared SQL area, database buffer cache, redo log buffer
C. Database buffer cache, system monitor, redo log
D. System monitor, redo log buffer, shared SQL area
更多精彩文章及讨论,请光临枫下论坛. 网址: rolia.net/zh
(#276057@0)
2001-11-26 -05:00

回到话题: SQL TEST

回到论坛: HOME枫下论坛枫下论坛主坛加国之约移民留学申请

URL:   
http://www.rolia.net/zh/post.php?f=0&p=276057