 Hello friends, welcome to SS Unitech. My name is Susheel Singh and this is Seco Server interview quiz part 4 test yourself. So here we have 10 questions and each question has four options and you will get 45 seconds to select the correct option. So before going forward, if you haven't watched part 10 of Seco Server interview questions and answers video series, so I would strongly recommend to watch that video where you can understand how we can apply joints and how many number of rows will be written and this is the link and this link will be available on the description of this video. So you can go and watch that video. So let's start with our first question. This is our question and your time starts now. So time up. Option A is true because two null values are treated as different values in Seco Server. So let's move to another question. This is our question and your time starts now. So time up. Option A is true because when null values are used in aggregate functions like sum, count, average, then null values would be skipped. So option A is true. Let's move to another question. This is your question and your time starts now. So time up. Option C is true. Here we are using self join and again two null values are treated as a different values. So option C is true. Let's move to another question. So this is your question and your time starts now. So time up. Option C is true. Here again we are using self join and null values is skipped when we used inside the aggregate functions. So option C is true. Let's move to another question. This is your question and your time starts now. So time up. Option D is true. So here we are using the right join so it will pick all the data from right table and we can count it would be four. So option D is true. Let's move to another question. This is your question and your time starts now. So time up. Option D is true. It's a cross join. So all rows will become from left table. It will combine from right table. So we have four rows in our left table and again we have four rows in our right table. So we can multiply between four and four and we can get 16. So output would be 16. So option D is true. Let's move to another question. This is your question and your time starts now. So time up. Option B is true because again two null values are treated as a different values. So let's move to another question. This is your question and your time starts now. So time up. Option A is true because we cannot use on operator with cross join. So option A is true. Let's move to another question. So this is your question and your time starts now. So option B is true because when we take any column in count then it looks for null values. Else it returns all the rows. Doesn't matter it has null values or not. So option B is true. I hope you enjoyed this quiz. Please leave your score on comment box. If you like this video please subscribe our channel to get many more videos like this. Thank you so much for watching.