Data and Database Administration Questions and Answers

Q: Data modeling and database design are key responsibilities of data and data base administration.

Correct answer: TrueData administration owns the enterprise data model and the standards; database administration owns the physical design, tuning and operation. Both are design responsibilities rather than merely operational ones, which is why the roles sit alongside development rather than beneath it.

Q: Databases are not the property of a single function or individual within the organization.

Correct answer: TrueThis is the principle underlying data administration. Data is an organisational asset, so no department owns the database it happens to have created, and definitions, standards and access rights are set centrally. Departmental ownership is exactly what produces the fragmented, inconsistent systems that integration projects then have to reconcile.

Q: Failure to control confidentiality may lead to loss of competitiveness.

Correct answer: TrueConfidentiality failures do not only expose personal data; they expose costings, designs, customer lists and plans, any of which a competitor can act on. The damage is commercial as well as legal, and it is one reason security is treated as a business responsibility rather than a purely technical one.

31.

Performance analysis and tuning is which of the following?

A.Undertaken one time at the time of a DBMS installation
B.Undertaken one time at the time of the implementation of a new application
C.Undertaken as an ongoing part of the backup of a database
D.Undertaken as an ongoing part of managing a database

Answer: D

Correct answer: Undertaken as an ongoing part of managing a database

Performance tuning is continuous, not a one-off at installation. Data volumes grow, the mix of queries changes, indexes that once helped become a burden on updates - so a database that was well tuned last year may not be now. Monitoring and adjustment are part of ordinary administration.

Discuss in Forum

32.

Data modeling and database design are key responsibilities of data and data base administration.

A.True
B.False

Answer: A

Correct answer: True

Data administration owns the enterprise data model and the standards; database administration owns the physical design, tuning and operation. Both are design responsibilities rather than merely operational ones, which is why the roles sit alongside development rather than beneath it.

Discuss in Forum

33.

Databases are not the property of a single function or individual within the organization.

A.True
B.False

Answer: A

Correct answer: True

This is the principle underlying data administration. Data is an organisational asset, so no department owns the database it happens to have created, and definitions, standards and access rights are set centrally. Departmental ownership is exactly what produces the fragmented, inconsistent systems that integration projects then have to reconcile.

Discuss in Forum

34.

Concurrency control is important for which of the following reasons?

A.To ensure data integrity when updates occur to the database in a multiuser environment
B.To ensure data integrity when updates occur to the database in a single-user environment
C.To ensure data integrity while reading data occurs to the database in a multiuser environment
D.To ensure data integrity while reading data occurs to the database in a single-user environment

Answer: A

Correct answer: To ensure data integrity when updates occur to the database in a multiuser environment

Concurrency control exists because several users may update at once. Reads alone cannot corrupt anything, and with a single user there is no interleaving to control - so it is the combination of updates and multiple users that creates the problem.

Discuss in Forum

35.

Failure to control confidentiality may lead to loss of competitiveness.

A.True
B.False

Answer: A

Correct answer: True

Confidentiality failures do not only expose personal data; they expose costings, designs, customer lists and plans, any of which a competitor can act on. The damage is commercial as well as legal, and it is one reason security is treated as a business responsibility rather than a purely technical one.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: Data and Database Administration Questions and Answers || Data and Database Administration MCQ Questions and Answers || Data and Database Administration GK Questions and Answers || Data and Database Administration GK MCQ Questions || Data and Database Administration Multiple Choice Questions and Answers || Data and Database Administration GK || GK on Data and Database Administration || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database

Data and Database Administration Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications