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!
Describe five main functions of a database administrator.
Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Generally, these include:
a) Recoverability - Creating and testing Backups
b) Integrity - Verifying or helping to verify data integrity
c) Security - Defining and/or implementing access controls to the data
d) Availability - Ensuring maximum uptime
e) Performance - Ensuring maximum performance
f) Development and testing support - Helping programmers and engineers to efficiently utilize the database.
Describe the host language? Host Language: You could write applications along with SQL statements embedded inside a host language. The SQL statements give the database inter
Describe a technique for direct search? Explain how data is stored within a file so which direct searching can be performed. For a file of unordered fixed length records by u
what is multivalued dependency
Explain outer join? Outer Join - If there are any values in one table which do not have corresponding value(s) in the other, in an equi-join which will not be chosen. Such ro
What is called an evaluation primitive? A relational algebra operation annotated with instructions on how to evaluate is known as an evaluation primitive.
Why 'AS' clause is used in SQL ? 'As' clause is used for Rename operation. ‘AS' clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)
Define Two phase commit Two phase commit: To make sure atomicity, all the sites where a transaction is being executed must agree on the final outcome of the execution. The tran
The need for three level architecture The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.
Explain Relational model and their use in DBMS? Relational Model - The relational model was first introduced through E.F. Codd of the IBM Research in the year of 1970. The mode
1) Information about a bank is about customers and their account. Customer has a name, address which consists of house number, area and city, and one or more phone numbers. Ac
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