Alien head

Simple DBMS Quiz

Description: Simple DBMS Quiz
Number of Questions: 8
Created by:
Tags: dbms

Which one of the following comes under Transaction controlled Language ?

sql
  1. grant

  2. revoke

  3. rollback

  4. none

Answer: 3

Which of the following are cursor attributes ?

sql
  1. %ISOPEN

  2. %NOTFOUND

  3. both a and b

  4. %CURSORSOPEN

Answer: 3

Which one of the following is false about cursor?

sql
  1. Cursors can hold multiple records at the same time

  2. Cursors are a private SQL area network

  3. Cursors are used to retrieve and manipulate data

  4. Cursor is not a pointer to a memory location

Answer: 4

Which of the following is a problem of file management system?

  1. difficult to update

  2. lack of data independence

  3. data redundancy

  4. program dependence

  5. all of above

Answer: 5

Which of the following is true of a network structure?

  1. It is a physical representation of the data

  2. It allows a many-to-many relationship

  3. It is conceptually simple

  4. It will be dominant data base of the future

Answer: 2

Information can be transferred between the DBMS and a

  1. spreadsheet program

  2. word processor program

  3. graphics program

  4. all of the above

Answer: 4

One data dictionary software package is called

  1. DB/DC dictionary

  2. TOTAL

  3. ACCESS

  4. Datapac

  5. Data Manager

Answer: 1

The ascending order of a data hierarchy is:

  1. bit-byte-record-field-file-database

  2. byte-bit-field-record-file-database

  3. bit-byte-field-record-file-database

  4. bit-byte-file-record-field-database

Answer: 3
+ View questions