Technical Questions

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

0 2596
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

0 2604
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

0 2865
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

0 2365
Q:

Which among the following is the disadvantage of circular list?

A) An info field that contains the information stored in the node B) Can’t traverse the list backward
C) A pointer to the node is given we cannot delete the node D) Both 2 and 3
 
Answer & Explanation Answer: D) Both 2 and 3

Explanation:

Both 2 and 3 are clearly the diadvantages of circular list

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 2544
Q:

The time complexity of sequential search is

A) O(n) B) O(2n)
C) O(n^2) D) None
 
Answer & Explanation Answer: A) O(n)

Explanation:

The time complexity of sequential search is O(n)

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 2754
Q:

If you are using C language to implement the heterogeneous linked list, what pointer type will you use?

Answer

The heterogeneous linked list contains different data types in its nodes and we need a link, pointer to connect them. It is not possible to use ordinary pointers for this. So we go for void pointer. Void pointer is capable of storing pointer to any type as it is a generic pointer type.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Exam Prep: GATE
Job Role: Database Administration

0 1945
Q:

Which of the following products implemented the CODASYL DBTG model?

A) IDMS B) DB2
C) dBase-II D) R:base
 
Answer & Explanation Answer: A) IDMS

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 6481