Which of the following is not the responsibility of utilities component of DBMS software?

This Test will cover complete DBMS with very important questions, starting off from basics to advanced level.

Nội dung chính Show

Which of the following is not a component of DBMS?
Which is not utility of DBMS?
Which of the following is component of DBMS software?
What are the utilities of DBMS?

Q. Database management systems are intended to __________.

A. eliminate data redundancy

B. establish relationship among records in different files

C. manage file access

D. all of these

Q. Which of the following is not a characteristics of a relational database model?

A. Tables	B. Treelike Structure
C. Complex logical relationships	D. Records

Q. Which of the following is not the responsibility of the utilities component of DBMS software?

A. Creating the physical and logical designs

B. Removing flagged records for deletion

C. Creating and maintaining the data dictionary

D. Monitoring performance

Q. Which of the following is a type of DBMS software?

A. Database manipulation language

B. Query language

C. Utilities

D. All of these

Q. A database administrator's function is __________.

A. Database design	B. Backing up the database
C. Performance monitoring	D. All of these

Q. A data dictionary doesn't provide information about __________.

A. where data is located

B. the size of the storage disk

C. who owns or is responsible for the data

D. how the data is used

Q. Which of the following is a serious problem of file management systems?

A. Difficult to update

B. Lack of data independence

C. Data redundancy

D. All of these

Q. A database management system __________.

A. allows simultaneous access to multple file

B. can do more than a record management system

C. is a collection of programs for managing data in a single file

D. both (a) and (b)

Q. Which of the following is true for a large DBMS?

A. In a large DBMS each user can "see" only a small part of the entire database.

B. In a large DBMS each sub-schema contains every field in the logical schema.

C. In a large DBMS each user can access every sub-schema.

D. All of these

Q. Which of the following is true for a transparent DBMS?

A. A transparent DBMS cannot hide sensitive information from users.

B. A transparent DBMS keeps its logical structure hidden from users.

C. A transparent DBMS keeps its physical structure hidden from users.

D. both (b) and (c)

Q. Goals for the design of the Logical schema includes __________.

A. avoiding data inconsistency

B. being able to construct queries easily

C. being able to accesss data efficiently

D. all of these

Q. A top to bottom relationship among the items in a database is established by a __________.

A. Hierarchical Schema	B. Network Schema
C. Relational Schema	D. all of these

Q. Which of the following is true for a Network Schema?

A. A Network Schemarestricts the structure to a one to many relationships.

B. A Network Schema permits many to many relationships.

C. A Network Schema stores data in tables.

D. None of these

Q. In a relational schema, each tuple is divided into fields called __________.

A. relations	B. domains
C. queries	D. none of these

Q. The online(over Internet) softcopy displays a customer's charge account to respond to an inquiry is an example of __________.

A. Forecasting report	B. Exception report
C. Regularly scheduled report	D. On demand report

Which of the following is not a component of DBMS?

Answer: 1 query processor is not the dbms.

Which is not utility of DBMS?

DBMS is not a utility software rather it is software for general purpose. The full form of DBMS is Data Management Systems which is used for creating, maintaining and providing controlled access to the database. DBMS can run queries on data.

Which of the following is component of DBMS software?

Components of a database management system.

Storage engine..

Query language..

Query processor..

Optimization engine..

Metadata catalog..

Log manager..

Reporting and monitoring tools..

Data utilities..

What are the utilities of DBMS?

A DBMS also provides a set of utilities for managing and controlling database activities. Examples of database utilities include reorganization, runstats, backup and copy, recover, integrity check, load data, unload data and repair database.

Entity is a