Sawaal

Database Administration Questions

Popular Latest Rated
Q:

Parenthesis is never required in Postfix or Prefix expressions

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

Explanation:

Parenthesis is not required because the order of the operators in the postfix /prefix expressions determines the actual order of operations in evaluating the expression

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

3 8156
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 2755
Q:

It is necessary to sort a file before searching a particular item 

A) True B) False
C) May or may not be true D) None of the above
 
Answer & Explanation Answer: C) May or may not be true

Explanation:

If less work is involved in searching a element than to sort and then extract, then we don’t go for sort

If frequent use of the file is required for the purpose of retrieving specific element, it is more efficient to sort the file.

Thus it depends on situation

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

2 7017
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 2545
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 2370
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 2869
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 2605
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

1 4085