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!
Explain five duties of Database Administrator?
1. DBA administers the three stages of the database and, in consultation along with the whole user community, sets up an definition of the global view or conceptual level of the database.2. Mappings among the internal and the conceptual stages, as well as among the conceptual and external levels, are also defined through the DBA.3. DBA ensures in which appropriate measures are in place to manage the integrity of the database and in which the database is not accessible to unauthorized users.4. DBA is responsible for granting permission to the users of the database and stores the profile of each user within the database.5. DBA is responsible for defining process to recover the database from failures along with minimal loss of data.
Define Serializable schedule Serializable schedule: An interleaved schedule of much more than one transaction is known as a serializable schedule, if it is equal to some serial
sql is relationally complete-justify
What are the three classes of SQL expression? SQL expression consists of three clauses: Select From Where
Attribute Preservation This is a easy and obvious necessity that includes preserving all the attributes that were there in the relation that is being decomposed.
Differentiate between a Global and a Local temporary table? - A local temporary table exists only for the duration of a connection or if defined inside a compound statement, fo
Give the reasons for allowing concurrency? The reasons for allowing concurrency is if the transactions run serially, a short transaction might have to wait for a preceding long
What are the kinds of Strings? -A binary string in MySQL is one that MySQL treats as case sensitive in comparisons. -A non binary string in MySQL is one that MySQL does'nt
A Functional dependency is described by X Y between two groups of attributes Y and X that are subsets of R specifies a constraint on the possible tuple that can make a relation
The participation Constraints shows whether the existence of an entity depends on its being associated to another entity by the relationship type. There are two kinds of participat
List the types of authorization. A) Read authorization B) Write authorization C) Update authorization D) Drop authorization
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: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd