Tag: databases

Questions Related to databases

  1. TRUNCATE Sales TABLE

  2. TRUNCATE * FROM TABLE Sales

  3. TRUNCATE TABLE Sales

  4. All the above


Correct Option: C
  1. A process for data export/import.

  2. A set of SQL statements stored and executed as a single entity.

  3. A process to convert tables.

  4. Data stored in a database.


Correct Option: B

what does SQL Lack

  1. The complexity and size of the SQL standard means that most databases DO NOT implement the entire standard.

  2. The simplicity and size of the SQL standard means that most databases DO implement the entire standard.

  3. The simplicity and size of the SQL standard means that most databases DO NOT implement the entire standard.

  4. The complexity and size of the SQL standard means that most databases DO implement the entire standard.


Correct Option: A
  1. Logically

  2. Physically

  3. Both of the above

  4. None of the above


Correct Option: C

Schema consists of - sections?

  1. 2

  2. 4

  3. 6

  4. 8


Correct Option: B
  1. Record Number

  2. Page Number

  3. Area Name

  4. Page Name

  5. Area Code

  6. Record Name


Correct Option: A,B,E
  1. Via Set

  2. Direct

  3. Calc

  4. Index Sequential


Correct Option: B

How many areas are associted with an Index Sequential Record

  1. 1

  2. 2

  3. 3

  4. 4


Correct Option: B