Download App

Computer Science M.C.Q

Database Management – SQL · CBSE STD 12 Commerce (CBSE - English Medium). 10 questions.

Questions

M.C.Q

🎯

Test yourself on this topic

10 questions · timed · auto-graded

MCQ 11 Mark
A Table customer contains 5 rows and 7 columns. What will be its cardinality and degree?
  • ✓
    Degree 7, Cardinality 5.
  • B
    Degree 5, Cardinality 7.
  • C
    Degree 5, Cardinality 7.
  • D
    Cardinality 7, Degree 7.
Answer
Correct option: A.
Degree 7, Cardinality 5.
A
View full question & answer→
MCQ 21 Mark
Which clause is used to group the column(s) with aggregate function?
  • A
    Order by
  • B
    Like
  • C
    Where
  • ✓
    Group by
Answer
Correct option: D.
Group by
D
View full question & answer→
MCQ 31 Mark
Number of rows in a relation is known as
  • A
    Degree
  • ✓
    Cardinality
  • C
    Cartesian Product
  • D
    Attribute
Answer
Correct option: B.
Cardinality
B
View full question & answer→
MCQ 41 Mark
Which command is used to modify rows in a table.
  • A
    Delete
  • ✓
    Update
  • C
    Alter
  • D
    Modify
Answer
Correct option: B.
Update
B
View full question & answer→
MCQ 51 Mark
Which command is used to close the MySQL Software/application?
  • ✓
    exit();
  • B
    Close();
  • C
    Close;
  • D
    exit;
Answer
Correct option: A.
exit();
A
View full question & answer→
MCQ 81 Mark
Command to remove the row(s) from table student is
  • A
    drop table student;
  • B
    drop from student;
  • C
    remove from student;
  • ✓
    delete from student;
Answer
Correct option: D.
delete from student;
View full question & answer→
Generate Paper FreeAll Database Management – SQL topics
M.C.Q - Computer Science STD 12 Commerce Questions - Vidyadip