
DBMS CA-1
Quiz by Yashaswini B M
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
- 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
- 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