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

Databases AllOther Interview Questions

Questions Answers Views Company eMail

what is meant by Dynamic query?

Satyam,

3 13794

what is Normalization means..?

AZTEC, Bank Of America, Infosys, TCS,

8 32203

Integrity constraints means..? how many and what are they?

AZTEC,

4 14561

can we delete autodiff back up that we have set through sql server agent.

Indian Web Technology,

2200

if we have set auto differencial back up then waht is difference between 1.appen to media 2.over right the existing media

Indian Web Technology,

1 4419

characters of DBMS A) non redundant B) data independence C) increased security D) all the above

Accenture, XP,

1 9180

utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN

Accenture,

2 5788

What is OQL?

4 11875

what is primary key,unique key, foreign key? can u teach me in simple language?

Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro,

44 187699

What are the differences between Database Trigger and Integrity constraints ?

Synergy,

2 7581

WHAT KIND OF TOOL BO IS?

APC,

2328

WHAT IS CARDINALITIES OF JOIN?

2363

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

Wipro,

2250

WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?

HP,

2 6766

What is Stored procedure ?

IBM, iGate, Inspira Technologies,

4 10811

Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

Why do we need distributed database?

989

Write a query to retrieve for many to many relationships?

1001

What are the tools used for backup and ticketing?

998

Give the syntax of exception handling used in DBMS?

1199

What is database collection?

1010

Is redis in memory database?

997

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

1842

Explain artificial key?

1170

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

1133

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

2105

What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?

2012

Explain normalization in one line?

1092

What is Data Modelling?

1079

Difference between sql and mysql?

2092

5. Explain about relational algebra.

2178

For More Un-Answered { Databases AllOther } Questions Click Here