Sawaal
  • Home/
  • Searching for at

 Searching for "at"

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 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:

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