Advanced Database Management Systems Quality Assesment

The given Query can also be replaced with_______:

SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID;

• Select name,course_id from teaches,instructor where instructor_ID=course_ID;

• Select name, course_id from instructor natural join teaches;

• Select name, course_id from instructor;

• Select course_id from instructor join teaches;

List different types of distributed data DBMS architectures

• The different types of distributed database architectures include client-server architecture, peer-to-peer architecture, and multi-tier architecture.

• Relational architecture, NoSQL architecture, Object-oriented architecture

• Single-tier architecture, Two-tier architecture, Three-tier architecture

• Centralized architecture, Decentralized architecture, Hybrid architecture

A deadlock exists in the system if and only if the wait-for graph contains a ___________.

• Cycle

• Direction

• Bi-direction

• Rotation

Identify the procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?

• Record controller

• Exclusive lock

• Authorization rule

• Two phase lock

Identify the query that deletes all tuples in the instructor relation for those instructors associated with a department located in the Watson building which is in department relation?

• DELETE FROM instructor WHERE dept_name IN 'Watson';

• DELETE FROM department WHERE building='Watson';

• DELETE FROM instructor WHERE dept_name IN (SELECT dept name FROM department WHERE building = ’Watson’);

• None

Identify the major advantage of horizontal fragmentation in distributed databases?

• Increased data availability

• Improved query performance

• Reduced network traffic

• Enhanced data security

Identify the encryption type that uses the same key for both encryption and decryption.

• Asymmetric encryption

• Symmetric encryption

• Public-key encryption

• Hashing

Identify the spatial data type that is used to represent a continuous surface, such as temperature or elevation?

• Point

• LineString

• Polygon

• Raster

Identify the spatial index structure that is effective for indexing data in multi-dimensional spaces

• R-tree

• Quadtree

• Grid file

• Kd-tree

Which of the following is NOT a fundamental principle of database security?

• Authentication

• Authorization

• Encryption

• Normalization