sql server onine training

1
For Free Demo Ph1(210)503-7100  For Details
Radiantits.com
2
1.Define DBMS? A management System (DBMS) could
be a program that controls creation, maintenance
and use of a info. Database management system is
termed as File Manager that manages information
during a info instead of saving it in file
systems.
For Free Demo Ph1(210)503-7100  For Details
Radiantits.com
3
2.Define RDBMS? RDBMS stands for computer
database Management System. RDBMS store the info
into the gathering of tables, that is expounded
by common fields between the columns of the
table. It additionally provides relative
operators to control the info hold on into the
tables.
For Free Demo Ph1(210)503-7100  For Details
Radiantits.com
4
3.What is SQL? SQL stands for Structured source
language , and it's accustomed communicate with
the info. this is often a regular language
accustomed perform tasks like retrieval,
updating, insertion and deletion of knowledge
from a info.
For Free Demo Ph1(210)503-7100  For Details
Radiantits.com
5
4.What is Database? Database is nothing however
associate organized variety of information for
straightforward access, storing, retrieval and
managing of knowledge. this is often additionally
called structured variety of information which
may be accessed in many ways.
For Free Demo Ph1(210)503-7100  For Details
Radiantits.com
6
5.Define a primary key? A primary key's a mixture
of fields that unambiguously specify a row. this
is often a special quite distinctive key, and
it's implicit NOT NULL constraint. It means,
Primary key values can't be NULL.
For Free Demo Ph1(210)503-7100  For Details
Radiantits.com
7
6.Define a unique key? A Unique key constraint
unambiguously known every record within the info.
This provides singularity for the column or set
of columns. A Primary key constraint has
automatic distinctive constraint outlined on
that. But not, within the case of distinctive
Key. There is several distinctive constraint
outlined per table, however only 1 Primary key
constraint outlined per table.
For Free Demo Ph1(210)503-7100  For Details
Radiantits.com
8

• 7.Define Foreign key?
• A foreign key's one table which may be associated
  with the first key of another table. Relationship
  must be created between 2 tables by referencing
  foreign key with the first key of another table.

For Free Demo Ph1(210)503-7100  For Details
Radiantits.com
9
8.What is a join? This is a keyword used to query
data from more tables based on the relationship
between the fields of the tables. Keys play a
major role when JOINs are used.
For Free Demo Ph1(210)503-7100  For Details
Radiantits.com
10
9.what's normalization? Normalization is that the
method of minimizing redundancy and dependency by
organizing fields and table of a info. the most
aim of normalization is to feature, delete or
modify field that may be created during a single
table.
For Free Demo Ph1(210)503-7100  For Details
Radiantits.com
11
10.what's Denormalization? Denormalization could
be a technique accustomed access the info from
higher to lower traditional sorts of info. it's
additionally method of introducing redundancy
into a table by incorporating information from
the connected tables
For Free Demo Ph1(210)503-7100  For Details
Radiantits.com
12
For Free Demo Ph1(210)503-7100  For Details
Radiantits.com