Alien head

Simple DBMS Quiz

Description: Simple DBMS Quiz
Number of Questions: 8
Created by:
Tags: dbms
Attempted 0/8 Correct 0 Score 0

Which one of the following comes under Transaction controlled Language ?

sql
  1. grant

  2. revoke

  3. rollback

  4. none


Correct Option: C

Which of the following are cursor attributes ?

sql
  1. %ISOPEN

  2. %NOTFOUND

  3. both a and b

  4. %CURSORSOPEN


Correct Option: C

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


Correct Option: D

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


Correct Option: E

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


Correct Option: B

Information can be transferred between the DBMS and a

  1. spreadsheet program

  2. word processor program

  3. graphics program

  4. all of the above


Correct Option: D

One data dictionary software package is called

  1. DB/DC dictionary

  2. TOTAL

  3. ACCESS

  4. Datapac

  5. Data Manager


Correct Option: A

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


Correct Option: C
+ View questions