Technical Questions

Q:

 In the relational model, relationships between relations or tables are created by using:

A) composite keys. B) determinants.
C) candidate keys. D) foreign keys.
 
Answer & Explanation Answer: D) foreign keys.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 5081
Q:

What are the different hazards? How do you avoid them?

Answer

There are situations, called hazards, that prevent the next insturction in the instruction stream from executing during its designated clock cycle. hazards reduce the performance from the ideal speedup gained by pipelining.


There are three classes of Hazards:


1. Structural hazards: It arise from resource conficts when the hardware cannot support all possible combinations of instructions simultaniously in overlapped execution.


2. Data Hazards: It arise when an instruction depends on the results of previous instruction in a way that is exposed by the overlapping of instructions in the pipeline.


3.control hazards. it arise from the pipelining of branches and other instructions that chage the PC.

Report Error

View answer Workspace Report Error Discuss

Subject: Hardware

8 5061
Q:

Which of the following indicates the maximum number of entities that can be involved in a relationship?

A) Minimum cardinality B) Maximum cardinality
C) ERD D) Greater Entity Count (GEC)
 
Answer & Explanation Answer: B) Maximum cardinality

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 5039
Q:

SQL Server program code that is executed instead of an SQL command that needs to be processed is called

A) INSTEAD OF trigger. B) BEFORE trigger.
C) AFTER trigger. D) BEGIN trigger.
 
Answer & Explanation Answer: A) INSTEAD OF trigger.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 5026
Q:

Why crystal is a preferred clock source?

Answer

Because of high stability, large Q (Quality Factor) & the frequency that doesn't drift with aging. Crystal is used as a clock source most of the times.

Report Error

View answer Workspace Report Error Discuss

Subject: Hardware

0 5014
Q:

What is the difference between Hard and Soft real-time systems?

Answer

A hard real-time system guarantees that critical tasks complete on time. This goal requires that all delays in the system be bounded from the retrieval of the stored data to the time that it takes the operating system to finish any request made of it. A soft real time system where a critical real-time task gets priority over other tasks and retains that priority until it completes. As in hard real time systems kernel delays need to be bounded

Report Error

View answer Workspace Report Error Discuss

0 5001
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

7 4931
Q:

 If a table has been normalized so that all determinants are candidate keys, then that table is in:

A) 1NF B) 2NF
C) 3NF D) BCNF
 
Answer & Explanation Answer: D) BCNF

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 4917