Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Databases Interview Questions
Questions Answers Views Company eMail

REGULAR CLASSES for Informatica 8.6 is starting from Monday, 07th Nov, 8:00 AM IST .

1 4111

what do u mean by heptic shedule over india

1 3632

in how many ways we can use count()

2 3748

what are the limitations of parameters in a storedprocedure

1 3896

i have three table 1. student (stuid,name) 2. subject (subid,sname,studid) 3. marks (subid,studentid,marks) i want the reslut of how as got max marks in each subject sudentname,max(marks), name abc,70,nikitha

CMC,

1 3919

Which index created when Create Index on table(col), Why

CGI,

2 6007

last function used in MS Access to convert sql what function will use in sql

Cap Gemini,

2077

WHAT IS ecc 6.0

2150

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 4744

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

Fidelity,

2 12617

Table1: Col1 col2 1 2 10 3 4 89 5 6 Table:2 Col1 col2 3 2 9 5 4 7 6 87 With the help of table1 and table2 write a query to simulate the fallowing results. Output1: Col1 col2 1 2 2 3 3 4 4 5 5 6 Output2: Col1 col2 2 3 10 4 5 89 6 7 1.Write query for single row to multiple row using sql statements. Eg:a,b,c,d,e,f Change to A B C D E F 2. Write query for multiple row to single row using sql statements. Eg2 A B C D E F Change to Eg:a,b,c,d,e,f Table1: Col1 col2 8 5 2 9 4 2 5 1.Write a query to select all the rows from a table1,if the value of A is null then corresponding B’s value should be printed in A’s value.if the value of A is null in that table then corresponding B’s value should be printed as 30. 2. write a query to find the sum of A and B .display the max among both. 3.write a query to find total number of rows from table 1. Note: if any column value is null in a row then that row should be considered as 2 rows. 4.write a query to display all the records of table1 except A containg 2 as well B containg 5. 5.rewrite the fallowing without using join and group by. Select b.title,max(bc.returneddate –bc.checkoutdate)” mostdaysout” From bookshelf_checkout bc, Book shelf B Where bc.title(+)=b.title Group by b.title. 6.rewrite fallowing query Select id_category from category_master X where exists (select 1 from sub_category Y where X.id_category=Y.id_category) Customer: Name phone1 phone2 phone3 bitwise A 23456 67890 12345 --- B 67459 89760 37689 --- Don’t_call Col1 67890 37689 1.q) update the customer table of bitwise with 1 or 0. Exists in don’t_call table menas show -1 Other wise -0. Output. Name bitwise A 010 B 010

Protech,

2422

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

Cap Gemini,

2412

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

Cap Gemini, Syntel,

2 6745

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

TCS,

2402

how can we send a concurrent program output to the clients through mail or fax give me example.

Cap Gemini,

1 5855


Un-Answered Questions { Databases }

what are the differences between an exclusive lock and a shared lock?

991


How many servers can we create in a single subscription?

162


What is difference between inner join and cross join?

972


What are magic tables in sql server?

1138


Explain what are commit and rollback in sql?

935


What are the various types of snapshots ?

1030


What is the importance of covered query?

1


Explain what are the advantages of views?

1069


What are the four objects in a database?

1065


What are the parts of microsoft access?

930


What is secondary key?

936


What is pg_toast?

805


Can a formula column be obtained through a select statement ?

2331


What are the benefits of database?

917


How to download oracle database 10g xe?

1018