Databases Interview Questions
Questions Answers Views Company eMail

How internally data stores in MyISAM and INNODB table types?

Zensar,

2085

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

1 3900

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 4073

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

AC, HP,

5 8015

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

L&T,

2 5557

Which is the best place to learn hadoop?

1 4624

write sub query for eliminating duplicate rows using analytical function?

Metric Stream,

3 11740

what is switch column,colums cost in oracle?

Metric Stream,

3125

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

Metric Stream,

1 8528

maximum database size of mysql database

2 4367

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 7588

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 4881

display records from 5 to 9 using rowid or rownum

Agile Software,

5 14154

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 2683

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

3 4766


Un-Answered Questions { Databases }

When to use null data driven subscription?

148


What is efficiency data?

520


What are sub reports?

149


How to run pl sql program in mysql?

510


How is data stored in sql?

547






What is an indice?

571


What do you mean by sybase iq?

484


How do I connect to postgresql using putty?

432


Define RDBMS.

744


when would you go for denormalization? : Sql server database administration

483


What is cql? How can you run cql commands in neo4j?

1


What does an oracle dba do?

297


What is StandAlone Agent and default port number?

354


What does (+) mean in sql joins?

521


How can you find out how many users are currently logged into the database?

315