Database Security and Administration Practice Exam
Course Introduction
This course explores the principles and practices of ensuring the security and effective administration of database systems. Students will examine topics such as access control, authentication, database auditing, encryption, backup and recovery, and protection against common threats like SQL injection and privilege escalation. Emphasis is placed on both theoretical concepts and practical approaches to safeguard data integrity, confidentiality, and availability. Additionally, the course covers database administration tasks including installation, configuration, performance tuning, and regular maintenance, preparing students to efficiently manage secure and resilient database environments in diverse organizational settings.
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) In a typical Oracle10g application system,the user tier includes a browser.
A)True
B)False
Answer: True
Q2) The Oracle ____ package encrypts outgoing data before it goes onto the network or across the Internet.
A) Online Analytical Processing
B) Label Security
C) Advanced Security
D) Database Extensions for .NET
Answer: C
Q3) ____________________ redo logs contain copies of current and past redo logs for recovery if needed.
Answer: Archive
Q4) The <database name> is usually stored as the ____ environment variable.
A) ORACLE_DB
B) ORACLE_NAME
C) ORACLE_DNAME
D) ORACLE_SID
Answer: D
Page 3
To view all questions and flashcards with answers, click on the resource link above.
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 Instance Manager allows starting and stopping of the database when running the console from a client machine.
A)True
B)False
Answer: False
Q2) The Schema Manager provides a way to manipulate anything in the database that is in a schema.
A)True
B)False
Answer: True
Q3) A ____ is a set of database structures,such as tables,indexes,user-defined attributes,and procedures.
A) session
B) view
C) console
D) schema
Answer: D
Q4) The ____________________ is used for java code buffering specific to user sessions.
Answer: Java pool
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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) Creating a database is a separate process (from the installation process)that occurs after the database software has been installed.
A)True
B)False
Answer: True
Q2) The ____ tool guides you through database setup and creation using windows with instructions for each step.
A) DBCA
B) SQL*Plus
C) OMF
D) OFA
Answer: A
Q3) The CREATE DATABASE ____ option is an optional setting that determines the maximum number of datafiles that can be open when the database is open.
A) MAXLOGFILES
B) MAXLOGMEMBERS
C) MAXINSTANCES
D) MAXDATAFILES
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) ____ lists the names of the control files in use by the database.
A) V$CONTROLFILE
B) V$CONTROLFILE_RECORD_SECTION
C) V$PARAMETER
D) V$DATABASE
Q2) You cannot rename or relocate a control file.
A)True
B)False
Q3) ____ shows data held in the record section.
A) V$CONTROLFILE
B) V$CONTROLFILE_RECORD_SECTION
C) V$PARAMETER
D) V$DATABASE
Q4) Data dictionary views can be updated.
A)True
B)False
Q5) ASM stands for ______________________________.
Q6) What is the purpose of grid computing? How can this be achieved?
Q7) One of the most significant problems with the Oracle ____________________ option is that it is often used inappropriately for backup and failover databases. Page 6
To view all questions and flashcards with answers, click on the resource link above.
Page 7
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) The IMMEDIATE,TEMPORARY,and ____________________ options do not apply to taking a datafile offline.
Q2) A(n)____ is the smallest of the logical units.
A) segment
B) database block
C) schema object
D) extent
Q3) A data block can't be smaller than ____ or larger than 32KB.
A) 1KB
B) 2KB
C) 4KB
D) 8KB
Q4) The primary purpose of a read-only tablespace is to make large amounts of static data available to the database without having to slow down the database backup and recovery or the need for logging and checkpointing.
A)True
B)False
Q5) A(n)____________________ is the set of extents that make up one schema object within a tablespace.
To view all questions and flashcards with answers, click on the resource link above. Page 8
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) ____________________ SQL functions operate on one row at a time.
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) What is an outer join?
Q4) The ____ set operator returns one query less the other,similar to a left outer join where only distinct rows in the first query are returned.
A) UNION ALL
B) INTERSECT
C) MINUS
D) DISTINCT
Q5) Some tables contain hierarchies of data and are natural candidates for using ____________________-joins.
Q6) AS is often used to check membership of one element in a list of elements.
A)True
B)False
9
To view all questions and flashcards with answers, click on the resource link above.
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) Tables can be partitioned to store large quantities of data and increase performance of access to that data.
A)True
B)False
Q2) Clusters speed up the access to sets of tables that are frequently referenced together.
A)True
B)False
Q3) A(n)____________________ alias is a short name for a results column and is used when generating tables or views to give the results column a valid column name.
Q4) Two sessions cannot use the same temporary table at the same time.
A)True
B)False
Q5) The two types of embedded tables are called VARRAYs and ____ tables.
A) nested
B) complex
C) hierarchical
D) embedded
Q6) A table resides in a single tablespace unless it is ____________________.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
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 pointer that directs the database to the actual location of the value is called the ____ locator for internal LOBs.
A) internal
B) external
C) BFILE
D) LOB
Q2) When creating a relational table with a BLOB column,naming the LOB data segment is optional.
A)True
B)False
Q3) How can you decide what chunk size to use when creating a relational table with a BLOB column?
Q4) When creating a relational table with a BLOB column,the ____ parameter sets the number of bytes allocated for working with the LOB value.
A) CHUNK
B) LOB
C) STORAGE
D) STORE AS
Q5) LONG and ____________________ are deprecated.
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) A table can have more than one UNIQUE constraint.
A)True
B)False
Q2) Application constraints cannot be fine-tuned for each application.
A)True
B)False
Q3) Creating a primary key in an Oracle 10g database automatically creates an internal unique ____________________.
Q4) The ON DELETE ____ setting tells Oracle 10g that when a parent row is deleted,all the related child rows are also deleted.
A) DEFER
B) CASCADE
C) SET NULL
D) UPDATE
Q5) What are the advantages of the integrity constraint method of enforcing constraints over the other methods?
Q6) One of the rules of ____________________ is that every table should have a key that contains a unique value for every row.
Q7) What is a reverse key index?
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 ____ parameter for the SET TRANSACTION forces all queries to see data as a snapshot at a single point in time regardless of any database changes after the start of execution of each query in a transaction.
A) READ ONLY
B) ISOLATION LEVEL READ COMMITTED
C) USE ROLLBACK SEGMENT
D) READ WRITE
Q2) The ____ statement allows you to change column values in existing rows in a table.
A) SELECT
B) INSERT
C) MERGE
D) UPDATE
Q3) In general a properly coded application is likely to contain many more ROLLBACK than COMMIT statements.
A)True
B)False
Q4) What does ROLLBACK do?
Q5) Describe the syntax for the single table INSERT statement.
Q6) The locking mode ____________________ prohibits changes and allows queries only.
To view all questions and flashcards with answers, click on the resource link above. Page 13
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) The ____________________ keyword causes an error to be returned from a block of code.
Q2) A(n)____ path load writes data to the end of a table into new block and extent structures,creating new blocks as it goes.
A) direct
B) conventional
C) indirect
D) parallel direct
Q3) Explicit cursors are operated on using the special cursor commands OPEN,GRAB,and CLOSE.
A)True
B)False
Q4) A(n)____________________ block of code is stored and can be recalled later and re-executed again,without having to retype the entire block of code.
Q5) SQLERR is a built-in procedure that returns an error message,determined by the value of SQLCODE.
A)True
B)False
Q6) What is the difference between a function and a procedure?
Page 14
To view all questions and flashcards with answers, click on the resource link above.
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) A ____ is an object based on another object,for example an object type that is based on another object type.
A) derivated object
B) subobject
C) child object
D) template-based object
Q2) There are over ____ system privileges in the Oracle 10g database.
A) 10
B) 100
C) 1000
D) 10000
Q3) A(n)____________________ is simply the name for the calculated value of the weighted sum of the resources consumed by the user session.
Q4) To enforce password complexity you must use a combination of a function and a
A) control file
B) profile
C) configuration file
D) default value
To view all questions and flashcards with answers, click on the resource link above. Page 15
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 P$ Views are also known as the Oracle database performance views.
A)True
B)False
Q2) ____ statistics parameters generate system statistics essential to tuning.
A) Object
B) System
C) Timed
D) Tuning
Q3) The ____ utility can be used to join the trace activity of a single session,from multiple trace files,when using a shared server configuration.
A) Autotrace
B) TKPROF
C) Trace
D) TRCSESS
Q4) There are operating system tools that provide information about the resources of an underlying Oracle database.
A)True
B)False
Q5) What is the role of the TopNNNN tools?
To view all questions and flashcards with answers, click on the resource link above. Page 16
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) Proactive maintenance is contrary to ____________________ maintenance.
Q2) A data warehouse does not need to utilize the database buffer cache nearly as much as an OLTP database so it can be set as small as software will allow.Why?
Q3) Setting the Java pool to zero if Java is in use is a waste of memory resources.
A)True
B)False
Q4) The ____ is made up of various buffers including the shared pool and the database buffer cache.
A) GSA
B) SGA
C) PGA
D) GPA
Q5) With respect to the proactive maintenance default configuration,for most databases it is very likely that you will need to change the default setup in the Database Control.
A)True
B)False
Q6) The ____________________ the undo tablespace,the larger the physical size of changes that can be undone.
To view all questions and flashcards with answers, click on the resource link above. Page 17
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) A ____ standby database passes newly created archive log files to a standby database server computer.Those archive logs are then applied on the standby database computer to the standby database.
A) temporary
B) manual
C) physical
D) backup
Q2) Oracle backup and recovery is actually broken up into ____ separate actions.
A) three
B) four
C) five
D) six
Q3) ____________________ environments consisting of multiple nodes can be useful if one node fails,in which case another node assumes the node of both the failed node and of itself.
Q4) User and application errors are usually object-centric,such as the dropping of a table.
A)True
B)False
Q5) How does a cold backup work?
To view all questions and flashcards with answers, click on the resource link above. Page 18