1. Categories >> Software >> Databases >> Databases AllOther
  2. Suggest New Category
Databases AllOther Interview Questions
Questions Answers Views Company eMail

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

3i Infotech,

694

Which three commands cause a transaction to end?

3i Infotech,

589

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

3i Infotech,

778

How does non-cluster index functions?

Alcatel-Lucent,

637

What are the tools used for backup and ticketing?

Alcatel-Lucent,

574

What is the difference between oracle and MS Access?

Alcatel-Lucent,

613

What is the function of cluster index?

Alcatel-Lucent,

610

How concurrency problems effect the database?

BirlaSoft,

631

What does specialization in DBMS mean?

BirlaSoft,

638

What is a sequence? Explain it with one example?

BirlaSoft,

638

What is the candidate key used for?

BirlaSoft,

618

What is the difference between primary and candidate key?

BirlaSoft,

569

What is the difference between specialization and generalization?

BirlaSoft,

572

Data structure used to implements a menu:

Verifone,

622

How default key is different from primary key?

Abacus,

611

Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

5. Explain about relational algebra.

1727

what are wrappers and build ups and what it's use?

1690

Can you tell any two advantages of stored procedures?

586

What is the use of graph database?

544

What is ole db used for?

576




What do you mean by cluster and non cluster index?

565

Explain entity set?

581

What are the disadvantages of views in a database?

536

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

1480

Does facebook use graph database?

602

what is tkprof tool and how it is used???

2370

What is database bounce?

585

What are the most common databases?

537

What is the concept of Virtual field?

1614

What is Data Modelling?

627

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