Scribd
Upload
6 views2 pages

RDBMS ACID Properties Explained

The document outlines the details for the Continuous Internal Assessment Test 2 for the M.Sc. (CS) 2nd Semester, scheduled for April 23, 2025. It includes the course code, title, total marks, and a list of multiple-choice questions related to Advanced RDBMS and PL/SQL, each carrying 2 marks. The questions cover topics such as RDBMS definitions, ACID properties, PL/SQL commands, and ER diagram representations.

Uploaded by

sandeep rangari
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views2 pages

RDBMS ACID Properties Explained

The document outlines the details for the Continuous Internal Assessment Test 2 for the M.Sc. (CS) 2nd Semester, scheduled for April 23, 2025. It includes the course code, title, total marks, and a list of multiple-choice questions related to Advanced RDBMS and PL/SQL, each carrying 2 marks. The questions cover topics such as RDBMS definitions, ACID properties, PL/SQL commands, and ER diagram representations.

Uploaded by

sandeep rangari
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

[Link].

(CS) 2nd Semester (Session 2024-25)

Continuous Internal Assessment (CIA) Test 2

Date of Examination 23/04/2025


Course Code MSc(CS)206
Course Title Advanced RDBMS and PL/SQL
Total Marks 20
Name/Signature of Student

Note: Each Question Carry 2 marks.

1. Which of the following is the full form of RDBMS?


a) Relational Data Management System b) Relational Database Management System
c) Relative Database Management System d) Regional Data Management System
2. Does RDBMS have ACID properties?
a) Follows ACID properties b) Doesn’t follow ACID properties
c) Depends on the data stored in the database d) Can’t say
3. Which of the following systems use RDMS?
a) Oracle b) Microsoft SQL Server c) IBM d) All of the mentioned
4. Which of the following constraints RDBS doesn’t check before creating the tables?
a) Not null b) Primary keys c) Data Structure d) Data integrity
5. Which of the following commands do we use to delete a relation (RDBMS) from a database?
a) delete table RDBMS b) drop table RDBMS
c) delete from RDBMS d) drop relation RDBMS
6. Which of the following pair of block structures is mandatory to include in a PL/SQL block?
a) BEGIN, END b) DECLARE, END
c) EXCEPTIONS, BEGIN d) EXCEPTIONS, END
7. What do double diamonds represent in an ER diagram?
a) They link entity sets to relationship sets b) Total participation of an entity in a relationship set
c) Relationship sets linked to weak entity sets d) None of the mentioned
8. Which of the following command is used to direct the PL/SQL output to a screen?
a) dbms_output.line b) dbms_output.put c) dbms_output.put_line d) utl_file.put_line
9. The dependency rules specified by the database designer are known as ?
a) Functional dependencies b) Designer dependencies c) Database rules d) None of the mentioned
10. What is unique role assumption?
a) The attribute name has a unique meaning in the database
b) The attributes are all unique
c) No two tuples have even a single same value in a relation
d) None of the mentioned

You might also like