A Web Based Application Abstract: This document has been prepared for a database project entitled “Fisheries Management System”. Its purpose is to create a database framework, which will…
1. What is incremental backup? Incremental backup makes a copy of all data blocks that have changed since a previous backup. 2. What are types of incremental backup?…
1. WHAT IS SQL* LOADER? SQL * LOADER loads data from external files into tables of an oracle database. It has a powerful data parsing engine that puts…
1. What is true regarding direct-load insert? A. A direct-load insert can be invoked by suing the APPEND hint. B. Inserting using the NOLOGGING option is the default…
1. Which RMAN command do you use to verify that the RMAN repository information is synchronized with the actual files that exist on disk? A. LIST B. CHANGE…
1. When performing incomplete recovery using UNTIL SEQUENCE with RMAN, which two pieces of information are required? (Choose two) A. Thread number. B. Log Sequence number. C. Control…
1. When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform? A. Until SCN B. Until time…
1. Your database is running in NOARCHIVELOG mode. Every night there is a backup taken using RMAN. During your startup this morning you received en error regarding DISK…
1. You discover that a disk failure occurred on DISK3 where the data file belonging to the USER_DATA tablespace is stored. The database is currently open and you…
1. Which phrase best describes RMAN multiplexed backup sets? A. Stripes a single backup set across multiple channels. B. Identical copies of backup pieces within a backup set….