Databases Interview Questions
Questions Answers Views Company eMail

Explain about ur projets on teradata???

Wipro,

732

what is checksum in sql server.........???

TCS,

482

what is try_catch block in procedure

522




how to retrieve data from different tables ,place this data in different excel worksheets.

Gap Inc,

1 736

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

399

What is AUTH_ID and AUTH_USER in pl/sql ?

INDUS,

764

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

United Healthcare,

473

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

ICICI,

3 1133

how to write customizations in po

Ernst Young,

483

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

CTS,

1 651

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

Societe Generale,

1 1413

how to handle exceptions in post production

316

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

406

What is Lock table in SQL?

Wipro,

367

How to get maxsal , minsal, ename department wise in single query

350







Un-Answered Questions { Databases }

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1145


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

940


How to trouble shoot if unable to connect SQL Server

869


How would you best determine why your MVIEW couldn't FAST REFRESH?

1194


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1033






Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

950


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

797


i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........

759


How would you best determine why your MVIEW couldnt FAST REFRESH?

801


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

2207


What are the uses of Database Trigger ?

451


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

934


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1033


How to get maxsal , minsal, ename department wise in single query

350


what is port in oracle? how is it related to database application.

772