Automation testing QTP with ISTQB Exam modal papers
Automation testing QTP with VB Script functions
Constants in C
Data types in C
File management in Unix
Introduction to C
Process Model and IPC
Variables in C
Sqlserver interview questions
Total available count: 38
Subject - Databases
Subsubject - Sqlserver
Difference between Index defrag and Index rebuild in SQL Server?
Disadvantage of Index in SQL Server?
Explain different types of Locks in SQL Server?
Explain SQL Server Index Optimization tips?
Explain the difference between a Local and a Global temporary table?
Explain the difference between text and image data type?
Explain the differences between char, nvarchar and varchar in SQL Server?
Explain the joins in SQL Server?
Explain Transact-SQL optimization tips?
How can a programmer enforce to use particular Index?
How many clustered indexes can a table have?
How many types of Joins in SQL Server?
What are different types of Collation Sensitivity?
What are the authentication modes in SQL Server?
What are the data types in SQL Server?
What are the difference between clustered and a non-clustered index?
What are the differences between UNION and JOINS in SQL Server?
What are the different index configurations a table can have?
What are the properties and different Types of Sub-Queries?
What do you mean by ACID?
What is a Primary key?
What is Check Constraint?
What is difference between DELETE and TRUNCATE commands?
What is fill factor in SQL Server?
What is Foreign key?
What is Index in SQL Server?
What is Index Tuning in SQL Server?
What is NOT NULL Constraint?
What is OLTP (Online Transaction Processing)?
What is sorting and what is the difference between sorting & clustered Indexes?
What is SQL Profiler?
What is SQL Server Agent?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What is the difference between a primary key and a unique key?
What is the difference between UNION and UNION ALL?
What is Unique key constraint?
When is the use of UPDATE_STATISTICS command?
Which TCP/IP port does SQL Server run on? How can it be changed?
2020 www.slightbook.com | All Rights Reserved