NULL is | EXAMIANS

Introduction to SQL
NULL is

the same as blank for character

the same as 0 for integer

not a value

the same as 0 for integer and blank for character

the same as blank for character

the same as 0 for integer

not a value

the same as 0 for integer and blank for character

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?

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

None of these

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

Both A and B

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

None of these

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

Both A and B

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following is the original purpose of SQL?

All of these

To specify the syntax and semantics of SQL manipulation language

To specify the syntax and semantics of SQL data definition language

To define the data structures

All of these

To specify the syntax and semantics of SQL manipulation language

To specify the syntax and semantics of SQL data definition language

To define the data structures

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the cities whose humidity is 89

SELECT humidity = 89 FROM weather;

SELECT city WHERE humidity = 89;

SELECT city FROM weather WHERE humidity = 89;

SELECT city FROM weather;

SELECT humidity = 89 FROM weather;

SELECT city WHERE humidity = 89;

SELECT city FROM weather WHERE humidity = 89;

SELECT city FROM weather;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL NULL is

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 Which of the following is the original purpose of SQL?

Introduction to SQL Find all the cities whose humidity is 89

Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

Introduction to SQL
NULL is

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
Which of the following is the original purpose of SQL?

Introduction to SQL
Find all the cities whose humidity is 89

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Introduction to SQL
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.