Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

ICS-212 > DBA Oracle + MongoDB > Flashcards

DBA Oracle + MongoDB Flashcards

(104 cards)

Start Studying
1
Q

Large Object Types can store up to 128 Terrabytes of data.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Tables can only have a single LOB column in them.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

LOB columns must be accessed in sequential order.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

BLOB is short for _____ LOB type.

A

Binary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

NCLOB is short for _____ _____ Set LOB.

A

National Character

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

BFILE columns are used to only store the pointer to a file.

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

LOBs allow the storage of

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

An Oracle Sequence is a database object that represents a sequence of integers.

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Before you can store a pointer to a file in a BFILE, you must create a ______ object in the database.

A

directory

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

BFILENAME() is used to…

A

populate a field or variable with a pointer to a file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The reason a DBA needs situational awareness is.

A

To solve problems before others notice.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

The right tools are important to the DBA because.

A

Databases are complex systems and tools make information accessible.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

The best DBAs are technically adequate.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

The primary reason to audit who has access to a database is because.

A

It is a requirement of the Principle of Least Security.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

To promote situational awareness, a DBA would…

A

Talk to database users.

Review event logs.

Query DBA_* views.

All of the above. (this one)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which tool or tools would you use to find the details of a schema object?

A

SQL*Plus

Enterprise Manager Express

SQL Developer (This One)

(A) and (B)

(B) and (C)

(A) and (C)

All of the above

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

The feature you would use to determine why a query isn’t performant is called.

A

Explain

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

A table space is a collection of tables.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Table spaces can be taken off-line.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Which is not a predefined table-space?

A

SYS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

The log file that contains incidents that occur within an Oracle database is called the.

A

alert log

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

To monitor table space size you must first enable auditing.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

To maintain situational awareness you need not continuously monitor using a tool such as PRTG.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

The main reason you need to be able to reproduce a problem is.

A

to support your root cause analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Standard Operating Procedures are covered by an ISO standard.
false
26
If someone says they can't connect to a database you should first.
Talk to the user
27
If you want to import a CSV file and filter records on the way in you should use.
SQL*Loader
28
Restore and Recover are a last resort when all else fails.
false
29
Restore and Recover are always used together.
true
30
Backups are not needed if you are using the RAC architecture.
false
31
Incremental Backups are more efficient than full backups.
false
32
You need to recover a database following a database restore
to fix a problem backup that may have media issues.
33
RMANS's command BACKUP DATABASE also backs up the redo logs.
true
34
You don't need to test your recovery processes because RMAN does that automatically for you.
false
35
Inconsistent backups are bad.
false
36
Learning about Oracle's architecture is important.
for the same reasons it is important to know how your car works.
37
The largest area of memory in an Oracle instance is.
The SGA (System Global Area)
38
The Oracle component responsible for executing user authentication and authorization is.
The dedicated server process.
39
The process responsible for the initial database -> client connection is.
The Listener
40
Redo logs are used for
Transaction rollbacks
41
Which is not part of Oracle's storage architecture
Directory
42
Oracle speeds disk accesses by
Using memory in the SGA for a block cache
43
The process used to store redo logs for the long term is
The LGWR process
44
The configuration file that contains the port number that Oracle uses for incoming database connections is
tnsnames.ora
45
If my customer required my database to fail-over in case of a database failure, I would
Install a standby database
46
Which Oracle server process configuration is most like the way a bank services in-person customers
Shared Server
47
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
48
Books are to databases as card catalogs are to
Indexes
49
Generally speaking, what should you not index
All textual fields
50
Concatenated indexes are best used for primary keys
true
51
If I were partitioning data by geographic region, I would probably use a
List partition
52
Materialized views are good for
Generating reports
53
According to the learning pyramid I can expect to retain this percentage of a lecture
5%
54
The Oracle security model component that is a collection of privileges is
The role
55
You don't give your users DBA access because
that is a violation of the principle of least privilege
56
New users can log into Oracle
false
57
You assign the built-in connect role to a user by
Using the GRANT command
58
If I want to see what privileges are assigned a particular built-in role I would
query the dba_sys_privs table
59
The best place to set the number of days between password changes is
In a user profile
60
Which is not a schema object
Materialized view
61
If you wanted to import a CSV you would probably use
SQL*Loader
62
Imp and Exp work well importing from and exporting to a remote workstation
true
63
If I wanted to look at how a query were going to execute, I would probably use
Oracle SQL Developer
64
SQL Developer can export from and import to Oracle
true
65
The best way to find locked user accounts is to
Look at the DBA_ACCOUNT_STATUS view
66
The midterm exam is on
October 21
67
Modern database require DBAs to look after them because
They are complicated.
68
A feature that isn't necessarily offered by a DBMS would be
Fast performance
69
SQL (Structured Query Language)
Is used behind the scenes by anything that interacts with a DBMS.
70
DML and DDL are essentially the same language.
false
71
The following is not a feature of a transaction
They are specific to Oracle
72
Most DBMSs cost a lot of money
false
73
The person who specs the hardware that a DBMS runs on is called:
The End User
74
Which is not a function of the DBA
Table Design
75
The best way to make a database application run faster is to allocate more RAM to Oracle
false
76
Embedded SQL is
SQL that is stored within application code
77
PL/SQL contains conditional statements such as if/then/else and case
true
78
PL/SQL can be used in a JAVA application as embedded SQL
false
79
PL/SQL procedures must contain exception handlers
false
80
A PL/SQL variable is assigned a value using
the := operator
81
A PL/SQL cursor is used
To access data returned by a query in a PL/SQL procedure
82
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
83
Triggers ...
Are a way of writing event driven programs for Oracle
84
System triggers are for insert, update or delete events on Oracle tables
false
85
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
86
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
87
:OLD and :NEW refers to
the old and new values of a record being updated or deleted
88
You can create a trigger on someone else's table when you are given the create trigger privileges
false
89
Its best to enforce business rules using triggers whenever you can.
false
90
A DBMS is the software and services that manage databases.
true
91
The 'a' in ACID (as in properties of a transaction) refers to "Automatic".
false
92
A primary advantage of a DBMS is that they are proprietary to the application that is using it.
false
93
Triggers must be restricted by its mandatory conditional statement.
false
94
One of the best ways to improve the performance of your database application is to write more efficient SQL.
true
95
The dedicated server process authenticates the database user.
true
96
Its best to store the archived redo logs alongside the database data files.
false
97
The checkpoint process is responsible for writing buffered data blocks to the data files.
true
98
The primary reason to use a standby database server is for fault tolerance.
true
99
Primary keys require unique indexes.
false
100
A user profile is an example of a schema object.
true
101
The first thing you should do when solving a reported database problem is to talk to users.
true
102
Table spaces are collections of data files and can be taken offline.
true
103
The problem.log file contains useful trouble shooting information about an Oracle instance.
false
104
DBAs should strive to take consistent backups.
false

ICS-212 (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions