• Placement Questions
• /
• DBMS

Frequently Asked DBMS interview questions and answers for freshers

(#M40152808) DBMS QUESTION Keep an EYE

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

Asked In DBMS Puja Bhowmick (6 years ago)

Unsolved Read Solution (4)

Is this Puzzle helpful?   (11)   (4) Submit Your Solution Technical

(#M40164839) DBMS QUESTION SQL Keep an EYE

In SQL, what does the query SIGN(-50) will produce the output??

Asked In DBMS Sapna (4 years ago)

Unsolved Read Solution (4)

Is this Puzzle helpful?   (11)   (2) Submit Your Solution

(#M40155921) DBMS QUESTION Keep an EYE

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

Asked In DBMS Tushar Borole (6 years ago)

Unsolved Read Solution (7)

Is this Puzzle helpful?   (89)   (56) Submit Your Solution

(#M40039454) DBMS QUESTION Keep an EYE

Anil is designing a database of motor vehicles. It has one base entity ‘Vehicles’ which is classified into two sub-entities, 2 wheeler and 4 wheeler. He further breaks them down into more entities. What is the process being used here?
o Generalization
o Specialization
o Aggregation
o Segregation

Asked In DBMS PRANJALI SHARMA (7 years ago)

Unsolved Read Solution (32)

Is this Puzzle helpful?   (71)   (37) Submit Your Solution Technical

(#M40030356) DBMS QUESTION DBMS Keep an EYE

What are constraints on generalization and
specialization?

Asked In DBMS MAN (8 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (5)   (1) Submit Your Solution Cryptography

(#M40030399) DBMS QUESTION DBMS Keep an EYE

What are a virtual machines and site their advantages?

Asked In DBMS MAN (8 years ago)

Unsolved Read Solution (2)

Is this Puzzle helpful?   (14)   (4) Submit Your Solution Technical

(#M40164799) DBMS QUESTION Difference between DBMS and Big Data Keep an EYE

What is use of DBMS and Big Data and What is the difference between them?

Asked In DBMS jayakumar (4 years ago)

Unsolved Read Solution (3)

Is this Puzzle helpful?   (11)   (1) Submit Your Solution Interview

(#M40157363) DBMS QUESTION DBMS query Keep an EYE

how to print 3rd highest salary in tha salary table?

Asked In DBMS muthukumar (5 years ago)

Unsolved Read Solution (7)

Is this Puzzle helpful?   (9)   (3) Submit Your Solution Technical

(#M40038106) DBMS QUESTION Keep an EYE

In order to use a record management system

a. you need to understand the low level details of how information is stored

b. you need to understand the model the record management system uses

c. bother a and b

d. none of the above

Asked In DBMS Ramya (8 years ago)

Unsolved Read Solution (8)

Is this Puzzle helpful?   (14)   (7) Submit Your Solution Database

(#M40030366) DBMS QUESTION DBMS Keep an EYE

What are the type of locks ?

Asked In DBMS MAN (8 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (0)   (0) Submit Your Solution Technical