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 7790
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 7776
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 7741
Q:

Point out the error in the following program.

main()

{

    char mybuf[] = "Zanzibar" ;

    char yourbuf[] = " Zienckewiz";

    char * const ptr = mybuf;

     *ptr = 'a';

     ptr = yourbuf;

}

Answer

ptr pointer is constant. In ptr = yourbuf the program is trying to modify it, hence an error.

Report Error

View answer Workspace Report Error Discuss

Subject: Programming

5 7727
Q:

White Box Techniques are also called as

A) Design Based Testing B) Experience Based Technique
C) Structural Testing D) Error Guessing Technique
 
Answer & Explanation Answer: C) Structural Testing

Explanation:

Structural Testing is the other name for White Box Techniques.

Report Error

View Answer Report Error Discuss

4 7681
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

20 7530
Q:

A data dictionary is a special file that contains

A) The width of all fields in all files B) The data type of all fields in all file
C) The name of all fields in all files D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

A data dictionary is a special file that contains a set of information describing the contents, format, and structure of a database and the relationship between its elements, used to control access to and manipulation of the database.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: Bank Exams
Job Role: Analyst , Bank Clerk , Database Administration , IT Trainer

44 7400
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 7347