Searching for "schema"

Q:

The database schema is written in

A) DDL B) HLL
C) DCL D) DML
 
Answer & Explanation Answer: A) DDL

Explanation:

The database schema is written in DDL. A data definition language or data description language (DDL) is a syntax similar to a computer programming language for defining data structures, especially database schemas.

Report Error

View Answer Report Error Discuss

Q:

What does BUS Schema means ?

Answer

BUS Schema is composed of a master suite of confirmed dimension and standardized definition if facts.

Report Error

View answer Workspace Report Error Discuss

Q:

What is the meaning of Copy IDMS Subschema-Binds?

Answer

It generates a bind run-unit and binds all the records for the sub-schema the program is referencing.

Report Error

View answer Workspace Report Error Discuss

Q:

Explain the difference between star and snowflake schemas.

Answer

Star schema: A highly de-normalized technique. A star schema has one fact table and is associated with numerous dimensions table and depicts a star.


Snow flake schema: The normalized principles applied star schema is known as Snow flake schema. Every dimension table is associated with sub dimension table.


 


Differences:


- A dimension table will not have parent table in star schema, whereas snow flake schemas have one or more parent tables.


- The dimensional table itself consists of hierarchies of dimensions in star schema, where as hierarchies are split into different tables in snow flake schema. The drilling down data from top most hierarchies to the lowermost hierarchies can be done.

Report Error

View answer Workspace Report Error Discuss

Q:

 The process of reading a database schema and producing a data model from that schema is known as:

A) data modeling. B) database design.
C) reverse engineering. D) None of the above is correct.
 
Answer & Explanation Answer: C) reverse engineering.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

To eliminate definition duplication, XML Schemas define:

A) an intersection table. B) global elements.
C) a normalized definition table. D) None of the above is correct.
 
Answer & Explanation Answer: B) global elements.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

Definition of the Cube Dimensions with Master Data Tables can be checked from TCodes

A. LISTSCHEMA.

B. RSRV.

C. LISTCUBE.

D. All of the above.

Answer

Answer : A

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Payroll schema consists of a sequence of functions. Which of these functions is used to import Absence infotype data?

A. PAB.

B. PIT.

C. P0015.

D. RAB.

Answer

Answer : D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP HR