Database Management Systems
Exam Practice Tests
Course Introduction
Database Management Systems is a course that introduces the fundamental concepts, design, and implementation of modern database management systems. Students will explore data models, relational databases, and Structured Query Language (SQL) while examining topics such as data normalization, indexing, transactions, concurrency control, and database security. The course also covers emerging trends and technologies, including NoSQL systems, distributed databases, and big data management, providing hands-on experience through practical assignments and projects. By the end of the course, students will possess a solid foundation to design, develop, and manage robust database solutions for a variety of real-world applications.
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 company called ____ offers a complete graphic information system software solution for computer-generated maps that stores all its data in your Oracle10g database.
A) GIS
B) ESRI
C) Sybase
D) Symantec
Answer: B
Q2) A ____ is a physical file on the computer disk containing data,such as tables and indexes.
A) redo log
B) datafile
C) control
D) tablespace
Answer: B
Q3) ____________________ redo logs contain copies of current and past redo logs for recovery if needed.
Answer: Archive
Q4) RAC stands for _________________________.
Answer: Real Application Clusters
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) When you are using tools that reside on the same computer as the database,you might assume that no Oracle Net Services connection is needed.
A)True
B)False
Answer: True
Q2) An easy way to validate configuration is to use an Oracle version of the TCP / IP ping utility,called ____.
A) tnsping
B) netmgr
C) netping
D) tcpping
Answer: A
Q3) The _________________________ network name is used to call external programs (external to Oracle software),such as DLL's.
Answer: EXTPROC_CONNECTION_DATA
Q4) The ____________________ file is stored on the database server,providing configuration for how the listener process listens over the network,for connection requests.
Answer: listener.ora
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) Oracle recommends that you multiplex your control file.
A)True
B)False
Answer: True
Q2) The ____ database configuration option allows for a lot of change activity,raising concurrency requirements,and lowering I / O activity requirements.
A) Custom
B) Data Warehouse
C) General Purpose
D) Transaction Processing
Answer: D
Q3) There are well over ____ initialization parameters.
A) 50
B) 200
C) 500
D) 1000
Answer: B
Q4) The Oracle command,____________________ creates the password file. Answer: orapwd
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) Multiple tablespaces can share the same datafile.
A)True
B)False
Q2) An online redo log group (or member of a group)can be dropped only when the group is ____________________.
Q3) The ____________________ tablespace contains Oracle database metadata structures.
Q4) ____ lists current checkpoint numbers and control file sequence numbers.
A) V$CONTROLFILE
B) V$CONTROLFILE_RECORD_SECTION
C) V$PARAMETER
D) V$DATABASE
Q5) ____ partitioning splits a table based on distinct ranges of values,such as quarters in a year.
A) Hash
B) Composite
C) Range
D) List
Q7) DDL stands for _________________________. Page 6
Q6) RAC stands for _________________________.
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) When you modify the DEFAULT ____________________ clause from its original settings using the ALTER TABLESPACE command,the new settings only affect blocks created after the change.
Q2) All critical errors need to be sent to the trace files.
A)True
B)False
Q3) Logical structures can be viewed or modified outside the database (from the operating system).
A)True
B)False
Q4) The biggest issue with using locally managed tablespaces is one of performance.
A)True
B)False
Q5) When you use ____,you allow the database to determine the actual names of datafiles.
A) OMF
B) OFA
C) RAC
D) SQL*Plus
Q6) Tables,indexes,and other objects are created within a(n)____________________.
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) A(n)____ is not a function,but can be added to a table query or into other SQL commands to retrieve values not normally accessed from simple table queries.
A) NULL
B) marker
C) index
D) pseudocolumn
Q2) The ____ SQL group function adds values across rows in a group
A) ADD
B) ADDITION
C) SUM
D) SUMMATION
Q3) Most Oracle database built-in functions will return a NULL value when passed a NULL value.
A)True
B)False
Q4) Pseudocolumns contain values present in a table,but not in an Oracle instance.
A)True
B)False
Q5) What is an outer join?
To view all questions and flashcards with answers, click on the resource link above. Page 9
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) The ____ are bytes of storage used for rows inserted or updated in a data block.
A) row data
B) free space
C) chained rows
D) segments
Q2) ____ are rules that define data integrity for a column or group of columns.
A) Raw date
B) Optimizers
C) Constraints
D) Restrictions
Q3) A query cannot execute against a single partition.
A)True
B)False
Q4) Technically,a ____ is not a table,but a group of tables stored together as if they were one table.
A) partition
B) cluster
C) nested table
D) block
Q5) What is XML?
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) A non index-organized table is also called a heap-organized or ____________________ table.
Q2) Index-organized tables help you query table rows more quickly by reducing the number of times a process must read either memory or disk to retrieve the row data,when rows are read according to the ____.
A) primary key
B) foreign key
C) index
D) pseudocolumn
Q3) A good use for index-organized tables is a table in which most of the columns are indexed within the primary key of the table and the data that is not part of the primary key is relatively small and static.
A)True
B)False
Q4) Why should you periodically analyze tables in a schema?
Q5) There is more to the FLASHBACK TABLE command than simply recovering tables from the recycle bin.
A)True
B)False
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) You cannot change the state of a NOT NULL constraint.
A)True
B)False
Q2) Any constraint other than ____ can be dropped using the ALTER TABLE DROP CONSTRAINT command.
A) NOT NULL
B) CHECK
C) PRIMARY KEY
D) FOREIGN KEY
Q3) A data dictionary view named ____ lists indexed column names and statistics either owned by the user or accessible to the user.
A) ALL_IND_COLUMNS
B) DBA_IND_COLUMNS
C) USER_IND_COLUMNS
D) ALL_INDEXES
Q4) The ____ data dictionary view lists the columns associated with each constraint.
A) ALL_CONSTRAINTS
B) ALL_CONS_COLUMNS
C) ALL_COLUMNS
D) ALL_CONS_COLS
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) Why can DDL statements not be rolled back?
Q2) The locking mode ____ is similar to ROW SHARE,additionally prohibiting a SHARE lock on the table.
A) SHARE ROW EXCLUSIVE
B) SHARE UPDATE
C) ROW EXCLUSIVE
D) MODE
Q3) It is important for database administrators to understand how COMMIT and ROLLBACK statements function.
A)True
B)False
Q4) In relational database terminology a(n)____________________ is a sequence of one or more DML statement-induced database changes,not yet permanently committed to that database.
Q5) The ____________________ statement makes pending changes permanent for an existing transaction in the current session.
Q6) A(n)____________________ contains data in a file outside the database,such as in a text file.
Q7) Describe the syntax for the single table INSERT statement.
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) In an anonymous procedure or block any local variables must be declared using the ____________________ keyword,in the declaration section.
Q2) The ____________________ keyword is required in PL / SQL in to copy unique values retrieved by a SELECT statement into program variables.
Q3) An advantage of Data Pump over the original Import and Export utilities is that Data Pump has metadata filters allowing inclusion and exclusion of specific metadata items. A)True
B)False
Q4) By reference (BYREF)implies that a variable is a pointer and can be passed into,but not out of,a procedure within procedure parameters.
A)True
B)False
Q5) 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.
Q6) In programming terms a block is a block of ____________________.
Q7) The PL / SQL ____________________ datatype stores a TRUE,FALSE or null value.
To view all questions and flashcards with answers, click on the resource link above.
Page 14
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) The ____ predefined role provides extensive abilities to create objects,such as procedures,triggers,and object types,for users who need to create their own objects.
A) CONNECT
B) DBA
C) RESOURCE
D) OBJECT
Q2) It is advisable to store temporary segments in the SYSTEM tablespace.
A)True
B)False
Q3) Very few privileges are given to ____________________ (all users).
Q4) After a user has a role,you cannot add more privileges to the role.
A)True
B)False
Q5) The creator of a role or the DBA can adjust the default roles for a user using the ____________________ command.
Q6) A(n)____________________ privilege gives a user the ability to manage some part of the database system.
Q7) Most privileges are given to specific users or ____________________.
Q8) How can you turn off auditing?
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) Statistics are a computation or estimation of the exact size and placement of data in tables and indexes.
A)True
B)False
Q2) Setting dynamic sampling to ____ switches it off.
A) 0
B) NULL
C) FALSE
D) DISABLE
Q3) A(n)____ lock completely prohibits changes to data,but still allows read access.
A) exclusive
B) share
C) full
D) complete
Q4) The easiest way to access performance metrics is to administer and analyze them using the ____.
A) Enterprise Manager
B) Optimizer
C) Database Control
D) DBMS_STATS package
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) The objective of proactive maintenance is to prevent critical problems ____________________ they occur and damage a database.
Q2) The primary focus of the ____________________ advisor is forecasting.
Q3) The ______________________________ contains memory required for concurrent connections.
Q4) The undo advisor works best with ____________________ undo.
Q5) ____ is not a port commonly used by the Database Control.
A) 1158
B) 3367
C) 5500
D) 5600
Q6) 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?
Q7) Proactive maintenance is contrary to ____________________ maintenance.
Q8) Running out of disk space can crash a database because it has no space to write changes to disk.
A)True
B)False
Q9) SGA stands for ____________________.
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(n)computer ____________________ differs from a cluster in that there is no common shared storage area.
Q2) The redo log buffer is always larger than the database buffer cache.
A)True
B)False
Q3) The UNDO and TEMP tablespaces are usually only backed up during a ____ backup because of the flexible nature of their contents.
A) tablespace
B) consistent
C) hot
D) cold
Q4) The redo logs and ____ logs consist of records of all transactions made to a database.
A) backup
B) recovery
C) undo
D) archive
Q5) You should always ____________________ controlfile so you have a copy that can simply be plugged into a shutdown database.
To view all questions and flashcards with answers, click on the resource link above. Page 18