adspace


  1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

How internally data stores in MyISAM and INNODB table types?

Zensar,

1 2858

why not null constraint showing its constraint type as 'c'

 1 4781

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

TCS,

2 5217

without using count(*) and rownum how can we count total record in a table

AC, HP,

5 10579

What is the basic difference between a sql and stored procedure ?

L&T,

2 7015

Which is the best place to learn hadoop?

 1 5448

write sub query for eliminating duplicate rows using analytical function?

Metric Stream,

3 13238

what is switch column,colums cost in oracle?

Metric Stream,

3809

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

Metric Stream,

1 9465

maximum database size of mysql database

 2 5548

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

TCS,

3 9102

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

BirlaSoft,

2 6018

display records from 5 to 9 using rowid or rownum

Agile Software,

5 16406

when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

 1 3394

determine the minimum salary of the employee and his details who join on the same date

 3 6378

Un-Answered Questions { Databases }

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1057

do you know how to configure db2 side of the application? : Sql server database administration

1138

Are you familiar with user exits in reports?

72

What is self contained sub query?

1151

Does view occupy space?

1039

how to use regular expression in pattern match conditions? : Sql dba

1126

Is there some bulk load or other way to import a lot of data fast?

942

Who proposed the relational model?

1044

What are the kinds of subquery?

1119

what is sql server agent? : Sql dba

1193

what is the difference between openrowset and openquery?

1213

What is sql or structured query language?

1239

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2103

Can you index views?

962

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1866

For More Un-Answered { Databases } Questions Click Here