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: What is Cartesian product in SQL?
answered
Jan 28
in
Sql
by
AdilsonLima
sql-server
0
votes
Q: What is degree and cardinality in SQL?
answered
Jan 28
in
Sql
by
AdilsonLima
sql-server
sql
+1
vote
Q: How would you prevent T-SQL code from running on a production SQL Server?
answered
Jan 15
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What is the use of GO in Transact SQL?
answered
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What is the difference between PARTITION BY and GROUP BY
answered
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What is the difference between EXEC vs sp_executesql?
answered
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: Is it possible to import data directly from T-SQL commands without using SQL Server Integration Services? If so, what are the commands?
answered
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What's the difference between TRUNCATE and DELETE in SQL?
answered
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are types of XML indexes in SQL Server?
answered
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are the practical differences between COALESCE() and ISNULL(,'')?
answered
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are bitwise operators and what is the value from a database design perspective?
answered
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: Provide an example of Left Outer Join with Exclusions?
answered
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What is uncommittable transactions?
answered
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What does the T-SQL command IDENT_CURRENT does?
answered
Jan 14
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are the Join Types in TSQL?
answered
Jan 14
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are ROLLUP and CUBE in T-SQL?
answered
Jan 14
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: Is there a difference between T-SQL linked server and a synonym?
answered
Jan 14
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: How can you delete duplicate records in a table with no primary key?
answered
Jan 14
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: How can you capture the length of a column when it is a Text, NText and/or Image data type?
answered
Jan 14
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: When should we use primary key or index?
answered
Jan 14
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What is TSQL Window functions?
answered
Jan 14
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What are the two commands to remove all of the data from a table? Are there any implications with the specific commands?
answered
Jan 14
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What are the three ways that Dynamic SQL can be issued?
answered
Jan 14
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What are 5 commands that can be used to manipulate text in T-SQL code?
answered
Jan 14
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What is OFFSET-FETCH filter in tsql?
answered
Jan 14
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: what are the limitations of IDENTITY column?
answered
Jan 14
in
Sql
by
GeorgeBell
sql
0
votes
Q: What are functions and their usage in SQL?
answered
Nov 8, 2021
in
Sql
by
rajeshsharma
sql-functions
0
votes
Q: Is a blank space or zero the same as a NULL value?
answered
Nov 8, 2021
in
Sql
by
rajeshsharma
null-value
0
votes
Q: What is the ACID property in a database?
answered
Nov 8, 2021
in
Sql
by
rajeshsharma
acid-property
0
votes
Q: What is the difference between DELETE and TRUNCATE statements?
answered
Nov 8, 2021
in
Sql
by
rajeshsharma
#delete
#truncate
#truncate-sql
To see more, click for all the
questions in this category
.
...