Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
Sql Interview Questions and Answers
Home
Questions
Sql
0
votes
Q: Why do I need an index in a database?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
index-database
0
votes
Q: What is an index?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
sqlindex
0
votes
Q: What are local and global variables and their differences?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
globalvariables
0
votes
Q: What is a Cursor?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
cursor
0
votes
Q: What is BCP utility in SQL SERVER?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
bcputility
0
votes
Q: What are the different types of replication supported by SQL SERVER?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
sql-replication
0
votes
Q: What is the purpose of Replication?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
replication-sql
0
votes
Q: What is DBCC?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
dbcc
0
votes
Q: How can you raise custom errors from stored procedure?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
storedprocedure
0
votes
Q: What is the difference between Stored Procedure (SP) and User Defined Function (UDF)?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
userdefinedfunction
udf
0
votes
Q: What is SQL injection?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
sql
injection
0
votes
Q: if we have multiple AFTER Triggers on table how can we define the sequence od the triggers?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
aftertriggers
0
votes
Q: What are the different types of triggers in SQl SERVER?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
sql-triggers
0
votes
Q: What is the difference between UNION and UNION ALL SQL syntax?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
unionallsql
0
votes
Q: What are the different ways of moving data between databases in SQL Server?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
databasessqlserver
0
votes
Q: What is LOCK escalation?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
lockescalation
0
votes
Q: Can we suggest locking hints to SQL SERVER?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
sql
lock
0
votes
Q: What are the different locks in SQL SERVER?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
sql-locks
sql-server
0
votes
Q: What are different transaction levels in SQL SERVER?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
sqlserver
0
votes
Q: If locking is not implemented, what issues can occur?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
table-lock
0
votes
Q: What is the difference between DELETE TABLE and TRUNCATE TABLE commands?
asked
Jun 15
in
Sql
by
Robin
(
14.6k
points)
delete-table
0
votes
Q: Difference between char varchar and nvarchar in sql server
asked
Jun 13
in
Sql
by
rahuljain1
(
6.5k
points)
nvarchar
sqlserver
0
votes
Q: What is RAID and how does it work?
asked
Jun 13
in
Sql
by
rahuljain1
(
6.5k
points)
raid
sql
0
votes
Q: What is fill factor ? or When does page split occurs?
asked
Jun 13
in
Sql
by
rahuljain1
(
6.5k
points)
fillfactor
0
votes
Q: What is DTS?
asked
Jun 13
in
Sql
by
rahuljain1
(
6.5k
points)
dts
0
votes
Q: What are fact tables and dimension tables in OLAP?
asked
Jun 13
in
Sql
by
rahuljain1
(
6.5k
points)
olapdimensiontables
0
votes
Q: What are levels in dimensions?
asked
Jun 13
in
Sql
by
rahuljain1
(
6.5k
points)
dimensions-level
0
votes
Q: What are dimensions in OLAP?
asked
Jun 13
in
Sql
by
rahuljain1
(
6.5k
points)
olap-dimension
0
votes
Q: What is a measure in OLAP?
asked
Jun 13
in
Sql
by
rahuljain1
(
6.5k
points)
olap
0
votes
Q: What is the use of OLAP?
asked
Jun 13
in
Sql
by
rahuljain1
(
6.5k
points)
olap
Page:
1
2
3
4
5
6
...
12
next »
...