To accomplish user-managed backup for the USERS tablespace, ..

第1题

You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）

A. The database must be opened in restricted mode.

B. The database must be configured to run in ARCHIVELOG mode.

C. The tablespaces are required to be in backup mode before taking the backup.

D. The tablespaces are required to be in read-only mode before taking the backup

点击查看答案

第2题

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of t

he DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:ALTER TABLESPACE data1 BEGIN BACKUP;While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）

A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

D. If you restart the database, the database will not be opened.

点击查看答案

第3题

You are working on a 24X7 database. You want to design a backup strategy for your database

that uses user managed backups. You want to be able to perform all backups while the database remains online.Which statement about performing user-managed backups in a 24x7 environment is true？（）

A. You must have change tracking enabled in your database

B. Your database must be running in NOARCHIVELOG mode

C. To back up a tablespace, it must be in backup mode

D. To back up a tablespace, it must first be taken offline

点击查看答案

第4题

You recently upgraded all Windows NT Workstation 4.0 computers to Windows 2000 Professiona

l. You want to give a new employee named Maria the ability to back up files, share resources, and install programs on a client computer that she shares with other users. You do not want Maria to be able to read other users' files.

What should you do to accomplish these goals？ (Choose all that apply)

A．Add Maria's user account to the System group.

B．Add Maria's user account to the Interactive group.

C．Add Maria's user account to the Power Users group.

D．Add Maria's user account to the Administrators group.

E．Add Maria's user account to the Backup Operators group.

点击查看答案

第5题

Whatcouldbethereasonforthis()

A.Thelistenerisnotrunningonthedatabasenode.

B.TheTNS_ADMINenvironmentalvariableissettoawrongvalue.

C.Theorcl.oracle.comdatabaseserviceisnotregisteredwiththelistener.

D.TheDEFAULT_DOMAINparameterissettoawrongvalueinthesqlnet.orafile.

点击查看答案

第6题

When should you create a role?()

A. To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.

B. To grant a group of relate privileges to a user.

C. When the number of people using the database is very high.

D. To simplify the process of granting and revoking privileges.

E. To simplify profile maintenance for a user who is constantly traveling.

点击查看答案

第7题

Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?()

A. Because row IDs may change during the flashback operation

B. Because the object number changes after the flashback operation

C. Because the rows are retrieved from the recycle bin during the flashback operation

D. Because the table is moved forward and back to a temporary during the flashback operation

点击查看答案

第8题

YoursystemhasbeenupgradedfromOracleDatabase10gtoOracleDatabase11g.YouimportedSQLTuningSets（STS）fromthepreviousversion.AfterchangingtheOPTIMIZER_FEATURE_ENABLEparameterto10.2.0.4andrunningtheSQLPerformanceAnalyzer，youobservedperformanceregressionforafewSQLstatements.WhatwouldyoudowiththeseSQLstatements？（）

A.SetOPTIMIZER_USE_PLAN_BASELINEStoFALSEtopreventtheuseofregressedplans.

B.CapturetheplansfromthepreviousversionusingSTSandthenloadthemintothestoredoutline.

C.CapturetheplansfromthepreviousversionusingSTSandthenloadthemintoSQLManagementBase（SMB）

D.SetOPTIMIZER_CAPTURE_SQL_PLAN_BASELINEStoFALSEtopreventtheplansfrombeing loadedtotheSQLplanbaseline.

点击查看答案

第9题

Yourarchive-logdestinationdirectoryrunsoutofspace.Whatistheimpactofthisonthedatabase?()

A.None.Thedatabasewillswitchovertothestand-byarchive-logdestinationdirectory.

B.Awarningmessagewillbewrittentothealertlogofthedatabase,butnoadverseimpactstothedatabasewillbeexperienced.

C.Thedatabasewillshutdown,andwillnotrestartuntilyoucorrecttheout-of-spacesituation.

D.Thedatabasewillcontinuetotrytowritetothearchive-logdestinationdirectoryforonehour.Afteronehour,thedatabasewillshutdownnormally.

E.OnceOraclehascycledthroughallonlineredologs,itwillstopprocessinganyDMLorDDLuntiltheout-of-spaceconditioniscorrected.

点击查看答案

功能	扣减规则
功能	基础费（查看答案）	加收费（AI功能）
文字搜题、查看答案	1/每题	0/每次
语音搜题、查看答案	1/每题	2/每次
单题拍照识别、查看答案	1/每题	2/每次
整页拍照识别、查看答案	1/每题	5/每次

To accomplish user-managed backup for the USERS tablespace, you issued the following comma