Searching for "i"

Q:

How many lines can you draw using 3 non collinear (not in a single line) points A, B and C on a plane?

A) 3 B) 6
C) 2 D) 4
 
Answer & Explanation Answer: A) 3

Explanation:

You need two points to draw a line. The order is not important. Line AB is the same as line BA. The problem is to select 2 points out of 3 to draw different lines. If we proceed as we did with permutations, we get the following pairs of points to draw lines.

 

AB , AC

 

BA , BC

 

CA , CB

 

There is a problem: line AB is the same as line BA, same for lines AC and CA and BC and CB.

 

The lines are: AB, BC and AC ; 3 lines only.

 

So in fact we can draw 3 lines and not 6 and that's because in this problem the order of the points A, B and C is not important.

Report Error

View Answer Report Error Discuss

Q:

In how many ways can the letters of the word "PROBLEM" be rearranged to make 7 letter words such that none of the letters repeat?

A) 49 B) 7!
C) 7^7 D) 7^3
 
Answer & Explanation Answer: B) 7!

Explanation:

There are seven positions to be filled.

 

The first position can be filled using any of the 7 letters contained in PROBLEM.

 

The second position can be filled by the remaining 6 letters as the letters should not repeat.

 

The third position can be filled by the remaining 5 letters only and so on.

 

Therefore, the total number of ways of rearranging the 7 letter word = 7*6*5*4*3*2*1 = 7! ways.

Report Error

View Answer Report Error Discuss

Q:

Which among the following is the relationship constraints

A) Cardinality ratio B) Participation constraints
C) Both A and B D) None of the above
 
Answer & Explanation Answer: C) Both A and B

Explanation:

Both of them are relation ship constraints

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

Q:

The relationship where both the participating entities belong to same entity type is called

A) Participation B) Recursive
C) Standard D) Normal
 
Answer & Explanation Answer: B) Recursive

Explanation:

The relationship where both the participating entities belong to same entity type is called Recursive relationship

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

Q:

The no of entities participating in a relation is called

A) Relation B) Degree of relationship
C) Recursive relationship D) None of the above
 
Answer & Explanation Answer: B) Degree of relationship

Explanation:

The no of entities participating in relation is called Degree of relationship

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

Q:

An entity is a thing in the real world with an independent existence.

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

Entity is a real world object

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

Q:

What are different types of DBMS?

Answer

1. DBMS


2. RDBMS (Relational)


3. ORDBMS (Object Relational)


4. DDBMS (Distributed)


5. FDBMS (Federated)


6. HDDBMS (Homogeneous)


7. HDBMS (Hierarchical)


8. NDBMS (Networked)

Report Error

View answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

Q:

The capacity to change the conceptual schema without having to change external schemas or application programs is called

A) Physical Data Independence B) Logical Data Independence
C) Both A and B D) None
 
Answer & Explanation Answer: B) Logical Data Independence

Explanation:

LDI is the capacity to change the conceptual schema without having to change external schemas or application programs.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration