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 are the different kinds of database end users? Discuss the major activities of each?
End-Users - End-users are the people whose jobs need access to the database for querying, updating, and generating reports; the database first and foremost exists for their use. The different types of end-users are:
Casual end-users - occasionally access the database, required different information each time
Naive or Parametric end-users - includes tellers, clerks, etc., make up a sizable portion of database end-users, major job function revolves around constantly querying and updating the database
Sophisticated end-users - involves engineers, scientists, business analyst, etc., use for their complex requirements
Stand-alone users - manage personal databases by using ready-made program packages, gives easy-to-use menu-based or graphics-based interfaces
Explain hash file organization? Hash functions a) The distribution is uniform Hash functions assign each bucket the similar number of search -key values from the set of a
Define the terms i) DDL ii) DML DDL: Data base schema is particular by a set of definitions expressed by a special language known as a data definition language. DML: A data
What is an Operand? The data on which the operation is to be performed is known as an Operand
Consider a table student (std_id, std_name, date_of_birth, percent_marks, dept_name). Write a QBE query to display names of Computer Science department students who have scored mo
What are the difference between clustered and a non-clustered index? A clustered index is a special type of index that reorders the way records in the table are physically stor
Short Note on mid Square Method of hashing? Mid square method of hashing: In the method midsquare hashing, the key is squared and the address selected from the center of the s
What is bucket overflow and how bucket overflow is handled through Over Flow Chaining or Closed Hashing? Ans: Bucket: unit of storage holding records. Bucket is a disk block
What are the drawbacks of shadow-paging technique? The drawbacks of shadow paging is:- a) Commit Overhead b) Data fragmentation c) Garbage collection
What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.
explain multi key file organisation
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