Quizalize logo
placeholder image to represent content

DBMS CA-1

Quiz by Yashaswini B M

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1

    If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default

    DESC

    There is no default value

    ASC

    None of the mentioned

    30s
  • Q2

     Which operator is used to compare the NULL values in SQL?

    Equal

    None of Above

    IN

    IS

    30s
  • Q3

    Which statement is used to get all data from the student table whose name starts with p?

    SELECT * FROM student WHERE name LIKE '_p%';

    SELECT * FROM student WHERE name LIKE 'p%';

    SELECT * FROM student WHERE name LIKE '%p';

    SELECT * FROM student WHERE name LIKE '%p%';

    30s
  • Q4

     Which of the following gives a logical structure of the database graphically?

     Entity-relationship diagram

     Architectural representation

    Database diagram

    Entity diagram

    30s
  • Q5

    Minimal Superkeys are called

    Domain keys

    Attribute keys

    Schema keys

    Candidate keys

    30s
  • Q6

    Which of the following in true regarding Referential Integrity?

    Every primary-key value must match a primary-key value in an associated table

    Every foreign-key value must match a primary-key value in an associated table

    Every foreign-key value must match a foreign-key value in an associated table

    Every primary-key value must match a foreign-key value in an associated table

    30s
  • Q7

    A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

    Primary

    Specific

    Referencing 

    Referential

    30s
  • Q8

    Which of the following can replace the below query?

    SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID;

    Select name,course_id from teaches,instructor where instructor_id=course_id;

    Select name, course_id from instructor;

    Select course_id from instructor join teaches;

    Select name, course_id from instructor natural join teaches;

    30s
  • Q9

    _______ produces the relation that has attributes of R1 and R2.

    Difference

    Intersection

    Cartesian product

    Product

    30s
  • Q10

    Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is:

     (m+n)/2

    mn

    2(m+n

    m+n

    30s

Teachers give this quiz to your class