English

code snippet. CREATE TABLE student( name CHAR(30) student_id INT, gender CHAR(1), PRIMARY KEY (student_id) ); What will be the degree of student table?

Advertisements
Advertisements

Question

Choose the appropriate answer with respect to the following code snippet.

code snippet.
CREATE TABLE student(
name CHAR(30)
student_id INT,
gender CHAR(1),
PRIMARY KEY (student_id)
);

What will be the degree of student table?

Options

  • 30

  • 1

  • 3

  • 4

MCQ
Advertisements

Solution

3

Explanation:

The student table has 3 columns (attributes):

  • name
  • student_id
  • gender

Therefore, the degree = 3.

shaalaa.com
  Is there an error in this question or solution?
Chapter 8: Introduction to Structured Query Language (SQL) - Exercise [Page 170]

APPEARS IN

NCERT Informatics Practices [English] Class 11
Chapter 8 Introduction to Structured Query Language (SQL)
Exercise | Q 2. a) | Page 170
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×