【多项选择题】 You performed a backup of the flash recovery area by u...
【多项选择题】 Youconfiguredtheflashrecoveryareainthedatabase.Whichtwofileswou...
【单项选择题】 You enabled the flashback logging feature, but you have...
【单项选择题】 Youdecidedtochangethelocationoftheflashrecoveryarea.Youexecuted...
【单项选择题】 You executed the following query in your database: FROM...
【单项选择题】 You disabled the Flashback Database feature by using the...
【单项选择题】 InwhichcasewouldyouusetheFlashbackDatabasefeaturetoperformarecov...
【单项选择题】 View the Exhibit and examine the Flashback Database arch...
【多项选择题】 You are working on an Oracle Database 10g database. ...
【单项选择题】 OnTuesday,ajuniorDBAdroppedanimportantapplicationuseraccount,w...
【单项选择题】 A data file became corrupted in your database due to b...
【单项选择题】 EverySunday,consistentbackupsareperformedonyourdatabase.Becaus...
【单项选择题】 You are working on Oracle Database 10g, which is in...
【单项选择题】 You are using Oracle Database 10g. The LOG_ARCHIVE_F...
【单项选择题】 View the Exhibit. One of the important tables in the ...
【多项选择题】 Your database operates in ARCHIVELOG mode and all the t...
【单项选择题】 Your database operates in ARCHIVELOG mode. The redo log...
【多项选择题】 Foranincompleterecovery,whichfourbackuptypescanbeusedbyRecovery...
【单项选择题】 Consider the recovery steps in each of the cases given...
【单项选择题】 You performed an incomplete recovery on your Oracle Data...
【单项选择题】 The current time is 12:00 noon. You want to recov...
【多项选择题】 YourdatabaseisfunctioninginARCHIVELOGmode.Inwhichtwosituationsw...
【单项选择题】 You have only two redo log groups and these groups get...
【单项选择题】 YourdatabaseoperatesinARCHIVELOGmodeandusermanagedconsistentbac...
【单项选择题】 Your database operates in ARCHIVELOG mode. Usermanaged ...
【多项选择题】 You are connected to Recovery Manager (RMAN) without a...
【多项选择题】 You used the following command in Recovery Manager (RMA...
【多项选择题】 In your database, all the tablespaces are locally manag...
【单项选择题】 In your database, all the tablespaces are locally manag...
【单项选择题】 The loss of the control file forced you to recreate t...
【单项选择题】 Youhaveareadonlytablespaceonreadonlymedia.Youwanttoperformame...
【单项选择题】 One of the tablespaces is readonly in your database. ...
【单项选择题】 YoulostthePRODSTDtablespace,whichwasread write.Thetablespacew...
【多项选择题】 Younoticedthattheindextablespaceinyourdatabaserequiresarecovery...
【多项选择题】 You lost the index tablespace in your database. You de...
【单项选择题】 Youlosttheindextablespaceinyourdatabase.Youarenotabletousetable...
【单项选择题】 In your database, online redo log files are multiplexed...
【单项选择题】 A user executes a query on the EMP table, which conta...
【多项选择题】 Lastnight,amediafailurecausedthelossofatemporaryfilethatbelongs...
【单项选择题】 Whilesettingupthethresholdsfortablespacespaceusagemetricsforoneo...
【单项选择题】 Users are performing a large volume of inserts and dele...
【多项选择题】 Intheparameterfileoftheproductiondatabase,theBACKGROUND_DUMP_...
【单项选择题】 In your test database, you find that a user’s session...
【单项选择题】 Theproductiondatabasehasbeenfunctionalforthelastsevendays.Becau...
【单项选择题】 The backup retention policy is configured as RECOVERY WI...
【多项选择题】 UsingtheLISTcommandinRecoveryManager(RMAN),whichtwopiecesofin...
【单项选择题】 You executed the following command in Recovery Manager ...
【多项选择题】 WhenperformingabackupusingRecoveryManager(RMAN),whichfourtype...
【多项选择题】 Your database is functioning in NOARCHIVELOG mode. Your...
【多项选择题】 View the Exhibit. You executed the following command to...
【单项选择题】 View the Exhibit. You executed the following command to...
【单项选择题】 You execute the following command to perform a backup b...
【单项选择题】 You observe that the senior database administrator always...
【单项选择题】 In Recovery Manager (RMAN), you set the retention pol...
【多项选择题】 In Recovery Manager (RMAN), you have set control file...
【单项选择题】 You set the recovery window to seven days and the back...
【单项选择题】 You defined the Recovery Manager (RMAN) retention polic...
【单项选择题】 An RMAN backup job fails, displaying the following erro...
【多项选择题】 An RMAN backup job fails, displaying the following erro...
【单项选择题】 Youwererecentlyhiredbyanorganizationasadatabaseadministrator.Yo...
【单项选择题】 Youhavetwolistenerprocesses,namedL1andL2.Boththelistenerproc...
【多项选择题】 While creating a scheduler window using the DBMS_SCHEDUL...
【单项选择题】 In your production database there is a job, CALC_STAT...
【单项选择题】 Your business has departmental reports that are generated...
【多项选择题】 Inyourproductiondatabase,youhavemultipleresourceplandirectivest...
【多项选择题】 You have created a resource plan, PROD_DB_PLAN, with...
【单项选择题】 You have created a resource plan, PROD_DB_PLAN, that...
【单项选择题】 You want to create a consumer group, GROUP1, and you...
【单项选择题】 You want to create a consumer group, GROUP1, and you...
【多项选择题】 You execute the following command to create two consumer...
【单项选择题】 YouareusingResourceManagertomanagesystemresources.Whilecreating...
【多项选择题】 View the Exhibit and examine the Resource Manager settin...
【多项选择题】 Inyourproductiondatabase,youobservethatusers’transactionsareco...
【单项选择题】 From the V$SESSION_LONGOPS view, you find that some o...
【单项选择题】 FromtheV$SESSION_LONGOPSview,youfindthatsomeofthedatabaseuser...
【单项选择题】 YourdatabaseisrunningintheautomaticProgramGlobalArea(PGA)memor...
【单项选择题】 In your production database you want to use an Automati...
【单项选择题】 YouhaveanAutomaticStorageManagement(ASM)instancemanagingthedat...
【多项选择题】 YouwanttomigrateyourexistingnonASMfilestoASMfilesforthedatabase...
【单项选择题】 YourproductiondatabaseusesanAutomaticStorageManagement(ASM)ins...
【单项选择题】 You have a disk group, DGROUP1, with three disks and...
【单项选择题】 You are using an Automatic Storage Management (ASM) in...
【单项选择题】 Consider the following command to create a tablespace in...
【单项选择题】 You are using an Automatic Storage Management (ASM) in...
【单项选择题】 You are using an Automatic Storage Management (ASM) in...
【单项选择题】 You want an ASM instance to manage the files of your ...
【单项选择题】 You have many users complaining about slow inserts into...
【多项选择题】 Users in your production database complain that they are...
【单项选择题】 In one of your online transaction processing (OLTP) ap...
【单项选择题】 In your test database, you have created the ORDERS tab...
【单项选择题】 You are designing an application for a telecom company ...
【单项选择题】 Inyourdatawarehousingapplication,yougeneratereportsfrequently....
【单项选择题】 Whiledesigningyourdatabase,youhavecreatedtheEMPLOYEEStableasani...
【单项选择题】 While designing the database for one of your online tra...
【多项选择题】 View the Exhibit and examine the properties of the USER...
【单项选择题】 View the Exhibit and examine the properties of the TT ...
【单项选择题】 Youhavespecifiedthewarningandcriticalthresholdvaluesofanapplicat...
【单项选择题】 InanOracle10gdatabase,theinmemorystatisticsaregatheredatregu...
【单项选择题】 WhichtypeofPL SQLconstructwouldyouusetoautomaticallycorrectthee...
【多项选择题】 In your production database, you have observed that the...
微信扫一扫免费使用
拍照搜题、语音搜题、文字搜题