Databases Interview Questions
Questions Answers Views Company eMail

Can you tell me how to add new column in existing views?how?How is possible?

FIS,

220

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

IBM, Saama Tech,

171

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from ; except this you can't use another select statement. You can use no of variables as per requirement.

304




Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

Infosys,

158

how to find 6th highest salary

Chetak Logistics,

216

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

167

difference of using cursor for loop and open,fetch,close.which one is better

Accenture,

98







Un-Answered Questions { Databases }

How would you determine who has added a row to a table?

1064


Which is better Oracle or MS SQL? Why?

4051


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1406


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1323


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

1045






all the queries used in sql

1529


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

771


Is there any link between pr form(purchse requisition)and po form(purchase order)

1135


Can a formula column be obtained through a select statement ?

1066


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.........

724


i want to know about the javaBean.what is its purpose and how it can use in Forms.

999


What are the Roles and responsibilities of database administrator?

1503


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

2981


How can set the multipal database ?

1781


can we use lexical perameter in oracle plsql if yes how

1125