Databases Interview Questions
Questions Answers Views Company eMail

wat is mean by normalization?......programing defination i need...(i know basic defination)

Wipro,

4 7557

definition of cluster and non-clustered index?

CSS,

2560

how to get the index id?

Cognizant, TCS,

1 5038

What is normalization? dec 2009

Cognizant,

3 6988

hi, i am new to database cau give me link where can i get about databse..

1880

If we use where clause in the left outer join then how the query would behave/act?

1 3535

write sql program to get the detail of student in a class?

2 9182

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

Cognizant, Infosys,

10 16211

1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

1624

how u can find the n row from a table?

Tech Mahindra,

19 25435

What is Primary Key?

Ramco,

4 8564

Difference between join and a subquery?

Base Automation, NMDC,

8 42948

Difference between sql and mysql?

1699

Its possible to use auto increment in oracle or not? If no means why?

1 3710

What does TKPROF stand for?

5 12810


Un-Answered Questions { Databases }

Explain neo4j vs. Mongodb?

1


What is foreign key in database?

588


Can you do multiple joins in sql?

635


How to use count function in mysql?

553


What is rds instance?

521






Is port 1433 secure?

638


List few ways to code transactions in an efficient manner?

563


What is function of ROLLUP ?

728


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1718


What is the most used database?

623


What to do if dba lost the system password?

693


List various types of log-based recovery in DBMS.

660


Is foreign key a primary key?

587


Is it possible to have clustered index on separate drive from original table location?

606


What is difference between postgresql and mysql?

491