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
- 19027 Views
- Perot Systems, I also Faced
- E-Mail Answers
Answer Posted / apparao akki
For 10 records..
SQL> Select * from Emp where rownum<=10;
/
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is standby servers? Explain types of standby servers.
How can you append an identity column to a temporary table?
What are the different SQL Server Versions you have worked on?
How to convert character strings into numeric values?
Is it possible to have clustered index on separate drive from original table location?
What is the primary use of the model database?
List out the different types of locks available in sql server?
What is clustered index
Why we use the openxml clause?
What is temporary table in sql server? Why we use temp table?
What is the difference between upgrade and migration in sql server?
Why use identity in sql server?
What is the difference between for xml raw and for xml auto?
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?
How to enter binary string literals in ms sql server?
