Quizific | ANSI SPARC Quiz

The purpose of a relational DBMS model is to

Combine the hierarchical model and the network model

Treat data as if they were stored in two-dimensional tables

Make reports more difficult to program

Share common data elements with application programs

Which of the following is/are the basic operation(s) used to develop useful sets of data in a relational database?

Sort, select and report

Combine, relate and sort

Select, project and join

Join, relate and sort.

The conceptual design of a database is

More important than the physical design

An abstract model of the database from the business perspective

Easier for a programmer to understand than the logical design

The actual arrangement of data on direct access storage devices

The methodology for documenting databases illustrating the relationship between various entities in the database is

Data flow diagram

State transition diagram

Entity-relationship diagram

Entity sequence diagram

Which of the following is the conceptual data model used by database designers?

Normalization diagrams

An entity-relationship diagram

A distributed-hierarchical diagram

An entity-attributes diagram

State the effective way of using a relational data model?

Three-dimensional models must be created

There must be a minimum of four relationships

Flat files must be eliminated

Complex groupings of data must be streamlined

When implementing security in a DBMS, which of the following is not supported by the GRANT command?

Providing DELETE privileges

Supporting the devolution of access control to non-DBAs

Removing privileges of other people

Providing SELECT privileges

Which of the following best describes the internal level of the ANSI/SPARC three level architecture?

The internal level is concerned with the layout of records and their locations within disk blocks

The internal level is concerned with the data as seen by individuals internal to the enterprise

The internal level is concerned with the users’ view of the data

The internal level is concerned with the how stored fields are represented and which indices exist

In the ANSI/SPARC three level database model, the external view is best described by which of the following options?

It is the link between users and the storage structures

It is dependent on the underlying DBMS product used (e.g. Oracle, DBASE)

It is the place where the users interface to the DBMS

It is not part of the model

The unit of storage that can store one are more records in a hash file organization are

Buckets

Disk pages

Blocks

Nodes