• Placement Questions
• /
• DBMS
• /
• Programming

DBMS Programming Technical Interview Questions : Unsolved Question

(#M40157363) DBMS QUESTION DBMS query Keep an EYE

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

Asked In DBMS muthukumar (8 years ago)

Unsolved Read Solution (7)

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

(#M40152809) DBMS 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 (9 years ago)

Unsolved Read Solution (1)

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

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

Unsolved Read Solution (4)

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

(#M40046355) DBMS QUESTION Normalization Keep an EYE

What is virtual memory?

Asked In DBMS nakul (10 years ago)

Unsolved Read Solution (3)

Is this Puzzle helpful?   (17)   (4) Submit Your Solution Database

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

Unsolved Read Solution (32)

Is this Puzzle helpful?   (74)   (42) 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 (10 years ago)

Unsolved Read Solution (8)

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

(#M40038105) DBMS QUESTION Keep an EYE

Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

a. report writer

b. query language

c. data manipulation language

d. transaction log

e. none of the above

Asked In DBMS Ramya (10 years ago)

Unsolved Read Solution (7)

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

(#M40038104) DBMS QUESTION Keep an EYE

The model for a record management system might be

a. handwritten list

b. a Rolodex card file

c. a business form

d. all of above

Asked In DBMS Ramya (10 years ago)

Unsolved Read Solution (3)

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

(#M40034134) DBMS QUESTION Find the nth heightest salery Keep an EYE

Find the nth heightest salery
of employee without using subqurey

Asked In DBMS DHIRENDRA (10 years ago)

Unsolved Read Solution (12)

Is this Puzzle helpful?   (5)   (0) Submit Your Solution Definition

(#M40030402) DBMS QUESTION DBMS Keep an EYE

Describe the three levels of data abstraction?

Asked In DBMS (11 years ago)

Unsolved Read Solution (6)

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