Whichviewprovidesinformationonthebackupstatusofthedatafilesinthedatabase？（）
A. V$BACKUP
B. V$BACKUP_STATUS
C. V$BACKUP_DATAFILE
D. V$DATAFILE_BACKUP
E. V$TABLESPCE_BACKUP
查看答案
YourdatabaseisfunctioninginNOARCHIVELOGmode.Yourdatabasecontains15tablespaces.YouwanttouseRecoveryManager（RMAN）toperformbackups.Whichtwobackupswouldyoubeabletoperformwhenthedatabaseisbeingaccessedbyusers？（）
A. backupofofflinetablespaces
B. backupofreadonlytablespaces
C. backupofsystemcriticaltablespaces
D. backupofonline，locallymanagedtablespaces
E. backupofread/writedictionarymanagedtablespaces
Whilesettingupthethresholdsfortablespacespaceusagemetricsforoneofyourtablespaces，youdefinethecriticalthresholdas60%andwarningthresholdas75%.Whatwouldbetheresultofthissetting？（）
A. Itwouldresultinanerrorbecausethewarningthresholdcannotbemorethanthecriticalthreshold.
B. Thewarningthresholdisignoredandalertswouldbegeneratedwhenspaceusageexceedsthecriticalthreshold.
C. Thecriticalthresholdisignoredandalertswouldbegeneratedwhenspaceusageexceedsthewarningthreshold.
D. Boththresholdvaluesareusedandalertsaregeneratedwhenspaceusageexceedstherespectivethresholdvalues.
TheDBAhaschosentomanageSGAandPGAmemoryseparatelyinanOLTPdatabasebecauseofhisuniqueknowledgeoftheapplication.WhichofthesearegoodstartingpointstousewhenconfiguringthemaximumvaluesforSGAandPGA，basedontheamountofmemoryavailableonthesystem？（）
A. 20%SGA 80%PGA
B. 25%SGA 75%PGA
C. 50%SGA 50%PGA
D. 75%SGA 25%PGA
E. 80%SGA 20%PGA
Whichstatementsarecorrectabouttemporarytables（）
A. Indexesandviewscanbecreatedontemporarytables.
Boththedataandthestructureoftemporarytablescanbeexported.
C. Temporarytablesarealwayscreatedinauser’stemporarytablespace.
D. Thedatainsertedintoatemporarytableinasessionisavailabletoothersessions.
E. Datamanipulationlanguage（DML）locksareneveracquiredonthedataoftemporarytables
微信支付 
支付宝支付