Exam 15: Database Administration and Security
Exam 1: Database Systems70 Questions
Exam 2: Data Models70 Questions
Exam 3: The Relational Database Model100 Questions
Exam 4: Entity Relationship (ER)Modeling100 Questions
Exam 5: Advanced Data Modeling70 Questions
Exam 6: Normalization of Database Tables100 Questions
Exam 7: Introduction to Structured Query Language (SQL)100 Questions
Exam 8: Advanced SQL100 Questions
Exam 9: Database Design100 Questions
Exam 10: Transaction Management and Concurrency Control70 Questions
Exam 11: Database Performance Tuning and Query Optimization70 Questions
Exam 12: Distributed Database Management Systems70 Questions
Exam 13: Business Intelligence and Data Warehouses100 Questions
Exam 14: Database Connectivity and Web Technologies100 Questions
Exam 15: Database Administration and Security100 Questions
Select questions type
____ are general statements of direction or action that communicate and support DBA goals.
(Multiple Choice)
4.9/5
(37)
The testing and evaluation of a database application cover all aspects of the system-from the simple collection and creation of data to its use and retirement.What is covered by the evaluation process?
(Essay)
4.9/5
(36)
A(n)____ serves as the basis for planning,development,and control of future information systems
(Multiple Choice)
4.7/5
(40)
The security,privacy,and integrity of the data in the database are of minimal concern to DBAs who manage current DBMS installations.
(True/False)
4.9/5
(44)
The requirement that a password must have a maximum of 12 characters is an example of a(n)____________________.
(Short Answer)
4.9/5
(28)
Several DBMS packages contain features that allow the creation of a(n)____,which automatically records a brief description of the database operations performed by all users.
(Multiple Choice)
4.9/5
(42)
By default,Oracle automatically creates ____________________ and SYS user IDs that have administrative privileges with every new database you create.
(Short Answer)
4.9/5
(27)
Some common physical security practices found in large database installations include secured entrances,password-protected workstations,____,closed-circuit video,and voice-recognition technology.
(Multiple Choice)
4.8/5
(29)
Procedures and standards must be revised at least ____ to keep them up-to-date.
(Multiple Choice)
4.9/5
(37)
____________________ focuses on maintaining the data free of inconsistencies and anomalies.
(Short Answer)
4.9/5
(35)
The end user must provide testing and evaluation services for all the database and DBA applications.
(True/False)
4.8/5
(38)
At the level of middle management,the database must be able to ____.
(Multiple Choice)
4.8/5
(29)
There is a growing trend toward ____ in the data-management function.
(Multiple Choice)
4.8/5
(31)
Performance monitoring and ____________________ require much of the DBA's attention and time.These activities are designed to ensure that the DBMS,utilities,and applications maintain satisfactory performance levels.
(Short Answer)
5.0/5
(33)
____ CASE tools provide support for the coding and implementation phases.
(Multiple Choice)
4.9/5
(40)
In the Oracle Enterprise Manager,a ____ is basically any object created by end users;for example,tables,views,indexes,stored procedures,and triggers.
(Multiple Choice)
4.8/5
(34)
Disaster management includes all the end-user activities designed to secure data availability following a physical disaster or a database integrity failure.
(True/False)
4.9/5
(33)
A(n)________________________________________ provides a framework that includes the use of computerized,automated,and integrated tools such as a DBMS and CASE tools.
(Short Answer)
4.9/5
(35)
Instructions to create a password are an example of a ____.
(Multiple Choice)
4.9/5
(35)
Showing 61 - 80 of 100
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)