DB Development Interview Questions and Answers

1 :: Write short notes on XSU and JAVA?

java :it is programming language .it is m/c independent.
it is best for web development. it remo ve all the
drawbacks of c and c++.

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

2 :: In which phase of mload can i use .FILLER?

When your data file has additional columns comparet to your
target table, you specify "FILLER" against the attribute
against the control file and the same will not get loaded

0/5 Rating (0 vote)

Is This Answer Correct?    1 Yes 0 No

3 :: How to find the duplicate rows count from employees table in oracle?

select employee_id, count(*) from employees group by
employee_id having count(*) > 1

0/5 Rating (0 vote)

Is This Answer Correct?    1 Yes 0 No

4 :: What is the family trees and connection by clause?

On its face, the relational database management system would appear to be a very poor tool for representing and manipulating trees. This chapter is designed to accomplish the following things:
show you that a row in an SQL database can be thought of as an object
show you that a pointer from one object to another can be represented by storing an integer key in a regular database column
demonstrate the Oracle tree extensions (CONNECT BY … PRIOR)
show you how to work around the limitations of CONNECT BY with PL/SQL
The canonical example of trees in Oracle is the org chart.
create table corporate_slaves (
slave_id integer primary key,
supervisor_id references corporate_slaves,
name varchar(100)
);
insert into corporate_slaves values (1, NULL, ‘Big Boss Man’);
insert into corporate_slaves values (2, 1, ‘VP Marketing’);
insert into corporate_slaves values (3, 1, ‘VP Sales’);
insert into corporate_slaves values (4, 3, ‘Joe Sales Guy’);
insert into corporate_slaves values (5, 4, ‘Bill Sales Assistant’);
insert into corporate_slaves values (6, 1, ‘VP Engineering’);
insert into corporate_slaves values (7, 6, ‘Jane Nerd’);
insert into corporate_slaves values (8, 6, ‘Bob Nerd’);

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

5 :: What is the difference between case version and decode version?

Decode
1.It’s a function
2.can compare only discrete values
3.pl/sql standards
4.cannot process null

Case
1.It's an Expression
2.can handle range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No