Latest DBMS Aptitude Question SOLUTION: )Question on inner Join returning N- tuples & Full outer Join returns M- tuples. For both Variables are given & in options relationship is given to find whichever have greater

Follow Quotesrain

DBMS Question Papers:

DBMS Select Another Category Output Select Another Topic

Programming and Technical

DBMS Question Topics

Category (2)

HR Interview (1)

Interview(1)

Logical Reasoning (2)

Cryptography(1)
Decision Making and Problem Solving(1)

Programming (63)

Advertisements

Previous Question: employee(eno,ename) works_on(eno,pno,ename) project(pno, project) select ename from employee where eno in(select eno from works_on where pno =(select *from project) what is the output ? a)Employee who works on all project. b)Employee who works one project . c) name of employee who works on more than one project. d)Select ename from employee where salary = salary Next Question: What does isolation in Acid rules for transaction in database mean? a)either the effects of whole transaction is reflected on database or database is rolled back to its original state b)No transaction can interfere in the end result of another transaction c)effects of a successful transaction must persist in a database d)Every individual transaction must leave database in a cosistent state .maintaining the integrity of the database

(#M40152809) DBMS Programming question Keep an EYE

)Question on inner Join returning N- tuples & Full outer Join returns M- tuples. For both Variables are given & in options relationship is given to find whichever have greater tuples.And variable D is given----- a)then N= M b) N = M + D: Asked In DBMS Puja Bhowmick (8 years ago); Unsolved Read Solution (1); Is this Puzzle helpful? (6) (1) Submit Your Solution Output

Advertisements

Read Solution (1) :

Please Login to Read Solution.

Previous Question: employee(eno,ename) works_on(eno,pno,ename) project(pno, project) select ename from employee where eno in(select eno from works_on where pno =(select *from project) what is the output ? a)Employee who works on all project. b)Employee who works one project . c) name of employee who works on more than one project. d)Select ename from employee where salary = salary Next Question: What does isolation in Acid rules for transaction in database mean? a)either the effects of whole transaction is reflected on database or database is rolled back to its original state b)No transaction can interfere in the end result of another transaction c)effects of a successful transaction must persist in a database d)Every individual transaction must leave database in a cosistent state .maintaining the integrity of the database

Login
Register

Sponsored Links

Advertisements

Challenger of the Day

no image

Dimple

India

Punjab

Time: 00:01:33

Points

19

Maths Quotes

maths is the study of infinity in life

D . Kalyan Kumar

"Play the game with attitude, incase if you loose you will win the heart of the spectators and opponents"

Sandeep Upadhyay

Placed User Comments

M4Math helped me a lot.

Vipul Chavan 3 years ago

Thanks m4 maths for helping to get placed in several companies.
I must recommend this website for placement preparations.

yash mittal 4 years ago

2510K+Registerd user
1757K+Engineers
753K+MBA Asprirant
3K+Enginnering College
250+Company Exam
150K+Interview Questions

All rights are reserved to @m4maths.com