Let us say that we have a Student Database in which we have the detail

1.	Let us say that we have a Student Database in which we have the details of the students like their names, address, attendance percentage, etc. Now we run an SQL Query that says: SELECT AVG ATTENDANCE FROM STUDENTS.
Answer» Can you tell me any issues that may be here? Yes, there might be an ISSUE. For instance, if there is such a case where we have set that the ATTENDANCE of any student cannot be NULL and at the same time we have some students in the table whose attendance we don’t know, the AVG FUNCTION will calculate these students as well. Hence, we will get an answer but, it might not be correct.

Let us say that we have a Student Database in which we have the details of the students like their names, address, attendance percentage, etc. Now we run an SQL Query that says: SELECT AVG ATTENDANCE FROM STUDENTS.

Answer»

Can you tell me any issues that may be here?

Yes, there might be an ISSUE. For instance, if there is such a case where we have set that the ATTENDANCE of any student cannot be NULL and at the same time we have some students in the table whose attendance we don’t know, the AVG FUNCTION will calculate these students as well. Hence, we will get an answer but, it might not be correct.

Discussion

No Comment Found

Related InterviewSolutions

How will you achieve record level locking in DB2 versions where record level locking is not allowed?
What is DSNDB07? What does it do?
Is there any specific reason why SELECT is not preferred in embedded SQL programs?
What is the RUN STATS that was mentioned in the previous answer?
Let us say that I have a program it uses dynamic SQL. It has been working fine till now, however, lately, I have found that the performance has been affected and deteriorated. Can you guess what can be the reason behind this?
What are SPUFI and QMF? What is the difference between them?
In a COBOL-DB2 program, where are all the SQL statements coded?
What are ACQUIRE and RELEASE in BIND?
Let us say that we have a Student Database in which we have the details of the students like their names, address, attendance percentage, etc. Now we run an SQL Query that says: SELECT AVG ATTENDANCE FROM STUDENTS.
Is it possible for you to alter the table (adding a column to it) while some other person is accessing the table and even updating some values in it?

Let us say that we have a Student Database in which we have the details of the students like their names, address, attendance percentage, etc. Now we run an SQL Query that says: SELECT AVG ATTENDANCE FROM STUDENTS.

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment