QUESTIONS INTERVIEW.IN
Sign Up
|
Sign In
Post a Question
Asked Questions
Question Bank
Home
Interview Questions
-
Computer Language
-
Computer Database
-
Data Structure
-
Algorithm
-
SAP
-
Accounts
-
Arts
-
Banking
-
Bluetooth
-
Business
-
Call Center
-
Cashier
-
Certifications
-
Clarify CRM
-
Commerce
-
Computers
-
Cost Accounting
-
Common Interview Questions
-
Aerospace
Home
>>
Computer Database
>> sql
Question
View Answer
=>
What is blocking and how would you troubleshoot it?
View Answer
=>
What are the steps you will take, if you are tasked with securing anWhat is a deadlock and what is a live lock? How will you go about resolving deadlocks?SQL Server?
View Answer
=>
What are the steps you will take to improve performance of a poorperforming query?
View Answer
=>
Whar is an index? What are the types of indexes? How many clusteredindexes can be created on a table?I create a separate index on each column of a table.what are the advantages and disadvantages of this approach?
View Answer
=>
What are constraints? Explain different types of constraints.
View Answer
=>
Explain the storage models of OLAP
View Answer
=>
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
View Answer
=>
What is lock escalation?
View Answer
=>
Explain the architecture of SQL Server
View Answer
=>
Explain Active/Active and Active/Passive cluster configurations
View Answer
=>
What's the maximum size of a row?
View Answer
=>
What is a transaction and what are ACID properties?
View Answer
=>
What is bit datatype and what's the information that can be storedinside a bit column?
View Answer
=>
What are user defined datatypes and when you should go for them?
View Answer
=>
What's the difference between a primary key and a unique key?
View Answer
=>
How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
View Answer
=>
What is denormalization and when would you go for it?
View Answer
=>
What is normalization? Explain different levels of normalization?
View Answer
=>
You query the database with this command
View Answer
=>
Which two of the following orders are used in ORDER BY clauses? (choose two)
View Answer
First
« Previous 20
Page:
1
2
3
4
5
6
7
8
Next 20 »
Last
Latest sql 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