RelationalDBDesignRelationalDBDesign


Managing Tables   «Prev  Next»

Table Creation Basics - Quiz

Reviewing table creation basics

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. You would define the column with a datatype of:
Please select the best answer.
  A. NCHAR(8000)
  B. NVARCHAR2(8000)
  C. NLOB
  D. CLOB

Score =
Correct answers: