Crowdly
Add to Chrome
MDM-DBMS
Looking for MDM-DBMS test answers and solutions? Browse our comprehensive collection of verified answers for MDM-DBMS at moodle.spit.ac.in.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
Query ___ is the activity performed in extracting data from the database.
Consider the SQL statement(s) below:
S1:
CREATE table employees( emp_id number(2), first_name varchar2(20), last_name varchar2(20)) ;
S2:
SELECT instructor.ID, department.dept_name FROM instructor, department
WHERE instructor.dept_name = department.dept_name AND department.budget >
95000
Identify the correct statement.
An entity is a real-world object distinguishable from other objects, and it is described as a set of relationships
As soon as the queries are translated, they are evaluated and various ___ transformations are performed.
Consider the following transaction to transfer 50 rupees.
Step
|
Operation
|
1
|
Read(A)
|
2
|
A=A-50
|
3
|
Write (A)
|
4
|
Read(B)
|
5
|
B=B+50
|
6
|
Write (B)
|
Which will be the state of transaction after 3
If an entity appears in only one relationship, then it is
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?
Given an instance of the Employee relation as shown below:
EID
|
EName
|
EEmail
|
EAge
|
ESalary
|
2345
|
Shah
|
shah@math
|
X
|
94000
|
1287
|
Roopal
|
Roopal@ee
|
29
|
95000
|
7853
|
Shah
|
shah@cse
|
29
|
94000
|
9876
|
Swati
|
swati@mech
|
28
|
93000
|
8765
|
Paresh
|
Paresh@civil
|
29
|
87000
|
For (EName,EAge) to be a key for this instance, the value X should NOT be equal to ________.
What is/are the step(s) involved in fetching the data from the database in query processing?