Security characteristics of a DBMS
Write down the some of the important security characteristics of a DBMS?
Expert
One of the characteristics includes the employ of views that allows the presentation of only data needed by someone and limits the ability of database updates. The employ of integrity controls includes such things as assertion, domain, and checks. As well authorization rules, encryption, user-defined procedures, authentication schemes, and backups are imperative.
You have been given a setup of tables with data and inquired to make a new database to store them. What are you looking for, when you observe the data values in the tables?
Briefly describe the term ‘BOMain.Key’?
What are the difficulties faced by the database developer during implementing pre compiled statements?
Define the term environment variables?
Explain the Stored Procedure transformation?
What is a derived (artificial) primary key? When must this be used?
Explain, why we use the lookup transformations?
Explain how do you produce the Sequence number within the Data stage?
Specify the tasks of universe designer?
Briefly describe the differentiation between the EXCEPT and INTERSECT operators?
18,76,764
1936688 Asked
3,689
Active Tutors
1427622
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!