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,

2084

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

 1 3897

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 4069

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

AC, HP,

5 8009

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

L&T,

2 5555

Which is the best place to learn hadoop?

 1 4624

write sub query for eliminating duplicate rows using analytical function?

Metric Stream,

3 11738

what is switch column,colums cost in oracle?

Metric Stream,

3124

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

Metric Stream,

1 8527

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 4875

display records from 5 to 9 using rowid or rownum

Agile Software,

5 14152

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 2681

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

 3 4759

Un-Answered Questions { Databases }

How to update a field in SQL after ALTERING a row?

685

What is an oracle and why it is used?

619

What is crud in mongodb?

1

Explian rowid, rownum?

558

Does pdo prevent sql injection?

520




What happens if you set the sga too low in oracle?

548

How do I convert an access database to excel?

416

What is the use of double ampersand (&&) in sql queries? Give an example

609

what is the difference between group by and order by in sql? : Sql dba

596

what is the difference between delete table and truncate table commands? : Sql server database administration

517

Explain what is use of dbcc commands?

507

Suppose you are designing an access database form. How will you get your next control in the form to be automatically selected?

477

Explain polymorphism in pl/sql.

635

What are audit control procedures?

582

What are foreign keys in database?

489

For More Un-Answered { Databases } Questions Click Here