• 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 (4 years ago)

Unsolved Read Solution (4)

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

(#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 (5 years ago)

Unsolved Read Solution (29)

Is this Puzzle helpful?   (51)   (22) Submit Your Solution Technical

(#M40030366) DBMS QUESTION DBMS Keep an EYE

What are the type of locks ?

Asked In DBMS MAN (5 years ago)

Unsolved Read Solution (1)

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

(#M40030345) DBMS QUESTION DBMS Keep an EYE

What is difference between entity set and entity type?

Asked In DBMS MAN (5 years ago)

Unsolved Read Solution (3)

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

(#M40030396) DBMS QUESTION DBMS Keep an EYE

What are system calls?

Asked In DBMS MAN (5 years ago)

Unsolved Read Solution (2)

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

(#M40030374) DBMS QUESTION DBMS Keep an EYE

What is view serializable?

Asked In DBMS MAN (5 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (2)   (0) 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 (1 year ago)

Unsolved Read Solution (3)

Is this Puzzle helpful?   (6)   (1) Submit Your Solution

(#M40030383) DBMS QUESTION DBMS Keep an EYE

What are triggers?

Asked In DBMS MAN (5 years ago)

Unsolved Read Solution (3)

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

(#M40157363) DBMS QUESTION DBMS query Keep an EYE

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

Asked In DBMS muthukumar (2 years ago)

Unsolved Read Solution (5)

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

(#M40030399) DBMS QUESTION DBMS Keep an EYE

What are a virtual machines and site their advantages?

Asked In DBMS MAN (5 years ago)

Unsolved Read Solution (2)

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