Mdt

Question 1

A mobile DBMS

Answer 1

runs on a pervasive device

Question 2

How many users are automatically created when oracle DB is installed?

Answer 2

2 (SYS and system)

Question 3

An oracle DB can access _ databases at a time

Answer 3

1

Question 4

Put these in the correct order

Segment
Datablock
Extent

Answer 4

Datablock Extent Segment (DES)

Question 5

This file is the brain of the database, and stores information on the state of the databse

Answer 5

The control file

Question 6

This log contains information about errors and major db events

Answer 6

Oracle Alert Log

Question 7

PMON is a part of oracle ______

Answer 7

instance

Question 8

The library cache stores

Answer 8

SQL parsing details

Question 9

startup open

What does this do?

Answer 9

Allows users to access the database

Question 10

This type of buffer is a buffer that’s content has been modified

Answer 10

A dirty buffer

Question 11

What term is used by Oracle to age data out of the database buffer cache?

Answer 11

Least recently used

Question 12

Under what circumstance does the DBWn process write dirty buffers to the disk?

Answer 12

When a commit occurs

Question 13

In oracle, what is the minimum number of recommended control files?

Answer 13

2

Question 14

T/F - An extent can be made up of more than one segment

Answer 14

False

Question 15

T/F - A tablespace can contain more than 1 datafile

Answer 15

True

Question 16

A datablock is a logical structure, a tablespace is a physical structure

Answer 16

True

Question 17

create tablespace test datafile “E:\test\test09.dbf” size 100M;

create tablespace test datafile ‘E:\test\test09.dbf’ size 100M;

Double parenthesis or single?

Answer 17

Single

Question 18

The control file is located/verified during the ____ state

Answer 18

Mount

Question 19

What DB role gives the most permissions/privileges?

Answer 19

SYSDBA

Question 20

What is the highest admin user possible in Oracle?

Answer 20

SYS

Question 21

I can use ______ ______ to instantiate the instance and stop the control file before it is read

Answer 21

startup nomount

Question 22

Which type of shutdown is executed when you use the simple “shutdown” command?

Answer 22

shutdown normal

Question 23

Which parameter file allows certain parameters to be changed while the DB is open?

Answer 23

SPFILE

Question 24

The ___________ process confirms the identity of a user

Answer 24

Authentication

Question 25

Does this line create an error in the CREATE USER statement?

profile limit set PASSWORD_REUSE_MAX=10

Answer 25

Yes

Question 26

create user aaa identified by bbb

Can aaa login and create tables, drop tables, or create indexes in their own schema?

Answer 26

No

Question 27

PGA stands for

Answer 27

program global area

Question 28

How can I create a PFILE? (Think SPFILE)

Answer 28

CREATE PFILE from SPFILE

Question 29

T/F - There’s 2 tablespaces in every database: System and Sysaux

Answer 29

True

Question 30

T/F - the system tablespace can be taken offline

Answer 30

FALSE

Question 31

The DB is in mount mode, how can I change it to open?

Answer 31

alter database open;

Question 32

An oracle instance is a set of _________ processes and a set of _______ structures

Answer 32

background, memory

Question 33

An oracle databse is a set of _________ structures

Answer 33

physical

Question 34

When is the SGA (System global area) created?

Answer 34

When an instance is opened

Question 35

A normal logged on user wants to see the list of objects they have access to, what contains this?

Answer 35

ALL_OBJECTS

Question 36

This stores data segments that might overflow from the PGA during sorting, and temporary tables that exit during a certain session or transaction

Answer 36

Temporary files

Question 37

“lnrctr status” does what

Answer 37

Displays the host name and port number that can be used to connect through to oracle enterprise manager (and more)

Question 38

AAACw3AABAAAAWJAAA

What is the object ID here?

Answer 38

AAACw3

Question 39

T/F - “password expire;” is correct

Answer 39

False

Question 40

T/F - “create profile User_Profle LIMIT” is correct

Answer 40

True

Question 41

T/F - “password_life_time_90” is correct

Answer 41

True

Question 42

T/F - password_lock_time_1” is correct

Answer 42

True