What are the components of physical database structure in the Oracle database?
The components of the physical database structure are:
• Greater than equal to two redo log files.
• Greater than equal to one control file.
• Greater than equal to one data file.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
Define the terms primary key foreign key and also the difference between primary and the unique key
What is Data Block ?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to connect to the server with user account: sys?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is proxy method?
can you explain performance tunning in oracle(sql,PL/SQL)
How are Indexes Update ?
master table and child table performances and comparisons in Oracle ?
What is the minimum client footprint required to connect c# to an oracle database?
Why do we use coalesce function in oracle?