DBMS SQL

Which statement allows us to add a record to a table?

• Add To

• Update To

• Add Into

• Insert Into

Where does the CREATE Command belong?

• DML

• DDL

• DCL

select all DDL commands are:-

• UPDATE

• ALTER

• DROP

• DELETE

In existing table, ALTER TABLE statement is used to

• Add columns

• Add constraints

• Delete columns

• Delete constrains

• All the above

Correct syntax query syntax to drop a column from a table is

• DELETE COLUMN column_name;

• DROP COLUMN column_name;

• ALTER TABLE table_name DROP COLUMN column_name;

• None is correct.

Which SQL statement would add a record to the database?

• INSERT INTO Designer VALUES ('SMI01', 'M Smith', '[e-mail]', '01224123456')

• INSERT VALUES ('SMI01', 'M Smith', '[e-mail]', 01224123456') INTO Designer

• INSERT ('SMI01', 'M Smith', '[e-mail]', '01224123456') INTO Designer

• INSERT Designer INTO VALUES (''SMI01', 'M Smith', '[e-mail]', '01224123456')

This symbol is an SQL wildcard that can substitute for one or more characters when searching for data in a database.

• $

• %

• =

• *

You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

• UPDATE Designer SET PhoneNo = '01224123456'

• UPDATE Designer (PhoneNo) VALUES ('01224123456')

• UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'

• UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

• ASC

• DESC

• There is no default value

• None of the mentioned

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

• SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70

• SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70

• SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

• SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70