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
- 18459 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
Can the query output be sorted by multiple columns in ms sql server?
How many columns can we include on clustered index ?
What is @@error in sql?
How to replace null values in expressions using isnull()?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Is null vs coalesce?
Explain what are the basic functions for master, msdb, model, tempdb databases?
in the physical file layout, where should the transaction log be stored in relation to the data file?
How to change the name of a database user?
What is the use of @@spid?
What is the command used to check locks in microsoft sql server?
Is t sql the same as sql server?
What is the difference between a fill factor of 100 and 0?
Explain encryption of entire databases without the need for application changes in sql server 2008?
How do I completely remove sql server instance?
