1 .
The relational database environment has all of the following components except
A.  user's
B.  seperate files
C.  database
D.  query languages
E.  database
View Answer Discuss in Forum
2 .
A form defined
A.  where data is placed on the screen
B.  the width of each field
C.  both a and b
D.  the breadth of each field
E.  none of the above
View Answer Discuss in Forum
3 .
Database management systems are intended to
A.  eliminates data redundancy
B.  establish relationship among records in different files
C.  manage file access
D.  maintain data integrity
E.  all of the above
View Answer Discuss in Forum
4 .
The highest level in the hierarchy of data organization is called
A.  data bank
B.  database
C.  datafile
D.  data record
E.  None of these
View Answer Discuss in Forum
5 .
Choose the RDBMS which supports fully fledged client server application development
A.  dBase V
B.  Oracle 7.1
C.  Foxpro2.1
D.  Ingress
E.  None of these
View Answer Discuss in Forum
6 .
If a relation scheme is in BSNF then it is also in
A.  First normal form
B.  Second normal form
C.  Third noraml form
D.  Forth normal from
E.  Not in any normal form
View Answer Discuss in Forum
7 .
Report generators are used to
A.  store data input by a user
B.  retrieve information from files
C.  answer queries
D.  both b and c
E.  None of these
View Answer Discuss in Forum
8 .
Data item characteristics that are important in data management include
A.  punctuation
B.  language
C.  spelling
D.  width
E.  None of these
View Answer Discuss in Forum
9 .
The management information system (MIS) structure with one main computer system is called a ------
A.  hierarchical MIS structure
B.  distributed MIS structure
C.  centralized MIS structure
D.  decentralized MIS structure
E.  None of these
View Answer Discuss in Forum
10 .
The language used application programs to request data from the DBMS is referred to as the
A.  The data definition language (DDL)
B.  The data manipulation language (DML)
C.  The database administrator (DBA)
D.  A query language
E.  None of these
View Answer Discuss in Forum
11 .
The language which has recently become the defect standard for interfacing application programs with relational database system is
A.  Oracle
B.  SQL
C.  DBase
D.  4GL
E.  None of these
View Answer Discuss in Forum
12 .
A Field is a related group of __________.
A.  Records
B.  Files
C.  Characters
D.  Tables
E.  None of the above
View Answer Discuss in Forum
13 .
In an E-R diagram an entity set is represent by a
A.  Rectangle
B.  Ellipse
C.  Diamond Box
D.  Circle
E.  None of these
View Answer Discuss in Forum
14 .
A report generator is used to
A.  Update files
B.  Print files on papaer
C.  data entry
D.  Delete files
E.  None of these
View Answer Discuss in Forum
15 .
The property / properties of a database is / are:
A.  It is an integrated collection of logically related records.
B.  It consolidates separate files into a common pool of data records.
C.  Data stored in a database is independent of the application programs using it.
D.  All of the above
E.  None of these
View Answer Discuss in Forum
16 .
The way a particular application views the data from the database that the application uses is a
A.  Module
B.  Relational model
C.  Schema
D.  Sub schema
E.  None of these
View Answer Discuss in Forum
17 .
A relational database developer refers to a record as
A.  A criteria
B.  A relation
C.  A tuple
D.  An attribute
E.  None of these
View Answer Discuss in Forum
18 .
The relational model feature is that there
A.  Is no need for primary key data?
B.  Is much more data independence than some other database models
C.  Are explicit relationships among records?
D.  Are tables with many dimensions?
E.  None of these
View Answer Discuss in Forum
19 .
A transparent DBMS
A.  cannot hide sensitive information from users
B.  keeps its logical structure hidden from users
C.  keeps its physical structure hidden from users
D.  both b and c
E.  None of these
View Answer Discuss in Forum
20 .
A command that lets you change one or more fields in a record is
A.  insert
B.  modify
C.  lookup
D.  none of above
E.  None of these
View Answer Discuss in Forum
21 .
A record management system
A.  can handle many files of information at a time
B.  can be used to extract information stored in a computer file
C.  always uses a list as its model
D.  both a and b
E.  None of these
View Answer Discuss in Forum
22 .
When data changes in multiple lists and all lists are not updated, this causes
A.  data redundancy
B.  information overload
C.  duplicate data
D.  data inconsistency
E.  data repetition
View Answer Discuss in Forum
23 .
what a backup?
A.  Restoring the information backup
B.  An exact copy of a system's information
C.  The ability to get a system up and running in the event of a system crash or failure
D.  All of these
E.  None of these
View Answer Discuss in Forum
24 .
Database management systems are used to
A.  To eliminate data redundancy
B.  To establish relationships among records in different files
C.  To manage file access
D.  To access the data warehouse
E.  None of these
View Answer Discuss in Forum
25 .
Which is not a logical database structure?
A.  chain
B.  tree
C.  relational
D.  network
E.  None of these
View Answer Discuss in Forum
26 .
Data management system may be implemented as
A.  system software
B.  application software
C.  computer program
D.  all of above
E.  None of these
View Answer Discuss in Forum
27 .
Which among following is not a relational database?
A.  dBase IV
B.  4th Dimension
C.  Foxpro
D.  Reflex
E.  None of these
View Answer Discuss in Forum
28 .
After a user has saved and deleted many files, many scattered areas of stored data remain that are too small to be used efficiently, causing ___________.
A.  disorder
B.  turmoil
C.  disarray
D.  fragmentation
E.  None of these
View Answer Discuss in Forum
29 .
Which is a type of DBMS software?
A.  utilities
B.  query language
C.  report writer
D.  all of above
E.  None of these
View Answer Discuss in Forum
30 .
Which of the following contains information about a single 'entity' in the database like a person, place, event, or thing?
A.  qurey
B.  form
C.  record
D.  table
E.  None of these
View Answer Discuss in Forum

Computer Network Internet


Sponsored Links
500
Write your Comment or Discuss..
    Log in | Sign up

    Copyright 2019-2020 | Privacy Policy | Terms and Conditions | Contact us | Advertise