CSC 2663 - Database administrative Functions

"All the attribute names and characteristics for each table in relational database is found in the data _____________.

• dictionary

• definition

• manipulation

• model

Company __________ kept all details about database maintenance that consist maintenance date, lisense key, issues, updates personal and resolution.

• live system

• run book

• sand box

• warm site

In some situations, DBA might split a table into multiples tables. Which of the following is the best reason on why there is a need for changing the design?

• To prevent from virus attack

• Easier to back up

• Easier to train the user

• To improve performance of database

"It could help to increase accessing time, provide faster storage, provide faster network connections and improve updates. Those are best describe about __________.

• archiving

• performance turning

• testing

• database design

Training is importance for all database users. Which of the following is the DBA's responsibility towards training?

• Review the new release version

• Provide training to vendor

• Handle the scheduling of coaching

• Provide payment to vendor

Separate system that is used by a DBA and programmer to modify the existing program is known as test system

• True

• False

The function of live system is similar to test system.

• True

• False

In order to ensure all the employees of an organization are knowledgeable and efficient, there is a need for testing.

• True

• False

Test system are also known as ____________.

• test box

• sand box

• cool box

• seed box

The place where records of certain corporate data are kept for future reference is data catalogue.

• True

• False