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!
The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but that's not an unique situation because it does not create the database structure very flexible for controlling access to storage for different accounts, putting the database on different storage disk drives, or backing up and restoring just phase of the database. You must have at least one database file but generally, more than one file are needed. In terms of accepting and using the data in the other objects and tables, the number of the folders is immaterial. The database files are not variable in size and never goes bigger than the size at which they were prepared
What is known as fudge factor? The number of partitions is enhanced by a small value called the fudge factor, which is usually 20 percent of the number of hash partitions compu
a set of possible data value of an attribute is called??
Oracle & Distributed Databases 1. Differentiate between PL/SQL functions and procedures. 2. Draw the diagram of logical structure of oracle database and explain it in brief.
What is transaction? Collections of operations that form a single logical unit of work are known as transactions.
Consider the following database containing five transactions. Let min_sup = 60%. Mine all frequent itemsets using Apriori and FP-growth algorithm. Compare the efficiency of the t
What is a hash index? A hash index organizes the search keys, with their associated pointers, into a hash file structure.
What is a data dictionary? A data dictionary is a data structure which keeps Meta data about the structure of the database i.e. the schema of the database.
What is the difference between serial and sequential files? How searching is applied on both? Ans: A serial file is one where the records have been stored in the order where
Creating views with Replace option : This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted o
What is conceptual schema? The schemas at the view level are known as subschema that describe dissimilar views of the database.
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