Q.1
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
0 h : 0 m : 1 s