DISTRIBUTED DATABASE SYSTEM
Note: Question serial number may be change. Kindly find and search.
Section A
1 . 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).
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
Section B
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:
1. 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.
Section C
Question No. 1 Marks - 10
________________________________________
1) ____ 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
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