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!
Differance between DDL and SDL?
DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and mappings between these two. In a few DBMSs, a clear separation is maintained among conceptual schema and internal schema. In that case, DDL is used to exact the conceptual schema only. The other language, storage definition language (SDL) is used to specify the internal schema. The mappings among the two schemas may be specified in either one of these languages.
What is deadlock? Neither of the transaction can ever proceed with its normal implementation. This situation is known as deadlock.
Describe the four main ways of optimising disk block access. Ans: a. Disk b. Non-volatile writes buffers c. File organization (Clustering) d. Log-based file system
In an organisation various projects are undertaken. Each projects can employ one or more employees. Every employee can work on one or more projects. Each project is undertaken on
Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c
What are composite attributes? Composite attributes can be separated in to sub parts.
State the Steps of Object Design Object design is a very iterative process in which various classes, relationships among objects are added when you move from one level to
Difference between SQL and SQL*Plus SQL SQL*Plus SQL is a language SQL *Plus is an environment It is bas
What is serializability? Explain its types? The data base system must control concurrent implementation of transactions, to ensure that the data base state remains consistent.
Deadlock Prevention One of the easiest approaches for avoiding a deadlock would be to obtain all the locks at the begin of the transaction. Though, this approach restricts conc
What is horizontal fragmentation? Horizontal fragmentation divides the relation by assuming every tuple of r to one or more fragments
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