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


SQL Server Interview Questions
Questions Answers Views Company eMail

Give an example of SQL injection attack ?

HAL,

564

What is lookup override?

Informatica,

580

Explain what you mean by 3 tier architecture.

TCS,

619

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

Genpact,

1 1486

What is an active database?

HCL,

587

What is used to replicate sessions between instances in coldfusion clusters?

HCL,

572

How to transfer a table from one schema to another?

MCN Solutions,

553

Write the queries for commands like Create Table, Delete table, Drop Table etc.

HPCL, Hughes Systique Corporation,

602

What is the difference RDBMS and Graph Database?

EXL,

621

do views contain data ?

MCN Solutions,

574

What is difference between global temporary tables and local temporary tables?

Tech Mahindra,

654

What is trigger and different types of Triggers?

QuestPond,

563

What are difference between Cluster index and Non-Cluster index?

QuestPond,

601

How to delete duplicate records based on single column from a table?

Petranics Solutions,

596

Which Model uses the SET concept

Infosys,

572

Un-Answered Questions { SQL Server }

Can we install sql server 2016 on windows 7?

664

What is meant by dirty read?

547

Explain what role entity and relationship play in an ER diagram.

567

What is surrogate key? : sql server analysis services, ssas

683

What is Transparent Data Encryption?

581




After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

559

How do you open a cluster administrator?

619

How to use the inserted and deleted pseudo tables?

535

How to maintain a fill factor in existing indexes?

522

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

589

How can we rewrite sub-queries into simple select statements or with joins?

519

Give a example to search fr a string in all stored procedure in sql server.

524

How to make a column nullable?

588

How will you monitor replication latency in transactional replication? : sql server replication

601

What is database mirroring?

556

For More Un-Answered { SQL Server } Questions Click Here