InterviewUp – Job Interview Questions and Answers

Add or view comments about this interview question

Comments (0) |

Share this interview question with your friend

Email

|

Inappropriate

|

View all interview questions asked by this user

Asked By: detech1 |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

The point at which ORACLE ends writing to one online
redo log file and begins writing to another is called a log
switch

Create Date

:

Thursday, March 06, 2008

Tags

:

log switch

Asked At

:

None

Job Positions

:

database management

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

123

UPs

What is HOT BACK UP and how it can be taken?

Comments (0) |

Email

|

Inappropriate

|

Asked By: detech1 |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Taking the backup of ARCHIVE LOG files when the DATABASE is open and ARCHIVE LOG mode should be enabled before taking Hot Backup.

All Data files, all Archivelog files, all Redo log files, all Control files need to be backed up Before this.

Create Date

:

Thursday, March 06, 2008

Tags

:

Hot Back Up

Asked At

:

None

Job Positions

:

database management

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

96

UPs

Can we take the FULL BACK UP when the DATABASE is open?

Comments (0) |

Email

|

Inappropriate

|

Asked By: detech1 |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

No.

Create Date

:

Thursday, March 06, 2008

Tags

:

Full backup

Asked At

:

None

Job Positions

:

database management

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

68

UPs

What is Cold Backup?Mention the elements of it?

Comments (0) |

Email

|

Inappropriate

|

Asked By: detech1 |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Back up of all Physical files after normal shutdown of Database is COLD BACK up.

All Data files , All Control files, All online redo log files, init.ora file are the elements in that.

Create Date

:

Thursday, March 06, 2008

Tags

:

Cold Back up

Asked At

:

None

Job Positions

:

database management

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

100

UPs

Constraints can be exported through EXPORT command or not?

Comments (0) |

Email

|

Inappropriate

|

Asked By: detech1 |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Yes

Create Date

:

Thursday, March 06, 2008

Tags

:

export, constraints

Asked At

:

Suvidha

Job Positions

:

database management

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

84

UPs

What is mean by Free Extent?

Comments (0) |

Email

|

Inappropriate

|

Asked By: detech1 |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Unallocated area of a Segment is Free Extent.

Create Date

:

Thursday, March 06, 2008

Tags

:

Free Extent

Asked At

:

None

Job Positions

:

Database Architecture

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

126

UPs

What are the factors that can affect the accuracy of the estimations ?

Comments (0) |

Email

|

Inappropriate

|

Asked By: detech1 |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

The space used transaction entries and deleted records does not become free
immediately after completion due to delayed cleanout. Trailling nulls and length bytes are not stored. Inserts of, updates to and deletes of rows as well as columns larger than a
single datablock, can cause fragmentation an chained row pieces.