Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ICS-212 > DBA Oracle + MongoDB > Flashcards

DBA Oracle + MongoDB Flashcards

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
Q

Standard Operating Procedures are covered by an ISO standard.

A

false

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

If someone says they can’t connect to a database you should first.

A

Talk to the user

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

If you want to import a CSV file and filter records on the way in you should use.

A

SQL*Loader

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

Restore and Recover are a last resort when all else fails.

A

false

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

Restore and Recover are always used together.

A

true

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

Backups are not needed if you are using the RAC architecture.

A

false

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

Incremental Backups are more efficient than full backups.

A

false

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

You need to recover a database following a database restore

A

to fix a problem backup that may have media issues.

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

RMANS’s command BACKUP DATABASE also backs up the redo logs.

A

true

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

You don’t need to test your recovery processes because RMAN does that automatically for you.

A

false

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

Inconsistent backups are bad.

A

false

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

Learning about Oracle’s architecture is important.

A

for the same reasons it is important to know how your car works.

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

The largest area of memory in an Oracle instance is.

A

The SGA (System Global Area)

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

The Oracle component responsible for executing user authentication and authorization is.

A

The dedicated server process.

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

The process responsible for the initial database -> client connection is.

A

The Listener

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

Redo logs are used for

A

Transaction rollbacks

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

Which is not part of Oracle’s storage architecture

A

Directory

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

Oracle speeds disk accesses by

A

Using memory in the SGA for a block cache

43
Q

The process used to store redo logs for the long term is

A

The LGWR process

44
Q

The configuration file that contains the port number that Oracle uses for incoming database connections is

A

tnsnames.ora

45
Q

If my customer required my database to fail-over in case of a database failure, I would

A

Install a standby database

46
Q

Which Oracle server process configuration is most like the way a bank services in-person customers

A

Shared Server

47
Q

When computing the amount of storage to reserve for a database, its best to allocate

A

4x the amount of raw data you plan to store

48
Q

Books are to databases as card catalogs are to

A

Indexes

49
Q

Generally speaking, what should you not index

A

All textual fields

50
Q

Concatenated indexes are best used for primary keys

A

true

51
Q

If I were partitioning data by geographic region, I would probably use a

A

List partition

52
Q

Materialized views are good for

A

Generating reports

53
Q

According to the learning pyramid I can expect to retain this percentage of a lecture

A

5%

54
Q

The Oracle security model component that is a collection of privileges is

A

The role

55
Q

You don’t give your users DBA access because

A

that is a violation of the principle of least privilege

56
Q

New users can log into Oracle

A

false

57
Q

You assign the built-in connect role to a user by

A

Using the GRANT command

58
Q

If I want to see what privileges are assigned a particular built-in role I would

A

query the dba_sys_privs table

59
Q

The best place to set the number of days between password changes is

A

In a user profile

60
Q

Which is not a schema object

A

Materialized view

61
Q

If you wanted to import a CSV you would probably use

A

SQL*Loader

62
Q

Imp and Exp work well importing from and exporting to a remote workstation

A

true

63
Q

If I wanted to look at how a query were going to execute, I would probably use

A

Oracle SQL Developer

64
Q

SQL Developer can export from and import to Oracle

A

true

65
Q

The best way to find locked user accounts is to

A

Look at the DBA_ACCOUNT_STATUS view

66
Q

The midterm exam is on

A

October 21

67
Q

Modern database require DBAs to look after them because

A

They are complicated.

68
Q

A feature that isn’t necessarily offered by a DBMS would be

A

Fast performance

69
Q

SQL (Structured Query Language)

A

Is used behind the scenes by anything that interacts with a DBMS.

70
Q

DML and DDL are essentially the same language.

A

false

71
Q

The following is not a feature of a transaction

A

They are specific to Oracle

72
Q

Most DBMSs cost a lot of money

A

false

73
Q

The person who specs the hardware that a DBMS runs on is called:

A

The End User

74
Q

Which is not a function of the DBA

A

Table Design

75
Q

The best way to make a database application run faster is to allocate more RAM to Oracle

A

false

76
Q

Embedded SQL is

A

SQL that is stored within application code

77
Q

PL/SQL contains conditional statements such as if/then/else and case

A

true

78
Q

PL/SQL can be used in a JAVA application as embedded SQL

A

false

79
Q

PL/SQL procedures must contain exception handlers

A

false

80
Q

A PL/SQL variable is assigned a value using

A

the := operator

81
Q

A PL/SQL cursor is used

A

To access data returned by a query in a PL/SQL procedure

82
Q

If you want to use a cursor to update a record in an Oracle table you would

A

Declare the cursor using the for update option, fetch the record, update the record using an update statement and close the cursor

83
Q

Triggers …

A

Are a way of writing event driven programs for Oracle

84
Q

System triggers are for insert, update or delete events on Oracle tables

A

false

85
Q

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

A

false

86
Q

Triggers can be applied to

A

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
Q

:OLD and :NEW refers to

A

the old and new values of a record being updated or deleted

88
Q

You can create a trigger on someone else’s table when you are given the create trigger privileges

A

false

89
Q

Its best to enforce business rules using triggers whenever you can.

A

false

90
Q

A DBMS is the software and services that manage databases.

A

true

91
Q

The ‘a’ in ACID (as in properties of a transaction) refers to “Automatic”.

A

false

92
Q

A primary advantage of a DBMS is that they are proprietary to the application that is using it.

A

false

93
Q

Triggers must be restricted by its mandatory conditional statement.

A

false

94
Q

One of the best ways to improve the performance of your database application is to write more efficient SQL.

A

true

95
Q

The dedicated server process authenticates the database user.

A

true

96
Q

Its best to store the archived redo logs alongside the database data files.

A

false

97
Q

The checkpoint process is responsible for writing buffered data blocks to the data files.

A

true

98
Q

The primary reason to use a standby database server is for fault tolerance.

A

true

99
Q

Primary keys require unique indexes.

A

false

100
Q

A user profile is an example of a schema object.

A

true

101
Q

The first thing you should do when solving a reported database problem is to talk to users.

A

true

102
Q

Table spaces are collections of data files and can be taken offline.

A

true

103
Q

The problem.log file contains useful trouble shooting information about an Oracle instance.

A

false

104
Q

DBAs should strive to take consistent backups.

A

false

ICS-212 (1 decks)

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