Technical Questions

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 Workspace Report Error Discuss

Filed Under: Database
Job Role: Database Administration

1 5457
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 Workspace Report Error Discuss

Filed Under: Database

7 5428
Q:

 The load and index is which of the following?

A) A process to reject data from the data warehouse and to create the necessary indexes B) A process to load the data in the data warehouse and to create the necessary indexes
C) A process to upgrade the quality of data after it is moved into a data warehouse D) A process to upgrade the quality of data before it is moved into a data warehouse
 
Answer & Explanation Answer: B) A process to load the data in the data warehouse and to create the necessary indexes

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database

0 5358
Q:

What resources are used when a thread is created? How do they differ from those when a process is created?

Answer

When a thread is created the threads does not require any new resources to execute the thread shares the resources like memory of the process to which they belong to. The benefit of code sharing is that it allows an application to have several different threads of activity all within the same address space. Whereas if a new process creation is very heavyweight because it always requires new address space to be created and even if they share the memory then the inter process communication is expensive when compared to the communication between the threads.

Report Error

View answer Workspace Report Error Discuss

3 5357
Q:

What is cladding?

Answer

A layer of a glass surrounding the center fiber of glass inside a fiber-optic cable.

Report Error

View answer Workspace Report Error Discuss

Subject: Networking
Job Role: Network Engineer

6 5301
Q:

enum colors {BLACK,BLUE,GREEN}

main()

{

printf( "%d..%d..%d", BLACK, BLUE, GREEN );

return(1);

}

A) 1..2..3 B) 0..1..2
C) 1..1..1 D) 0..0..0
 
Answer & Explanation Answer: B) 0..1..2

Explanation:

enum assigns numbers starting from 0, if not explicitly defined.

Report Error

View Answer Workspace Report Error Discuss

Filed Under: Programming

2 5279
Q:

Explain the popular multiprocessor thread-scheduling strategies.

Answer

  1. Load Sharing: Processes are not assigned to a particular processor. A global queue of threads is maintained. Each processor, when idle, selects a thread from this queue. Note that load balancing refers to a scheme where work is allocated to processors on a more permanent basis.

  2. Gang Scheduling: A set of related threads is scheduled to run on a set of processors at the same time, on a 1-to-1 basis. Closely related threads / processes may be scheduled this way to reduce synchronization blocking, and minimize process switching. Group scheduling predated this strategy.

  3. Dedicated processor assignment: Provides implicit scheduling defined by assignment of threads to processors. For the duration of program execution, each program is allocated a set of processors equal in number to the number of threads in the program. Processors are chosen from the available pool.

  4. Dynamic scheduling: The number of thread in a program can be altered during the course of execution.

Report Error

View answer Workspace Report Error Discuss

8 5199
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 Workspace Report Error Discuss

Filed Under: Database

2 5167