Database Implementation and Security
Solved Exam Questions
Course Introduction
This course explores the principles and practices involved in implementing and securing modern database systems. Students will learn about relational and non-relational database architectures, data modeling, SQL query development, and database application programming. The course emphasizes strategies for securing databases, including access control, encryption, auditing, and ensuring data integrity. Through practical exercises and projects, students will develop skills in configuring databases, managing user privileges, defending against common threats such as SQL injection, and implementing backup and recovery solutions to maintain data availability and confidentiality.
Recommended Textbook
Oracle 10g Database Administrator Implementation and Administration 2nd Edition by Gavin Powell
Available Study Resources on Quizplus
15 Chapters
1424 Verified Questions
1424 Flashcards
Source URL: https://quizplus.com/study-set/1654
Page 2
Chapter 1: Oracle Architecture Overview
Available Study Resources on Quizplus for this Chatper
79 Verified Questions
79 Flashcards
Source URL: https://quizplus.com/quiz/32808
Sample Questions
Q1) The Oracle ____ tool provides the network link between the Oracle10g database and most applications that communicate with the database.
A) Application Server
B) Financials
C) JDeveloper
D) Net Services
Answer: D
Q2) OFA provides standards intended to improve performance of the database by,among other things,spreading I / O functions across separate devices by separating data from software.
A)True
B)False
Answer: True
Q3) When installing Oracle10g on Windows 2000,you should not install Service Pack 3 before installing the Oracle software because it has some incompatibility issues with Oracle.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Tools and Architecture
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/32809
Sample Questions
Q1) The ____ allows definition of all possible individual sections of configuration for Oracle Net Services.
A) Schema Manager
B) Net Configuration Assistant
C) Security Manager
D) Storage Manager
Answer: B
Q2) The Schema Manager performs storage-related tasks in the Oracle10g database.
A)True
B)False
Answer: False
Q3) Oracle ____________________ is made up of several subcomponents that work together to translate your requests,such as SQL queries,into network packages for the local,or Internet,network.
Answer: Net Services
Q4) The SID has been replaced by the service name in Oracle8i and higher.
A)True
B)False Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Creating an Oracle Instance
Available Study Resources on Quizplus for this Chatper
109 Verified Questions
109 Flashcards
Source URL: https://quizplus.com/quiz/32810
Sample Questions
Q1) In the SQL*Plus statement CONNECT / @ORACLASS AS SYSDBA,the ____ tells the database to use OS authentication.
A) CONNECT
B) @
C) /
D) AS
Answer: C
Q2) Omitting a fully qualified DATAFILE clause in the CREATE DATABASE command causes Oracle 10g to create Oracle Managed Files as the datafiles for the SYSTEM tablespace.
A)True
B)False
Answer: True
Q3) A(n)____ database is used to service Internet applications.
A) Custom
B) Data Warehouse
C) General Purpose
D) OLTP
Answer: D
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Oracle Physical Architecture and Data Dictionary Views
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/32811
Sample Questions
Q1) Other than the huge impact of parallel processing of multiple partitions concurrently,or eliminating unwanted partitions (partitioning ____________________),various tricks can be performed with partitioning.
Q2) DBA prefixed views are solely for database administration use,allowing access to everything in the database,regardless of who owns it.
A)True
B)False
Q3) The ____ data dictionary view contains source code for all stored objects,such as functions,Java source,and triggers.
A) DBA_SOURCE
B) SOURCE
C) USER_SOURCE
D) USR_SRC
Q4) If the control file is damaged,the database is damaged too.
A)True
B)False
Q5) Data dictionary views can be updated.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Basic Storage Concepts and Settings
Available Study Resources on Quizplus for this Chatper
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/32812
Sample Questions
Q1) What are rollback segments?
Q2) A(n)____ is the smallest of the logical units.
A) segment
B) database block
C) schema object
D) extent
Q3) A ____-managed tablespace stores the details about its free space and other information inside the data dictionary tables,in the SYSTEM tablespace.
A) locally
B) dictionary
C) remotely
D) distributively
Q4) The size of an operating system block is 8 bytes.
A)True
B)False
Q5) A database may not contain a large number of tablespaces.
A)True
B)False
Q6) You can drop an undo tablespace by using the ____________________ TABLESPACE command.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: The Basics of Querying a Database
Available Study Resources on Quizplus for this Chatper
109 Verified Questions
109 Flashcards
Source URL: https://quizplus.com/quiz/32813
Sample Questions
Q1) ____________________ represents nothing,not a space,not a zero (0),or even an unknown value;simply nothing.
Q2) If you obtain a description of the DUAL table using the DESC command in SQL*Plus Worksheet,you will see that the only column present is called ____.
A) DUAL
B) NULL
C) VOID
D) DUMMY
Q3) The GROUP BY clause column list ____ include all columns in the SELECT statement not affected by any aggregate functions.
A) must B) must not C) should D) should not
Q4) Use of upper- and lowercase is only a factor in queries for strings or expressions enclosed in Oracle database quotation marks.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Basic Table Management
Available Study Resources on Quizplus for this Chatper
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/32814
Sample Questions
Q1) A chained or migrated row is located by the ____________________ stored in the row header.
Q2) A(n)____ is a calculation producing an integer for a particular value of a string.
A) raw value
B) index
C) VARRAY
D) hash value
Q3) A subpartition ____________________ describes all the subpartitions once and then all the partitions that use it.
Q4) A(n)____________________ value is a value that is filled into the column when an inserted row does not specify the value for that column.
Q5) The ____ runs on a database server through an HTTP protocol and could have security issues.
A) Enterprise Manager
B) Database Control
C) SQL*Plus
D) SQL*Plus Worksheet
Q6) A table resides in a single tablespace unless it is ____________________.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Advanced Table Management
Available Study Resources on Quizplus for this Chatper
84 Verified Questions
84 Flashcards
Source URL: https://quizplus.com/quiz/32815
Sample Questions
Q1) The BLOB,CLOB,and NCLOB datatypes all have their data stored outside the database.
A)True
B)False
Q2) How can you decide what chunk size to use when creating a relational table with a BLOB column?
Q3) The LOB datatypes are divided into ____ groups,according to where they are stored.
A) two B) three C) four
D) five
Q4) When deallocating space,the data blocks that are below the high watermark are released back to the database.
A)True
B)False
Q5) When an internal LOB is stored out of line,a separate LOB data ____________________ is created.
Q6) LONG and ____________________ are deprecated.
Q7) The BLOB,CLOB,and NCLOB datatypes are called ____________________ LOBs.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Constraints, indexes, and Other Specialized Objects
Available Study Resources on Quizplus for this Chatper
108 Verified Questions
108 Flashcards
Source URL: https://quizplus.com/quiz/32816
Sample Questions
Q1) PRIMARY KEY column(s)is / are usually placed ____ the table. A) at the beginning of B) at the end of C) anywhere in D) randomly in
Q2) Integrity constraints are always enforced,no matter what application or tool is used to modify a table's data.
A)True
B)False
Q3) ____ is a pseudocolumn that represents the current date and time.
A) DATE
B) TODAY
C) CURRENT
D) SYSDATE
Q4) The indexed columns in a ____ index should have low cardinality.
A) cluster
B) BTree
C) domain
D) bitmap
Q5) An index containing multiple columns is called a(n)____________________ index. Page 11
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Basic Data Management
Available Study Resources on Quizplus for this Chatper
65 Verified Questions
65 Flashcards
Source URL: https://quizplus.com/quiz/32817
Sample Questions
Q1) The ____________________ statement makes pending changes permanent for an existing transaction in the current session.
Q2) External tables can have all DML statements executed against them.
A)True
B)False
Q3) Default settings for the SET TRANSACTION statement are READ WRITE and ISOLATION LEVEL READ COMMITTED.
A)True
B)False
Q4) A transaction starts whenever a DML statement is issued.
A)True
B)False
Q5) The locking mode ____ locks a table (or an updatable view),disallowing locking of the table in SHARE mode,and prohibiting changes to the table.
A) SHARE ROW EXCLUSIVE
B) SHARE
C) EXCLUSIVE
D) SHARE UPDATE
Q6) Database changes are undone using a(n)____________________ statement.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Advanced Data Management
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/32818
Sample Questions
Q1) A cursor ____________________ is an implicit cursor on the basis that it does not require use of the OPEN,FETCH,and CLOSE statements.
Q2) A ____ is a block of code that allows by value and by reference parameters with no return value.
A) function
B) trigger
C) package
D) procedure
Q3) The ____________________ keyword causes an error to be returned from a block of code.
Q4) You can invoke SQL*Loader from a shell using the ____________________ command.
Q5) What is the difference between a by value parameter and a by reference parameter?
Q6) A(n)____ is an event-driven procedure. A) function
B) trigger C) package D) exception
Page 14
Q7) What is the difference between a function and a procedure?
Q8) What is an associative array?
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 12: Security Management
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/32819
Sample Questions
Q1) Oracle10g allows a quota allocation on the TEMP tablespace;Oracle 9i did not.
A)True
B)False
Q2) If a user has created other users,those users are not dropped when the creating user is dropped.
A)True
B)False
Q3) You can find out what your current password settings are by running the following query:
SELECT * FROM _________________________;
Q4) The syntax of DROP PROFILE is similar to the syntax for dropping a user in that it includes a(n)____________________ parameter.
Q5) The ____ data dictionary view contains all object privileges granted.
A) DBA_SYS_PRIVS
B) DBA_OBJ_PRIVS
C) DBA_OBJ_PRIVS_MADE
D) DBA_TAB_PRIVS
Q6) System privileges are more pinpointed than object privileges.
A)True
B)False
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Performance Monitoring
Available Study Resources on Quizplus for this Chatper
84 Verified Questions
84 Flashcards
Source URL: https://quizplus.com/quiz/32820
Sample Questions
Q1) The STATSPACK is the recommended tool for statistics generation in Oracle 10g.
A)True
B)False
Q2) ____ is a particular tool that is very good for monitoring performance of busy production databases.
A) Trace
B) Spotlight
C) Wait Event Interface
D) Database Control
Q3) Automatic SQL tuning is new to Oracle 10g Database where the optimizer can be switched from normal mode to a tuning mode.
A)True
B)False
Q4) Autotrace can be enabled using the SET AUTOTRACE ENABLE EXPLAIN command,executed from within SQL*Plus.
A)True
B)False
Q5) What is the role of the TopNNNN tools?
Q6) Describe the files generated by SQL Trace.
Page 17
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Proactive Maintenance
Available Study Resources on Quizplus for this Chatper
83 Verified Questions
83 Flashcards
Source URL: https://quizplus.com/quiz/32821
Sample Questions
Q1) ____________________ undo allows rollback of transactions,recovery of aborted and partly completed transactions,and some recovery.
Q2) An increase in shared pool size may harm performance.
A)True
B)False
Q3) Describe the sections of the segment advisor.
Q4) AWR stands for ______________________________.
Q5) The ____advisor searches for,automatically detects,and posts warnings and alerts for segment issues.
A) Memory
B) Undo Management and Undo
C) ADDM
D) Segment
Q6) ____ is the session connection memory that is shared by connections to the database server.
A) GSA
B) SGA
C) PGA
D) GPA
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 15: Backup and Recovery
Available Study Resources on Quizplus for this Chatper
86 Verified Questions
86 Flashcards
Source URL: https://quizplus.com/quiz/32822
Sample Questions
Q1) The ____________________ process is essentially the application of redo log entries,from both redo log files and archive log files,back into the datafiles.
Q2) A type of hot backup is a ____ backup,for which you switch a tablespace into a special mode called backup mode.
A) tablespace
B) logical
C) physical
D) consistent
Q3) Loss of an application datafile includes any non-system tablespace,excluding the ____________________ and the SYSAUX tablespace.
Q4) ____ is the process of rebuilding a database after some part of a database has been lost.
A) Backup
B) Restoration
C) Recovery
D) Rollback
Q5) What can be done to avoid Oracle Database-induced failures?
Q6) With respect to a backup strategy,what is the acceptable loss upon failure?
To view all questions and flashcards with answers, click on the resource link above. Page 19