MySQL String Functions

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.

SELECT LENGTH(‘I am with you‘);


Output is?

2.

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


3.

UPDATE COMMAND USED FOR?


4.

CREATE command used for?


5.

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


6.

Following command used in MySQL for ______________.


INSERT INTO STUDENT1

SELECT * FROM STUDENT2

WHERE ID>1006;

7.

Which is the MySQL instance responsible for data processing?


8.

How to modifying data of a table?


9.

What is Degree in relational database?


10.

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


11.

Correct way to get the current date?


12.

Fill the blanks with suitable options? BETWEEN ______ AND ______


13.

What statement use for change the table name?


14.

Attributes is also known as _________.


15.

SELECT id, name, fee+100 FROM STUDENTS;


the syntax of the command is?

16.

SELECT RIGHT(‘JOIN ARMY‘ , 5);


output is?

17.

Full form of RDBMS?


18.

__________clause is used to “Filters out unwanted data”


19.

What represents a ‘tuple’ in a relational database?


20.

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


Output is?

21.

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


22.

MySQL is freely available and is open source.


23.

What command used for add integrity constraints in existing table?


24.

___________ is the synonym of DATABASE.


25.

what command used for view the structure of a table?


26. <h4><span id="lblQuestion" class="question">DISTINCT command be used for more than one column?</span></h4>

27.

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


28.

SQL Stand for?


29.

What does ‘address’ represent in the following code snippet?


CREATE TABLE students
(
id integer,
name CHAR(20),
dob date,
address CHAR(30),
mobile bigint
);

30.

DISTINCT command be used for more than one column?


31.

The name of Chief Inventor of MySQL?


32.

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


output of the following command is?

33.

Output of the Following command –


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

34.

Change the column name of a table using_________ command.


35.

Can you define multiple PRIMARY KEY in a table?


36.

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?


37.

______ not a numeric datatype.


38.

Drop command used for?


39.

Which SQL statement is used to return only different values?


40.

DELETE command used for?




All the Best…




Leave a Reply

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