SQL Extensions   «Prev  Next»

 

Creating Oracle Tables - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Examine the following SQL command: 
1   CREATE TABLE JOB_OPP 
2   (JOB_ID NUMBER(10) NOT NULL,
3   COLLEGE_ED_FLAG CHAR(1), 
4   APP_METHOD VARCHAR2(25) DEFAULT 'MAIL')

Please select the best answer.
  A. 1
  B. 2
  C. 3
  D. 4

2. Which of the following column specifications best fits the two data values 155.13 and 35576.08?
Please select the best answer.
  A. CHAR(7,2)
  B. NUMBER(7,2)
  C. NUMBER(5,2)
  D. VARCHAR2(8)

3. Which parameter is not part of the storage parameters in the CREATE TABLE command?
Please select the best answer.
  A. MAXEXTENTS
  B. DEFAULT
  C. PCTFREE
  D. NEXT

4. If a tablespace runs out of space, which of the following statements is true?
Please select the best answer.
  A. You can add another datafile to increase the tablespace's space.
  B. You cannot increase the size of the tablespace or its datafiles.
  C. You cannot update any table inside the tablespace.
  D. A non-partitioned table that needs more space can use a different tablespace.

5. Examine the following SQL statement:
Please select the best answer.
  A. The maximum space that this table can use is 200K.
  B. If a block of data contains more than 20 percent data, no more rows will be updated.
  C. The maximum space that this table can use is 190K.
  D. If the USERS tablespace contains less than 190K of free space, this table cannot be created.

Correct answers:

Your Score: 0