Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/20
Score 0
1. Which one of the following is NOT a part of the ACID properties of database transactions?
30
Isolation
Atomicity
Deadlock freedom
Consistency
Q 2/20
Score 0
2. The term _______ is used to refer to a row.
30
Field
Tuple
Attribute
Instance
20 questions
Q.
1. Which one of the following is NOT a part of the ACID properties of database transactions?
1
30 sec
Q.
2. The term _______ is used to refer to a row.
2
30 sec
Q.
3. Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________
3
30 sec
Q.
4. Student(ID, name, dept name, tot_cred) In this query which attributes form the primary key?
4
30 sec
Q.
5. Tables in second normal form (2NF):
5
30 sec
Q.
6. What are the desirable properties of a decomposition
6
30 sec
Q.
7. We can use the following three rules to find logically implied functional dependencies. This collection of rules is called
7
30 sec
Q.
8. The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
8
30 sec
Q.
9. Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
9
30 sec
Q.
10. In E-R Diagram, attribute is represented by
10
30 sec
Q.
11. Which of the following makes the transaction permanent in the database?
11
30 sec
Q.
12. Consider the following action:
TRANSACTION.....
Commit;
ROLLBACK;
What does Rollback do?
12
30 sec
Q.
13. . The union operation is represented by
13
30 sec
Q.
14. In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy?
14
30 sec
Q.
15. What are the ways of dealing with deadlock?
15
30 sec
Q.
16. . When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj). Otherwise, Ti is rolled back (dies). This is
16
30 sec
Q.
17. A deadlock exists in the system if and only if the wait-for graph contains a ___________
17
30 sec
Q.
18. Which of the following is not a state in transaction?
18
30 sec
Q.
19. The ________________ is essentially used to search for patterns in target string.
19
30 sec
Q.
20. The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is
