WorksheetsParallel & Distributed Database
Total questions: 20
Worksheet time: 10mins
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
The ____________ contains a set of tables and views that Oracle uses as a reference to the database?
PGA
Data Dictionary
SGA
Library cache
____________ is an area on disk which comprises of one or more disk files?
A partition
Heap
A package
A table space
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
Partition description identifying partition bounds.
Range Partition
Hash Partition
List Partition
Range-Hash Partition
Which partitioning methods can be used for index-organized tables?
Range Partition
Hash Partition
List Partition
All the above
Oracle instance can have following tablespaces
System
Temp
Users
Undo
All the above
The table space used for keeping data dictionary and oracle data
Temp
Undo
System
None of these
The tablespace used for execution of query for keeping temporary data like intermediate data generated for sorting operation is
System tablespace
Undo tablespace
Temp tablespace
All the above
In case of _____ partitioning, partition key is defined and partition is defined using partition boundary in the ascending order.
hash
interval
range
list
Consider the following statement
CREATE TABLE emp (
empno NUMBER(4),
ename VARCHAR2(30),
sal NUMBER
)
PARTITION BY RANGE(empno) (
partition e1 values less than (1000) tablespace ts1,
partition e2 values less than (2000) tablespace ts2,
partition e3 values less than (MAXVALUE) tablespace ts3
);
In above EMP table if following record inserted, in which partition it will be available?
insert into emp values(1890,'Sudha',55000);
e1
e2
e3
None of these
Consider the following
CREATE TABLE emp (
empno NUMBER(4),
ename VARCHAR2(30),
sal NUMBER
)
PARTITION BY RANGE(empno) (
partition e1 values less than (1000) tablespace ts1,
partition e2 values less than (2000) tablespace ts2,
partition e3 values less than (MAXVALUE) tablespace ts3
);
In above EMP table if following record inserted, in which partition it will be available?
insert into emp(ename) values('Shnaya');
e1
e2
e3
Error will occur
Hash partitioning is a partitioning technique where a ______ key is used to distribute rows evenly across the different partitions
primary
foreign
hash
unique
Consider the following
CREATE TABLE myemp_work (
empno NUMBER PRIMARY KEY,
ename VARCHAR2(30),
salary NUMBER(8,2),
deptno NUMBER)
PARTITION BY LIST (deptno) (
PARTITION part1 VALUES (10),
PARTITION part2 VALUES (20),
PARTITION part3 VALUES (30,40));
If record inserted is (1000,'Mahi',75000,15) in which partition it will be inserted?
part1
part2
part3
Error will occur
Following syntax can be used to partition an existing table
ALTER TABLE ... EXCHANGE PARTITION ...
ALTER TABLE ... MODIFY PARTITION ...
ALTER TABLE ... RENAME PARTITION ...
ALTER TABLE ... SPLIT PARTITION ...
Which of the following is type of distributed DB?
Homogeneous only
Heterogeneous only
Homogeneous and Heterogeneous
None of these
Which of the following is not an architecture of parallel DB?
Shared Nothing
Shared Memory
Shared Time
Shared Disk
What are the types fragmentation in distributed database?
Horizontal and Vertical
Range and List
Vertical and Tuple
None of these
To facilitate connections between the individual databases of a distributed database, Oracle uses database links. A database link defines a "path" to a remote database and the syntax to create database link is
CREATE OR REPLACE DATABASE LINK <linkname> CONNECT TO -----
CREATE DATABASE LINK <linkname> CONNECT TO -----
ADD DATABASE LINK <linkname> CONNECT <username> ----
None of these
You can create copies of data at the various sites of a distributed database to make access to data faster for local clients, is called
Fragmentation
Segmentation
Replication
Data Sharing
