sql queries

1.Write two examples of DML commands to SQL. (All India 2014C)

• Insert

• select

• create

• drop

When using the LIKE clause, which wildcard symbol represents any sequence of none, one or more characters? (All India 2014c)

Answer explanation

The % wildcard symbol is used in LIKE clause to represent any sequence of none, one or more characters.

Write the UPDATE statement in MySQL to increase commission by 100.00 in the “Commission” column in the ‘EMP’ table. (All India 2014C)

Answer explanation

UPDATE EmpSET Commission = Commission +100;

Rewrite the following SQL statement after correcting the error(s). Underline the corrections made. (All India 2014C)

INSERT IN STUDENT(RNO, MARKS)

VALUEC5, 78.5);

TCL Is a type of SQL commands stands for

• transfer control language

• transaction control language.

• transaction cardinal language

• type core language

An attribute in a relation is a foreign key if it is the ______ key in any other relation.

• (a) Candidate

• (b) Primary

• (c) Super

• (d) Sub

A ____ is a property of the entire relation, which ensures through its value that each tuple is unique in a relation.

• (a) Rows

• (b) Key

• (c) Attributes

• (d) Fields

Which of the following is not a legal sub-language of SQL ?

• (a) DDL

• (b) QAL

• (c) DML

• (d) TCL

. The___ clause of SELECT query allows us to select only those rows in the result that satisfy a specified condition.

• (a) where

• (b) from

• (c) having

• (d) like

Logical operator used in SQL are:

• (a) AND, OR, NOT

• (b) &&, ||, !

• (c) $,|,!

• (d) None of these