Which of the following is the original purpose of SQL?

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

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

All of these

To specify the syntax and semantics of SQL manipulation language

To specify the syntax and semantics of SQL data definition language

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following must be enclosed in double quotes?

All of these

Dates

Column Alias

Strings

All of these

Dates

Column Alias

Strings

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Select the right statement to insert values to the student table.

INSERT VALUES (

INSERT VALUES INTO student (

INSERT student VALUES (

INSERT INTO student VALUES (

INSERT VALUES (

INSERT VALUES INTO student (

INSERT student VALUES (

INSERT INTO student VALUES (

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The command to eliminate a table from a database is:

DELETE TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

REMOVE TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

REMOVE TABLE CUSTOMER;

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.

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.

None of these

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 all sailors 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

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 all sailors 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

None of These

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

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

Introduction to SQL Which of the following must be enclosed in double quotes?

Introduction to SQL Select the right statement to insert values to the student table.

Introduction to SQL The command to eliminate a table from a database is:

Introduction to SQL What is a view?

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

Introduction to SQL
Which of the following must be enclosed in double quotes?

Introduction to SQL
Select the right statement to insert values to the student table.

Introduction to SQL
The command to eliminate a table from a database is:

Introduction to SQL
What is a view?

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')