Q.1

In SQL, the command(s) is(are) used to create an index for a table or cluster

  • CREATE INDEX
  • MODIFY INDEX
  • SET INDEX TO FILE
  • All of the above
  • None of the above
Q.2

In SQL, which of the following is not a data definition language commands?

  • RENAME
  • REVOKE
  • GRANT
  • UPDATE
  • None of the above
Q.3

In SQL, which command(s) is(are) used to recompile a stored function?

  • SET FUNCTION
  • SET STORED FUNCTION
  • ALTER FUNCTION
  • All of the above
  • None of the above
Q.4

Report generators are used to

  • store data input by a user
  • retrieve information from files
  • answer queries
  • both (b) and (c)
  • None of the above
Q.5

The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?

  • Bits
  • Characters
  • Data field
  • Schema
  • None of the above
Q.6

There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?

  • Data storage system
  • Database management system (DBMS)
  • Batch processing system
  • Data communication package
  • None of the above
Q.7

When you have finished entering information into a form

  • the template is written to the data file
  • the contents of the form are written to the data file
  • the contents of the form can be printed
  • All of the above
  • None of the above
Q.8

If you want to group the records in the abc database, you could use the Jobcode as the _____.

  • Delete
  • Update
  • Sort Key
  • Index
  • None of the above
Q.9

In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.

  • Network database
  • Relational database
  • Distributed database
  • Hierarchical database
  • None of the above
Q.10

A database management system

  • allows simultaneous access to multiple files
  • can do more than a record management system
  • is a collection of programs for managing data in a single file
  • both (a) and (b)
  • None of the above
Q.11

Subschema can be used to

  • create very different, personalized views of the same data
  • present information in different formats
  • hide sensitive information by omitting fields from the sub¬schema's description
  • All of the above
  • None of the above
Q.12

In SQL, GRANT command is used to

  • allow user to access databases
  • allow user to create databases
  • grant system privileges, roles, and object privileges to uses and roles
  • choose auditing for specific SQL commands
  • None of the above
Q.13

A report generator is used to

  • update files
  • print files on paper
  • data entry
  • All of the above
  • None of the above
Q.14

In SQL, which command is used to changes data in a table?

  • UPDATE
  • INSERT
  • BROWSE
  • APPEND
  • None of the above
Q.15

Administrate supervision of database activities is the responsibility of the

  • Database administrator
  • DP Manager
  • DB Manager
  • DP administration
  • None of the above
Q.16

Which command is used to remove an index from the database in SQL?

  • DELETE INDEX
  • DROP INDEX
  • REMOVE INDEX
  • ROLL BACK INDEX
  • None of the above
Q.17

A _____ DBMS distributes data processing tasks between the workstation and a network server.

  • Network
  • Relational
  • Client Server
  • Hierarchical
  • None of the above.
Q.18

The main idea behind computer files is that it is convenient to

  • arrange them
  • store information together
  • create them
  • access them
  • None of the above
Q.19

A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be

  • the pin code
  • the last name
  • a compound key consisting of the first name and the last name
  • All of the above
  • None of the above
Q.20

The Management Information system (MIS) structure with one main computer system is called a

  • hierarchical MIS structure
  • distributed MIS structure
  • centralized MIS structure
  • decentralized MIS structure
  • None of the above
Q.21

Which two files are used during operation of the DBMS?

  • query language and utilities
  • data manipulation language and query language
  • data dictionary and transaction log
  • data dictionary and query language
  • None of the above
Q.22

When using a database management system, the first thing that you must do is to

  • create a database file
  • activate file editor
  • load the software into your micro¬computer
  • keep a floppy disk in readiness
  • None of the above
Q.23

Which of the following hardware components is the most important to the operation of a database management system?

  • high-resolution video display
  • printer
  • high speed, large-capacity disk
  • plotter
  • mouse
Q.24

The PROJECT command will create new table that has

  • more fields than the original table
  • more rows than the original table
  • both (a) and (b)
  • all the fields of master table
  • None of the above
Q.25

Database management systems are intended to:

  • eliminate data redundancy
  • establish relationships among records in different files
  • manage file access
  • maintain data integrity
  • All of the above
Q.26

In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?

  • CREATE PACKAGE
  • CREATE SCHEMA
  • CREATE CLUSTER
  • All of the above
  • None of the above ;
Q.27

The highest level in the hierarchy of data organization is called

  • data bank
  • database
  • data file
  • data record
  • None of the above
Q.28

Which of the following is not a logical data-base structure?

  • tree
  • relational
  • network
  • chain
  • All of the above
Q.29

Which of the following is a database administrator's function?

  • database design
  • backing up the database
  • performance monitoring
  • user coordination
  • All of the above
Q.30

What name is given to the collection of facts, items of information or data which are related in some way?

  • Database
  • Directory information
  • Information tree
  • Information provider
  • None of the above
0 h : 0 m : 1 s