Oracle DBA Structure Interview Questions and Answers Pdf - 3

Question: 11

What kind of information is stored in a control file?

Control file stores information about log switches, checkpoints, and modification in disk resources.

Question: 12

How can you get the information about log files and archive log files?

There are different data recovery views, such as V$LOGFILE and V$ARCHIVE_LOG, to obtain information about log files and archiving log files.

Question: 13

What is the need to multiplex redo log file? How can you do that?

Multiplexing is required to improve recoverability of the database in case of disk failure.

You can multiplex redo log file by maintaining more than one member in each group.

Question: 14

How do you move tables from one tablespace to another tablespace?

You can use alter table <table name> move tablespace <new tablespace name> statement to move tables from one tablespace to another tablespace.

Question: 15

How many rows in a table chained?

The information about chained rows is available in either the chain_cnt column or the dba_tables, all_tables or user_tables view.

However, this information can be out dated. You need to analyze the table to get the correct information in these views.