Set - 2

Question 76 :

What is the basic data structure that is required for creating an LOV?

Answer :

Record Group.


Question 77 :

How does one backup archived log files? (for DBA )

Answer :

One can backup archived log files using RMAN or any operating system backup utility. Remember to delete files after backing them up to prevent the archive log directory from filling up. If the archive log directory becomes full, your database will hang! Look at this simple RMAN backup script:
RMAN> run {
2> allocate channel dev1 type disk;
3> backup
4> format '/app/oracle/arch_backup/log_t%t_s%s_p%p'
5> (archivelog all delete input);
6> release channel dev1;
7> }


Question 78 :

Does Oracle write to data files in begin/hot backup mode? (for DBA )

Answer :

Oracle will stop updating file headers, but will continue to write data to the database files even if a tablespace is in backup mode.
In backup mode, Oracle will write out complete changed blocks to the redo log files. Normally only deltas (changes) are logged to the redo logs. This is done to enable reconstruction of a block if only half of it was backed up (split blocks). Because of this, one should notice increased log activity and archiving during on-line backups.


Question 79 :

What is the Maximum allowed length of Record group Column?

Answer :

Record group column names cannot exceed 30 characters.


Question 80 :

Which parameter can be used to set read level consistency across multiple queries?

Answer :

Read only