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
- 18184 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 raid and what are different types of raid configurations? : Sql server database administration
what is normalization? : Sql server database administration
explain databases and sql server databases architecture? : Sql server database administration
What is collation sensitivity? Explain different types.
What options are available to audit login activity? : sql server security
How to change a login name in ms sql server?
Is candidate a key?
ow to bring suspect mode datbase online from scratch
What is built-in function?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What are character string data types in ms sql server?
What are the main sources of data?
Define inner join in sql server joins?
What are the features of Embedded SQL
Write the queries for commands like Create Table, Delete table, Drop Table etc.
