Download App

Computer Science M.C.Q

Database Query Using–SQL · CBSE STD 12 Science (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
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
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 61 Mark
Which is not a category of $\text{SQL}$ command?
  • A
    $\text{DDL}$
  • ✓
    $\text{XML}$
  • C
    $\text{DML}$
  • D
    $\text{TCL}$
Answer
Correct option: B.
$\text{XML}$
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 Query Using–SQL topics
M.C.Q - Computer Science STD 12 Science Questions - Vidyadip