Which of the following operators perform pattern matching?
Correct Answer: %
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Microsoft SQL Server Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Microsoft SQL Server MCQ Questions
Which of the following statements regarding 'views' are incorrect?
You have a table named 'employees', having the following structure. empid int(4) deptname varchar(50) salary int(4) And a view is created as follows: create view viemployees as select * from employees You want to insert a new row into the table having the following values: empid=1010, deptname=HR, salary=10000. Which of the following are the correct insert SQL queries?
Examine the data in the EMPLOYEES table given below: LAST_NAME DEPARTMENT_ID SALARY Allen 10 3000 Miller 20 1500 King 20 2200 Davis 30 5000 Which of the following sub-queries work?
Which of the following are not Database Models?
Which functions does the following SQL QUERY perform? DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)
What is the default port number for SQL Server?
What does the 'IN' clause do?
In regard to SQL Server Mirroring - A server instance can be a partner in some sessions and a witness in other sessions.
What does the Query Analyzer, or SQL Server Management Studio, tool do?
What is the role of a processadmin user?