Technical Questions

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 7741
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 7712
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 7709
Q:

What happens during the bootstrap process?

Answer

A bootstrap is the process of starting up a computer. It also refers to the program that initializes the operating system (OS) during start-up.


It referred to a bootstrap load button that was used to initiate a hardwired bootstrap program, or smaller program that executed a larger program such as the OS.

Report Error

View answer Workspace Report Error Discuss

44 7683
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 7568
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 7510
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 7331
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 7314