what are the disadvantages of hierarchial database over
RDBMS?
Answer / manjeet kumar
The disadvantages of a hierarchical database are:
·lack of flexibility (non-hierarchical relationships are
awkward to represent; redundancy may be required),
·poor performance for non-hierarchical accesses,
·lack of maintainability (changing relationships may
require physical reorganization of data).
| Is This Answer Correct ? | 11 Yes | 9 No |
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
how to genarate random numbers in oracle for particular row?
How to import one table back from a dump file?
what is the scenario where you take the database to NoArchivelog mode?
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 create a temporary table in oracle?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
which statement is running fastly ie insert or delete?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
What is the data type of dual table?
what is candidate key & super key