Give the two types of tables involved in producing a star
schema and the type of data theyhold.
Answer Posted / 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 |
Post New Answer View All Answers
What is transparent data encryption? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what do you understand by flashback feature of oracle?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What authentication modes does sql server support? : sql server DBA
how can a session indicate its interest in receiving alerts?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can you get actual data change values from previous transactions in oracle?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the different sql server versions you have worked on? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?