ALTISOURCE QUESTION
2ND
ROUND
1. BRIEF
ME ABOUT YOURSELF
2. WHAT
RDBMS you know
3. WHAT
IS DIFFERENCE BETWEEN SQL & PLSQL
4. DIFFERENCE
BETWEEN TRUNCATE & DELETE
5. IF
I WANT TO UPDATE & INSERT INTO EMP TABLE FROM EMP_TEST TABLE WHAT I SHOULD
DO
6. WHAT
IS RANK FUNCTIONS
7. WRITE
SINGLE QUERY USE ALL RANK FUNCTIONS FOR EMP TABLE
8. WHAT
ARE INDEXES
9. TYPES
OF INDEXES . EXPLAIN IT
10. WHAT
IS BITMAP INDEX HOW IT IS STORED
11. TYPES
OF JOIN
3RD
ROUND
1. BRIEF
ME ABOUT YOUR TECHNICAL
2. WAQ I/P
O/P
|
EMP ID
|
SAL
|
|
1
|
18000
|
|
2
|
20000
|
|
3
|
9000
|
|
NEXT SAL
|
|
|
20000
|
|
|
9000
|
|
|
|
|
ID
|
|
|
1
|
A
|
|
1
|
B
|
|
1
|
C
|
|
2
|
D
|
|
2
|
E
|
|
3
|
F
|
|
3
|
G
|
3. WAQ I/P O/P
|
ID
|
|
|
1
|
A,B,C
|
|
2
|
D,E
|
|
3
|
F,G
|
|
EMAIL
|
|
SOWMYA.B@GMAIL.COM
|
|
SOWMYA.B2@GMAIL.COM
|
4. WRITE
A PROCEDURE I/P O/P
|
FIRST NAME
|
LAST NAME
|
|
SOWMYA
|
B
|
|
SOWMYA
|
B
|
5. I
HAVE A EMP_TEMP TABLE I WANT TO INSERT THE RECORDS & OLD RECORDS SHOULD BE
WITH DEACTIVATED FLAG
|
EMP ID
|
ENAME
|
SAL
|
|
|
1
|
SMITH
|
18000
 |
|
|
2
|
JOHN
|
20000
 |
|
|
3
|
TIM
|
9000
|
|
|
EMP ID
|
ENAME
|
SAL
|
DEACTIVATED
|
|
1
|
SMITH
|
18000
|
D
|
|
2
|
JOHN
|
20000
|
D
|
|
3
|
TIM
|
9000
|
D
|
|
4
|
SMITH
|
18000
|
|
|
5
|
JOHN
|
20000
|
|
|
6
|
TIM
|
9000
|
|
|
ID
|
|
VALUE
|
|
1
|
HOST
|
|
|
1
|
PORT
|
|
|
1
|
SID
|
|
4TH
ROUND
1. I/P
O/P
|
ID
|
DATABASE NAME
|
|
1
|
ORACLE
|
|
2
|
MS SQL
|
|
3
|
DB2
|
2. WHAT
IS V$ SESSION & V$VIEW
3. DIFFERENCE
BETWEEN ROWID & ROWNUM
4. BREIF
ABOUT YOUR PROJECT
5. WHAT
YOU DID YESTERDAY IN OFFICE
6. HOW
COMPLEX QUERY YOU CAN WRITE
No comments:
Post a Comment