BARC 2020: DBMS Nuclear Quiz 2 (App update required to attempt this test)
Attempt now to get your rank among 853 students!
Find the loan details for Branch name Alipore and Loan amoun is greater than 5000 in tuple realtonal calculus from the given relation schema.
And a SQL query →
FROM A GROUP BY Group_id. Value of SUM(payable_amount)
The minimum number of tables required if attribute a22 is a composite attribute?
Now consider the following query-
Select name from student where P>80 and M<50;
Number of Output after executing above query will be:
A) Relational calculus is equivalent to relational algebra in its capabilities.
B) Relational calculus is stronger than relational algebra.
C) Relational calculus is weaker than relation algebra
D) It is based on predicate calculus of formal logic.
Number of elements in the output of the following query?
A name,Age(R Place=’Mumbai’(Employee (Natural Join) City))
1 for 1NF, 2 for 2 NF, 3 for 3NF and 4 for BCNF. If Anything, else write
AB -> C
C -> D
CD -> BE
- 853 attempts
- 1 upvote
- 3 comments