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
- 18168 Views
- Perot Systems, I also Faced
- E-Mail Answers
Answer Posted / ramesh babu
4) It is used to enforce a set of rules in the database
table. It used to limit the data that can go into
table.
Five type of constraints
Primary key
Unique Key
Foreign Key
Not Null
Check
5) nchar [ ( n ) ]
Fixed-length Unicode character data of n characters. n must
be a value from 1 through 4,000. The storage size is two
times n bytes.
nvarchar [ ( n | max ) ]
Variable-length Unicode character data. n can be a value
from 1 through 4,000. max indicates that the maximum
storage size is 2^31-1 bytes.
9) DML
DML is abbreviation of Data Manipulation Language. It is
used to retrieve, store, modify, delete, insert and update
data in database.
Examples: SELECT, UPDATE, INSERT statements
DDL
DDL is abbreviation of Data Definition Language. It is used
to create the structure of database objects in
database.
Examples: CREATE, ALTER, DROP statements
DCL
DCL is abbreviation of Data Control Language. It is used to
create roles, permissions, and referential integrity as
well
it is used to control access to database by securing it.
Examples: GRANT, REVOKE statements
TCL
TCL is abbreviation of Transactional Control Language. It
is
used to manage different transactions occurring within a
database.
Examples: COMMIT, ROLLBACK statements
11) The DEFAULT constraint is used to insert a default
value into a column.The default value will be added to all
new records, if no other value is specified.
Ex:CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255) DEFAULT 'Chennai'
)
12)No
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are page splits? : SQL Server Architecture
What is the maximum size per database for sql server express?
What is table valued function and scalar valued functions?
What is the advantage of sql server?
What is the difference between lock, block and deadlock? : sql server database administration
Does full backup break log chain?
How to create sub reports?
What is a View ? Can we insert, Update and delete a view?
What is executereader?
How will you add a dimension to cube? : sql server analysis services, ssas
How to send a ssrs report from ssis?
What are data regions?
Explain how would you store your query in an SSRS report or a Database server?
What is Cross Join and in which scenario do we use Cross Join?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
