Databases Interview Questions
Questions Answers Views Company eMail

What is the SQL?????????????????????????????

CMS,

5 6394

What is the Query to print out the individual total number of duplicate row in sql.

TCS,

5 10049

what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,

1651

How to display the hierarchy of employee and managers without using connect by prior.

1 3212

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

IBM,

1977

how to know the tables in database having foreign key?

2 3532

find the second highest salary of the emp table

6 6598

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

TCS,

3 20761

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

HP,

1507

what is pragma ?

Polaris,

1 6312

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

Cognizant, IBM,

7 7565

What is the Query Optimizer. How you optimize your qeury.

Ericsson,

2 6270

what is an sql server?

1 3468

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 3946

find 2nd highest salary of person using cursor concept?

HCL,

6 9759


Un-Answered Questions { Databases }

What is the main purpose of ms access?

440


What are sql triggers used for?

490


Explain the significance of the & and && operators in pl sql.

548


What is the maximum length a text field can be in access?

398


how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

498






You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

538


What purpose does the model database server?

625


Can we insert data if clustered index is disabled?

491


Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

830


Is database a data structure?

457


Write a SQL command to insert and update only a particular field?

597


explain the difference between delete , truncate and drop commands? : Sql dba

526


Explain what is dbms?

557


What do you understand by mirroring and mention the advantages of the mirroring?

557


Where can you add custom error messages to sql server?

559