QUESTIONS INTERVIEW.IN

Sign Up | Sign In

Post a Question

Asked Questions

Interview Questions

- Computer Language

- Computer Database

- Data Structure

- Certifications

- Cost Accounting

- Common Interview Questions

Home >> Computer Database >> Sql server

Question

View Answer

=> How many types of system privileges are there, Can we add or delete privileges?

=> How does a differential backup know which extents have changed so that it can be very quickly run?

=> What is the difference between "translate" and "replace"?

=> What is the scale of measurement for the cost threshold for parallelism setting in SQL Server 2005?

=> Report Builder has no built in support for source control. Which of the following choices could be implemented if you decided that those reports needed to be under source control?

=> How to replace particular string. For example:- suppose their are 1000 of records for email-id. like tarun.it@hotmail.com..but i want to replace the only hotmail.com for all email-ids not the user name(tarun.it) with yahoo.com.

=> What is a dirty page and dirty report?

=> Which of the following statements best describes the filter capabilities of Report Builder?

=> What is the difference between weak entity set & strong entity set?

=> What is the cost threshhold for parallelism in SQL Server 2005?

=> Where does Profiler store its temporary data in SQL Server 2005?

=> Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.

=> Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause

=> What is a "trigger"?

=> How will you copy the structure of a table without copying the data?

=> What are "HINTS"? What is "index covering" of a query?

=> How functional dependency is related to database table design?

=> What is the difference between User Identification and Authentication?

=> What is DESCRIBE command in SQL Server?What is its purpose?How to use it?

Page: 5 6 7 8 9 10

Last

Latest Sql server Interview video

Latest Topic

How to Import sqlserver data to mysql?

Uncaught TypeError: extract(): Argument #1 ($array) must be of type array, null given

Fatal error: Uncaught TypeError: extract(): Argument #1 ($array) must be of type array

HTTPS is invalid and might prevent it from being indexed

Deprecated: Required parameter $sql follows optional parameter $name in

Fatal error: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null

Your account isn’t eligible for the Google Workspace Individual plan