what dba activities support end users? course hero

How does the dba interACT with the end user?

Dec 10, 2019 · This preview shows page 14 out of 14 pages. 2. Explain user requirements gathering as part of the DBA's end-user support services. ANS: The DBA must work with end users to help gather the data required to identify and describe their present and future information needs. The DBA’s communication skills are important in working closely with ...

What are the most time-consuming DBA activities?

• Managing the training and support of DBMS users: One of the most time-consuming DBA activities is teaching end users how to properly use the database. The DBA must ensure that all users accessing the database have a basic understanding of …

What does a DBA do?

1.5 What are the different types of database end users? Discuss the main activities of each. Naïve Users. These users do not know how to operate a database management system and also have no skills on making requests from database directly. Naïve users access the database through given GUIs that has readable menu items to extract data from the database. Sophisticated Users.

What are the technical activities of a Database Administrator (DBA)?

May 25, 2015 · 16. What are the DBA's managerial roles? Describe the managerial activities and services provided by the DBA. See section 15.5.1, especially Table 15.3. 17. What DBA activities are used to support the end user community? See Section 15.5.1. 18. Explain the DBA's managerial role in the definition and enforcement of policies, procedures, and ...

How does a DBA interact with the end user?

The DBA interacts with the end user by providing data and information support services to the organization’s departments. Because end users usually have dissimilar computer backgrounds, end-user support services include:

What is the function of a DBA?

The DBA function also provides data-modeling and design services to end users. Such services are often coordinated with an application development group within the data-processing department. Therefore, one of the primary activities of a DBA is to determine and enforce standards and procedures to be used.

Why is data backup and recovery important?

When data are not readily available, companies face potentially ruinous losses. Therefore, data backup and recovery procedures are critical in all database installations. The DBA must also ensure that the data in the database can be fully recovered in case of physical data loss or loss of database integrity.

What is a DBA in DBMS?

The DBA defines and enforces the procedures and standards to be used by programmers and end users during their work with the DBMS. The DBA also verifies that programmer and end-user access meets the required quality and security standards. The DBA activities portrayed in the above figure suggest the need for a diverse mix of skills.

Why is a DBA important?

The DBA is responsible for ensuring that the data are distributed to the right people, at the right time, and in the right format. The DBA’s data distribution and use tasks can become very time-consuming, especially when the data delivery capacity is based on a typical applications programming environment, where users depend on programmers to deliver the programs to access the data in the database. Current data distribution philosophy makes it easy for authorized end users to access the database. One way to accomplish that task is to facilitate the use of a new generation of more sophisticated query tools.

What is the role of a DBA in a database?

Therefore, the DBA must work with both application programmers and end users to teach them the database standards and procedures required for data quality, access, and manipulation.

What is the DBA strategy?

A prime component of a successful data administration strategy is the continuous enforcement of the policies, procedures, and standards for correct data creation, usage, distribution, and deletion within the database. The DBA must define, document, and communicate the policies, procedures, and standards before they can be enforced.

How to cancel a subscription on iTunes?

Log in to your account and hover over your profile picture to and go to your Account Settings. Click the Stop Recurring Membership button. Follow the instructions on the page to confirm cancellation. If you signed up through iTunes, you can cancel your subscription directly through your iTunes account. Contact Apple directly for any billing related ...

Can you cancel Course Hero?

You can cancel your Course Hero recurring subscription at any time to stop further charges. Please note: This will not automatically refund any new or recent recurring charges. If you signed up through our Course Hero website, f ollow these steps to cancel your recurring subscription: Log in to your account and hover over your profile picture ...