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 ?
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
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
In what three ways is the return statement used in a stored procedure?
What are the built in functions in sql server?
How do you start single user mode in clustered installations?
Why the trigger fires multiple times in single login?
Does a specific recovery model need to be used for a replicated database? : sql server replication
What is xdr?
Explain about unique identifier data type in sql server?
What is exclusive locks?
How to create a view on an existing table in ms sql server?
List down some advantages of sql stored procedure?
How to provide values to stored procedure parameters in ms sql server?
What is data mart? : sql server analysis services, ssas
What is rolap and its advantage? : sql server analysis services, ssas
Define outer join?