schema definition constraints queries and views

MCQsQuestion.com has 8 Question/Answers about Topic schema definition constraints queries and views

When schema is to be dropped in SQL which has no elements then type of DROP Command used is called

When schema is to be dropped in SQL which has no elements then type of DROP Command used is called
  • A. SCALE DROP command
  • B. PRECISION DROP command
  • C. RESTRICT DROP schema
  • D. CASCADE DROP command
  • Correct Answer: Option C

Data type in SQL which includes various size integers and floating point numbers are classified as

Data type in SQL which includes various size integers and floating point numbers are classified as
  • A. query data type
  • B. numeric data types
  • C. binary data types
  • D. formatted data types
  • Correct Answer: Option B

Relations that are declared in SQL through CREATE VIEW statements are classified as

Relations that are declared in SQL through CREATE VIEW statements are classified as
  • A. binary relations
  • B. ternary relations
  • C. logic relations
  • D. virtual relations
  • Correct Answer: Option D

In TIMESTAMP data type, relative value which is used to decrease or increase absolute value of time stamp is classified as

In TIMESTAMP data type, relative value which is used to decrease or increase absolute value of time stamp is classified as
  • A. nest position
  • B. interval
  • C. decimal
  • D. notation
  • Correct Answer: Option B

Formatted numbers are declared in SQL by using statement such as

Formatted numbers are declared in SQL by using statement such as
  • A. DECIMAL (I, j)
  • B. DEC ()
  • C. NUMERIC ()
  • D. all of above
  • Correct Answer: Option D

In varying length character string CHAR(n), ‘n’ represents

In varying length character string CHAR(n), ‘n’ represents
  • A. number of rows
  • B. number of columns
  • C. number of characters
  • D. maximum number of characters
  • Correct Answer: Option D

If length of bit string is multiple of 4 then it can be specified with notation called

If length of bit string is multiple of 4 then it can be specified with notation called
  • A. fixed string notation
  • B. triple decimal notation
  • C. double decimal notation
  • D. hexadecimal notation
  • Correct Answer: Option D

Clause used in CREATE TABLE statement in SQL to specify secondary keys is called

Clause used in CREATE TABLE statement in SQL to specify secondary keys is called
  • A. STAMPED clause
  • B. UNIQUE clause
  • C. SECOND clause
  • D. FIRST clause
  • Correct Answer: Option B