Explore topic-wise InterviewSolutions in .

TRIM() function.

NOW() returns a constant time that indicates the time at which the statement began to execute. (Within a stored function or trigger, NOW() returns the time at which the function or triggering statement began to execute.) This differs from the behavior for SYSDATE (), which returns the exact time at which it executes.

ALTER TABLE command is used to modify the structure of a table.

CREATE TABLE DEPARTMENT (DepartmentlD INT(4) PRIMARY KEY DepName VARCHAR(50) NOT NULL, ManagerlD CHAR(4), Location VARCHAR(30));

USE CONTACTS;

Yes, MySQL allow to change the primary key in all cases.

DROP TABLE BACKUP;

DESCRIBE Product (or) DESC Product

USE <database name>;

Alter table Hospital add Address Varchar(20);

Create Table Train

MetroID integer Primary Key,

Origin Varchar (50),

Destination Varchar (50),

Disiance Integer

CREATE TABLE Player(playerld integer PRIMARY KEY name varchar(S0), height integer, weight integer, datebirth date, teamname varchar(50));

Create Table Event (Eventld Varchar (5) Primary Key, EventName varchar (30), Not NULL;  Location Varchar (50), ClientlD Integer, EventDate Date).

USE Gadgets;

SHOW TABLES;

Create Table Song 

(Songid Int Primary Key, Title Varchar (50), Duration Int, ReleaseDate Date);

Create table Job

J_Code Integer(3) Primary Key,

J_Description Varchar(25) Not Null,

J_Chg_Hr Integer,

J_Lastupdate Date);

Create Table Bank_Customer (Acc_No Integer Primary key, Cust_Name Varchar(20) Not null, Cust_Add Varchar(20), Cust-City Varchar(20) );

(i) Code

(ii) Category

(iii) Cardinality : 4 Degree : 2

(iv) Category 77 is not present in Category table. R-eferential integrity doesn't exist.

(v) UPDATE CD SET Singer='Sonvi Mehra' where Singer like 'Sonvi kumar';

(vi) ALTER TABLE CD ADD COLUMN Music _Director Varchar(30);

(vii) SELECT CODE, TITLE, DESCRIPTION FROM CD, TYPE WHERE CD.CATEGORY = TYPE CATEGORY;

CREATE TABLE STOCK(Id Decimal(4) PRIMARY KEY, Name VARCHER(20), Company VARCHER(20), PRICE DECIMAL(8) NOT NULL);

CREATE TABLE SHOP(Fno int(10) Primary Key, Fname Varchar(15), Type Char(10), Stock int(3), Price decimal(8,2));

ALTER TABLE Student DROP Hobbies

CREATE TABLE SALESPERSON (SCODE Decimal( 6) Primary Key, FIRSTNAME,Varchar(30) NOTNULL, LASTNNAME Varchar(30) Not NULL, CITY Varchar(30), SALES Decimal(8));

CREATE TABLE BANK (Acct_Number INTEGER(4) PRIMARY KEY, Name VARCHAR(3), BirthDate DATE, Balance INTEGER(8) NOTNULL);

(i)

(ii) 

Update Book set Price = 200

where Title = 'Informatics made fun'.

SELECT DISTINCT  Location FROM Employee;

SELECT STOREID, SUM (SALESAMOUNT) FROM SALES WHERE STORE ID IN (25,40).

ALTER TABLE modify the existing table structure CREATE TABLE creates a new table.

SELECT ID, Salary FROM empsalary WHERE Salary is NOT NULL;

Select Department, MAX (Salary)

From Company

Group BY Department;

Alter,Table Student Add,(Game-played VAR, CHAR(30));

(i) Select Name From Friends Where Country Not Like "lndra";

(ii) Select Name, City, Country From Friends Order By Age Desc;

(iii) Select Count(*) From Friends Where Email_id like "% gmail%";

(iv) Select Name, City,  From Friends Where Email_id is null;

                          OUTPUT

(vi)

(vii)

DELETE FROM Emp where First Name  = "Rama"

UPDATE Emp SET Commission = Commission + 100.00.

Group A (i) (iii)

Group B (ii) (iv)

(i) avg(Salary) 5300.0000

(ii) Salary+100 NULL

SELECT Name Class FROM Students where Course_name IS NULL OR Course_name LIKE '%economics';

INSERT and UPDATE

3 Employee;

1 Commission Employee;

SELECT * FROM STUDENTS ORDER BY AGGREGATE, NAME DESC;

(i) Select * From Sports Where Game like 'Badminton'.

(ii) Select Name from Sports where Gender =  'F' and Game = 'Lawn Tennis'.

(iii) Select Name, Game, Fee From Sports Order By Fee.

(iv) Select Game, Count (Studentld) from Group By Game.

(v)

(vi)   Name                        DateAdmit

       Tripti Saluja                 2015-08-15

SELECT * FROM Class WHERE Grade IS NULL; 

(i) Update PharmaDB set Price = price+50 Where DrugName = "Amlodipine";

(ii) Select * From PharmaDB where price between 100 and 150;

(iii) Select Max(Price) from pharmaDB where Pharmacylocation like  "% Gurgaon %" ;

(iv) Select Drug ID, DrugName, pharmacyName from PharmaDB order by price desc;

(i) SELECT GName FROM Garment Where Size='XL'

(ii) SELECT Gcode, Gname FROM Garment- WHERE Name LIKE "Ladies%";

(ii) SELECT Gcode, Gname, Price FROM Garment WHERE Price BETWEEN 1000 and 1500;

(iv) UPDATE Garment SET Colour ='Orange' WHERE Gcode=116;

(v) 3

(vi) 1800

(vii) Jeans

(i) Select Name From Friends Where Country Not Like "lndra";

(ii) Select Name, City, Country From Friends Order By Age Desc;

(iii) Select Count(*) From Friends Where Email_id like "% gmail%";

(iv) Select Name, City,  From Friends Where Email_id is null;

                          OUTPUT

(vi)

(vii)

INSERT INTO STUDENT(RNO, MARKS) VALUES (5,78.5);

(i) SELECT * FROM FLIGHT WHERE START = 'Delhi'

(ii) SELECT * FROM FLIGHT WHERE NO _FLIGHTS > 4

(iii) SELECT FLCODE, START, DESTINATION, NO-FLIGHTS FROM FLIGHT ORDER BY NO-FLIGHTS DESC

(iv) SELECT DESTINATION, FLCODE FROM FLIGHT WHERE DESTINATION LIKE "A%";

(v) MAX(No_FLIGHTS)

7

(vi) DISTINCT(NO_STOPS)

0

1

2

3

(vii) DELHI 3 MUMBAI 2 KANPUR 1 INDORE 1

(i) Select Name, Location, City, SalesAmount From Store Order By SalesAmount desc.

(ii) select Name, salesAmount From store where Name like '% fashion%'

(iii) Select Name, Location, Date Opened From Store Where Date Opened <'2015 -03 - 01'

(iv) Select SVM (SalesAmount), City from store group by City'

(v) distinct (CitY) Delhi Mumbai

(vi) Name, length (name) left (name, 3) No. output