Database Transactions

Transactions Terms

Introducation – 

Concept of Database Transaction –

Transaction Execution –

System View of Transaction – 

Rollback Operation

Commit Operation

Transaction Handling Issues

Transaction Properties (ACID Properties)

1. AUTOMICITY

2. CONSISTENCY

3. ISOLATION

4. DURABILITY

Transaction Control Command

 BEGIN or BEGIN WORK or START TRANSACTION

COMMIT or COMMIT WORK (WORK keyword is optional)

ROLLBACK or ROLLBACK WORK (WORK keyword is optional)

SAVEPOINT

SET AUTOCOMMIT

 

Create table – 

(With INTEGRITY CONSTRAINTS)

 CREATE TABLE Students

 (

    S_ID integer PRIMARY KEY,

    NAME char(30) NOT NULL,

    GENDER enum(‘M’, ‘F’, ‘O’),

    SUBJECT enum(‘MATH’, ‘COMMERCE’, ‘BIOLOGY’ ,’ART’),

    CLASS char(4),

    SECTION enum(‘A’, ‘B’, ‘C’, ‘Z’),

    BIRTH_DATE date,

    School_Name varchar(40) DEFAULT ‘KV HARDA’,

    CHECK (ID>1000)

 );

 

Welcome to your MySQL Quiz

Name
1.

Can you define multiple PRIMARY KEY in a table?


2.

The name of Chief Inventor of MySQL?


3.

Following command used in MySQL for ______________.


INSERT INTO STUDENT1

SELECT * FROM STUDENT2

WHERE ID>1006;

4.

DISTINCT command be used for more than one column?


5.

Fill the blanks with suitable options? BETWEEN ______ AND ______


6.

How do you select all the columns from a table named “Persons”?


7.

SELECT LCASE(‘My Name is Pranjali’);


Following Command output is?

8.

Which one is not a logical operator in MySQL?


9.

What is Cardinality?


10.

Attributes is also known as _________.


11.

SQL Stand for?


12.

what command used for view the structure of a table?


13.

___________ is the synonym of DATABASE.


14.

Which is the MySQL instance responsible for data processing?


15.

Correct way to get the current date?


16.

How do I find out all databases starting with ‘test‘?


17.

SELECT SUBSTR(‘VISHAL’, 2, 3);


Output is?

18.

SHOW TABLES command used for?


19.

DELETE command used for?


20.

Table ‘Students‘ have 20 records and Table ‘School‘ have 17 records.


SELECT * FROM STUDENTS, SCHOOL;


After the passing Query, how many record will show in the table?


21.

What command used for change the column property of the table?


22.

Output of the Following command –


Select CONCAT (‘Join’ , ‘Group’);

23.

Which statement is used to select a default database?


24.

Data Organized in a MySQL DBMS into__________.


25.

How to modifying data of a table?


26.

Which is the default order of sort in ORDER BY clause?


27.

What represents a ‘tuple’ in a relational database?


28.

Find the YEAR in “19201212202018” TIMESTAMP?


29.

__________ not an Integrity Constraints.


30.

SELECT LEFT(‘NEW/12/MySQL/18‘ , 5);


output of the following command is?

31.

__________ Key is used to link two tables in MySQL.


32.

__________clause is used to “Filters out unwanted data”


33.

UPDATE COMMAND USED FOR?


34.

What command used for add new column in the table of Database?


35.

________ keyword is used to sort the result-set IN MySQL.


36.

% (percent) or _ (underscore) sign used with ____________?


37.

______ not a numeric datatype.


38.

Drop command used for?


39. <h4><span id="lblQuestion" class="question">How do I find out all databases starting with ‘test‘?</span></h4>

40.

Change the column name of a table using_________ command.




All the Best…




Leave a Reply

Your email address will not be published. Required fields are marked *