Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Database Administrator
One of the main perpose for having the database management system is to have control of both data or programs accessing that data. The person having like control over the system is called as the database administrator (DBA). The DBA administers the 3 stages of the database and tells the global view or conceptual level of the database. The DBA also displays the external view of the applications and several users and is responsible for the definition and execution of the internal level, as well as the storage structure and access techniques to be used for the optimum performance of the DBMS. A modification to any of the 3 levels due to varies in the organisation and/or emerging technology is under the control of the DBA.
Mappings among the internal and the conceptual levels, as well as between the conceptual and external levels, are also describe through the DBA. The DBA is responsible for granting permission to the users of the database and remainsthe profile of each user in the database. This profile defines the permissible activities of a user on that portion of the database accessible to the user through one or more user views. The user profile could be used by the database system to confirm in which a particular user can present a given operation on the database.
The DBA is also responsible for describing procedures to recover the database from natural, failures due to human, or hardware causes along with minimal loss of data. This recovery procedure should permit the organisation to continue to function and the intact portion of the database has to continue to be available.
Therefore, the functions of DBA are:
What are the Objectives of Advance object design After this unit, you shall be able to: combine three OOAD models to obtain operations on the classes; develop algo
How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with
Describe Embedded Query Language? Embedded Query Language - A query language (e.g., SQL) can be implemented in two ways. It can be used interactively or embedded within a host
#quCreate a database design specification (Enhanced Entity Relationship Diagram (EERD) and Relational Data Model (RDM)) from the given business description. The RDM must be in 3rd
What is Identity? Identity (or AutoNumber) is a column that automatically produces numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID
Aggregation : One limitation of the E-R diagram is that they do not permit representation of relationships between relationships. In such a case the relationship along with its ent
how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples
Dependency Preservation It is obvious that the decomposition must be lossless so that we do not lose any information from the relation that is decomposed. Dependency preservati
What is Candidate Key Super Key or Candidate Key: It is such an attribute of a table that can uniquely recognize a row in a table. Generally they have unique values and can n
What is meant by buffer blocks and disk buffer The blocks residing temporarily in main memory are referred to as buffer blocks. The area of memory where blocks reside t
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd