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.
What are the two main goals of parallelism? Load -balance multiple small accesses, so that the throughput of such accesses enhances. Parallelize large accesses so that the res
In case of entity integrity, the primary key may be declared? In a case of entity integrity primary key may be not Null.
Describe Query evaluation engine? Query Evaluation engine: Vehicle executes low-level instructions obtained through the DML compiler. The Storage Manager Components gives in
What are the ways of obtaining the connection parameters? Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters
Benefits of heap files 1. This is a easy file Organisation method. 2. Insertion is somehow capable. 3. Good for bulk-loading data into a table. 4. Best if file
Describe the algorithm for updating indices for a single level index when a record is (i) Inserted (ii) deleted What will be the modification if there are multilevel in
Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4
Single Valued Normalisation Codd in the year 1972 formed three normal forms (1NF, 2NF, and 3NF). These were based on functional dependencies between the attributes of a relati
Three Level Architecture of DBMS or Logical DBMS Architecture The logical architecture defines how data in the database is perceived by users. It is not deals with how the da
how to submit answers softcopy
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