Questions from Database Systems

Q: What is data quality, and why is it important?

What is data quality, and why is it important?

Q: Write a query to display the first name, last name,

Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title “CLERK I.”...

Q: What are security vulnerabilities? What is a security threat? Give

What are security vulnerabilities? What is a security threat? Give some examples of security vulnerabilities that exist in different IS components.

Q: Define the concept of a data dictionary, and discuss the different

Define the concept of a data dictionary, and discuss the different types of data dictionaries. If you were to manage an organization's entire data set, what characteristics would you look for in the d...

Q: Using SQL statements, give some examples of how you would use

Using SQL statements, give some examples of how you would use the data dictionary to monitor the security of the database.

Q: What characteristics do a CASE tool and a DBMS have in common

What characteristics do a CASE tool and a DBMS have in common? How can these characteristics be used to enhance the data administration?

Q: Briefly explain the concepts of information engineering (IE) and information

Briefly explain the concepts of information engineering (IE) and information systems architecture (ISA). How do these concepts affect the data administration strategy?

Q: Identify and explain some of the critical success factors in the development

Identify and explain some of the critical success factors in the development and implementation of a good data administration strategy.

Q: How have cloud-based data services affected the DBA’s role?

How have cloud-based data services affected the DBA’s role?

Q: What is the tool used by Oracle to create users?

What is the tool used by Oracle to create users?