Give the two types of tables involved in producing a star
schema and the type of data theyhold.
Answer Posted / monal
FACT TABLE: SALES
DIMENSION TABLE: GEOGRAPHY, PRODUCT, TIME
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can you enable flashback feature?
What is the default fill factor value? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What would you do with an "in-doubt" distributed transaction?
how can you schedule a job in database?
what is ora 24313?what is the procedure to exclude that error?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to start SQL Server in minimal configuration mode?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What is dbcc? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how does an oracle clusterware manage crs resources?