Technical Questions

Q:

Of the following tree structure, which is, efficient considering space and time complexities?

A) Incomplete Binary Tree B) Complete Binary Tree
C) Full Binary Tree D) None
 
Answer & Explanation Answer: B) Complete Binary Tree

Explanation:

Full binary tree loses its nature when operations of insertions and deletions are done. For incomplete binary trees, extra storage is required and overhead of NULL node checking takes place. So complete binary tree is the better one since the property of complete binary tree is maintained even after operations like additions and deletions are done on it.

Report Error

View Answer Report Error Discuss

Filed Under: Software Testing

6 7411
Q:

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

A) Equi-join B) Natural join
C) Outer join D) Cartesian join
 
Answer & Explanation Answer: D) Cartesian join

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

7 7377
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 7344
Q:

 When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

A) LIKE only. B) IN only.
C) NOT IN only. D) Both IN and NOT IN.
 
Answer & Explanation Answer: D) Both IN and NOT IN.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 7214
Q:

What are the reasons for process suspension?

Answer

swapping


interactive user request


timing


parent process request

Report Error

View answer Workspace Report Error Discuss

19 7212
Q:

When does the condition 'rendezvous' arise?

Answer

In message passing, it is the condition in which, both, the sender and receiver are blocked until the message is delivered.

Report Error

View answer Workspace Report Error Discuss

12 7077
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 6994
Q:

 A benefit of the three-tier architecture is which of the following?

A) New modules can be built to support specific business needs B) Performance improves for compiled SQL statements
C) Results in a thinner client and database server D) All of the above.
 
Answer & Explanation Answer: A) New modules can be built to support specific business needs

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 6887