Which of the following command makes the updates performed by the transaction permanent in the database?

Introduction to SQL
Which of the following command makes the updates performed by the transaction permanent in the database?

TRUNCATE

DELETE

ROLLBACK

COMMIT

TRUNCATE

DELETE

ROLLBACK

COMMIT

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

6789

1234

2345

456789

6789

1234

2345

456789

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 define the data structures

To specify the syntax and semantics of SQL data definition language

All of these

To specify the syntax and semantics of SQL manipulation language

To define the data structures

To specify the syntax and semantics of SQL data definition language

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the temperature in increasing order of all cities

SELECT city, temperature FROM weather ORDER BY temperature;

SELECT city FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather;

SELECT city, temperature FROM weather ORDER BY city;

SELECT city, temperature FROM weather ORDER BY temperature;

SELECT city FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather;

SELECT city, temperature FROM weather ORDER BY city;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds the names of the sailors who have reserved at least one boat?

SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

None of These

SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

None of These

SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

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.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database?

Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

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

Introduction to SQL Find the temperature in increasing order of all cities

Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat?

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
Which of the following command makes the updates performed by the transaction permanent in the database?

Introduction to SQL
The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

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

Introduction to SQL
Find the temperature in increasing order of all cities

Introduction to SQL
Which of the following query finds the names of the sailors who have reserved at least one boat?

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.