042-4

B. The Oracle software will be placed in this location.

C.The server parameter file (SPFILE) will be placed in this location.

D.The database files will be placed in this location, if not specified explicitly.

E.The location will be considered for the base of Oracle Managed Files (OMF).

F.The location will be considered for the base of Optimal Flexible Architecture (OFA).

179. The operating system file cratab in the Linux platform gets updated whenever you create a new database on the

same host machine. What kind of information is stored is stored in this file?

A. OracleSIDsonly

B. Oracle homes only

C.Oracle install timestamp

D.Oracle inventory pointer files

E.Oracle database creation timestamp

F.OracleSIDsand Oracle homes only

G.OracleSIDs, Oracle homes and flag for auto startup

180. You work as a database administrator for Supportcenter.cn. Your database is configured for automatic undo

management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How

far back can the flashback query go?

A. 3 hours

B. 6 months

C.until last year

http://

D.until last commit

E.until the point when the undotablespacewas refreshed

F.until the database is shut down and the memory erased

181. In your Supportcenter.cn production database, you find that the database users are able to create and read files

with unstructured data, available in any location on the host machine from an application. You want to restrict the

database users to access files in a specific location on the host machine. What could do to achieve this?

A. Modify the value for the UTL_FILE_DIR parameter in the parameter file

B. Grant read and write privilege on the operating system path to the database users

C.Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file

D.Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file

E.Create a directory object referring to the operating system path, and grant read and write privilege on the directory object

to the database users

182. Your boss at Supportcenter.cn wants you to clarify Oracle 10g. What statement about the Shared Server

configuration is valid?

A. Program Global Area (PGA) is stored in Shared pool.

B. User session data and Cursor state are stored inLargepool and Stack space is stored Shared pool.

C.User session data is stored in Shared pool and Stack space and Cursor state are stored inLargepool.

D.User session data and Cursor state are stored in Large pool and Stack space is stored outside the System Global (SGA).

E.User session data and Cursor state are stored outside the System Global Area (SGA) and Stack space is stored inside the

SGA.

183. You work as a database administrator for Supportcenter.cn. On a Monday morning, you find the database

instance aborted. After inspecting the alert log file, you execute the STARTUP command in SQL*Plus to bring the

instance up. What statement is true?

A. PMON coordinates media recovery.

B. SMON coordinates instance recovery.

C.PMON coordinates instance recovery.

D.Undo Advisor would roll back all uncommitted transactions.

E.SQL*PLUS reports an error with the message asking you to perform instance recovery.

184. In your Supportcenter.cn database server the parameter PLSQL_CODE_TYPE has been set to NATIVE.

Which object would be achieved by the setting?

A. The source PL/SQL code will be stored in native machine code.

B. The source PL/SQL code will be stored in interpreted byte code.

C.The compiled PL/SQL code will be stored in native machine code.

D.The compiled PL/SQL code will be stored in interpreted byte code.

185. Exhibit:

You work as a database administrator for Supportcenter.cn. You have started the database instance and you want to

manage your database remotely with Enterprise Manager through a Web browser.

Which two URLs would you use to access the Database Control? (Choose two.)

A.

B.

http://

C. Supportcenter.cn:5500/em

D.http:// SupportCenter 13.162.67.17.123:5500/em

E.http:// SupportCenter 13.fubar.europe. Supportcenter.cn:5500

F. SupportCenter 13.fubar.europe. Supportcenter.cn:5500/em

G.http:// SupportCenter 13.fubar.europe. Supportcenter.cn:5500/em

186. You work as a database administrator for Supportcenter.cn. While loading data into the SupportCenter STAFF

table using Oracle Enterprise Manager 10g Database Control, you find the status of the job as failed. On further

investigation, you find the following error message in the output log:

ORA-01653 unable to extend table HR. SupportCenter STAFF by 8 intablespaceUSERS

Which task would you perform to load the data successfully without affecting the users who are accessing the table?

A. Restart the database instance and run the job

B. Truncate the SupportCenter STAFF table and run the job

C.Delete all rows from the SupportCenter STAFF table and run the job

D.Increase the size of the USERStablespacethe and run the job

E.Increase the size of the database default permanenttablespaceand run the job

187. You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database

complain about the slow response of transactions. While investigating the reason you find that the transactions are

waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to

overcome this problem?

A. Increase the undo return

B. Create more undo segments

C.Create another undotablespace

D.Increase the size of the undo tablespace

188. You are working on a test database where instance recovery takes a considerable amount of time. How can

reduce the recovery time? (Choose two)

A. By multiplexing the control files

B. By multiplexing the redo log files

C.By decreasing the size of redo log files

D.By configuring mean time to recover (MTTR) to a lower value

E.By setting the UNDO_RETENTION parameter to a higher value

189. Exhibit #1

Exhibit #2, command

http://

You work as a database administrator for Supportcenter.cn. You have created a database link, devdb.uk.

Supportcenter.cn, between the database PRODDB and DEVDB. You want to import schema objects of the HR user

using Oracle Data Pump from the development database, DEVDB, to the productiondatagbase, PRODDB.

View Exhibit #1 to see the source and targetdatabase.l You execute the code in Exhibit #2.

The code fails and produces the error displayed in Exhibit #3.

What would you do to overcome the error?

A. Remove thedumpfileoption in the command

B. Remove theflashback_timeoption in the command

C.Add the user,SYSTEM, to the schemas option in the command

D.Add thenetwork_link= devdb.uk. Supportcenter.cnoption in the command

E.Remove the schemasoptions and add thenetwork_link= devdb.uk. Supportcenter.cnoption in the command

F.Remove the dump file options and add the network_link= devdb.uk. Supportcenter.cnoption in the command

190. You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred,

resulting in loss of all the control files in your database. Which statement regarding the database instance is true in

this scenario?

A. The instance would hang.

B. The instance needs to be shut down.

C.The instance would be in the open state.

D.The instance would abort in such cases.

E.The instance would be in the open and invalid state.

F.The instance would in the open state, but all the background processes will be restarted.

191. You work as a database administrator for Supportcenter.cn. In a production environment, users complain about

the slow response time when accessing the database. You have not optimized the memory usage of the Oracle

instance and you suspect the problem to be with the memory. To which type of object would you refer to determine

the cause of the slow response?

A. The trace file

B. The fixed views

C.The data dictionary views

D.The operating system log fields

E.The dynamic performance views.

192. You are working on the SupportCenter database. What is the default name of the alert log file in this database?

A. alert_ SupportCenter .log

B. alertlog_ SupportCenter .log

C.alert_log_ SupportCenter .log

D. SupportCenter _alert_log.log

E.log_alert_: SupportCenter .log

F.trace_alert_ SupportCenter .log

http://

193. You work as a database administrator for Supportcenter.cn. You have set the retention period for Automatic

Repository (AWR) statistics to four days and collection interval to 15 minutes. You want to view the statistics

collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics? (Choose two)

A. use enterprise manager

B. use DBMS_SQL package

C.use DBMS_AWR package

D.use PRVT_WORKLOAD package

E.query the AWR snapshot repository objects

F.use DBMS_WORKLOAD_REPOSITORY package

194. Two database users, Jack and Bill, are accessing the SupportCenter STAFF table of the SupportCenter DB

database. When Jack modifies a value in the table, the new value is invisible to Bill. Which is the modified value

invisible to Bill?

A. The modified data are not available on disk.

B. The modified data have been flushed out from memory.

C.The modified rows of the SupportCenter STAFF table have been locked.

D.Jack has not committed the changes after modifying the value.

E.Both users are accessing the database from two different machines.

195. You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in

your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.

Which advisory component would you refer to, in order to determine the appropriate indexes?

A. Memory Advisors

B. Segment Advisors

C.SQL Tuning and Access Advisors

D.Automated Workload Repository (AWR)

E.Automatic Database Diagnostic Monitor (ADDM)

196. In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting

achieve?

A. It degrades the run time and compiler performance.

B. It provides better run time and compiler performance.

C.It provides better optimization of the statement during parse time.

D.It forces the rule based optimizer to be used for statement optimization.

E.It provides better run time performance but slightly degraded compiler performance.

F.It provides better run time performance but slightly degraded run time performance.

197. Initially, for the Automatic Workload Repository (AWR) statistics, the retention period is set to 7 days, the

collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have

been using the Memory Advisor for the last three months to generate recommendations for tuning memory

components. However, when you observe the Memory Advisor on a Friday, you find that the statistics are available

only for two days, Thursday and Friday, of that week. What would have caused the statistics to be removed?

A. On Wednesday, the statistics have been purged.

B. On Wednesday, the retention period has been set to zero.

C. On Wednesday, the collection interval has been set to zero.

D. On Wednesday, the collection level has been changed to All.

E. On Wednesday, the retention period has been set to one day.

F. On Wednesday, the retention period has been set to two days.

http://

G. On Wednesday, the collection level has been changed to Typical.

H. On Wednesday, the collection interval has been set to 1440 minutes.

198. You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database

complain about the slow response when accessing the database. In the Active Session Waiting: Configuration page

you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue

graph and operating system tools reveals that the redo log files are on the same disks, and that the disk I/O for the

redo log files is the reason for the performance degradation. Which two actions would you take to gain performance?

(Choose two)

A. Increase the size of redo log files

B. Increase the size of redo log buffer

C.Increase the number of redo log files

D.Place the redo log files on a separate disk

E.Decrease the number of redo log groups to two

F.Increate the number Log Writer (LGWR) process

199.Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to

perform only consistent backups?

A. The database is in mount state.

B. One of the tablespaces is offline.

C.One of the tablespaces is read only.

D.The database operates in ARCHIEVELOG mode.

E.The database operates in NOARCHIEVELOG mode.

200. You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The

database has been configured with three redo logs groups, and there have been five log switches. You lost one

non-system-critical data file from your database. Which method would you use to recover the data file?

A. Restore all the data files and open the database

B. Create the data file and perform tablespace recovery

C.No need to restore any file, just recover the database

D.Restore only the system data file and recover the database

E.Restore only lost date file and performtablespacerecovery

201. You work as a database administrator for Supportcenter.cn. Your database is opened in NOARCHIVEKLOG

mode. You decide to place the database in ARCHIVELOG mode. How would you do this? (Select two)

A. Execute the ALTER DATABASE ARCHIVELOG statement

B. Select ARCHIVELOG option in the database control and restart the database to apply the changes.

C.Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG

statement.

D.Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.

202. You work as a database administrator for Supportcenter.cn. You are using three database, SupportCenter DB01,

SupportCenter DB02, and SupportCenter DB03, on different host machines in your development environment. The

database server configuration, such as IP address and listener port number, change frequently due to development

requirements, and you have the task of notifying the developers of the changes. Which connection method would you

use to overcome this overhead?

A. Host naming

http://

B. Local naming

C.Easy Connect

D.External naming

E.directory naming

203. Exhibit

You work as a database administrator for Supportcenter.cn. While creating a new user or changing the password for

existing users, the password must adhere to the restrictions specified in the exhibit. Which option would you use to

achieve this objective?

A. Use a trigger to validate the password

B. Use a user defined PL/SQL block to validate the password

C.Use a profile to include the password verify function to validate the password

D.Use Oracle's default password verification procedure to validate the password

E.Use a procedure name in the CREATE USER command to validate the password

204. Exhibit, HR Database properties

You work as a database administrator for Supportcenter.cn. You have two database, SALES and HR; created ion the

same machine using Oracle database 120g. For the SALES database, the initialization parameter COMPTIBLE is

set to 9.2.0 and for the HR database, COMPATIBLE is set to 10.0.0. Thesales_tbstablespaceiscreatein the SALES

database as follows:

CREATE TABLESPACEsales_tbsDATAFILE '/ SupportCenter / SupportCenter data/sales_tbs.dbf'

SIZE50M EXTENT MANAGEMENT LOCAL;

Thehr_tbstablespacecreated in the HR database is as follows:

CREATIVE TABLESPACEhr_tbsDATAFILE'/ SupportCenter / SupportCenter data/hr_tbs.dbf' SIZE 50M

Which two statements are correct in this scenario?

A. Hr_tbsis abigfiletablespace.

B. Abigfiletablespacecannot be created in the SALES database

C.All tablespaces in HR database will be locally managed by default.

D.Sales_tbsandhr_tbstablespaces can share the same data file.

E.All the tablespaces in the SALES database will be dictionary managed by default.

205. You work as a database administrator for Supportcenter.cn. In your development environment, the developers

are responsible for modifying the table structure according to the application requirements. However, you want to

http://

keep track of the ALTER TABLE commands being executed by developers, so you enable auditing to achieve this

objective. Which two views would you refer to find out the audit information? Choose two

A. DBA_AUDIT_TRAIL

B. DBA_AUDIT_SESSION

C.DBA_FGA_AUDIT_TRAIL

D.DBA_COMMON_AUDIT_TRAIL

206. You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long

time to complete. You suspect the database buffer cache size to be the reason, and you define an alert to be generated

when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views, you find that

the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem?

A. The advisory memory has been turned off.

B. The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.

C.The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.

D.The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.

E.The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

207. You work as a database administrator for Supportcenter.cn. You want to be notified when the number of disk

I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday's disk I/O performance.

How do you use the baseline metrics to achieve your objective?

A. Save the baseline in the database

B. Save the baseline in the Database Control Home Page

C.Create a procedure to read and apply the baseline to disk I/O metrics

D.Apply the baseline to the disk I/O metrics in the Mange Metrics page

E.Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd

208. You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to

your database. What additional information is available to you when you enable tracing?

A. Information about each Oracle Net connection.

B. Information about each entry in theLinstener.orafile

C.Information about the changed done in the database

D.Information about the different listeners in your system

E.Information about all thenondatabasefiles required to operate the database

209. You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and

you want to perform a backup. Which type of backup would be appropriate in this case?

A. Hot backup

B. Online backup

C.consistent backup

D.incremental backup

E.inconsistent backup

210. You work as a database administrator for Supportcenter.cn. Because of space constraints, you decided to

manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and

you receive an error as follows:

ERROR at Line 1:

ORA-10635: Invalid segment or tablespace type

What could be the reason?

http://

A. The table is partitioned

B. The table name is wrong.

C.It is an index-Organized table (IOT)

D.The table is stored in locally managedtablespace.

E.The table is stored in atablespacewhere segment space is managed manually.

211.You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo

management feature enable.Which two tasks must you perform to achieve this? Choose two.

A. Set the UNDO_RETENTION parameter to AUTO.

B. Create an initial undo segment in undotablespace.

C.Set the UNDO_RETENTION parameter to 900 or more

D.Set the initialization parameter UNDO_MANAGEMENT to AUTO

E.Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

212. You work as a database administrator for Supportcenter.cn. In your organization, you have four databases,

SupportCenter DB01, SupportCenter DB02, SupportCenter DB03, and SupportCenter DB04, which are located in

Berlin, Frankfurt,Rammstein, and Munich respectively, and which were created using Database Configuration

Assistant (DBCA). You want to perform administrative tasks on these databases that include startup and shutdown,

taking regular backups, and so on, fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform

this task?

A. Control file

B. Password file

C.Parameter file

D.Online redo log file

E.Listener controller file

F.Server parameter file

213. You work as a database administrator for Supportcenter.cn. Your database is functional. One of the disks

containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the

loss of a redo log member affect the instance of the database that is currently running?

A. The instance would normally abort.

B. The instance would not be affected.

C.The instance would be invalid, so would have to be aborted.

D.The instance would remain open, but the LGWR process would fail.

E.The instance would remain open and would automatically create the missing file

214. You work as a database administrator for Supportcenter.cn. After being hired, you find that there is only one

database that is functional and that is being access by the applications. You want to create a replicate of the database,

to be used for testing purposes. What is the best method to create a replica?

A. Create a database by using CREATE DATABASE...command and manually copy the data

B. Use Database ConfigurationAssitant(DBCA) to create a template from the existing database to contain the database

structure.

C.Use DBCA to create a template from the existing database to contain the database structure and then manually copy the

data using Oracle Data Pump.

D.Use DBCA to create a template from the existing database to contain the database structure and then use the same

template to create the database in the new location.

215. Exhibit, error

http://

You work as a database administrator for Supportcenter.cn. When you try to connect to the database, you get an

error (See exhibit). What could be the possible reason for getting such an error?

A. Database is not open

B. Listener is not running

C.Service name is not correct

D.Wrong port number used in URL

E.Usersysdoes have themediaprivilege

216. You work as a database administrator for Supportcenter.cn. While granting a role,

SELECT_CATALOG_ROLE, to a user, SupportCenter, using Oracle Enterprise Manager 10g Database Control,

you have cleared the DEFAULT check box. What will be the result?

A. The user cannot use the role at all.

B. The role would not be granted to the user.

C.The user needs to enable the role explicitly.

D.The user can start using the role immediately.

E.The user would have the admin option for the role.

217. You work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To

forward client connections to an instance, the listener must know information such as the name of the instance and

where the instance's ORACLE_HOME is located. How does the listener get this information? Choose two.

A. It gets it from the parameter file.

B. The listener prompts for details on startup.

C.The listener gathers information from the control file.

D.The instance automatically registers with the default listener.

E.The listener gets this information through thelistener.orafile.

218.

http://

You work as a database administrator for Supportcenter.cn. While setting up the database for your production

environment, you want to create a user according to the requirements in the exhibit. Which three options of the

CREATE USER command would you use to achieve this objective? Choose three

A. Profile

B. Account lock

C.Account unlock

D.Password expire

E.Quota 10MB on SupportCenter TBS1

F.Password never expire

G.Defaulttablespace SupportCenter TBS1

H.Quota unlimited on SupportCenter TBS1

I.TemporarytablespaceTEMP

J.TemporarytablespaceSYSTEM

219. You work as a database administrator for Supportcenter.cn. You want to configure database backups to be run

automatically. Which tool or utility would you use to achieve this?

A. The DBMS_JOB package

B. The BACKUP_JOB package

C.The DBMS_BACKUP_RESTORE package

D.The calendar tool in the Operating System (OS)

E.The backup scheduler in Enterprise Manager (EM)

F.The DBMS_BACKUP_SCHEDULER packager inline mode

220. You work as a database administrator for Supportcenter.cn. You want to administer your database servers,

which are running on different host machines, using the Web-enabled grid control interface. You have configured the

agent on the host

machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional

components would you configure to achieve this objective? Choose two

A. Application Server Control

B. Oracle Management Service

C. Oracle Enterprise Manager Repository

D. Oracle Enterprise Manager Database Control

221. You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) to

perform backups in your databases. Which four backup operations can be performed using RMAN? Choose four.

A. A backup of the target database when it is mounted

B. A backup of online redo log files when the database is open

C. A backup of only used data blocks in the file beingbeingbackup up

D. A backup of online, read/write data files when the database is open

E. A backup of only those data blocks that have changed since a previous backup

F. A backup of online, read/write data files when the database is in the NOMOUNT state.

http://

222. Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log

files during instance recovery is true?

A. Transactions are rolled back using redo log files.

B. Transactions are rolled forward using redo log files.

C.Transactions are rolled back using redo log files and archived log files.

D.Transactions are rolled forward using redo log files and rolled back using redo log files.

223. You execute the following command in your Supportcenter.cn production database to change the width of the

CUST_NAME column of the CUSTOMERS table:

ALTER TABLE customers

MODIFY (cust_nameVARCHAR2 (40))

/

When you execute the command, it displays the following error message:

ERROR at line 1:

ORA-00054: resource busy and acquire with NOWAIT specified

What could be the reason for the error message?

A. The database instance is not available.

B. The ALTER TABLE command does not have WAIT option

C.The table or a row in the table is currently locked by another user session.

D.The database instance is busy processing other user sessions commands.

E.The CUSTOMERS table has no long running query active at the time when this request is made.

F.The server process executing the ALTER TABLE command is busy with another command execution

224. You work as a database administrator for Supportcenter.cn. When you tried to connect to the database, you

received the following error:

ERROR:

ORA-12541:TNS:no_listener

You found that the listener is not running on the server, so you issued the following command in the Listener Control

utility to start the listener.

lsnrctl>START

What statement is true?

A. It would attempt to start the default listener

B. itwould start the most recently created listener.

C.It would display an error with a message asking for the listener name to be specified.

D.It would show you a list of listeners and prompts for the listener name that you want to start.

225. You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all

the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, SupportCenter,

asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other

connected users while retrieving the deleted rows? Choose two.

A. Use a flashback query to retrieve the rows that were deleted

B. Useconventialincremental export and then import the affected object

C.Shutdown the database inNORMALmode and restart the database instance

D.Use DBMS_META package to reconstruct the object using undo segments

E.UseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the data

F.Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

http://

226. You work as a database administrator for Supportcenter.cn. You need to rename a data file of a tablespace. How

would you perform this?

A. Bring the database to the NOMOUNT state, rename the data file using the operating system, and then execute the

ALTER TABLESPACE... RENAME DATAFILE... statement.

B. Take thetablespacethat contains the data file offline, rename the data file using the operating system, and then execute the

ALTER DATABASE... RENAME DATAFILE... statement.

C.Take thetablespace that contains the data file offline, rename the data file using the operating system, and then execute the

ALTER TABLESPACE... RENAME DATAFILE... statement.

D.Make thetablespacethat contains the data file read only, rename the data file using the operating system, and then execute

the ALTER TABLESPACE... RENAME DATAFILE... statement.

227. Exhibit

You work as a database administrator for Supportcenter.cn. While executing the command line to create a table, the

user gets the following error message and the CREATE TABLE... command fails.

ERROR at line 1:

ORA-01950: no privileges ontablespace

What could be the possible reason for this error message?

A. Thetablespace SupportCenter tbs7 is full.

B. The user is not the owner of the SYSTEMtablespace.

C.The user does have quota on the SupportCenter 7tablespace.

D.The user does not have sufficient system privileges to create table in the SupportCenter 7 tablespace.

E.The user does not have sufficient privileges to create table on the default permanent tablespace

228. You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for

backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a

tablespace. Which statement is true in this scenario?

A. The backup status will be marked expired in RMAN recovery catalog.

B. The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.

C.The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the

recovery catalogl

D.The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).

E.The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system),

if you are not using Oracle Managed Files (OMF).

229. You work as a database administrator for Supportcenter.cn. Your listener process, L1, is currently listening to

three databases: CertK INDB04, SupportCenter DB05 and SupportCenter DB06. Using Database Configuration

Assistant (DBCA) you create one more database, SupportCenter DB07, and enable dynamic registration. Which two

commands of Listener Control Utility (lsnrct1) would you use to determine whether the dynamic registration

occurred for the database, SupportCenter DB07, with the L1 listener process? Choose two

A. SHOW L1

B. SPAWN L1

C.STATUS L1

http://

D.SERVICES L1

E.STATUS LISTENER

F.SERVICES LISTENER

G.SHOWcurrent_listener

230. Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement is true about the analysis of the

Automatic Database Diagnostic Monitor (ADDM)?

A. The analysis does not provide the output for the performance of SQL statements.

B. The results of analysis are stored in tables, belonging to SYS user, in the SYSAUX tablespace.

C.The results of analysis are stored in tables, belonging to SYS user, in the SYSTEM tablespace.

D.The analysis runs automatically after each Automatic Workload Repository (AWR) snapshots.

E.The ADDM analysis is done manually after each Automatic Workload Repository (AWR) snapshots.

F.The results of analysis are stored in tables, belonging to SYSMAN user, in the SYSTEMtablespace.

231. Exhibit, list of privileges.

You work as a database administrator for Supportcenter.cn. The database user, SupportCenter USER07, has the

CONNECT role assigned. You want this user to be able to:

A)connect to the database when the database is in restricted modeAND

B)querythe tables created by other users.