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.
Write a short note on the difference between embedded and dynamic SQL?
Explain what is meant by the term universe stage?
State the difference between the content store and content manager?
States the term Star Schema?
Illustrates the benefits of running stored procedure upon a database engine?
States the term Global temporary.
Explain the way of establishing connection by ODBC.
Write down a short note on the difference between two and three-tier architectures?
Why recursive relationships are not good? How do you solve them?
What are some of the demerits related with conventional file processing systems?
18,76,764
1959738 Asked
3,689
Active Tutors
1422987
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!