A snowflake schema is which of the following types of tables?

The price of 10 chairs is equal to that of 4 tables . The price of 15 chairs and 2 tables together is Tk. 4000. The total price of 12 chairs and 3 tables is-

A

TK. 3500

B

Tk. 3750

C

Tk. 3840

D

None of these

The price of 3 tables and 4 chairs is Tk. 3300. with the same money one can buy 2 tables and 10 chairs. If one wants to buy In 1 table and 1 chair , how much does he need to pay?

A

Tk. 940

B

Tk. 1050

C

Tk. 1040

D

Tk. 950

If 2 tables and 3 chairs cost Tk. 3500 and 3 tables and 2 chairs cost Tk. 4000, then how much does table cost?

A

Tk. 500

B

Tk. 750

C

Tk. 1000

D

Tk. 15000

In SQL, which command(s) is(are) used to create a synonym for a schema object?

A

CREATE SCHEMA

B

CREATE SYNONYM

C

CREATE SAME

D

All of the above

E

None of the above

User views are included as part of which schema?

A

Internal

B

Conceptual

C

External

D

None of the above.

A star schema has what type of relationship between a dimension and fact table?

A

Many-to-many

B

One-to-one

C

One-to-many

D

All of the above

How many copies of the database schema are typically used in the redesign process?

A

One

B

Two

C

Three

D

Four

Which of the following is one of the basic approaches for joining tables?

A

Subqueries

B

Union Join

C

Natural join

D

All of the Mentioned

Which of the following is a way to create and modify tables using SQL Server?

A

Write SQL code using either CREATE or ALTER SQL statements only

B

Use the graphical facilities of SQL Server Enterprise Manager only

C

Both of the two methods above will work

D

Neither of the two methods above will work

Fact tables are which of the following?

A

Completely denoralized

B

Partially denoralized

C

Completely normalized

D

Partially normalized

A snowflake schema is which of the following types of tables?

Related Questions