What are the grouping function in SQL ? Grouping functions are: max()

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 ?

Question Posted / laxman

10 Answers
18151 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

Please Help Members By Posting Answers For Below Questions

Can you explain what is indexed view? How to create it?

850

Explain the dbcc pintable command when would you use it?

865

What are orphan records?

885

What is subreport?

129

Describe in brief sql server monitoring ways.

1000

How to store and query spatial data?

933

How to write a query with a right outer join in ms sql server?

868

Explain about temporary stored procedure?

930

What is sql server english query?

1034

What is the command used to recompile the stored procedure at run time?

1015

Can you import Microsoft Excel data to SSRS?

123

What is meant by datasource?

870

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1322

Can a rule be bound to any column of any data type?

908

How to enter unicode character string literals in ms sql server?

1015