Technical Questions

Q:

When mapping a supertype/subtype relationship which of the following is true?

A) The supertype primary key is assigned to each subtype. B) The subtype primary key is assigned to each supertype.
C) There is no link between the supertype/subtype entities. D) There is no primary key/foreign key relationship between a supertype/subtype.
 
Answer & Explanation Answer: A) The supertype primary key is assigned to each subtype.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

4 10224
Q:

Define latency, transfer and seek time with respect to disk I/O.

Answer

Seek time is the time required to move the disk arm to the required track. Rotational delay or latency is the time it takes for the beginning of the required sector to reach the head. Sum of seek time (if any) and latency is the access time. Time taken to actually transfer a span of data is transfer time.

Report Error

View answer Workspace Report Error Discuss

10 10141
Q:

Unreachable code would best be found using

A) code inspections B) a static analysis tool
C) code reviews D) a test management tool
 
Answer & Explanation Answer: C) code reviews

Explanation:

Code review is a software quality assurance activity in which one or several humans check a program mainly by viewing and reading parts of its source code, and they do so after implementation or as an interruption of implementation.

Report Error

View Answer Report Error Discuss

10 9656
Q:

What are demand-paging and pre-paging?

Answer

With demand paging, a page is brought into memory only when a location on that page is actually referenced during execution. With pre-paging, pages other than the one demanded by a page fault are brought in. The selection of such pages is done based on common access patterns, especially for secondary memory devices.

Report Error

View answer Workspace Report Error Discuss

3 9567
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

14 9317
Q:

Which is the simplest file structure?

A) Sequential B) Indexed
C) Random D) None
 
Answer & Explanation Answer: A) Sequential

Explanation:

Sequential is the simplest file structure

Report Error

View Answer Report Error Discuss

Filed Under: Software Testing

5 9300
Q:

With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.

A) READ_ONLY B) SCROLL_LOCK
C) OPTIMISTIC D) PESSIMISTIC
 
Answer & Explanation Answer: C) OPTIMISTIC

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

3 8859
Q:

What are the disadvantages of context switching?

Answer

Time taken for switching from one process to other is pure over head. Because the system does no useful work while switching. So one of the solutions is to go for threading when ever possible.

Report Error

View answer Workspace Report Error Discuss

20 8764