QUESTIONS INTERVIEW.IN

Sign Up | Sign In

Post a Question

Asked Questions

Interview Questions

- Computer Language

- Computer Database

- Data Structure

- Certifications

- Cost Accounting

- Common Interview Questions

Home >> Computer Database >> Sql server

Question

View Answer

=> When do we use the UPDATE_STATISTICS command?

=> Define Local temporary table and global temporary table

=> Define Identity and uniqueidentifier property of Column.

=> List out the difference between CUBE operator and ROLLUP operator

=> What is RAID (Redundant Array of Inexpensive disks)? Explain its level.

=> Write SQL query to retrieve all tables of the database

=> Define sub-query

=> How can we move data along with schema of the server object?

=> What is BCP?

=> Where is users names and passwords stored in SQL Server?

=> Define COLLATION

=> What is the use of DBCC commands?

=> What is Extent and types of Extent?

=> What is database replicaion?

=> Explain different types of BACKUPs avaialabe in SQL Server

=> Ways of moving data/databases between servers and databases in SQL Server

=> What is blocking?

=> What is a deadlock and what is a live lock?

=> Steps to secure an SQL Server

=> Ways to troubleshoot performance problems in SQL Server

Page: 1 2 3 4 5 6 7 8 9 10

Last

Latest Sql server Interview video

Latest Topic

How to Import sqlserver data to mysql?

Uncaught TypeError: extract(): Argument #1 ($array) must be of type array, null given

Fatal error: Uncaught TypeError: extract(): Argument #1 ($array) must be of type array

HTTPS is invalid and might prevent it from being indexed

Deprecated: Required parameter $sql follows optional parameter $name in

Fatal error: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null

Your account isn’t eligible for the Google Workspace Individual plan