Page 1 :
Assignment no.4, Class 12, , Question 1., Write two examples of DML commands to SQL. (All India 2014C), Question 2., When using the LIKE clause, which wildcard symbol represents any sequence of none, one, or more characters? (All India 2014c), Question 3., Write the UPDATE statement in MySQL to increase commission by 100.00 in the, “Commission” column in the ‘EMP’ table. (All India 2014C), Question 4., Rewrite the following SQL statement after correcting the error(s). Underline the corrections, made. (All India 2014C), Question 5., What happens when auto-commit is set on? (Delhi 2014), Question 6., Table ‘CLUB’ has 4 rows and 3 columns. Table ‘MEMBER’ has 2 rows and 5 columns. What, will be the cardinality of the Cartesian product of them? (Delhi 2014), Question 7., Distinguish between ALTER TABLE and UPDATE commands of MySQL. (All India 2014), Question 8., Mention two categories in which MySQL commands are broadly classified. (All India 2014), Question 9., Give two characteristics of Primary Key. (All India 2014), Question 10., Write two examples of DBMS software. (Delhi 2014), Question 11., Write SQL command to create a SAVEPOINT called All (Delhi 2013), Question 12., Define a foreign key with reference to RDBMS. (Delhi 2013), Question 13., Write the command to display the list of existing databases. (Delhi 2012), Question 14., Mr. William wants to remove all the rows from INVENTORY table to release the storage, space, but he does not want to remove the structure of the table. What MySQL statement, should be used? (Delhi 2012), Question 15., Write MySQL command to open an existing database. (All India 2012)