Databases AllOther Interview Questions
Questions Answers Views Company eMail

After normalization, what are the conditions which have to keep in mind to de-normalize it?

C DAC, CDAC,

601

Explain normalization in one line?

C DAC, CDAC,

626

Give the syntax of exception handling used in DBMS?

C DAC, CDAC,

639

What are different types of blocks used in stored procedure?

C DAC, CDAC,

623

What are different types of clusters present?

C DAC, CDAC,

586

What is the difference between a stored procedure and a query?

C DAC, CDAC,

580

Differentiate between unique key and foreign key?

CGI,

575

How do you pass parameter in stored procedure?

CGI,

720

What are indexes in oracle?

CGI,

620

What is the relationship that exists inside in E-R diagram?

CGI,

625

Write a query to get maximum and second maximum in oracle?

CGI,

592

Write a query to retrieve for many to many relationships?

CGI,

563

How to produce such kind of file?

Tech Mahindra,

611

What is a trace file?

Tech Mahindra,

623

What is the purpose of TNS?

Tech Mahindra,

646


Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

Write a query to get maximum and second maximum in oracle?

592


What are indexes in oracle?

620


Explain various types of locks in a transaction? Which is better and why?

590


Explain the table term used in database.

561


Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

683






Explain inner and outer joins with examples.

699


What is a database string?

514


query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

1628


Is data lake a database?

555


How much does it cost to build a database?

560


How concurrency problems effect the database?

622


What are the tools used for backup and ticketing?

568


During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

936


What are the types of indexes that are present inside a database?

626


What is the database url?

543