Simple DBMS Quiz Online Test

Back

0

Simple DBMS Quiz

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

Start the Quiz

Which one of the following comes under Transaction controlled Language ?

sql

grant
revoke
rollback
none

Which of the following are cursor attributes ?

sql

%ISOPEN
%NOTFOUND
both a and b
%CURSORSOPEN

Which one of the following is false about cursor?

sql

Cursors can hold multiple records at the same time
Cursors are a private SQL area network
Cursors are used to retrieve and manipulate data
Cursor is not a pointer to a memory location

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

knowledge

difficult to update
lack of data independence
data redundancy
program dependence
all of above

Which of the following is true of a network structure?

knowledge

It is a physical representation of the data
It allows a many-to-many relationship
It is conceptually simple
It will be dominant data base of the future

Information can be transferred between the DBMS and a

knowledge

spreadsheet program
word processor program
graphics program
all of the above

One data dictionary software package is called

knowledge

DB/DC dictionary
TOTAL
ACCESS
Datapac
Data Manager

The ascending order of a data hierarchy is:

knowledge

bit-byte-record-field-file-database
byte-bit-field-record-file-database
bit-byte-field-record-file-database
bit-byte-file-record-field-database

- Hide questions