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
- 18574 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 the indexes in sql server?
Mention the 3 ways to get a count of the number of records in a table.
What is collation?
SQL Server Architecture ?
What are diverse clauses that form a part of sql?
What are “unrepeatable reads”?
Can binary strings be used in arithmetical operations?
What is difference between createstatement and preparedstatement?
Can a table have 2 foreign keys?
What is 'Join' and explain its various types.
What are the differences between substr and charindex in sql server.
Explain triggers in sql?
How to declare and use cursor variables?
How we can compare two database data?
Is a primary key unique?
