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

Oracle (3253)
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

Whats the benefit of dbms_stats over analyze?

2068

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2196

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1990

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 3299

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

Wipro,

1 5901

what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?

NIIT, TCS,

2658

What is difference b/w composit key n primary key and forigion key?

4 7990

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

Cognizant,

2 7965

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

Cognizant,

1 4125

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(, 1) BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKFILE(, 1) GO

Cognizant,

1 5076

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

Cognizant,

1 5458

Print 3 highest salary

9 12778

What are the steps you will take to improve performance of a poor performing query?

1 4686

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 5695

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

TCS,

5 9143

Un-Answered Questions { Databases }

How to disconnect the user connection?

945

What is striped backup

2295

Name the different types of indexes in sql and define them.

1227

What is extension and intension?

971

how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

2087

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2130

What is e-r model in the dbms?

1120

What are the sql commands?

1238

How can I introduce multiple conditions in like operator?

1057

What is a cursor, index in sql?

1130

What are the several methods to enter data in ms access 2013?

860

What is row level locking?

994

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2706

What is database normalization? Explain types of it.

1047

Which parameters are optional in init.ora parameter file?

2280

For More Un-Answered { Databases } Questions Click Here