Databases Interview Questions
Questions Answers Views Company eMail

How internally data stores in MyISAM and INNODB table types?

Zensar,

2346

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

1 4272

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 4524

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

AC, HP,

5 9052

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

L&T,

2 6138

Which is the best place to learn hadoop?

1 4926

write sub query for eliminating duplicate rows using analytical function?

Metric Stream,

3 12381

what is switch column,colums cost in oracle?

Metric Stream,

3355

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

Metric Stream,

1 8871

maximum database size of mysql database

2 4816

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 8175

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 5349

display records from 5 to 9 using rowid or rownum

Agile Software,

5 15072

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 2948

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

3 5339


Un-Answered Questions { Databases }

How to create table in particular schema in postgresql?

610


in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1254


What are sql commands?

721


Explain buffer manager?

718


How can you handle the –secure-file-priv in mysql?

700


What does clouddb kit mean?

1


What is concept of dbms?

690


How does postgresql compare to mysql?

797


what are the differences between network and hierarchical database model?

799


what are the differences between require and include, include_once and require_once? : Sql dba

778


What is the purpose of access?

640


How the stats updated in postgresql?

688


What is sql entity?

768


1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2197


How to use sum function in where clause in mysql?

710