Database Management System (DBMS)

351. How many general rules in a relational model and being general rules these are applicable to all database:

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

Correct answer: (A)
2

352. Which rules are know as ’entity integrity’ and ‘referential integrity’:

  1. General
  2. Database specific
  3. Both
  4. None

Correct answer: (A)
General

353. ___________ states that primary keys should not be null:

  1. Entity integrity
  2. Referential integrity
  3. Both
  4. None

Correct answer: (A)
Entity integrity

354. Integrity constraints that do not fall under the preceding two integrity rules are referred to as ___________:

  1. Entity integrity rule
  2. Referential integrity rule
  3. General integrity rule
  4. Database specific integrity rule

Correct answer: (D)
Database specific integrity rule

355. Which has support for specification of global rule applicable to the whole table:

  1. Microsoft access1.0
  2. Microsoft access1.5
  3. Microsoft access2.0
  4. Microsoft access2.5

Correct answer: (C)
Microsoft access2.0

356. In creating a table a row contains:

  1. Memory
  2. Record
  3. Field
  4. None

Correct answer: (B)
Record

357. In creating a table a column contains:

  1. Memory
  2. Record
  3. Field
  4. None

Correct answer: (B)
Record

358. Which have not have client/server architecture:

  1. DBS
  2. DBMS
  3. RDBMS
  4. All of these

Correct answer: (C)
RDBMS

359. Which command creates database objects like tables views and indexes:

  1. Create command
  2. Update command
  3. Both
  4. None

Correct answer: (A)
Create command

360. Which command enables alteration the data stored in existing records:

  1. Create command
  2. Update command
  3. Deletion command
  4. All of these

Correct answer: (B)
Update command

Page 36 of 45