文档介绍：oracle试卷及答案(Oracle test paper and answer)
Oracle test paper and answer
First, multiple-choice questions
1, paragraph is a logical storage structure in table space, and the following (D) is not a segment type used by ORACLE database.
(A) index segment (B) temporary segment (C) rollback segment (D) code segment
2, ORACLE database physical structure includes the following three kinds of documents, the following does not belong to (A)
(A) system file (B) log file (C) data file (D) control file
3, you can install multiple service software on a physical server to form multiple logical servers. To distinguish these different logical servers, a concept called "B" is used.
(A) chip (B) port (C) range (D) data block
4, the following is the correct judgment (B)
(A) '2006-05-01' less than '2006-04-31' (B) '1234' is greater than '123_'
(C) 'beautiful' is greater than 'D', and '2e-3' is less than '-2e3'
5, the result of the following is not empty value is (C)
(A) 12+NULL (B) 60*NULL (C) NULL, 'NULL' (D) 12/ (60+NULL)
6, has created sequence S1, if the current value is 2, first execute 3 times , and then execute 3 times , and finally the value of S1 is (C)
(A) 3 (B) 4 (C) 5 (D) 6
There are two users of Scott and muuser 7, material database, table WZ is belong to myuser users, but the current user is Scott, the query table WZ materials (wno, wname, wtype, wunit) wunit materials units listed as null records, the first 5 records from the results showed the following SQL statement right is (C)
(A) select*from where wunit is null and rownum<5;
(B) select*from where wunit = null and rownum<5;
(C) select*from where wunit is null and rownum<6;
(D) select*form where wunit is null and rownum<6;
8, if the current date is' 25-5 months -06 ', the following (D) expression can calculate the date of the last day of the month after 5 months.
(A) NEXT_DAY (ADD_MONTHS (` 28-5 month -06 ', 5))
(B) NEXT_DAY (MONTHS_BETWEE