1.
Heap File Organization work with
(c) Data Blocks
2. New records are stored in another black when the current block of data is ____________
(b) Full
3. There are _______________ levels of independence.
(c) 3
4. What does heap file also known as _____________
(b) Unordered File
5. In a _____________ file, we must traverse the data from the beginning of the file until we get the requested record
if we want to search, update or delete the data.
(a) Sequential
6. Because there is no sorting or ordering of records, if the database is larger, it wil be very time consuming to
_________________ records
(d) All of the above
7. Tables in second normal form (2NF)
(a) Eliminate all hidden dependencies
8. Functional Dependencies are the types of constraints that are based on _________________
(a) Key
9. Which of the following makes the transaction permanent in the Database?
(b) Commit
10. Which one of the following is the assignment operator in oracle?
(a) =
11. An _________ value is generated and mapped to each primary key.
(c) Index
12. LIKE operators can be used in the WHERE clause for?
(c) Search for a pattern
13. The term attribute refers to a _______________ of a table
(b) Column
14. Records are stored in Files using ________________ a-like structure
(d) Tree
15. A technique for direct search is
b) Linear Search
16. Identify the one which is not the performance measure of disk?
(d) Circular Time
17. Identify the correct hierarchy
(a) Bit, Byte, Field, Record, File, Database
18. Identify the other word for the dynamic hashing
(b) Extended Hashing
19. Identify the correct reason for the bucket over
(c) Hash Function
NOTE: Correct answer should be “(d) All of these”
20. When a Hash function generate an address at which data is already stored, the next free bucket is allocated to it.
This mechanism is also known as
(b) Open Hashing
21. When buckets are full, a new bucket is allocated for the same hash result and is linked after the previous one, this
mechanism is known as
(a) Closed Hashing
22. Identify different types of file organizations
(d) All of these
23. Identify the option which is not the part of Hash File Organization
(a) Data Bucket
24. Identify the correct option, when a collection of data sets so large and complex that it becomes difficult to process
using on-hand database management tools or fractional data processing applications.
(c) Big Data
25. Which among the following do not produce Big Data?
(d) Students maintains their own data
26. Which of these are characteristics of Big Data?
(d) All of these
27. Identify three properties of a system as per the CAP theorem
(b) Concurrency, Availability, Partition
28. SQL databases are _________________ scalable whereas the NoSQL databases are _____________ scalable
(a) Vertically, Horizontally
29. SOL databases are primarily called as ______________ whereas NoSQL database are primarily called as _________
(b) Relational Databases, Non-relational Databases
30. Identify the examples of NoSQL databases from the following options
(d) All of these
31. Which of the following is not a type of database?
(d) Decentralized
32. ______________ is a hardware component that is most important for the operation of a database management
system.
(b) High speed, large capacity disk to store data
33. The traditional storage of data organized by the customer, stored in separate folder in filing cabinets is an example
of ______________ type of database management system.
(d) Hierarchical
34. Which of the following is a feature of a database?
(d) Store data in multiple locations
35. Which of the following is not a function of the database?
(d) Analysing code
