Which of the following is valid SQL for an Index?

Introduction to SQL
Which of the following is valid SQL for an Index?

REMOVE INDEX ID;

ADD INDEX ID;

CREATE INDEX ID;

CHANGE INDEX ID;

REMOVE INDEX ID;

ADD INDEX ID;

CREATE INDEX ID;

CHANGE INDEX ID;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The command to remove rows from a table 'CUSTOMER' is:

REMOVE FROM CUSTOMER ...

DROP FROM CUSTOMER ...

UPDATE FROM CUSTOMER ...

DELETE FROM CUSTOMER WHERE ...

REMOVE FROM CUSTOMER ...

DROP FROM CUSTOMER ...

UPDATE FROM CUSTOMER ...

DELETE FROM CUSTOMER WHERE ...

ANSWER DOWNLOAD EXAMIANS APP

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

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 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' AND 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' AND condition = 'cloudy' AND temperature > 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' AND temperature > 70;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
SQL data definition commands make up a(n) ________ .

DDL

DML

XML

HTML

DDL

DML

XML

HTML

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints

10

5

0

9

10

5

0

9

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Indexes may be created or dropped at any time.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL Which of the following is valid SQL for an Index?

Introduction to SQL The command to remove rows from a table 'CUSTOMER' is:

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

Introduction to SQL SQL data definition commands make up a(n) ________ .

Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints

Introduction to SQL Indexes may be created or dropped at any time.

Introduction to SQL
Which of the following is valid SQL for an Index?

Introduction to SQL
The command to remove rows from a table 'CUSTOMER' is:

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

Introduction to SQL
SQL data definition commands make up a(n) ________ .

Introduction to SQL
Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints

Introduction to SQL
Indexes may be created or dropped at any time.