Database Management System (DBMS)

211. How many join types in join condition:

  1. 2
  2. 3
  3. 4
  4. 5

Correct answer: (D)
5

212. How many tables in a join query have no join condition:

  1. 2
  2. 3
  3. 4
  4. None of these

Correct answer: (A)
2

213. Which product is returned in a join query have no join condition:

  1. Equijoins
  2. Cartesian
  3. Both
  4. None

Correct answer: (B)
Cartesian

214. Which is a join condition contains an equality operator:

  1. Equijoins
  2. Cartesian
  3. Both
  4. None

Correct answer: (A)
Equijoins

215. Which command defines its columns, integrity constraint in create table:

  1. Create command
  2. Drop table command
  3. Alter table command
  4. All of these

Correct answer: (A)
Create command

216. It refers to set of one or more columns that designates the ___________ key in a referential integrity constraint:

  1. Select key
  2. Foreign key
  3. Write key
  4. None of these

Correct answer: (B)
Foreign key

217. Which constraint that requires that the column contain a value when it is initially inserted into the table:

  1. IS NULL
  2. NOT NULL
  3. UNIQUE
  4. None

Correct answer: (B)
NOT NULL

218. Which constraint that identifies a column or combination of columns as a unique key:

  1. IS NULL
  2. NOT NULL
  3. UNIQUE
  4. None

Correct answer: (C)
UNIQUE

219. Which command is use for removing a table and all its data from the database:

  1. Create command
  2. Drop table command
  3. Alter table command
  4. All of these

Correct answer: (B)
Drop table command

220. Which command that allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:

  1. TRUNCATE command
  2. Create command
  3. Drop table command
  4. Alter table command

Correct answer: (A)
TRUNCATE command

Previous
Page 22 of 45
Next
Copyright © EngineeringMCQ.com