True

False

Correct Answer: False

The ‘SPATIAL’ indexes can be created on ‘NOT NULL’ spatial columns. Therefore, if it is planned to index the column, it would need to be declared as NOT NULL. This type can be used in many ways.

Point out the error (if any) in the following C code?

#include <stdlib.h>#include <stdio.h>int main(void){ int* p = NULL; struct S *s = NULL; void(*f)(int, double) = NULL; char *ptr = malloc(15); if (ptr == NULL) printf("Out of memory"); free(ptr);}

Error in the statement: void(*f)(int, double) = NULL;

Error in the statement: char *ptr = malloc(15);

Error in the statement: struct S*s = NULL;

No error

In SQL, Indexes can also be used on the columns containing null values.

True

False

For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is __________

For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is . . . . . . . .

What one of the following is best practice to handle Null Pointer exception?
i) int noOfStudents = line.listStudents().count;
ii) int noOfStudents = getCountOfStudents(line);

public int getCountOfStudents(List line){if(line != null) {if(line.listOfStudents() != null) { return line.listOfStudents().size();}}throw new NullPointerException("List is empty");}

Option (i)

Option (ii)

Compilation Error

Option (ii) gives incorrect result