In a given relation R, If an attribute A uniquely define all other attributes, then the attribute A is the key attribute which is also known as

1. Functional key
2. Foreign key
3. Candidate key
4. All of the above

Nandini

• Mar 9th, 2015

Candidate key

Answer Question  Select Best Answer

What is utlu211i.sql in Oracle DBA in upgrade concepts? Any one explain in detail

Mudassir

• Dec 4th, 2015

It is a utility provided by Oracle to change invalid objects valid

Answer Question  Select Best Answer

How many database writers are available (max) to create in Oracle.

Ayub

• Feb 3rd, 2016

20

Answer Question  Select Best Answer

Akbar Yuldoshev

• Jun 18th, 2016

Oracle Enterprise Manager

malli

 Profile Answers by malli Questions by malli

• Aug 1st, 2015

SQL Loader

Answer Question  Select Best Answer

Akbar Yuldoshev

• Jun 18th, 2016

By allocate_extent_clause

Answer Question  Select Best Answer

Kindly differentiate Redo, undo, Roll back and Roll forward

musa

• Aug 1st, 2016

Redo is for roll forward that can recover your data from online redolog files (archivelog file) and undo is for rollback of data from undo tablespace within default retention 900s(15 mins)

Answer Question  Select Best Answer

What is the difference between Roll back and Roll forward process?

ashok

• Oct 6th, 2016

Redo is for roll forward that can recover your data from online redolog files (archivelog file) and undo is for rollback of data from undo tablespace within default retention 900s(15 mins)

Answer Question  Select Best Answer

If I have incremental backup by RMAN of Mon, Tue, Wed and on Thursday Morning our database will crash somehow. Then which day we recover first and how?

Raju

• Nov 24th, 2016

If I have incremental backup by RMAN of Mon, Tue, Wed and on Thursday Morning our database will crash somehow. Then which day we recover first and how?

Answer Question  Select Best Answer

If there was a abnormal termination, upon startup smon performs instance recovery and rolls forward and rollbacks committed and uncomitted transaction. But if this happens before startup the DB files are not open before startup then how does smon carry out recovery.

harshini

• Oct 8th, 2017

Secondary Backup Server

Answer Question  Select Best Answer

What is the solution if some users are encountering slow performance in production db?

Abbey

• Feb 16th, 2018

Scan for virus first

Shalu

• Dec 4th, 2016

Check the query that is running in database, try to optimize the query by using correct hint and indexes"oracle8 SELECT department_id, last_name, salary FROM employees WHERE ...

Answer Question  Select Best Answer