SQL query and modification commands make up a(n) ________ .

Introduction to SQL
SQL query and modification commands make up a(n) ________ .

HTML

DML

XML

DDL

HTML

DML

XML

DDL

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

INSERT

MAKE

CREATE

ADD

INSERT

MAKE

CREATE

ADD

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

5

0

9

10

5

0

9

10

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

Data Manipulation Language(DML)

None

Data Definition Language(DDL)

Both of above

Data Manipulation Language(DML)

None

Data Definition Language(DDL)

Both of above

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
If a query involves NOT, AND, OR with no parenthesis

NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.

AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.

The order of occurrence determines the order of evaluation.

NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.

AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.

The order of occurrence determines the order of evaluation.

NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL SQL query and modification commands make up a(n) ________ .

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

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 Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

Introduction to SQL If a query involves NOT, AND, OR with no parenthesis

Introduction to SQL
SQL query and modification commands make up a(n) ________ .

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

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
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

Introduction to SQL
If a query involves NOT, AND, OR with no parenthesis