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

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 > ANY (SELECT SALARY FROM EMPLOYEE);prints

5

10

9

0

5

10

9

0

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
ORDER BY can be combined with the SELECT statements.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

A view is a database diagram.

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 special stored procedure executed when certain event occurs.

None of these

A view is a database diagram.

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 special stored procedure executed when certain event occurs.

None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following SQL commands is used to retrieve data?

JOIN

SELECT

INSERT

DELETE

JOIN

SELECT

INSERT

DELETE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green')

Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats

Find the sailor IDs of at least one sailor who have reserved red boats but not green boats

Find the sailor IDs of all sailors who have reserved red boats but not green boats

None of These

Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats

Find the sailor IDs of at least one sailor who have reserved red boats but not green boats

Find the sailor IDs of all sailors who have reserved red boats but not green boats

None of These

ANSWER DOWNLOAD EXAMIANS APP

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

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

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 > ANY (SELECT SALARY FROM EMPLOYEE);prints

Introduction to SQL ORDER BY can be combined with the SELECT statements.

Introduction to SQL What is a view?

Introduction to SQL Which of the following SQL commands is used to retrieve data?

Introduction to SQL What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green')

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

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 > ANY (SELECT SALARY FROM EMPLOYEE);prints

Introduction to SQL
ORDER BY can be combined with the SELECT statements.

Introduction to SQL
What is a view?

Introduction to SQL
Which of the following SQL commands is used to retrieve data?

Introduction to SQL
What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green')

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