Oracle试卷及答案（国外英文资料）.doc

Oracle试卷及答案（国外英文资料） Oracle test paper and answer Choice question The section is a logical storage structure in the table space, and the following (D) is not the type of segment used by the ORACLE database. (A) the section (C) of the index segment (B) is A segment (D) The ORACLE database physical structure includes the following three files, and the following is not (A) (A) system file (B) log file (C) data file (D) control file Multiple service software can be installed on a physical server that makes up multiple servers in logic. To distinguish these different logical servers, use the concept called (B). (A) slice (B) port (C) range (D) block The following is true (B) (A) 2006-05-01 is less than 2006-04-31 (B) 1234 is greater than 123_ (C) beauty is greater than rice (D) 2e - 3 is less than -2e3 The following operations are not null (C) (A) 12 + NULL (B) 60 * NULL (C) NULL (D) 12 / (60 + NULL) The sequence S1 has been created, and if the current value is 2, it executes three times S1. CURRVAL, three times S1. NEXTVAL, and the last value of S1 is (C). (A) 3 (B) 4 (C) 5 (D) 6 7, the database has two user Scott and muuser, supplies table wz belongs to myuser users, but the current user is Scott, ask for material table wz (wno, wname wtype, wunit) supplies unit wunit as a record of null, and get the result before 5 records, according to the following the correct SQL statement is (C) (A) select * from Scott. (B) select * from myuser.wz where wz. (C) select * from myuser.wz where wz is null and rownum 6. (D) select * form Scott. If the current date is 25 - may -06, the following (D) expression can calculate the date of the last day of the month of the month after 5 months. (A) NEXT_DAY ( 28-5-06 , 5)) (B) NEXT_DAY (28-5-06, 5)) (C) NEXT_DAY (28-5-06, 5)) (D) NEXT_DAY ( 28-5-06 , 5)) If the user wants to connect to the database, the user must have access to (C) (A) create table (B) create index (C) create session (D) create user The right SQL statement is (B) to delete A