Software safety is an activity that focuses on the identification and assessment of potential hazards that may affect software negatively and cause an entire system to fail.
| A. | Risk mitigation, monitoring and management |
| B. | Software quality assurance |
| C. | Software cost estimation |
| D. | Defect remdval efficiency |
|
Option: B Explanation : Click on Discuss to view users comments. |
The "PROJECT' operator of a relational algebra creates a new table that has always
| A. | More columns than columns in original table . |
| B. | More rows than original table |
| C. | Same number of rows as the original table |
| D. | Same number of columns as the original table |
|
Option: C Explanation : Click on Discuss to view users comments. |
The employee information of an Organization is stored in the relation : Employee (name, sex, salary, deptname)
Consider the following SQL query
Select deptname from Employee Where sex = 'M' group by deptname having avg (salary) > (select avg (salary) from Employee)
Output of the given query corresponds to
| A. | Average salary of employee more than average salary of the organization. |
| B. | Average salary less than average salary of the organization. |
| C. | Average salary of employee equal to average salary of the organization. |
| D. | Average salary of male employees in a department is more than average salary of the organization. |
|
Option: D Explanation : Click on Discuss to view users comments. |
For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency
a → c
b → d
holds in the following relation
| A. | In 1NF not in 2NF |
| B. | In 2NF not in 3NF |
| C. | In 3NF |
| D. | In 1NF |
|
Option: C Explanation :
1NF reference to the concept of 'atomicity' atomic value as one that "cannot be decomposed into smaller pieces by the DBMS (excluding certain special functions)." Meaning a field should not be divided into parts with more than one kind of data in it such that what one part means to the DBMS depends on another part of the same field. and we know that a ->b means b depends on a so according to question there partial dependency is given which we can not see in 1NF and 2NF so this is 3NF. So answer is (C)
This relation is in 3NF as we dont see any partial dependency (2NF) or transitive dependency (3NF) Click on Discuss to view users comments. HARI BABU V said: (7:13pm on Wednesday 4th September 2013)
here key is ab.partial dependency.so answer is A.
monalisa said: (10:20pm on Wednesday 4th December 2013)
but in ans key it is given D
|
| A. | iv i ii iii |
| B. | iii iv i ii |
| C. | iii i iv ii |
| D. | iii ii iv i |
|
Option: D Explanation :
Right Answer is
a b c d ii iii iv i
Right order is not given in options
For reference Click Here
Click on Discuss to view users comments. |
This section provides solution for UGC NET Computer Science Solved Papers June 2013. This can also be used as UGC NET June 2013 Answer Keys for Computer Science Exams. You can download UGC NET free answer keys from this section. Any candidate who is preparing for UGC NET Computer Science Exam should revise UGC NET Computer Science Solved Question Papers before appearing for final exams.
