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
- 18821 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 is the default schema of your login session in ms sql server?
Where views are stored in sql server?
Explain the difference between HTTP and HTTPS in database?
What is an indexed view?
How can I check if a view exists in a sql server database?
Explain the dbcc pintable command when would you use it?
How to provide login information for a new odbc dsn?
What is the difference between drop table and truncate table?
Explain primary key in sql server?
What does the on delete cascade option do?
Can a table have 2 primary keys?
Can we write ddl in trigger?
Differentiate between sql temp table vs table variable?
How do database indexes work?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
