Top 100+ questions and answers in Sql

0 votes

Q: Identify the structured data from the following.

answered Feb 24 in Sql by GeorgeBell

0 votes

Q: How to Fix error System.Data.SqlClient.SqlException: Login failed for user

answered Feb 2 in Sql by SakshiSharma

0 votes

Q: How to Fix SQL Server: Invalid Column Name

answered Feb 2 in Sql by SakshiSharma

0 votes

Q: How to run SQL Query for comparing dates?

answered Feb 2 in Sql by SakshiSharma

0 votes

Q: Define N in nvarchar and in nchar?

answered Jan 26 in Sql by SakshiSharma

0 votes

Q: Write query to print date in different language of india like Kannada, Marathi and Sanskrit

answered Jan 26 in Sql by SakshiSharma

0 votes

Q: How to run a sql statement more then one time?

answered Jan 26 in Sql by SakshiSharma

0 votes

Q: What is the Query in SQL to Get Month Name

answered Jan 7 in Sql by SakshiSharma

0 votes

Q: What is the difference between DROP and TRUNCATE statements?

answered Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: What is the difference between DELETE and TRUNCATE statements?

answered Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: What are Aggregate and Scalar functions?

answered Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: What is User-defined function? What are its various types?

answered Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: What is Online Transaction Processing (OLTP) ?

answered Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: What are the differences between OLTP and OLAP?

answered Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: What is Collation? What are the different types of Collation Sensitivity?

answered Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: What is a Stored Procedure in SQL?

answered Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: What is a Recursive Stored Procedure?

answered Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: How to create empty tables with the same structure as another table?

answered Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: What is Pattern Matching in SQL?

answered Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: Which of the following is known as a virtual table in SQL?

asked Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: An SQL query to delete a table from the database and memory while keeping the structure of the table intact?

asked Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: Normalization which has neither composite values nor partial dependencies?

asked Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: What is the main advantage of a clustered index over a non-clustered index?

asked Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: SQL query used to fetch unique values from a field?

asked Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: Which statement is false for ORDER BY statement?

asked Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: Query to select all records with "bar" in their name?

asked Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: Which statement is used to update data in the database?

asked Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: What does SQL stand for?

asked Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: What is a Query?

asked Dec 15, 2020 in Sql by SakshiSharma

0 votes

Q: Which statement is false for a FOREIGN KEY constraint?

asked Dec 15, 2020 in Sql by SakshiSharma

To see more, click for all the questions in this category.

...