Scribd
Upload
46 views7 pages

Database Midterm Quiz 2

UGRD-IT6203A Advanced Database Management Systems

Uploaded by

xaiglennbandala
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
46 views7 pages

Database Midterm Quiz 2

UGRD-IT6203A Advanced Database Management Systems

Uploaded by

xaiglennbandala
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
You are on page 1/ 7
‘78124, 652 PM Midterm Quiz 2: Attempt review Started on Tuesday, 9 July 2024, 10:19 PM State Finished Completed on Tuesday, 9 July 2024, 1023 PM Time taken 4 mins 10 secs ‘Marks 20.00/20.00 Grade 100.00 out of 100.00 ‘Other datafiles required to recover the tablespace(s) such as the datafile forthe SYSTEM, UNDO, and TEMP tablespaces. Answer:| auilary set V weston 2 key tuning parameters forthe BACKUP command: | flesperset V_ The maximum number of files per backupset, uerton 3 DUPLICATE command: OPEN RESTRICTED When the destination database is ready, open it immediately withthe RESTRICTED SESSION option. Select one They Fale werton 4 target time ‘The point in time or SCN to which the tablespace will be recovered -tipsiftimestral amaesonline.com/2333mod/quizraview:php2altems wr ‘78124, 652 PM Midterm Quiz 2: Attempt review uerton S Identify the correct statement regarding TSPITR terminology. Select one ‘2. The ausiliary destination isthe permanent lacaton for the uni ry instance’s datafles, The ausiliay set contains all datafles for recovery except the SYSTEM and UNDO tablespaces. The target time is any time after the corrupted tables were modified or tables were accidentally dropped. dd. The recovery sets the group of datafles containing the tablespaces) to be recovered. Your answer is correct, verton 6 ‘You can use VSBACKUP_ASYNC [0 to moniter asynchronous RMAN 1/0. What column or columns de you use to determine which fle isthe bottleneck during a backup? Select one 4 Alarge value for LONG. WAITS Alege value for 10_COUNT 6 Allarge value for 10 COUNT / LONG WAITS dd. Allrge value for Loxe_warrs /10_count Your answer is correct, uerton 7 recovery set ‘The group of datafile containing the tablespace(s to be recovered. -tipsiftimestral amaesonline.com/2333mod/quizraview:php2altems an ‘78124, 652 PM Midterm Quiz 2: Attempt review uerton 8 Identify the correct statement regarding duplicate databases Select one: 2. RMAN copies the source database to the target database and both can have the same name b.RMAN creates an auxiliary instance forthe duration ofthe copy operation and drops it ater the copy operation is complete RMN copies the database from target to the duplicate database and both can have the same name. 4. The aunty database isthe same asthe target database Your answer is correct, uerton 9 You set the initialz ‘TRUE. What effect does this have on the type of /0 thatthe server tion parameter BACKUP_TAPE IO, SLAVES t processes perform for RMAN if you are using tape? Select one 4. Tape l/Ois automaticaly asyachronous. ¥ BH LARGE,POOL, SIZE is et toa nonzero valu, tape I/O ie automaticaly synchronous. 6 LARGE POOL, SIZE is set to a nonzero value ape I/O is automatically asynctvonous.

You might also like