QUESTION 1

What statement about Database Writer (DBW0) process is NOT true?

a.
It flushes off "dirty" buffers from Data Buffer Cache to Data files on disk

b.
In writing to Data files on disk, some (very few) buffers from not saved changes (yet) will be transported as well.

c.
Main criteria to trigger DBW0 flush off is Commit

d.
Writing by DBW0 is much slower than writing by LGWR

1 points

QUESTION 2

When you want to add or increase the space in a certain Tablespace, which option is the valid one?

a.
ALTER DATABASE DATAFILE ... SIZE   ...

b.
ALTER DATABASE ADD DATAFILE ... SIZE ...

c.
ALTER TABLESPACE DATAFILE ... AUTOEXTEND ON ...

d.
None of them is valid choice

1 points

QUESTION 3

Which of the following parameters is static one i.e. you have to restart your Database in order to modify its value?

a.
DBA_CACHE_SIZE

b.
JAVA_POOL_SIZE

c.
SGA_MAX_SIZE

d.
SGA_TARGET

1 points

QUESTION 4

Which memory region in the SGA does NOT behave (when deciding about what Blocks need to be aged out) according to the LRU algorithm or in the circular manner?



a.
Library cache

b.
Data Buffer cache

c.
Log Buffer

d.
Large Pool

1 points

QUESTION 5

You closed your instance with SHUTDOWN IMMEDIATE option.

            What will happen on the next STARTUP?

a.
DBA must perform manual recovery.

b.
SMON will perform the automatic recovery in two steps

c.
The Database will open with success

d.
PMON will undo all uncommitted transactions

1 points

QUESTION 6

If you are using netca tool to add a new Net Alias for your Database service, what advanced connection option will be installed by default?

a.
SOURCE ROUTING

b.
LOAD BALANCING

c.
FAILOVER and LOAD BALANCING

d.
FAILOVER

1 points

QUESTION 7

What operation may be performed on a Tablespace after its creation?

a.
None of them can be done

b.
Change its Uniform size.

c.
Change its Extent Management from Autoallocate to Uniform

d.
Place it in Read-Only mode

1 points

QUESTION 8

You have decided to use Easy Connect method for Database connections.

What must be stored on the Client machine ?





a.
Nothing, because Local Naming always allows Easy Connect method

b.
Both listener.ora and tnsnames.ora files

c.
Just tnsnames.ora file

d.
Just listener.ora file, if users will use TCP protocol, and Listener is running on Port 1521

1 points

QUESTION 9

The information about values for INCREMENT_BY and MAXBYTES, that explain how is Autoextend option applied to Datafiles, may be found in which of the following dictionary views?

a.
DBA_DATA_FILES

b.
V$TABLESPACE

c.
V$DATAFILE

d.
DBA_TABLESPACES

1 points

QUESTION 10

Which of the following is most important moment when Log Writer becomes active and starts writing into Log files on disk?

a.
When Checkpoint happens

b.
When ARC0 starts writing into archiving destination

c.
Always after DBWR is writing into Data files on disk

d.
When Commit occurs

1 points

QUESTION 11

What activity is performed by SMON during the Instance Startup after an Instance crash? (Choose Two):



a.
Clearing and de-fragmenting temporary segments

b.
Roll Forward of non-committed transactions

c.
System Rollback of non-committed transactions

d.
Rollback of committed transactions

e.
Roll Forward of committed transactions

2 points

QUESTION 12

What statement about Log Writer (LGWR) process is NOT true? (Choose Two):

a.
This process may have slave processes, like LGW0, LGW1, ...

b.
It writes always before the Database Writer starts to flush off "dirty" buffers.

c.
This process is much faster than the Database Writer process

d.
Main criteria to trigger writing by LGWR is Checkpoint

e.
It writes buffers from the Log Buffer to Redo Log File on disk

2 points

QUESTION 13

Which of the following tools can may be used to create a new Database? (Choose Two):

a.
Database Upgrade Assistant (DBUA)

b.
Oracle Net Configuration Assistant (NETCA)

c.
EM DB Express

d.
Oracle Universal Installer (OUI)

e.
Database Configuration Assistant (DBCA)

2 points

QUESTION 14

During the transition from CLOSED to MOUNT state, which files are required? (Choose Two):

a.
All Redo Logfiles (at least one member per group)

b.
Alert Log File

c.
Parameter file PFILE or SPFILE

d.
All online Datafiles

e.
All copies of Controlfile

2 points

QUESTION 15

Which statement is correct about Extents? (Choose Two):



a.
An Extent can be distributed across one or more Datafiles

b.
New Extents are by default allocated manually by DBA

c.
DBA can check the extent situation manually in the Dictionary View called DBA_EXTENTS

d.
  An Extent is a randomly chosen group of Database Blocks

e.
An Extent can be assigned to only one Segment

2 points

QUESTION 16

Which statement is True regarding Undo Tablespace and its Retention period? (Choose Two):

a.
Parameter UNDO_RETENTION will be honored in a fixed Undo Tablespace with disabled retention guarantee option

b.
If retention guarantee option is enabled, it will be always honored, even if a new transaction may fail

c.
Parameter UNDO_RETENTION is specified in MB, with default value of 64

d.
Parameter UNDO_RETENTION is specified in minutes with Default value of 60

e.
Parameter UNDO_RETENTION is very important for a behaviour of an UNDO tablsepace.

2 points

QUESTION 17

When you use CREATE TABLESPACE command, which of the following options is given by default? (Choose Two)

a.
TEMPORARY

b.
LOGGING

c.
OFFLINE

d.
READ WRITE

e.
EXTENT MANAGEMENT LOCAL UNIFORM 1M

2 points

QUESTION 18

Undo Segments are used for Rollback of ongoing transactions, for Read when browsing,

and for Rollback of non-committed transactions during the Instance performed by

    The default Undo management mode is .

2 points

QUESTION 19

During THE SHUTDOWN option, Server will wait for all to finish and then it will perform Rollback followed by a and finally will gracefully close the Database.

In that case CONTROLFILE and all are in sync with the same System Change Number.

2 points

QUESTION 20

The EASY name resolution method is very ease to use, because it requires NO configuration at the side. If you use default Port#, you need to specify only 4 components, and they are : Username, Password, name and name.

2 points

QUESTION 21

Let's assume that user ROB created a new table called APPLE without the storage clause in a Tablespace PLAY that is in a UNIFORM mode and has all extents of 120K. The default Database block is 8K in size.

For this question do NOT try to create a User and a Table, answer question just by using your understanding and provide the right Syntax plus the Examples of the Outputs.

Provide the query that will show the extent numbers, blocks and leading blocks and file number for each extent. Display a possible output with 2 rows (2 extents used so far)

Manually add ANOTHER extent to this table without specified size and then show the output required earlier.

Now manually add ANOTHER extent to this table with size of 200K and then show the output again

6 points

QUESTION 22

Let's assume that you want to change dynamically some memory allocations and check the result as well. In SPFILE the situation is as shown below:

SGA_MAX_SIZE=900M

SGA_TARGET=800M

LARGE_POOL_SIZE=16M

SHARED_POOL_SIZE=240M

JAVA_POOL_SIZE=16M

DB_CACHE_

For this question do NOT change your SPFILE to match the parameters above, just provide the right syntax on paper, actually here in the answer box



You have used SPFILE to start your Instance. Can you guess about the real size of Database Buffer cache, will it be the same as in SPFILE, greater or smaller?

Now, turn off the ASMM with the right syntax, but do NOT make this change persistent (it will be forgotten after the next startup).

Next, use the default scope to increase your Java Pool to 80M (show the syntax and that scope in the syntax). Will the change be successful? Why?

If you perform the following syntax, what will be the output?

> SHOW PARAMETER SGA

7 points

QUESTION 23

You already have Tablespace called YORK as Locally managed with all Extents uniformed in size of 200K.



a. Add a second Datafile to this Tablespace with an initial size of 20M and that Datafile york02.dbf should go to the DISK4 folder under your home Directory. Can you specify an uniform size of 256K here?

b. Now enable the auto extended option for this Datafile with all extents of 4M in size and with the default growing limit. Show the default option incl. default option.

c. Check the appropriate dictionary view to see the names of all Datafiles in the database , their current size in bytes, status and their auto-extend information (with all 3 components), but only if their growing limit is greater than 100M.

  For this question, you may create tablespace YORK firstly and then test your solutions in MOBA, OR just answer by providing the right syntax on paper, actually here in the answer box

7 points

QUESTION 24

Your server name is senecalab and it has 2 services called River and Lake.

           Two open ports are 1521 and 1501.



By using Easy Connect method connect as user Scott (password is tiger) to a Default port to service Lake.

Same thing, but you will connect to a non-default port to service River

Net Alias for service Lake is Ontario. Connect as user Scott by using Local Naming method.

Can you use same net alias to connect to service River?

pur-new-sol

Related Questions

Address

Phone Number

Email Address