Skip to content
Worked Examples · Example 8.1

Q.Create table STUDENT.

Yanam BieapTextbookSubjective· 2mImportance★★★★★
2% · 1/45 Questions
🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

CREATE TABLE STUDENT with the book's own real columns: RollNumber, SName, SDateofBirth, GUID.

CREATE TABLE STUDENT(
    RollNumber INT,
    SName VARCHAR(20),
    SDateofBirth DATE,
    GUID CHAR(12),
    PRIMARY KEY (RollNumber));

Output:

Query OK, 0 rows affected (0.91 sec) …

Unlock everything free for 14 days

  • Full step-by-step solutions
  • Concept-first explanations
  • Methods, shortcuts & mistakes
  • PYQ mapping + timed mock tests

Full access for 14 days. No credit card required.