Which SQL statement is used to extract data from a database?
Which SQL statement is used to extract data from a database?
Which of the following best describes the purpose of SQL?
Which of the following best describes the purpose of SQL?
What does SQL stand for?
What does SQL stand for?
Which of the following is the instance of SQL Server that is your production server in log shipping?
Which of the following is the instance of SQL Server that is your production server in log shipping?
Which organization is responsible for maintaining the SQL standard?
Which organization is responsible for maintaining the SQL standard?
Which of the following is the main feature of dotConnect for SQL Server?
Which of the following is the main feature of dotConnect for SQL Server?
Backing up your SQL Server database is essential for _______ your dat
Backing up your SQL Server database is essential for _______ your dat
Which SQL standard introduced JSON data types and support for temporal data?
Which SQL standard introduced JSON data types and support for temporal data?
Which of the following SQL Server tools is used to enhance data management and governance?
Which of the following SQL Server tools is used to enhance data management and governance?
When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.
When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.
Which version of SQL introduced window functions and common table expressions (CTEs)?
Which version of SQL introduced window functions and common table expressions (CTEs)?
Which of the following is NOT a category of SQL commands?
Which of the following is NOT a category of SQL commands?
In a database, what is a unique identifier for each record in a table called?
In a database, what is a unique identifier for each record in a table called?
How does a transaction ensure data integrity in SQL?
How does a transaction ensure data integrity in SQL?
Which SQL keyword is used to sort the data returned by a SELECT statement?
Which SQL keyword is used to sort the data returned by a SELECT statement?
Which of the following command is used to create a database in SQL?
Which of the following command is used to create a database in SQL?
What is the purpose of the SQL keyword “DISTINCT” in a SELECT statement?
What is the purpose of the SQL keyword “DISTINCT” in a SELECT statement?
What command is used to create a new table in SQL?
What command is used to create a new table in SQL?
In SQL, what is the purpose of the WHERE clause in a DELETE statement?
In SQL, what is the purpose of the WHERE clause in a DELETE statement?
Identify the error in
"ALTER TABLE Students DROP COLUMN DateOfBirth date;"
Identify the error in
"ALTER TABLE Students DROP COLUMN DateOfBirth date;"
Correct the syntax error in
"CREATE TABLE Students (ID int PRIMARY, Name varchar(50));"
Correct the syntax error in
"CREATE TABLE Students (ID int PRIMARY, Name varchar(50));"
What does the UPDATE command in SQL do?
What does the UPDATE command in SQL do?
Correct the syntax error in
"DELETE FROM Employees HAVING Age < 25;"
Correct the syntax error in
"DELETE FROM Employees HAVING Age < 25;"
Identify the error in
"UPDATE Employees SET Salary = Salary * 1.05 WHERE;"
Identify the error in
"UPDATE Employees SET Salary = Salary * 1.05 WHERE;"
Which of the following is used to overcome the Replication in SQL Server?
Which of the following is used to overcome the Replication in SQL Server?
Which SQL standard introduced support for object-oriented features, recursive queries, and XML data types?
Which SQL standard introduced support for object-oriented features, recursive queries, and XML data types?
Which of the following language is used for procedural flow in SQL Server?
Which of the following language is used for procedural flow in SQL Server?
Which of the following feature of SQL Server was used before XML technology for semi structured data?
Which of the following feature of SQL Server was used before XML technology for semi structured data?
Who is credited with the creation of SQL?
Who is credited with the creation of SQL?
Which of the following pair of technology is supported in SQL Server?
Which of the following pair of technology is supported in SQL Server?
Which of the following is the instance of SQL Server that is your production server in log shipping?
Which of the following is the instance of SQL Server that is your production server in log shipping?
Backing up your SQL Server database is essential for _______ your data.
Backing up your SQL Server database is essential for _______ your data.
Which of the following SQL Server tools is used to enhance data management and governance?
Which of the following SQL Server tools is used to enhance data management and governance?
When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.
When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.
Which of the following is used to overcome the Replication in SQL Server?
Which of the following is used to overcome the Replication in SQL Server?
Which of the following is basis for SQL?
Which of the following is basis for SQL?
In which year was the first paper outlining the relational model published by Edgar F. Codd?
In which year was the first paper outlining the relational model published by Edgar F. Codd?
Exception handling is possible in SQL Server using _____________
Exception handling is possible in SQL Server using _____________
What was the initial name of SQL proposed by IBM?
What was the initial name of SQL proposed by IBM?
Which of the following is the main feature of dotConnect for SQL Server?
Which of the following is the main feature of dotConnect for SQL Server?
Which version of SQL standardized many features that are still in use today, such as joins and subqueries?
Which version of SQL standardized many features that are still in use today, such as joins and subqueries?
Which is the default field terminator for bulk insert in SQL Server?
Which is the default field terminator for bulk insert in SQL Server?
Which of the stored procedure is used to test the SQL injection attack?
Which of the stored procedure is used to test the SQL injection attack?
Which ANSI/ISO standard introduced the first official SQL specification in 1986?
Which ANSI/ISO standard introduced the first official SQL specification in 1986?
User defined function in SQL Server can return ____________
User defined function in SQL Server can return ____________
DML triggers in SQL Server is applicable to _____________
DML triggers in SQL Server is applicable to _____________
Which company introduced the first commercial relational database management system (RDBMS) based on SQL?
Which company introduced the first commercial relational database management system (RDBMS) based on SQL?
Which of the following stored procedure is already defined in SQL Server?
Which of the following stored procedure is already defined in SQL Server?
Which of the following stored procedure is already defined in SQL Server?
Which of the following stored procedure is already defined in SQL Server?
Which of the following tasks CANNOT be accomplished using SQL?
Which of the following tasks CANNOT be accomplished using SQL?