Data dictionary & Training

What does the data dictionary primarily contain?

• Application configurations

• User credentials

• Metadata about the database

Which of the following is included in the data dictionary details?

• Security permissions

• Backup schedules

• Information about tables, fields, indexes, programs, and users

Who is responsible for changes to the naming conventions in a data dictionary?

• System Analyst

• IT Manager

• Database Administrator (DBA)

Data integrity rules help maintain:

• The quality of data stored

• The integrity of developer

• Security policies

Which of the following is an example of a data integrity constraint?

• Tables without primary keys are acceptable

• Allowing duplicate entries in primary keys

• "Username" and "Password" fields cannot be null

What is the main purpose of training in database management?

• To upgrade the DBMS

• To ensure financial audits are completed

• To distribute knowledge to users on how to use the database and DBMS

What should the DBA handle if training is provided by a vendor?

• Scheduling the workshop sessions

• Managing the budget

• Schedule the vendor

What is a DBA's role in training content?

• Oversee HR recruitment

• Build hardware configurations

• Manage appropriate training content according to user types

What is the first step in a DBMS evaluation process?

• Creating a checklist and determining weightage

• Installing the DBMS

• Contacting other organizations for feedback

What happens after a DBMS is selected and purchased?

• The software development cycle begins.

• DBA distribute the user manual to all users

• The DBA configures and installs the DBMS.