Answer Posted / chiru
1
| Is This Answer Correct ? | 3 Yes | 13 No |
Post New Answer View All Answers
Write the queries for commands like Create Table, Delete table, Drop Table etc.
How to check if a table is being used in sql server?
What are the benefits and tasks of object explorer? : sql server management studio
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What are data resources?
Differentiate between SQL and ORACLE joins and write their syntax.
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Can we use max in where clause?
How do you use a subquery to find records that exist in one table and do not exist in another?
How global temporary tables are represented and its scope?
What do you mean by a Composite primary key?
What are the two authentication modes in sql server?
What is normalization and its types?
What is page-level compression?
What is the difference between value type and reference type?