MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Information Science
1000 Rdbms
Quiz 2
1
2
3
4
5
6
7
8
9
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
1
2
3
4
5
6
7
8
9
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page