Sawaal
  • Home/
  • Searching for %

 Searching for "%"

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

Q:

What is schema?

Answer

The description of a data base is called the database schema , which is specified during database design and is not expected to change frequently . A displayed schema is called schema diagram .We call each object in the schema as schema construct.

Report Error

View answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

Q:

Physical data models describe the details of how data is stored in the computers

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

Explanation:

They describe the details of how data is stored in the computers

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

Q:

Representation level data models provide the concepts that are close to the way many users perceive data

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

Explanation:

High level data models provide the concepts that are close to the way many users perceive data

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

Q:

In how many ways can the letters of the word ABACUS be rearranged such that the vowels always appear together?

A) 4!/2! B) 3!/2!
C) (4! x 3!) / 2! D) 36
 
Answer & Explanation Answer: C) (4! x 3!) / 2!

Explanation:

ABACUS is a 6 letter word with 3 of the letters being vowels.

 

If the 3 vowels have to appear together, then there will 3 other consonants and a set of 3 vowels together.

 

These 4 elements can be rearranged in 4! Ways.

 

The 3 vowels can rearrange amongst themselves in 3!/2! ways as "a" appears twice.

 

Hence, the total number of rearrangements in which the vowels appear together are (4! x 3!)/2!

Report Error

View Answer Report Error Discuss

Filed Under: Permutations and Combinations