You can add a row using SQL in a database with which of the following?

Introduction to SQL
You can add a row using SQL in a database with which of the following?

ADD

MAKE

INSERT

CREATE

ADD

MAKE

INSERT

CREATE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

None of these

A view is a special stored procedure executed when certain event occurs.

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.

None of these

A view is a special stored procedure executed when certain event occurs.

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.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the SQL statements is correct?

SELECT Username, Password WHERE Username = 'user1'

SELECT Username AND Password FROM Users

SELECT Username, Password FROM Users

None of these

SELECT Username, Password WHERE Username = 'user1'

SELECT Username AND Password FROM Users

SELECT Username, Password FROM Users

None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following do you need to consider when you make a table in SQL?

Primary keys

Default values

All of these

Data types

Primary keys

Default values

All of these

Data types

ANSWER DOWNLOAD EXAMIANS APP

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

SELECT city FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather ORDER BY city;

SELECT city, temperature FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather;

SELECT city FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather ORDER BY city;

SELECT city, temperature FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL You can add a row using SQL in a database with which of the following?

Introduction to SQL What is a view?

Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

Introduction to SQL Which of the SQL statements is correct?

Introduction to SQL Which of the following do you need to consider when you make a table in SQL?

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

Introduction to SQL
You can add a row using SQL in a database with which of the following?

Introduction to SQL
What is a view?

Introduction to SQL
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

Introduction to SQL
Which of the SQL statements is correct?

Introduction to SQL
Which of the following do you need to consider when you make a table in SQL?

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