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
- 18433 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 bit data type? What's the information that can be stored inside a bit column?
What are the different authentication modes in sql server? How can it be changed?
How to drop existing indexes in ms sql server?
Explain trigger and its types?
List all types of constraints in sql server?
What is the significance of null value and why should we avoid permitting null values?
when would you go for denormalization? : Sql server database administration
Explain the categories of stored procedure?
What is the use of tempdb? What values does it hold?
Explain the types of indexes.
Explain the use of keyword with encryption. Create a store procedure with encryption?
What is a dataset and what are the different types of datasets?
SQL Server Architecture ?
Explain datetime2 data type in sal server 2008?
Do you know data definition language, data control language and data manipulation language?
