DBA Oracle + MongoDB Flashcards
Large Object Types can store up to 128 Terrabytes of data.
true
Tables can only have a single LOB column in them.
true
LOB columns must be accessed in sequential order.
true
BLOB is short for _____ LOB type.
Binary
NCLOB is short for _____ _____ Set LOB.
National Character
BFILE columns are used to only store the pointer to a file.
LOBs allow the storage of
An Oracle Sequence is a database object that represents a sequence of integers.
Before you can store a pointer to a file in a BFILE, you must create a ______ object in the database.
directory
BFILENAME() is used to…
populate a field or variable with a pointer to a file
The reason a DBA needs situational awareness is.
To solve problems before others notice.
The right tools are important to the DBA because.
Databases are complex systems and tools make information accessible.
The best DBAs are technically adequate.
false
The primary reason to audit who has access to a database is because.
It is a requirement of the Principle of Least Security.
To promote situational awareness, a DBA would…
Talk to database users.
Review event logs.
Query DBA_* views.
All of the above. (this one)
Which tool or tools would you use to find the details of a schema object?
SQL*Plus
Enterprise Manager Express
SQL Developer (This One)
(A) and (B)
(B) and (C)
(A) and (C)
All of the above
The feature you would use to determine why a query isn’t performant is called.
Explain
A table space is a collection of tables.
true
Table spaces can be taken off-line.
true
Which is not a predefined table-space?
SYS
The log file that contains incidents that occur within an Oracle database is called the.
alert log
To monitor table space size you must first enable auditing.
false
To maintain situational awareness you need not continuously monitor using a tool such as PRTG.
true
The main reason you need to be able to reproduce a problem is.
to support your root cause analysis
Standard Operating Procedures are covered by an ISO standard.
false
If someone says they can’t connect to a database you should first.
Talk to the user
If you want to import a CSV file and filter records on the way in you should use.
SQL*Loader
Restore and Recover are a last resort when all else fails.
false
Restore and Recover are always used together.
true
Backups are not needed if you are using the RAC architecture.
false
Incremental Backups are more efficient than full backups.
false
You need to recover a database following a database restore
to fix a problem backup that may have media issues.
RMANS’s command BACKUP DATABASE also backs up the redo logs.
true
You don’t need to test your recovery processes because RMAN does that automatically for you.
false
Inconsistent backups are bad.
false
Learning about Oracle’s architecture is important.
for the same reasons it is important to know how your car works.
The largest area of memory in an Oracle instance is.
The SGA (System Global Area)
The Oracle component responsible for executing user authentication and authorization is.
The dedicated server process.
The process responsible for the initial database -> client connection is.
The Listener
Redo logs are used for
Transaction rollbacks
Which is not part of Oracle’s storage architecture
Directory
Oracle speeds disk accesses by
Using memory in the SGA for a block cache
The process used to store redo logs for the long term is
The LGWR process
The configuration file that contains the port number that Oracle uses for incoming database connections is
tnsnames.ora
If my customer required my database to fail-over in case of a database failure, I would
Install a standby database
Which Oracle server process configuration is most like the way a bank services in-person customers
Shared Server
When computing the amount of storage to reserve for a database, its best to allocate
4x the amount of raw data you plan to store
Books are to databases as card catalogs are to
Indexes
Generally speaking, what should you not index
All textual fields
Concatenated indexes are best used for primary keys
true
If I were partitioning data by geographic region, I would probably use a
List partition
Materialized views are good for
Generating reports
According to the learning pyramid I can expect to retain this percentage of a lecture
5%
The Oracle security model component that is a collection of privileges is
The role
You don’t give your users DBA access because
that is a violation of the principle of least privilege
New users can log into Oracle
false
You assign the built-in connect role to a user by
Using the GRANT command
If I want to see what privileges are assigned a particular built-in role I would
query the dba_sys_privs table
The best place to set the number of days between password changes is
In a user profile
Which is not a schema object
Materialized view
If you wanted to import a CSV you would probably use
SQL*Loader
Imp and Exp work well importing from and exporting to a remote workstation
true
If I wanted to look at how a query were going to execute, I would probably use
Oracle SQL Developer
SQL Developer can export from and import to Oracle
true
The best way to find locked user accounts is to
Look at the DBA_ACCOUNT_STATUS view
The midterm exam is on
October 21
Modern database require DBAs to look after them because
They are complicated.
A feature that isn’t necessarily offered by a DBMS would be
Fast performance
SQL (Structured Query Language)
Is used behind the scenes by anything that interacts with a DBMS.
DML and DDL are essentially the same language.
false
The following is not a feature of a transaction
They are specific to Oracle
Most DBMSs cost a lot of money
false
The person who specs the hardware that a DBMS runs on is called:
The End User
Which is not a function of the DBA
Table Design
The best way to make a database application run faster is to allocate more RAM to Oracle
false
Embedded SQL is
SQL that is stored within application code
PL/SQL contains conditional statements such as if/then/else and case
true
PL/SQL can be used in a JAVA application as embedded SQL
false
PL/SQL procedures must contain exception handlers
false
A PL/SQL variable is assigned a value using
the := operator
A PL/SQL cursor is used
To access data returned by a query in a PL/SQL procedure
If you want to use a cursor to update a record in an Oracle table you would
Declare the cursor using the for update option, fetch the record, update the record using an update statement and close the cursor
Triggers …
Are a way of writing event driven programs for Oracle
System triggers are for insert, update or delete events on Oracle tables
false
PL/SQL is a great language to use when you want to extend the capabilities of SQL procedurally for DBMSs such as Oracle, MySQL or PostgreSQL
false
Triggers can be applied to
Before, after or during Insert, Update, Delete operations on Oracle tables
After a user logs in
Following a commit operation in Trigger action
Both A and B (this one)
All of the above
:OLD and :NEW refers to
the old and new values of a record being updated or deleted
You can create a trigger on someone else’s table when you are given the create trigger privileges
false
Its best to enforce business rules using triggers whenever you can.
false
A DBMS is the software and services that manage databases.
true
The ‘a’ in ACID (as in properties of a transaction) refers to “Automatic”.
false
A primary advantage of a DBMS is that they are proprietary to the application that is using it.
false
Triggers must be restricted by its mandatory conditional statement.
false
One of the best ways to improve the performance of your database application is to write more efficient SQL.
true
The dedicated server process authenticates the database user.
true
Its best to store the archived redo logs alongside the database data files.
false
The checkpoint process is responsible for writing buffered data blocks to the data files.
true
The primary reason to use a standby database server is for fault tolerance.
true
Primary keys require unique indexes.
false
A user profile is an example of a schema object.
true
The first thing you should do when solving a reported database problem is to talk to users.
true
Table spaces are collections of data files and can be taken offline.
true
The problem.log file contains useful trouble shooting information about an Oracle instance.
false
DBAs should strive to take consistent backups.
false
