DBMS GRAND TEST-3

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

• difficult to update

• lack of data independence

• data redundancy

• all the above

Answer explanation

All the options listed are problems of file management systems. They can be difficult to update, lack data independence, and often lead to data redundancy, making 'all the above' the correct choice.

One data dictionary software packages is called

• DB/DC dictionary

• ACCESS

• TOTAL

• Datapac

Answer explanation

The correct answer is 'DB/DC dictionary' as it specifically refers to a data dictionary software package, while the other options are not primarily known for this function.

The function of a database is

• to check all input data

• to check all spellimg

• to collect and organize input data

• to output data

Answer explanation

The primary function of a database is to collect and organize input data, allowing for efficient storage, retrieval, and management of information. This makes 'to collect and organize input data' the correct choice.

What is the language used by most of the DBMSs for helping their users to access data?

• high level language

• query language

• SQL

• 4GL

Answer explanation

The correct answer is 'query language' because it is specifically designed for users to access and manipulate data in a database. While SQL is a type of query language, the broader term encompasses various languages used in DBMSs.

The model for a record management system might be

• handwritten list

• a Rolodex card file

• a business form

• all the above

Answer explanation

The correct answer is 'all the above' because a record management system can be represented by various models, including a handwritten list, a Rolodex card file, and a business form, all of which serve to organize records.

Primitive operations common to all record management system include

• print

• sort

• look-up

• all the above

Answer explanation

The correct answer is 'look-up' as it is a fundamental operation in record management systems, allowing users to retrieve specific records. While 'print' and 'sort' are useful, they are not universally essential like 'look-up'.

In a large DBMS

• each user can "see" only a small part of the entire database

• each subschema contains every field in the logical schema

• each user can access every subschema

• all the abov

Answer explanation

In a large DBMS, each user typically has access to a specific subset of the database, allowing for data security and privacy. This means they can only 'see' a small part of the entire database, making the first choice correct.

Information can be transferred between the DBMS and a

• spreadsheet program

• word processor program

• graphics program

• all the above

Answer explanation

Information can be transferred between a DBMS and various applications, including spreadsheet, word processor, and graphics programs. Therefore, the correct answer is 'all the above'.

What is Cartesian product

• group function

• the result of join select statement with no where clause

• a special feature of oracle server

• none of the above

Answer explanation

The Cartesian product is the result of a join select statement without a where clause, producing all possible combinations of rows from the involved tables. This matches the correct answer choice.

Which of the following is not considered to be a basic element of an enterprise-class database system?

• users

• DBMS

• database applications

• COBOL programs

Answer explanation

COBOL programs are not a fundamental component of an enterprise-class database system. The basic elements include users, the DBMS, and database applications, which are essential for database functionality.