If a transaction does not modify the database until it has committed it is said to use a _______ modification technique
a) Immediate
b) Deferred
c) More than one of the mentioned
d) None of the mentioned
Q.2.
The dependency rules specified by the database designer are known as _______
a) Functional dependencies
b) Designer dependencies
c) Database rules
d) None of the mentioned
Q.3.
During the _______ phase, the local variables that hold the write operations are copied to the database
a) Validation phase
b) Write phase
c) Read phase
d) None of the mentioned
Q.4.
What is the format of entering date into a database while inserting data into it?
a) “YYYY-MM-DD”
b) YYYY-MM-DD
c) “DD-MM-YYYY”
d) ‘YYYY-MM-DD’
Q.5.
What does the following query do?
UPDATE student
SET marks = marks*1.10;
a) It decreases the marks of all the students by 90%
b) It increases the marks of all the students by 10%
c) It is syntactically wrong
d) It increases the marks of all the students by 110%
Q.6.
Which of the following cannot be used to modify the data in a database?
a) delete
b) update
c) drop
d) insert
Q.7.
Observe the given SQL query and choose the correct option.
SELECT database_name, RDBMS (DISTINCT bankuser_name)
FROM depositor, account
WHERE depositor.account_number = account.account_number
GROUP BY branch_id
a) The query is syntactically correct and gives the correct answer
b) The query is syntactically wrong
c) The query is syntactically correct but gives the wrong answer
d) The query contains one or more wrongly named clauses
Q.8.
for each tuple tr in r do begin
FOR each tuple ts IN s do BEGIN
test pair (tr , ts ) TO see IF they satisfy the JOIN condition _
IF they do, ADD tr • ts TO the RESULT;
END
END
a) Block nested loop join
b) Nested loop join
c) Hash join
d) Equi join
Q.9.
Choose the correct option regarding the query
SELECT branch_name, COUNT (DISTINCT customer_name)
FROM depositor, account
WHERE depositor.account_number = account.account_number
GROUP BY branch_id
HAVING avg(balance) = 10000;
a) The having clause allows only those tuples that have an average balance of 10000
b) The having clause checks whether the query result is true or not
c) The having clause does not check for any condition
d) None of the mentioned
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.