oracle考试试题及答案(国外英语资料).doc

oracle考试试题及答案 Questions one by one, fill in the blanks (4 points per question exergy a total of 20 points) 1, database management technology has gone through three stages: manual management, file system and database system 2, database three level data structure is external mode, mode, internal model 3, the Oracle database SGA database buffer by exergy exergy exergy redo log buffer shared pool. 4, in the Oracle database integrity constraints exergy types are Primay key constraints. Foreign key Unique constraint exergy Check not need exergy exergy constraint constraint constraint Declare cursor open the cursor cursor exergy exergy exergy extraction in PL/SQL, including 5 close myCursor cursor operation Two, the true or false questions in every day 2 points 20 points total exergy rate The basic objects stored in the database is 1, the data rate in T 2, the database system is the core of DBMS in the T rate The characteristics of relationship between the 3 and the operation is set in the operating rate of T 4, five basic operations in relational algebra, and is the difference, selection, projection, connection in the F rate 5, Oracle process is the server process in the F rate 6, the oraclet system SGA process server and all users in the process of sharing rate T 7, the Oracle database system in the data block size in the T operation of the rate system 8, Oracle database system exergy start database and the first step is to start a database instance in the T rate The cursor 9, PL/SQL data can be changed in the F rate 10, the database concept model is mainly used in database conceptual structure design in the F rate Three, use the title in the match each 7 points 35 points total exergy rate Logical independence and physical independence in 1, what is the database system data in the program DBMS Provides a two layer mapping mechanism in external mode three mode structure / Schema, image, and mode / Internal schema image. The two The layer mapping mechanism guarantees the l