Give the two types of tables involved in producing a star
schema and the type of data theyhold.
Answers were Sorted based on User's Feedback
Answer / monal
FACT TABLE: SALES
DIMENSION TABLE: GEOGRAPHY, PRODUCT, TIME
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / jeshani
Fact tables and dimension tables.
A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.
Is This Answer Correct ? | 1 Yes | 0 No |
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
How can you enable a trace for a session?
How will u copy the objects of one schema to another schema in datapump & export/import?
what are the types of connection load-balancing?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
how can you communicate with operating system files from oracle?
How do you trace the traffic hitting a sql server? : sql server DBA
how can you connect from 10g user to 11g user??
If CPU is very slow What can u do to speed up?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What the different types of replication and why are they used? : sql server DBA