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

Can we create an List of Values without an RECORD GROUP ?

2 4257

How many number of columns can a RECORD GROUP have ?

2027

Oracle precompiler translates the EMBEDDED SQL statemens into ?

1 5259

what Kind of COMMENT statements placed within SQL statements ?

2 4520

What is TERM ?

1 3345

For a field in a repeating frame, can the source come from a column ?

1 3528

What are the different file extensions that are created by Oracle ?

2 14310

Is it possible to Disable the Parameter form while running the report ?

1 6706

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

1 3625

What are the types of Calculated columns available ?

1 3776

What are the different Sequence of events takes place while starting a Database ?

KPSC Karnataka Public Service Corporation,

1 5591

When the SYSTEM TABLESPACE can be made off-line ?

2 5585

From which command ENQUEUE_RESOURCES parameter information is derived from ?

1 5071

How the SMON process is used to write into LOG files ?

HCL,

2 8131

what is the use of EXP command ?

2 8903

Un-Answered Questions { Databases }

Why do we use triggers?

967

What are two statement types in sql?

1104

How do I stop a mysql service?

1008

How do I remove all records from a table?

1073

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1044

What are database links used for?

1046

What will be objects between two dates in mongodb?

Why variables called the most powerful component of ssis?

1079

Difference between connected and disconnected database in .net with sql server?

1094

What are the tools available in market as an alternative to sql server reporting services?

131

How to create local server in postgresql?

884

What are the drawbacks of reporting in ssrs?

149

Explain what is a subquery ?

1188

When configuring sqlnet on the client what files need to be set up?

642

explain GROUPBY & HAVING clause with examples.

2291

For More Un-Answered { Databases } Questions Click Here