Parallel & Distributed Database
Quiz
•
Computers
•
University
•
Practice Problem
•
Hard
harshali patil
Used 36+ times
FREE Resource
Enhance your content in a minute
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 Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
15 questions
IWP Digital Assignment 3
Quiz
•
University
20 questions
Cloud Deployment
Quiz
•
University
15 questions
Software Engineering Chapter 2
Quiz
•
University
20 questions
икт 21-40
Quiz
•
1st Grade - University
20 questions
Skill Competition Quiz 2024
Quiz
•
10th Grade - University
20 questions
SOFTWARE 7I
Quiz
•
7th Grade - University
20 questions
DBTHON-23 Round-1
Quiz
•
University
15 questions
Chapter 8 - Memory Management Strategies
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
