Give the two types of tables involved in producing a star schema and the type of data they hold.

Give the two types of tables involved in producing a star
schema and the type of data they hold.
by

1 Answer

Answer :

Fact tables and dimension tables. A fact table contains measurements
while dimension tables will contain data that will help describe the fact
tables.
by

Related questions

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

What is schema?

Description : What is schema?

Last Answer : A schema is collection of database objects of a User.

What is a Schema ?

Description : What is a Schema ?

Last Answer : The set of objects owned by user account is called the schema.

Can one rename a database user (schema)? (for DBA)

Description : Can one rename a database user (schema)? (for DBA)

Last Answer : No, this is listed as Enhancement Request 158508. Workaround: Do a user-level export of user A create new user B Import system/manager fromuser=A touser=B Drop user A

Can objects of the same Schema reside in different tablespaces.?

Description : Can objects of the same Schema reside in different tablespaces.?

Last Answer : Yes.

Can objects of the same schema reside in different tablespaces?

Description : Can objects of the same schema reside in different tablespaces?

Last Answer : Yes.

What are Schema Objects?

Description : What are Schema Objects?

Last Answer : Schema objects are the logical structures that directly refer to the database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages and database links.

What is schema?

Description : What is schema?

Last Answer : A schema is collection of database objects of a user.

What is a Relation Schema and a Relation?

Description : What is a Relation Schema and a Relation?

Last Answer : A relation Schema denoted by R(A1, A2, …, An) is made up of the relation name R and the list of attributes Ai that it contains. A relation is defined as a set of tuples. Let r be the relation which contains set tuples (t1, t2, t3, …,tn). Each tuple is an ordered list of n-values t=(v1,v2, …, vn).

How do you collect statistics for a table, schema and Database?

Description : How do you collect statistics for a table, schema and Database?

Last Answer : Using DBMS_STATS package to gather Oracle dictionary statistics.

Name the seven types of Oracle tables

Description : Name the seven types of Oracle tables

Last Answer : Heap Organized Tables, Index Organized Tables, Index Clustered Tables, Hash Clustered Tables, Nested Tables, Global Temporary Tables, Object Tables.

What are two virtual tables available during database trigger execution ?

Description : What are two virtual tables available during database trigger execution ?

Last Answer : The table columns are referred as OLD.column_name and NEW.column_name. For triggers related to INSERT only NEW.column_name values only available. For triggers related to UPDATE only OLD. ... values only available. For triggers related to DELETE only OLD.column_name values only available.

What is the use of TABLES option in EXP command ?

Description : What is the use of TABLES option in EXP command ?

Last Answer : List of tables should be exported.ze)

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Description : A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Last Answer : Disable the foreign key constraint to the parent, drop the table, re- create the table, enable the foreign key constraint.

What are mutating tables

Description : What are mutating tables

Last Answer : When a table is in state of transition it is said to be mutating. eg :: If a row has been deleted then the table is said to be mutating and no operations can be done on the table except select.

What is the difference between deleting and truncating of tables

Description : What is the difference between deleting and truncating of tables

Last Answer : Deleting a table will not remove the rows from the table but entry is there in the database dictionary and it can be retrieved But truncating a table deletes it completely and it cannot be retrieved.

What is in all those X$ tables? (for DBA

Description : What is in all those X$ tables? (for DBA

Last Answer : The following list attempts to describe some x$ tables. The list may not be complete or accurate, but represents an attempt to figure out what information they contain. One should generally not ... Fixed Table. It can predict the potential loss of decreasing the number of database buffers. The

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Description : Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Last Answer : No, a cursor variable points a row which cannot be stored in a two- dimensional PL/SQL table.

Name the tables where characteristics of Package, procedure and functions are stored ?

Description : Name the tables where characteristics of Package, procedure and functions are stored ?

Last Answer : User_objects, User_Source and User_error.

How will you estimate the space required by a non- clustered tables?

Description : How will you estimate the space required by a non- clustered tables?

Last Answer : Calculate the total header size Calculate the available dataspace per data block Calculate the combined column lengths of the average row Calculate the total average row size. Calculate the average number rows ... add 10 % additional space to calculate the initial extent size for a working table.

What are the dictionary tables used to monitor a database space?

Description : What are the dictionary tables used to monitor a database space?

Last Answer : DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.

What are the dictionary tables used to monitor a database spaces ?

Description : What are the dictionary tables used to monitor a database spaces ?

Last Answer : DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.

How does one get the view definition of fixed views/tables?

Description : How does one get the view definition of fixed views/tables?

Last Answer : Query v$fixed_view_definition. Example: SELECT * FROM v$fixed_view_definition WHERE view_name='V$SESSION';

Spurious tuples may occur due to i. Bad normalization ii. Theta joins iii. Updating tables from join a) i& ii b) ii & iii c) i& iii d) ii & iii

Description : Spurious tuples may occur due to i. Bad normalization ii. Theta joins iii. Updating tables from join a) i& ii b) ii & iii c) i& iii d) ii & iii

Last Answer : a) i& ii b) ii & iii

Tables derived from the ERD

Description : Tables derived from the ERD

Last Answer : a) Are totally unnormalised b) Are always in 1NF c) Can be further denormalised d) May have multi-valued attributes (b) Are always in 1NF

How do you move tables from one tablespace to another tablespace?

Description : How do you move tables from one tablespace to another tablespace?

Last Answer : There are several methods to do this; 1) export the table, drop the table, create the table definition in the new tablespace, and then import the data (imp ignore=y). 2) Create ... table and rename the temporary table as the original: DROP TABLE real_table; RENAME temp_name TO real_table;

Can you make collection of Statistics for tables automatically?

Description : Can you make collection of Statistics for tables automatically?

Last Answer : YES. Oracle databse has default, scheduled job "gather_stats_job" that analyses stats on a daily basis during the maintenance window time. There are two scheduled activities related to ... GATHER_STATS_JOB'); Oracle collects optimizer statistics for SQL via the default of autostats_target = auto.

Can a Tablespace hold objects from different Schemes ?

Description : Can a Tablespace hold objects from different Schemes ?

Last Answer : Yes.

Can a tablespace hold objects from different schemes?

Description : Can a tablespace hold objects from different schemes?

Last Answer : Yes.

How many sections a performance template can hold and what are those?

Description : How many sections a performance template can hold and what are those?

Last Answer : An Oracle Fusion Performance Template can hold maximum of six sections, which are given below 1. Competency Section 2. Goal Section 3. Worker Final Feedback Section 4. Manager Final Feedback Section 5. Questionnaire Section 6. Overall Review Section

A logical schema A. is the entire database B. is a standard wayof organizing information into accessible parts C. describes how data is actually stored on disk D. All of theabove E. None of the above

Description : A logical schema A. is the entire database B. is a standard wayof organizing information into accessible parts C. describes how data is actually stored on disk D. All of theabove E. None of the above

Last Answer : is a standard wayof organizing information into accessible parts

Goals for the design of thelogical schema include A. avoiding data inconsistency B. being ableto construct queries easily C. being ableto access data efficiently D. All of theabove E. None of the above

Description : Goals for the design of thelogical schema include A. avoiding data inconsistency B. being ableto construct queries easily C. being ableto access data efficiently D. All of theabove E. None of the above

Last Answer : All of theabove

A logical schema A) is the entire database B) is a standard way of organizing information into accessible parts. C) Describes how data is actually stored on disk. D) All of the above

Description : A logical schema A) is the entire database B) is a standard way of organizing information into accessible parts. C) Describes how data is actually stored on disk. D) All of the above

Last Answer : B) is a standard way of organizing information into accessible parts.

A Network Schema (A) restricts to one to many relationship (B) permits many to many relationship (C) stores Data in a Database (D) stores Data in a Relation

Description : A Network Schema (A) restricts to one to many relationship (B) permits many to many relationship (C) stores Data in a Database (D) stores Data in a Relation

Last Answer : (B) permits many to many relationship

Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) eliminating number of anomalies that could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced.

Description : Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) ... could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced. 

Last Answer : reducing the number of joins required to satisfy a query.

DBMS provides the facility of accessing data from a database through (A) DDL (B) DML (C) DBA (D) Schema

Description : DBMS provides the facility of accessing data from a database through (A) DDL (B) DML (C) DBA (D) Schema 

Last Answer : (B) DML

What are the steps involved in Database Shutdown ?

Description : What are the steps involved in Database Shutdown ?

Last Answer : Close the Database, Dismount the Database and Shutdown the Instance.

What are the steps involved in Database Startup ?

Description : What are the steps involved in Database Startup ?

Last Answer : Start an instance, Mount the Database and Open the Database. Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo ... Resolving any pending distributed transactions undergoing a two- phase commit at the time of the instance failure.

How much weight can the changing tables at most places hold?

Description : How much weight can the changing tables at most places hold?

Last Answer : I weigh 130lbs and I’ve set on one before. It held up. I was very gentle though.

What are the data types allowed in a table ?

Description : What are the data types allowed in a table ?

Last Answer : CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW.

Give the Types of modules in a form?

Description : Give the Types of modules in a form?

Last Answer : Form Menu Library

.......... is a special type of programming language used to provide instructions to the monitor simple batch processing schema. A) Job control language (JCL) B) Processing control language (PCL) C) Batch control language (BCL)

Description : .......... is a special type of programming language used to provide instructions to the monitor simple batch processing schema. A) Job control language (JCL) B) Processing control language (PCL) C) Batch control language (BCL)

Last Answer : A) Job control language (JCL)

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

Description : What should be the return type for a cursor variable.Can we use a scalar data type as return type?

Last Answer : The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE

When do you use data parameter type?

Description : When do you use data parameter type?

Last Answer : When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to produts invoked with the run_product built-in subprogra

How many types of columns are there and what are they

Description : How many types of columns are there and what are they

Last Answer : Formula columns :: For doing mathematical calculations and returning one value Summary Columns :: For doing summary calculations such as summations etc. Place holder Columns :: These columns are useful for storing the value in a variable

How many types of database triggers can be specified on a table ? What are they ?

Description : How many types of database triggers can be specified on a table ? What are they ?

Last Answer : Insert Update Delete Before Row o.k. o.k. o.k. After Row o.k. o.k. o.k. Before Statement o.k. o.k. o.k. After Statement o.k. o.k. o.k. If FOR EACH ROW clause is ... for each Row affected by the statement. If WHEN clause is specified, the trigger fires according to the returned Boolean value.

Consider the following two commands C1 and C2 on the relation R from an SQL database: C1: drop table R; C2: delete from R; Which of the following statements is TRUE? I. Both C1 and C2 delete the schema for R. II. C2 retains relation R, but deletes all tuples in R. III. C1 deletes not only all tuples of R, but also the schema for R. (A) I only (B) I and II only (C) II and III only (D) I, II and III

Description : Consider the following two commands C1 and C2 on the relation R from an SQL database:  C1: drop table R; C2: delete from R; Which of the following statements is TRUE? I. Both C1 and C2 delete the schema for R. II. C2 ... R. (A) I only (B) I and II only (C) II and III only (D) I, II and III

Last Answer : (C) II and III only

A set of predefined formats of text or color scheme is called ………………. (a) slide (b) presentation scheme (c) theme (d) schema -Technology

Description : A set of predefined formats of text or color scheme is called ………………. (a) slide (b) presentation scheme (c) theme (d) schema -Technology

Last Answer : (c) A set of predefined formats of text or color scheme is called theme.

In order to use a DBMS, it is important to understand A. the physical schema B. all sub-schemas that thesystem supports C. one subschema D. both (a)and (b) E. None of the above

Description : In order to use a DBMS, it is important to understand A. the physical schema B. all sub-schemas that thesystem supports C. one subschema D. both (a)and (b) E. None of the above

Last Answer : one subschema

In contrast, the contract-first approach encourages you to think of the service contract first in terms of :- a) XML b) XML Schema(.xsd) c) WSDL d) All of the mentioned

Description : In contrast, the contract-first approach encourages you to think of the service contract first in terms of :- a) XML b) XML Schema(.xsd) c) WSDL d) All of the mentioned

Last Answer : All of the mentioned