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 the Role of a database administrator
a. Defining the Schema
The DBA describes the schema which consists of the structure of the data in the application.
The DBA defines what data needs to be present in the system ad how this data has to be denoted and organized.
b. Liaising with Users
The DBA wants to interact continuously with the users to understand the data in the system and its employ.
c. Defining Security & Integrity Checks
The DBA finds out about the access restrictions to be defined and demonstrates security checks accordingly. Data Integrity checks are as well defined by the DBA.
d. Defining Backup / Recovery Procedures
The DBA as well defines processes for backup and recovery. Defining backup procedures involves specifying what data is to backed up, the periodicity of taking backups and as well the medium and storage place for the backup data.
E. Monitoring Performance
The DBA has to incessantly check the performance of the queries and take measures to optimize all the queries in the application.
exercise solution
Secondary Indexes Let consider the student database and its clustering index and primary (only one will be applicable at a time). Now consider the state when the database is to
Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exist in the structure of LDB, and are being explained in the Database part of LD
Evaluate: a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation. b.
Define the following constraints for the table client. (i) BAL_DUE must be at least 1000. (ii) NAME is a unique key. (i)ALTER TABLE CLIENT ADD CONSTRAINT CLIENT_BAL_DUE_C1
Create table employee and enter employee data in SQL? Consider the following relational schemas: EMPLOYEE (EMPLOYEE_NAME, STREET, CITY) WORKS (EMPLOYEE_NAME, COMPANYNAME, SAL
If the deletion violates referential integrity constraint, then three alternatives are available: Default option: - refuse the deletion. It is the job of the DBMS to describ
CREATE YOUR DATABASE TABLES Your database project must have a minimum of four tables. Include the SQL scripts used to create the tables in your documentation. Explain the tables
What are the basic objects of the data dictionary? Tables Domains Data elements Structures Foreign Keys
What are the drawbacks of File Oriented System in details?
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