In SQL, which command(s) is(are) used to change a table's storage characteristics?

Introduction to SQL
In SQL, which command(s) is(are) used to change a table's storage characteristics?

ALTER TABLE

MODIFY TABLE

All of these

CHANGE TABLE

ALTER TABLE

MODIFY TABLE

All of these

CHANGE TABLE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following is a SQL aggregate function?

AVG

LEFT

JOIN

LEN

AVG

LEFT

JOIN

LEN

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.

A view is a database diagram.

None of these

A view is a special stored procedure executed when certain event occurs.

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.

A view is a database diagram.

None of these

A view is a special stored procedure executed when certain event occurs.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is the meaning of LIKE '%0%0%'

Feature ends with two 0's

Feature begins with two 0's

Feature has two 0's in it, at any position

Feature has more than two 0's

Feature ends with two 0's

Feature begins with two 0's

Feature has two 0's in it, at any position

Feature has more than two 0's

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

None of these

Both A and B

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

SELECT name FROM staffinfo WHERE salary IN (10000, 25000);

None of these

Both A and B

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

SELECT name FROM staffinfo WHERE salary IN (10000, 25000);

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the name of cities with all entries whose temperature is in the range of 71 and 89

SELECT * FROM weather WHERE temperature NOT IN (71 to 89);

SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;

SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

SELECT * FROM weather WHERE temperature NOT IN (71 and 89);

SELECT * FROM weather WHERE temperature NOT IN (71 to 89);

SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;

SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

SELECT * FROM weather WHERE temperature NOT IN (71 and 89);

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics?

Introduction to SQL Which of the following is a SQL aggregate function?

Introduction to SQL What is a view?

Introduction to SQL What is the meaning of LIKE '%0%0%'

Introduction to SQL Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

Introduction to SQL Find the name of cities with all entries whose temperature is in the range of 71 and 89

Introduction to SQL
In SQL, which command(s) is(are) used to change a table's storage characteristics?

Introduction to SQL
Which of the following is a SQL aggregate function?

Introduction to SQL
What is a view?

Introduction to SQL
What is the meaning of LIKE '%0%0%'

Introduction to SQL
Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

Introduction to SQL
Find the name of cities with all entries whose temperature is in the range of 71 and 89