Parallel & Distributed Database

Quiz
•
Computers
•
University
•
Hard
harshali patil
Used 36+ times
FREE Resource
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
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
Database Management Systems Unit II Quiz

Quiz
•
University
22 questions
DP 900 - pt 6

Quiz
•
University
19 questions
Database Management Systems

Quiz
•
University
15 questions
Database concepts

Quiz
•
University
15 questions
DBMS

Quiz
•
University
20 questions
DBTHON-23 Round-1

Quiz
•
University
25 questions
Lvl 2 Relational Algebra

Quiz
•
University
18 questions
SQL Quiz

Quiz
•
University
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade