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!
Using Literal Character String
Example:
To print IS A as one string with column name employee
SELECT ENAME || ' IS A ' || JOB AS "EMPLOYEE" FROM EMP;
Define check point and its impact on data base recovery. Ans: There could be hundreds of transactions handled per minute, in a large on-line database system.
What is the use of unique function? UNIQUE function: If UNIQUE is specified then only unique values are used to computed the mean.
What is an ER diagram? Why is it used in Database management system (DBMS)?
E-R model uses this symbol to represent weak entity set ? A Doubly outlined rectangle symbol is used to represent weak entity set.
Log based recovery: Let us first describe the term transaction log in the context of DBMS. A transaction log is a record in DBMS that remains track of all the transactions of a dat
(a) Provide the description of the following ODMG schema in the Object Definition Language (ODL). (b) Based on the above object database, write the following queries i
1. Which model is used to store data in tree structures Ans: Hierarchical model is used to store data in tree structures
Benefits and limitations
Describe the two alternatives for specifying structural constraints on relationship kinds? Relationship kinds have certain constraints in which limit the possible combination o
#A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six mont
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