A SECTION

What is Distributed Database Management System? Discuss some problems to which subjects to DDBMS.     

2. Differentiate between Single-Site Processing Single-Site Data (SPSD) and Multi-Site Processing Multi-Site Data (MPSD).     
Answer:

3. Discuss the methodologies of Data Replication in Distributed Database Management System.     

4. Explain the difference between File Server and Client Server architecture.    

5. Explain the Allocation Algorithms in DDBMS. Discuss the factors leading to different types of Algorithms.     

6. Discuss the following components of DDBMS 
Transaction Processor

Application Processor

Transaction Manager

Data Processor

Data Manager    

B SECTION

Case Detail:  
Case Study
Consider the following relation.
EMPLOYEE (EMP, NAME, ADDRESS, SKILL, PROJ-ID)
EQUIPMENT (EQP-ID, EQP-TYPE, PROJECT)
Suppose that EMLOYEE relation is horizontally fragmented by PROJ-ID and each fragment is stored locally at its corresponding project site.  Assume that the EQUIPMENT relation is stored in its entirely at the Tokyo location.  Describe a good strategy for processing each of the following queries:

Find the join of relations EMPLOYEE and EQUIPMENT.

2.     Get all employee for projects using EQP-TYPE as "Welding Machine". 

3.     Find all employees of the project using equipment number 110.

C SECTION

Question No.  1     Marks - 10 
________________________________________
  
    ____ is used to reveal the meaning of data.    
  
Options     
    
Raw facts 

Knowledge 

Formatting 

Information 

Question No.  2     Marks - 10 
________________________________________
  
 ____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.    
  
Options     
    
Queries 

End-user data 

Metadata 

Information                    (Solved by www.solvezone.in ; please do not copy, plagiarism warning; contact: 8882309876)

Question No.  3     Marks - 10 
________________________________________
  
A(n) ____ might be written by a programmer or it might be created through a DBMS utility program.    
  
Options     
    
Query 

operating system 

database management system 

application program

Question No.  4     Marks - 10 
________________________________________
  
A(n) ____ database is used by an organization and supports many users across many departments.    
  
Options     
    
Desktop 

Workgroup 

enterprise 

transactional

Question No.  5     Marks - 10 
________________________________________
  
 A ____ database supports data distributed across several different sites.    
  
Options     
    
single-user 

Multiuser 

centralized 

distributed

Question No.  6     Marks - 10 
________________________________________
  
A workgroup database is a(n)____ database.    
  
Options     
    
single-user 

Multiuser 

enterprise 

distributed 

Question No.  7     Marks - 10 
________________________________________
  
 Most decision-support data are based on historical data obtained from ____.    
  
Options     
    
operational databases 

data warehouses 

enterprise databases 

workgroup databases 

Question No.  8     Marks - 10 
________________________________________
  
 The relational data model was developed in the ____.    
  
Options     
    
1960s 

1970s 

1980s 

1990s 

Question No.  9     Marks - 10 
________________________________________
  
The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.    
  
Options     
    
hierarchical 

network 

object-oriented 

entity relationship 

Question No.  10     Marks - 10 
________________________________________
  
 The relational model’s creator, E. F. Codd, used the term relation as a synonym for ____.    
  
Options     
    
index 

Key 

table 

relationship

Question No.  11     Marks - 10 
________________________________________
  
The set of possible values for an attribute is a ____.    
  
Options     
    
Domain 

Range 

set 

Key 

Question No.  12     Marks - 10 
________________________________________
  
 ____ attributes can have several values.    
  
Options     
    
Composite 

Simple 

Single-valued 

Multivalued 

Question No.  13     Marks - 10 
________________________________________
  
 Making sure all ____ are identified is a very important part of a database designer’s job.    
  
Options     
    
business rules 

cardinalities 

derived attributes 

relationships

Question No.  14     Marks - 10 
________________________________________
  
If an entity can exist apart from one or more related entities, it is said to be ____-independent.    
  
Options     
    
Existence 

Relationship 

business 

weak

Question No.  15     Marks - 10 
________________________________________
  
 If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship.    
  
Options     
    
Self 

self-referring 

looping 

Recursive

Question No.  16     Marks - 10 
________________________________________
  
 An attribute that is part of a key is known as a(n) ____ attribute.    
  
Options     
    
Important 
    
Nonprime 

prime 

entity

Question No.  17     Marks - 10 
________________________________________
 The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).     
  
Options     
    
subtype discriminator 

inheritance 

specialization hierarchy 

entity supertype 

Question No.  18     Marks - 10 
________________________________________
  
    ____ data refer to data whose values change over time and for which you must keep a history of the data changes.    
  
Options     
    
Time-sensitive 

Time-variant 

Historical 

Change-based 

Question No.  19     Marks - 10 
________________________________________
  
According to the data modeling checklist, ____ should clearly define participation and cardinality rules.    
  
Options     
    
Entities 

naming conventions 

relationships 

attributes

Question No.  20     Marks - 10 
________________________________________
  
Some RDBMS (like Oracle) will automatically ____ data changes when issuing data definition commands.    
  
Options     
    
ROLLBACK 

COMMIT 

UPDATE 

INVOKE

Question No.  21     Marks - 10 
________________________________________
  
    ____ requires that all operations of a transaction be completed.    
  
Options     
    
Specificity 

Atomicity 

Durability 

Time stamping

Question No.  22     Marks - 10 
________________________________________
  
 A single-user database system automatically ensures ____ of the database, because only one transaction is executed at a time.    
  
Options     
    
serializability and durability 

atomicity and isolation 

serializability and isolation 

atomicity and serializability

Question No.  23     Marks - 10 
________________________________________
  
 A(n) ____ condition occurs when two or more transactions wait for each other to unlock data.    
  
Options     
    
Deadlock 

exclusive lock 

binary lock 

two-phase lock

Question No.  24     Marks - 10 
________________________________________
  
     On the server side, the DBMS environment must be properly configured to respond to clients requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve that goal are commonly referred to as ____ tuning.    
  
Options     
    
client and server 

database 

SQL performance 

DBMS performance 

Question No.  25     Marks - 10 
________________________________________
  
 ____ is/are the central activity during the parsing phase in query processing.    
  
Options     
    
Database statistics 

Data sparsity 

SQL query 

Query optimization

Question No.  26     Marks - 10 
________________________________________
  
 The ____ must be set large enough to permit as many data requests to be serviced from cache as possible.    
  
Options     
    
data cache 

SQL cache 

sort cache 

optimizer mode

Question No.  27     Marks - 10 
________________________________________
  
   The ____ table space is used to store end-user data.    
  
Options     
    
System 

user data 

temporary 

rollback segment

Question No.  28     Marks - 10 
________________________________________
  
    ____ is a disadvantage of a DDBMS.    
  
Options     
    
Processor independence 

User-friendly interface 

Security 

Faster data access 

Question No.  29     Marks - 10 
________________________________________
  
    ____ is an advantage of a DDBMS.    
  
Options     
    
Reduced operating cost 

Simplicity of management and control 

Decreased storage requirements 

Decreased training cost 

Question No.  30     Marks - 10 
________________________________________
  
 ____ is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.    
  
Options     
    
Performance 

Fragmentation 

Location 

Local mapping

Question No.  31     Marks - 10 
________________________________________
  
   ____’s main goal is to provide a comprehensive and consistent definition of all data within an organization.    
  
Options     
    
DBMS 

OLAP 

Data warehousing 

MDM

Question No.  32     Marks - 10 
________________________________________
  
 One of the main characteristics of an OLAP system is ____.    
  
Options     
    
They use single-dimensional data analysis techniques 

They provide complex command-line end-user interfaces 

They provide minimal database support 

They support client/server architecture

Question No.  33     Marks - 10 
________________________________________
  
Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a ____.    
  
Options     
    
multi cube 

data matrix 

data cube 

hyper cube

Question No.  34     Marks - 10 
________________________________________
Computed or derived facts are sometimes called ____to differentiate them from stored facts.     
  
Options     
    
Details 

Attributes 

metrics 

fact tables 

Question No.  35     Marks - 10 
________________________________________
  
 A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.    
  
Options     
    
Snowflake 

starflake 

mesh 

matrix

Question No.  36     Marks - 10 
________________________________________
  
 A(n) ____is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.    
  
Options     
    
OLAP 

materialized view 

star schema 

data cube 

Question No.  37     Marks - 10 
________________________________________
  
Another name for a database server-side extension is ____.    
  
Options     
    
Web server 

Web application server 

star schema 

data cube

Question No.  38     Marks - 10 
________________________________________
  
 ____ are general statements of direction or action that communicate and support DBA goals.    
  
Options     
    
Standards 

Policies 

Documentation 

Procedures

Question No.  39     Marks - 10 
________________________________________
  
Classifying users into ____, according to common access needs, facilitates the DBA’s job of controlling and managing the access privileges of individual users.    
  
Options     
    
user groups 

sections 

authorization schemes 

policy definitions

Question No.  40     Marks - 10 
________________________________________
  
 A(n) ____ data dictionary is not updated automatically and usually requires a batch process to be run.    
  
Options     
    
Active 

passive 

static 

dynamic