Sawaal
  • Home/
  • Searching for h

 Searching for "h"

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:

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

Q:

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Answer

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What are the Referential actions supported by FOREIGN KEY integrity constraint?

Answer

UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration