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!
When are they useful? Justify with an example.
The temporary tables are commonly used to support specialized rollups or exact application processing needs. Unlike a permanent table, a space is not allocated to a temporary table while it is established. Space will be dynamically allocated for the table as rows are inserted. The
CREATE GLOBAL TEMPORARY
TABLE command is used to create a temporary table in Oracle.
CREATE GLOBAL TEMPORARY TABLE (
) ON COMMIT {PRESERVE|DELETE} ROWS;
What is called a query -execution engine? The query implementation engine takes a query evaluation plan, implements that plan, and returns the answers to the query.
Single-Valued Dependencies A database is a collection of related information and it is therefore inevitable that some items of information in the database would depend on some
Explain sorted File with advantages? Sorted file The sort utility shall perform one of the subsequent functions: 1.Sort lines of all the named files together and write the
What is a hashing function? What are the properties of a good hashing function? Describe the folding technique for hashing functions. Ans: Hashing function is a method
Which data type can store unstructured data? Raw data type can store unstructured data.
Define DBA database administrator? DBA : A database administrator (DBA) is a person who is responsible for the environmental aspects of a database. In common, these involves:
Example - ALTER TABLE emp MODIFY (empno NUMBER (7));
Identify the need and use of data control through problem solving, illustration
What types of adjustments are required to increase chances of inheritance. a) Some attributes can be added or ignored in the base class operation b) Some changes can be
List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view
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