Managing Tables   «Prev  Next»

Table Creation Basics - Quiz

Each question is worth one point. Select the best answer for each question.
1. Which one of these is syntactically correct?
Please select the best answer.
  A. CREATE TABLE auction COLS(auction_id NUMBER, start_time DATE, stop_time DATE)
  B. CREATE TABLE (auction_id NUMBER, start_time DATE, stop_time DATE)
  C. CREATE TABLE auction (auction_id NUMBER, start_time DATE, stop_time DATE)
  D. CREATE TABLE AUCTION (auction_id NUMBER, start_time DATE, stop_time)

2. You must define a column holding up to 800 English language characters. The best datatype for the column is:
Please select the best answer.
  A. CHAR(800)
  B. VARCHAR2(800)
  C. CLOB
  D. NVARCHAR2(800)

3. You want to store a string of 8,000 Japanese characters in a column. Which datatype is the best choice when you need a national character large object?
Please select the best answer.
  A. NCHAR(8000)
  B. NVARCHAR2(8000)
  C. NCLOB
  D. CLOB