stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
ICS 212 Midterm Exam Review - Fall, 2024 Flashcards | StudBud
Explore
/
ICS 212 Midterm Exam Review - Fall, 2024
ICS 212 Midterm Exam Review - Fall, 2024
36 terms
·
StudBud Administration
·
496 plays
Imported from external platform
Flashcards
36 cards
F
Practice quiz
P
Host live
L
Questions
36
Answers
1
Which is something you should not do *
during*
the 5-step problem resolution process
Talk to users
Do a root cause analysis
Update a production system
Ask for required authorizations
2
Which of these could you use when diagnosing an Oracle start up issue?
Ask Tom
Look in the Windows event viewer
Do a Google search
Look in the alert log
3
When you're a DBA
Are always looking for the best way to put fires out
Favour tools that ship with your DBMS over third party tools
Favour assigning privileges to users rather than roles
You prioritize a user's issues over most other things
4
If I want all of my application's data to reside on the same device, I would probably
Create a materialized view
Create a table space
Create a partition
Create a schema
5
A schema is
A table or index created by an Oracle user
The same thing as an Oracle user
The same thing as an SQL Developer connection
A collection of objects created by a single Oracle user
6
DML Triggers
Can be executed per statement or per row
Are commonly used to commit transactions when constraints are met
Must be authorized before executing
Can be used to implement session logging
7
The recommended way to assign privileges to a user in Oracle is to
Assigned privileges to the table space
Assign privileges to the user and then add that user to a role
Assigned privileges to the user's schema
Assigned privileges to the role and then add the user to that role
8
DDL allows you to create users
True
False
9
Which tool can't be used to export data from Oracle
expdp
exp
SQL*Loader
SQL Developer
10
If an SQL join operation is slow, it is most likely because
A cluster is missing
A partition is missing
A materialized view is missing
An index is missing
11
The reason denormalized data is sometimes preferred is because
You don't like Doug Greening
It is never preferred
Table joins can be expensive
It can be more reliable
12
DBMS's
are a collection of databases
has been largely replaced by NoSQL
works best with one user at a time
is software that controls access to a database
13
The primary purpose of an SOP is for performing unfamiliar procedures
False
True
14
Clusters are used for
Minimizing storage footprint
Minimizing disk access by storing related data together on same data blocks
Creating faster indexes
Making data management easier
15
The architectural component that enables a transaction to be abandoned before committed is
Alert log
Undo/Redo log
Flashback
RMAN
16
You should
always
strive for a consistent backup of your Oracle Database
True
False
17
create session
is an example of an object privilege
False
True
18
Transactions are
Always ACIDic
Sometimes ACIDic
Never ACIDic
Durable but not always Atomic
19
Which tool(s) could you use to see the status of your Oracle server
PRTG
SQL Developer
Alert.log
Enterprise manager
20
SQL and PL/SQL
Are both described in an ANSI standard
Can be used to write client-side code in web applications
Can be used to implement database triggers in Oracle, SQL Server and MySQL
Are executed within an Oracle DBMS
21
Adding an index to a table can speed queries up by
2x
10x
100x
exponentially
22
The best way to make Oracle horizontally scalable is to
Install it as a RAC
Install it as a standby database
Purchase more memory and faster SSDs
Install it as a shared server
23
The process responsible for authorizing a user's request is
IM - Identity Manager
Listener
OSP - Oracle Security Process
Foreground Server Process
24
To find locked out users you could
Look in the dba_locks view
Look in the sys_sessions view
Look in the dba_users view
look in the sys_all_users view
25
Oracle Cursors
Can be moved forward using fetch and backwards using unfetch
Are used by client-side for reading data from a table
Are callable from SQL
Can be used for reading AND updating data
26
Common reasons why your database might be unreliable include
No DBA has been assigned
Your organization isn't adhering to the Principle of Least Privilege
It is running on unreliable hardware
Your DBA is Saryta
27
A schema object is
Named the same as an Oracle user
The same thing as an Oracle user
An object created by an Oracle user
A collection of schemas
28
The best way to prevent DBMS emergencies is to have a solid backup and recovery process
True
False
29
The reason why the block cache found in the SGA makes Oracle faster is because
It doesn't make it any faster. Today's SSDs are as fast as the block cache
Allocating memory to the block cache also allocate more CPUs to the Oracle
It minimizes the number of comparisons Oracle has to perform
It minimizes the number of disk reads that Oracle has to perform
30
Which are true of Imp, Exp, ImpDP and ExpDP
Imp can import from Excel
ExpDP can run on computer not running the Oracle DBMS
You can ImpDP to a different schema than you ExpDP'd from
Exp supports encryption
31
If I want to organize my Oracle data by year and archive old data I would most likely use
a materialized view
a partition
a cluster
an index
32
The component that offers automatic denormalization using an Oracle server's idle time is
Materialized View
Oracle Reports
Clusters
RAC
33
Of these, the best tool to use to resolve deadlocks is
SQL Developer
SQL*Plus
Enterprise Manager Express
Taskman
34
Table spaces are
A collections of tables and indexes
A logical name that refers to a data file
A collections of tables
Oracle's lowest level unit of storage
35
A standby database is an easy way to double a database's processing capacity
True
False
36
If I wanted to change the number of failed login attempts before locking an account, I would modify
The account lock duration on the user's account
The account lock timeout on the user's session template
The session lock property on the connection role
The password lock time on the user's account profile
