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 difference between TRUNCATE and DELETE?
- Truncate can't be rolled back whereas Delete can be.
- Truncate keeps the lock on table whereas Delete keeps the lock on each row.
- Truncate resets the counter of the Identity column whereas Delete doesn't do so.
- Trigger is not fired in Truncate whereas it happens in Delete.
what is difference between circular inked lust and grunded linked list
Describe the definition of a transaction in SQL Ans: The SQL transaction starts implicitly. Transactions are finished by either Commit work that commits the transaction and st
System level permissions : With the use of data dictionary you can view them. Let us take the table name as user_sys_privs (used in oracle). DESCRIBE USER_SYS_PRI
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
Fifth Normal Form (5NF) These relations still have a difficulty. While defining the 4NF we mentioned that all the attributes depend upon each other. Whereas creating the two ta
Why do you go for sorting your query results? SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order
In an organization several projects are undertaken. Each project can employ one or more employees. Each employee can work on one or more projects. Each project is undertaken on the
Project Description: This is going to be a School portal to handle each activities in school such as, School fees payment, online registration and every other payment, course re
Explain the Exec statement in SQL Ans: Exec statement has the structure EXEC SQL END-EXEC Embeded SQl statements are of a form identical to non embedded SQL statem
Three way to handle missing field val
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd