1. What is Data Warehou Warehousing? sing? 2. Explain Explain The Project? Project? 3. What test process process are done done ur project? project? 4. Join And And Selfjoi Selfjoin n 5. Varchar and and vachar2 vachar2 Differences Differences 6. What is Dimension and and Fact table. table. 7. What is is data mart? 8. Latest Latest entry entry in table( table( Query) Query) 9. Display the max of avg sal from each each dept? 10.
My table is Emp
Eno ename loc 1
a
2
g
hyd blore
I want to display like this Eno ename loc 1 2
a g
blore hyd
11.
A,B two tables. In A have 10 columns and have 0 columns whenever I write a Query likes S elcet * from A,B ? Wt is the output above query
10. mY table name Student stdid maths phy che telu 1 25 52 32 12 5 25 42 23 44 i want to highest marks in each student
output look like as stdid highestmarks 1 52 5 44 11. In my Schema ,100 tables is there, some tables have same column names there, i want to display how many tables have same column names? 12. What is Fact Table ? what the fact tables in ur Project? 13.priority and severity 14. What is SCD1,SCD2 and SCD3 15 primary key ,foriegn key, unique 16. how to update all columns at a time?
17.dispaly 5 th highetst salary without using subquery? 18.display which dept having morethan 3 emloyees? 19. bug life cycle? 20 delete,truncate,drop 21. eaplain test plan ? 22. union and union all
UHG 1. Project 2. How to find files in directory/sub dir with first 5 letters? 3. How to know which process is runnning in Unix? 4. Types
of schemas in Data warehousing?
5. How to kill the processin unix? 6. How to see hidden files in unix? 7. How to know how many members r loggin in ur system in unix cmd? 8. OLAP and OLTp
9.
What is Datawarehousing?
10. How to know background/foreground process in unix 11.
To display duplicates in a table?
12.
To Delete duplicates in Trable?
13. In my table have 100 rows there ,I want to display 3 to 7 rows only 14. 15. To
To display emp name and his managaer name? Display each dept total employess
16.
To_char fn
17.
Trunc fn
18.
NVL fn
19.
Opearator precedence in sql
20.
Clauses in sql
21. What
is traceability matrix in testing
22.
Testing life cycle
23.
Etl test process
24.
Retesting and Regression testing
25.
To display max sal in table
26.
To display who was joined in last month ZENSAR
1 validation and verification 2.retesting and regression testing 3. DDL/DML difference 4 SDLC/STLC 5.waterfall moedel,prototype maodel,spiral model
Wipro
1.project 2.scd1,scd2,scd3 3 how to maintain history in scd2 4 group by clause 5.olap and oltp 6.bug life cycle 7 priority anf severity
1.Nth heighst sal query; 2. delete from duplicates & display duplicates 3.max sal query 4.display even number of records query
5.
perticular recards display query
6. display last display query 7. concat two col query 8.how to retrive all rows except last row 9.only distinct values display 10.deptwise heighst sal query 11.count the number columns query
