Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Databases Interview Questions

Questions Answers Views Company eMail

What are the components of physical database structure in the Oracle database?

1 1825

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

2156

how do you tune the slow running queries in oracle db , explain the methodology

3221

Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions

1 2895

Un-Answered Questions { Databases }

Define database.

1049

Explain oracle data types with examples?

1079

When should an artificial (or derived) primary key be used?

638

What is a sql join?

1080

Explain open server?

976

Explain the difference between replace() and translate() functions in oracle?

1084

Define the select into statement.

1108

What are the ways tablespaces can be managed and how do they differ?

2443

Is the primary key an index?

1078

What is connection pool in oracle?

1036

What is a postgres tuple?

936

How do you optimize a stored procedure in sql?

1014

What do you mean by mainframe connect tool in sybase?

945

What are the system database in sql server 2008?

1096

Point out the difference between user tables and data dictionary?

1033

For More Un-Answered { Databases } Questions Click Here