Parallel & Distributed Database
Authored by harshali patil
Computers
University
Used 36+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A data block is?
The place where all deleted records are persisted
The smallest logical storage unit for a database object
The largest logical storage unit ever available for any database block
All of the above
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The ____________ contains a set of tables and views that Oracle uses as a reference to the database?
PGA
Data Dictionary
SGA
Library cache
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
____________ is an area on disk which comprises of one or more disk files?
A partition
Heap
A package
A table space
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the use of an index?
Retrieve data more quickly and efficiently
Simplify the user’s perception of data access
Related data requires much less I/O overhead if accessed simultaneously
All of them
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Partition description identifying partition bounds.
Range Partition
Hash Partition
List Partition
Range-Hash Partition
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which partitioning methods can be used for index-organized tables?
Range Partition
Hash Partition
List Partition
All the above
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Oracle instance can have following tablespaces
System
Temp
Users
Undo
All the above
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
