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!
What is magnetic disks?explain it?
Magnetic disk provides the bulk of secondary storage of modern computer system. The disk capacity is growing at over 50% per year. But the storage needs of large applications have also been growing very fast and in some case each faster than the growth rate of disk capacities. A large data base may need 100 of disks.
Physical characteristics of disk
Physical disks are relatively simple. Every disc platter has a flat circular shape
We can call magnetic disk as
Ø hard disk
Ø Floppy disk
The read write head keeps information on a sector magnetically as reversals of the direction of magnetization of the magnetic material. There might be hundreds of concentric tracks on a disc surface, having thousands of sectors.
What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.
write an SQL statement to create the database in MYSQL server
What is Trigger? A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are kept in and managed by the DBMS. Triggers a
For every multivalued attribute 'A', we make a new relation R that contains an attribute corresponding to plus the primary key attribute k of the relation that shows the entity typ
what is database management system? & why it is required?
Define Join and Outer Join and differentiate between them. Ans: Join - It generates all the combinations of tuples from two relations which satisfy a join condition. Oute
distributed quey processing
Discuss the term- Design Optimization We have seen various ways of representing the objects.The fundamental design model uses analysis model as the framework for implementati
What is Oracle Process? Explain any four processes started by Oracle. Oracle Process is as follows: SMON: The System Monitor carries out a crash recovery while a crashed in
Data Redundancy -A lot of information is being repeated in the relation. For instance, the information that MCS-014 is named SSAD is repetitive, address of Rahul is "D- 27, Main ro
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