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?

MODIFY TABLE

All of these

ALTER TABLE

CHANGE TABLE

MODIFY TABLE

All of these

ALTER TABLE

CHANGE TABLE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
You can add a row using SQL in a database with which of the following?

INSERT

MAKE

ADD

CREATE

INSERT

MAKE

ADD

CREATE

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

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

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

Both A and B

None of these

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

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

Both A and B

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

None of these

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.

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

None of these

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.

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A dynamic view is one whose contents materialize when referenced.

False

True

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 You can add a row using SQL in a database with which of the following?

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 What is a view?

Introduction to SQL The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

Introduction to SQL A dynamic view is one whose contents materialize when referenced.

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

Introduction to SQL
You can add a row using SQL in a database with which of the following?

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
What is a view?

Introduction to SQL
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

Introduction to SQL
A dynamic view is one whose contents materialize when referenced.