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 the responsibilities of the DBA and the database designer ?
The responsibilities of DBA and database designer are:1. Planning for the database's future storage needs2. Describing database availability and fault management architecture3. Defining and forming environments for development and latest release installation4. Creating physical database storage structures after developers have designed an application5. Constructing the database6. Determining and setting the physical and size locations of data files7. Evaluating latest hardware and software purchase8. Researching, testing, and recommending tools for Oracle development, database administration, modeling, and backup and recovery implementation, as well as planning for the future9. Giving database design and implementation 10.Understanding and employing the optimal flexible architecture to ease administration, permit flexibility within managing I/O, and to increase the capability to scale the system
Consider the table student and list names of students in the departments other than maths and computer. SELECT std_name FRM student WHERE dept_name NOT IN (‘Maths','Computer);
What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage
Consider the following relational schema: Doctor(DName,Reg_no) Patient(Pname, Disease) Assigned_To (Pname,Dname) Give expression in both Tuple calculus and Domain calculus for
database help
Example: Consider the following relations: ROLLNO NAME ADDRESS COURSE_ID 100 Ka
What are the uses of the information in the Data dictionary? The following information is directly taken from the Data dictionary: Information on fields displayed with
What is meant by object-oriented data model? The object-oriented paradigm is based on encapsulation of data and code related to an object in to a one unit, whose contents are n
what is attribute is attribute inheritance in dbms?
Explain P command in the respect of QBE? P: It is the command in which is used to print (logically display) the value of the attribute in whose cell it is writ
3NF Normal Form A relation schema R is in 3NF if it is in 2NF and for each FD X A either of the following is true X is a Super-key of R. A is a prime attribute of R
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