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
- 16574 Views
- Perot Systems, I also Faced
- E-Mail Answers
Answer Posted / laxman
What are the grouping function in SQL ?
Grouping functions are:
max()
min()
sum()
avg()
Select 10 rows from a table ?
select * from table_name where count(*) <=10
or
select top 10 from table _name
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
Null is not equal to "" or 0. it is un identified value
12. Can we have more then primary Key in table ?
no, we can't.
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
i dont know exactly. but it likely base table doesnt exists.
4. What is constraints and types ?
types:
primary key
foreign key
not null
unique
defaults
check
rule
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is dbcc updateusage?
what are the core components of SSRS?
When is update_statistics command used?
What is row_number function?
what is create database syntax? : Sql server database administration
what is the main function of a query parameter?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is the difference between push and pull subscription? : sql server replication
How can you check the level of fragmentation on a table?
Do you know what are the differences between lost updates and uncommitted dependencies?
If no size is defined while creating the database, what size will the database have?
Do you know what are the properties of the relational tables?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What are the types of subscriptions in SQL Server replication?
What are the reporting services components?
