Which of the following do you need to consider when you make a table in SQL?-A-Data typesB-Primary keysC-Default valuesD-All of the above.-D-All of the above.

Question

APTITUDE CRACK · Accepted Answer

The correct option is  D All of the above. Because if there null values. When calculating the column values. If there is null then the total will be &#39;0&#39;. (anything + null = 0). If we use default value &#39;0&#39; at integer column. If we not specified the value then the 0 will be inserted in that column. Then the total result will be correct. And also for char column it changes default. That if we don&#39;t know a person name. Instead of leaving it null. If we put default as &#39;not specified&#39; then &#39;not specified&#39; will be inserted in column. And so on.

Introduction to SQL

Q1: Which of the following do you need to consider when you make a table in SQL?

For help Students Orientation
Mcqs Questions

Quick Links

Newsletter

Introduction to SQL

Q1: Which of the following do you need to consider when you make a table in SQL?

Solution

For help Students Orientation Mcqs Questions

For help Students Orientation
Mcqs Questions