Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of physical database structure in the Oracle database?
- 1 Answers
- 1435 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
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 |
Post New Answer View All Answers
Explain constraining triggers.
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Which dictionary tables and/or views would you look at to diagnose a locking issue?
When do you get a .pll extension in oracle?
What is SQL Tuning Advisor in Oracle?
What is snapshot is too old? Give and example for better understand.
State all possible different index configurations a table can possibly have?
What is a server parameter file in oracle?
Write a syntax for update query in oracle?
Explain the use of online redo log files in oracle.
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is a snapshot log?
How to get a create statement for an existing table?
What is backup in Oracle?
Is java required for oracle client?
