1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

What new changes are being made in SQL Server?

Blue Star,

578

Under which circumstance should you create an index on a table?

3i Infotech,

698

What is a super key?

3i Infotech,

632

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

3i Infotech,

701

Which three commands cause a transaction to end?

3i Infotech,

600

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

3i Infotech,

790

How does non-cluster index functions?

Alcatel-Lucent,

654

What are the tools used for backup and ticketing?

Alcatel-Lucent,

580

What is the difference between oracle and MS Access?

Alcatel-Lucent,

618

What is the function of cluster index?

Alcatel-Lucent,

617

How concurrency problems effect the database?

BirlaSoft,

639

What does specialization in DBMS mean?

BirlaSoft,

657

What is a sequence? Explain it with one example?

BirlaSoft,

651

What is the candidate key used for?

BirlaSoft,

628

What is the difference between primary and candidate key?

BirlaSoft,

581

Un-Answered Questions { Databases }

What is filter index?

519

What is a coalesce function?

669

Explain about the features of sybase iq?

437

How to Insert multiple rows with a single insert statement?

551

What are data resources?

508




Explain the difference between delete,drop and truncate in SQL Server?

592

What is the difference between BLOB AND TEXT?

590

what are the types of indexes? : Sql server database administration

601

Why mongodb is faster?

1

How many primary keys can a table have?

534

Who invented schema theory?

478

How does mongodb replica set work?

1

Is postgresql free for commercial use?

456

What happens in oracle commit?

573

How do I start sql server 2017?

537

For More Un-Answered { Databases } Questions Click Here