Mdt Flashcards
A mobile DBMS
runs on a pervasive device
How many users are automatically created when oracle DB is installed?
2 (SYS and system)
An oracle DB can access _ databases at a time
1
Put these in the correct order
Segment
Datablock
Extent
Datablock Extent Segment (DES)
This file is the brain of the database, and stores information on the state of the databse
The control file
This log contains information about errors and major db events
Oracle Alert Log
PMON is a part of oracle ______
instance
The library cache stores
SQL parsing details
startup open
What does this do?
Allows users to access the database
This type of buffer is a buffer that’s content has been modified
A dirty buffer
What term is used by Oracle to age data out of the database buffer cache?
Least recently used
Under what circumstance does the DBWn process write dirty buffers to the disk?
When a commit occurs
In oracle, what is the minimum number of recommended control files?
2
T/F - An extent can be made up of more than one segment
False
T/F - A tablespace can contain more than 1 datafile
True
A datablock is a logical structure, a tablespace is a physical structure
True
create tablespace test datafile “E:\test\test09.dbf” size 100M;
create tablespace test datafile ‘E:\test\test09.dbf’ size 100M;
Double parenthesis or single?
Single
The control file is located/verified during the ____ state
Mount
What DB role gives the most permissions/privileges?
SYSDBA
What is the highest admin user possible in Oracle?
SYS
I can use ______ ______ to instantiate the instance and stop the control file before it is read
startup nomount
Which type of shutdown is executed when you use the simple “shutdown” command?
shutdown normal
Which parameter file allows certain parameters to be changed while the DB is open?
SPFILE
The ___________ process confirms the identity of a user
Authentication
Does this line create an error in the CREATE USER statement?
profile limit set PASSWORD_REUSE_MAX=10
Yes
create user aaa identified by bbb
Can aaa login and create tables, drop tables, or create indexes in their own schema?
No
PGA stands for
program global area
How can I create a PFILE? (Think SPFILE)
CREATE PFILE from SPFILE
T/F - There’s 2 tablespaces in every database: System and Sysaux
True
T/F - the system tablespace can be taken offline
FALSE
The DB is in mount mode, how can I change it to open?
alter database open;
An oracle instance is a set of _________ processes and a set of _______ structures
background, memory
An oracle databse is a set of _________ structures
physical
When is the SGA (System global area) created?
When an instance is opened
A normal logged on user wants to see the list of objects they have access to, what contains this?
ALL_OBJECTS
This stores data segments that might overflow from the PGA during sorting, and temporary tables that exit during a certain session or transaction
Temporary files
“lnrctr status” does what
Displays the host name and port number that can be used to connect through to oracle enterprise manager (and more)
AAACw3AABAAAAWJAAA
What is the object ID here?
AAACw3
T/F - “password expire;” is correct
False
T/F - “create profile User_Profle LIMIT” is correct
True
T/F - “password_life_time_90” is correct
True
T/F - password_lock_time_1” is correct
True
