Sawaal
  • Home/
  • Searching for I

 Searching for "I"

Q:

How do you resize a data file?

Answer

ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>; 

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

How do you add a data file to a tablespace?

Answer

ALTER TABLESPACE ADD DATAFILE <datafile_name> SIZE <size>

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What does coalescing a tablespace do?

Answer

Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

How would you force a log switch?

Answer

ALTER SYSTEM SWITCH LOGFILE;

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

Describe what redo logs are.

Answer

Redo logs are logical and physical structures that are designed to hold all the changes made to a database and are intended to aid in the recovery of a database.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What does a Control file Contain?

Answer

A Control file records the physical structure of the database. It contains the following information. Database Name ,Names and locations of a database’s files and redolog files. Time stamp of database creation.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

Explain an ORA-01555?

Answer

You get this error when you get a snapshot too old within rollback. It can usually be solved by increasing the undo retention or increasing the size of rollbacks. You should also look at the logic involved in the application getting the error message.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

How would you go about increasing the buffer cache hit ratio?

Answer

Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set db_cache_size command.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration