DBSkool Header Image Background

Farm Management System

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…

DBA Fundamental II(1)

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?…

DBA Fundamental II

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…

Export and Import Utilities

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…

RMAN Maintenance

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…

RMAN Incomplete Recovery

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…

User-Managed Incomplete Recovery

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…

RMAN Complete Recovery

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…

User-Managed Complete Recovery

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…

RMAN Backup

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….