search

Which of the following is not a function of the database management system _______________?

1 Jahrs vor
Kommentare: 0
Ansichten: 125

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

Show

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 function of database management system?

Which of the following is not the utility of DBMS? Explanation: Backup utility is used to create a copy of the db as a backup. Loading utility is used to load existing file.

Which of the following is a function of a database management system?

The functions of a DBMS include concurrency, security, backup and recovery, integrity and data descriptions.

Which of the following is not features of DBMS?

The feature which is not of DBMS among the above-given options is utilities for performance analysis and logging. Whereas, other features such as maintenance of accuracy of the data, successful modifications of data, and recovery mechanism are features of the DBMS.

Which of the following is not an example of database management system?

The correct answer is Microsoft Outlook. Microsoft SQL Server is a relational database management system developed by Microsoft. MySQL Database Service is a fully managed database service to deploy cloud-native applications.

function database management system _______________

zusammenhängende Posts

Which of the following functions of management involves taking actions to implement the plan?
Which of the following functions of management involves taking actions to implement the plan?

What is the tendency to think of things only in terms of their usual function and leads to impediment to problem
What is the tendency to think of things only in terms of their usual function and leads to impediment to problem

Which is the purpose of the peak expiratory flow rate test for a child with asthma undergoing pulmonary function tests?
Which is the purpose of the peak expiratory flow rate test for a child with asthma undergoing pulmonary function tests?

Which of the following is the primary function of departments and agencies within the federal bureaucracy?
Which of the following is the primary function of departments and agencies within the federal bureaucracy?

Which parts of the inner ear are involved in the sense of balance and which parts are involved in the sense of hearing?
Which parts of the inner ear are involved in the sense of balance and which parts are involved in the sense of hearing?

What role does the planning function of human resource management play within organizations?
What role does the planning function of human resource management play within organizations?

Which test provides the most personalized assessment of an individuals true metabolic function?
Which test provides the most personalized assessment of an individuals true metabolic function?

Which function of attitudes serves to express an individuals central values lifestyle outlook and self
Which function of attitudes serves to express an individuals central values lifestyle outlook and self

Rsa is a one-way function widely used in e-commerce for both encryption and digital signing.
Rsa is a one-way function widely used in e-commerce for both encryption and digital signing.

Which of the following should an Organisation consider as a factor while selecting internal candidates for their vacant position?
Which of the following should an Organisation consider as a factor while selecting internal candidates for their vacant position?

Werbung

NEUESTEN NACHRICHTEN

Borderline wer ist schuld
1 Jahrs vor . durch LunarLine-up
Wer hat mich auf Instagram blockiert
1 Jahrs vor . durch IncipientHeader
Wie geht es dir was soll ich antworten?
1 Jahrs vor . durch SolubleAuthority
Kind 1 Jahr wie oft Fleisch
1 Jahrs vor . durch ThirstyRepublic
Was müssen Sie bei der Beladung von Fahrzeugen zu beachten?
1 Jahrs vor . durch WaxedHeadquarters
Schütz Die Himmel erzählen die Ehre Gottes
1 Jahrs vor . durch ExtrinsicSaucer
In planning an IS audit, the MOST critical step is the identification of the
1 Jahrs vor . durch SteepPanther
Wie lange darf eine Kaution einbehalten werden?
1 Jahrs vor . durch SeasonalBanjo
Sarah connor nicht bei voice of germany
1 Jahrs vor . durch FloridIceberg
Kann man mit dem Fachabitur Jura studieren?
1 Jahrs vor . durch PolarIndecency

Werbung

Populer

Werbung

Um

Legal

Hilfe

Sozial

homeendefrjpkoptzhhiitthtr
Urheberrechte © © 2024 ketiadaan Inc.