Sawaal
  • Home/
  • Searching for u

 Searching for "u"

Q:

What is Distributed database?

Answer

A distributed database is a network of databases managed by multiple database servers that appears to a user as single logical database. The data of all databases in the distributed database can be simultaneously accessed and modified.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

How can you enable a trace for a session?

Answer

Use the DBMS_SESSION.SET_SQL_TRACE or


Use ALTER SESSION SET SQL_TRACE = TRUE;

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

How can you rebuild an index?

Answer

ALTER INDEX <index_name> REBUILD;

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

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:

How would you force a log switch?

Answer

ALTER SYSTEM SWITCH LOGFILE;

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