Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18845 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 difference between foreign key and unique key?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What are different types of views?
What are the differences between left join and inner join in sql server?
What is the importance of three tier architecture?
Why olap is used?
How to delete multiple rows with one delete statement in ms sql server?
Which are the olap features?
Explain how to send email from sql database?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the purpose of grouping data in a report?
Can you name some of the dml commands in sql?
How to filter records of table in SQL SERVER?
What are different types of join?
