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

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

Where is a procedure return in an external pl/sql library executed at the client or at the server?

1 3676

Where is the external query executed at the client or the server?

Wipro,

2 5363

What are the default parameter that appear at run time in the parameter screen?

1 4312

Which parameter can be used to set read level consistency across multiple queries?

1 3475

What is term? What is use of term?

1 3882

Is it possible to insert comments into sql statements return in the data model editor?

1 3696

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

1 4913

What are the sql clauses supported in the link property sheet?

1 4232

To execute row from being displayed that still use column in the row which property can be used?

1 3348

Is it possible to set a filter condition in a cross product group in matrix reports?

1 4365

If a break order is set on a column would it effect columns which are under the column?

1 4049

With which function of summary item is the compute at options required?

1 3919

What is the purpose of the product order option in the column property sheet?

1 4023

How can a button be used in a report to give a drill down facility?

1 3955

What are the two ways by which data can be generated for a parameter's Using static values?

1 3789

Un-Answered Questions { Databases }

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2364

What is @@error in sql?

1073

What is graph sql?

998

How does mysql encrypt passwords?

899

What is text in mysql?

919

how can you process messages in order asynchronously?

982

What is oracle pl sql developer?

990

What do you mean by entity type?

1082

What is the difference between Clustered and Non-Clustered Index?

1068

What you can use regular expression for in mysql?

951

What is data model in database?

897

How do I recompile a procedure in oracle?

972

Is not null in sql?

1004

What is the difference between truncate and delete? How would a full table scan behave after?

557

Explian rowid, rownum? What are the psoducolumns we have?

1009

For More Un-Answered { Databases } Questions Click Here