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
- 18511 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
How to delete exactly duplicate records from a table?
Indexes are updated automatically is the full-text index also updated automatically?
What is a natural primary key?
Can you tell me about the concept of ER diagrams?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is user defined datatypes and when you should go for them?
How to loop through the result set with @@fetch_status?
What is ssl in sql server?
Determine how to use the inserted and deleted pseudo tables?
Do you know what are the steps to process a single select statement?
Write a program using SQL queries to find a unique entry in a table.
Can one drop a column from a table?
Can group functions be used in the order by clause in ms sql server?
Define msdb database?
Write an sql query to find first weekday of the month?
