> > Database MCQs > Database Administration MCQs

Database Administration MCQ

Flat, raised, sunken, etched, shadowed, and chiseled are options for the ____ control property.

Ribbon

Special Effect

Shift

Multiple

Answer

Correct Answer: Special Effect

Note: This Question is unanswered, help us to find answer for this one

The ____ establishes the naming conventions for tables, fields, and indexes in the data dictionary.

users

DBMS

DBA

Programmers.

Answer

Correct Answer: DBA

Note: This Question is unanswered, help us to find answer for this one

Unix allows permissions to be assigned to ________.

The account that owns the file or directory

A group associated with the directory

Everyone else

All of the above

Answer

Correct Answer: All of the above

Note: This Question is unanswered, help us to find answer for this one

A data administrator is also known as a(n) _____.

Data security officer

Systems administrator

Information resource manager

Information engineering officer

Answer

Correct Answer: Information resource manager

Note: This Question is unanswered, help us to find answer for this one

One of the important functions of a dbms is to provide the necessary tools for ________.

Administering the database

Storing data types such as images, audio, and videos in organizations

Application programs

Administration

Answer

Correct Answer: Administering the database

Note: This Question is unanswered, help us to find answer for this one

Management of classified data includes its storage and _________.

Systems-specific

Risk identification

Distribution, portability, and destruction (All of the above)

Disadvantage

Answer

Correct Answer: Distribution, portability, and destruction (All of the above)

Note: This Question is unanswered, help us to find answer for this one

A ____ is responsible for maintaining a large, multiuser system.

Software engineer

System administrator

Vice president of information systems

Answer

Correct Answer: System administrator

Note: This Question is unanswered, help us to find answer for this one

_____ are used to control the behavior or interactivity of the field in database objects.

Field size

Field properties

Remove the filter

Primary key field

Answer

Correct Answer: Field properties

Note: This Question is unanswered, help us to find answer for this one

A traditional data administrator performs which of the following roles?

Establish backup and recovery procedures

Resolve data ownership issues

Protect the security of the database.

Tune Database Performance

Answer

Correct Answer: Resolve data ownership issues

Note: This Question is unanswered, help us to find answer for this one

Performance analysis and tuning is which of the following?

Undertaken as an ongoing part of managing a database

Undertaken one time at the time of a DBMS installation

Undertaken as an ongoing part of the backup of a database

Undertaken one time at the time of the implementation of a new application

Answer

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

Note: This Question is unanswered, help us to find answer for this one

A torn page is where

A database object is split between 2 pages

Part of the page has become corrupt

Part of the page is not contiguously written to disk

Part of the page is not written to disk

Answer

Correct Answer: Part of the page is not written to disk

Note: This Question is unanswered, help us to find answer for this one

Which of the following could cause data to be unavailable?

Data becoming lost or inaccurate

Planned database maintenance activities

All of these

The database server

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

Failure to control confidentiality may lead to loss of competitiveness.

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

The ability to do an action on a table is called

A token

A password

A right

An action

Answer

Correct Answer: A right

Note: This Question is unanswered, help us to find answer for this one

Mirrored databases are almost always provided in high-availability systems.

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

We prevent a user from updating a table by:

Blocking the table

Granting a right

Revoking a right

Blocking the columns

Answer

Correct Answer: Revoking a right

Note: This Question is unanswered, help us to find answer for this one

If both data and database administration exist in an organization, the database administrator is responsible for which of the following?

All of these

Database design

Metadata

Data Modeling

Answer

Correct Answer: Database design

Note: This Question is unanswered, help us to find answer for this one

What does RDBMS stand for?

Relational Database Micro System

Relational Database, Microsoft

Rational Database Management System

Relational Database Management System

Answer

Correct Answer: Relational Database Management System

Note: This Question is unanswered, help us to find answer for this one

Poor data administration can lead to which of the following?

Missing data elements

A single definition of the same data entity

Familiarity with existing data

All of these

Answer

Correct Answer: Missing data elements

Note: This Question is unanswered, help us to find answer for this one

A default object is?

A stored procedure that activates when data is added, edited or deleted from a table

A set of T-SQL statements designed to perform a set task similar to a macro

An object assigned to a column which defines a value to be used if nothing is entered

An object assigned to a column which defines how data can be added

Answer

Correct Answer: An object assigned to a column which defines a value to be used if nothing is entered

Note: This Question is unanswered, help us to find answer for this one

An extent is a block of .... pages

Answer

Correct Answer: 8

Note: This Question is unanswered, help us to find answer for this one

Constraints are

A way of organising data in a table

Precompiled queries that are stored in the database

A way of providing a different perspective on data stored in the database

A way of checking that inserted values are within an acceptable range

Default values for fields that have not been filled in

Answer

Correct Answer: A way of checking that inserted values are within an acceptable range

Note: This Question is unanswered, help us to find answer for this one

Which of the following is part of an administrative policy to secure a database?

All of these

Ensure appropriate responses rates are in external maintenance agreements

Authentication policies

Limiting particular areas within a building to only authorized people

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one