Types of connections for connecting the database
Specify the types of connections we use while connecting with the database?
Expert
There exist three types of connections namely:
a) Secured, b) Shared and c) Personal.
Secured connection is used in order to centralize and control the access to the sensitive or critical data. It refers to the safest type of connection in order to protect the access to data.
A shared connection is used in order to access the common resources for example, documents or universes. Various users may therefore use it.
Generally, a personal connection is specific to one user and may be used only from the computer on which it was created.
Describe briefly perform recovery?
What is meant by the Surrogate key?
Give a brief introduction of the term critical column?
Explain the following term: a) ROLAP b) MOLAP
Give a brief introduction of the term data mining and data modeling? In what manner both the termed are used?
Give a brief introduction of the term Dimensional Modeling?
Explain how do you produce the Sequence number within the Data stage?
Briefly describe the new features of SQL Server 2005 Analysis Services (or SSAS)?
What is a derived (artificial) primary key? When must this be used?
Briefly describes the systems development life cycle.
18,76,764
1952707 Asked
3,689
Active Tutors
1418923
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!