1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
- 10 Answers
- 19029 Views
- Perot Systems, I also Faced
- E-Mail Answers
Answer Posted / srivas
What is mean by NULL value ?NULL means "" or 0 or
undefined ?
Answer : NULL means empty ie. ""
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
How can I check that whether automatic statistic update is enabled or not?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is sql server query analyzer?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
List out the different types of locks available in sql server?
What is standby servers? Explain types of standby servers.
What is the difference between for xml raw and for xml auto?
How raid can influence database performance?
How to connect php with different port numbers?
Can we do dml on views?
How efficient you are in oracle and SQL server?
Why and when do stored procedure recompile?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is normalization and what are the advantages of it?
What is sql or structured query language?
