DBMS external LAB VIVA VOCE

The command which changes the structure of a table is _____________________

DDL means

DML

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

• SELECT * FROM Persons WHERE FirstName<>'Peter'

• SELECT * FROM Persons WHERE FirstName LIKE 'Peter'

• SELECT * FROM Persons WHERE FirstName='Peter'

• SELECT [all] FROM Persons WHERE FirstName='Peter'

Which of the following is not a valid SQL type?

• DECIMAL

• NUMERIC

• FLOAT

• CHARACTER

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

• SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

• SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

• SELECT [all] FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

• SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

• True

• False

Which of the following is NOT a type of SQL constraint?

• Primary Key
• Foreign Key
• Alternate Key
• Unique
• NOT NULL

6. ___________ which helps to uniquely identify a record.

• Primary key Constraint

• Unique Constraint

• Default constraint

• Check constraint

1.Which Command is used to remove the table named Book from the Database.

• a) ALTER TABLE Remove Book;

• b) REMOVE TABLE BOOK;

• c) ALTER TABLE BOOK DROP BOOK;

• d) DROP TABLE BOOK;