Sawaal
  • Home/
  • Searching for

 Searching for ""

Q:

What are the responsibilities of a Database Administrator?

Answer

- Installing and upgrading the Oracle Server and application tools.


- Allocating system storage and planning future storage requirements for the database system.


- Managing primary database structures (tablespaces)


- Managing primary objects (table, views, indexes)


- Enrolling users and maintaining system security.


- Ensuring compliance with Oracle license agreement


- Controlling and monitoring user access to the database.


- Monitoring and optimizing the performance of the database.


- Planning for backup and recovery of database information.


- Maintain archived data on tape


- Backing up and restoring the database.


- Contacting Oracle Corporation for technical support.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What are the database administrators utilities available?

Answer

SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables. Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What is the use of ANALYZE command?

Answer

To perform one of these function on an index, table, or cluster:


 - To collect statistics about object used by the optimizer and store them in the data dictionary. 


 - To delete statistics about the object used by object from the data dictionary.


 - To validate the structure of the object.


 - To identify migrated and chained rows off the table or cluster.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What is database clusters?

Answer

Group of tables physically stored together because they share common columns and are often used together is called Cluster.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

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