Question

Question 9 (1 point) Which choice below describes the function of the following SQL statement? SELECT ID, Last Name, First Name, Address FROM Members WHERE Last Name Last Name a simple query a parameterized query a compound query a wildcard query Question 10 (1 point) The correct SQL syntax to sort a table by Last Name in order of A-Z is SORT BY Last Name ASCENDING ORDER BY Last Name Down ORDER BY Last Name ASC ORDER BY Last Name DESC

Answer 1

9

Ans: simple query

Here it involved only single query.it means I don't have any multiple queries or any nested queries.so it is a simple query.

10

Ans: ORDER BY last_name ASC

It means it sorts the all last_names in ascending order.

ASC means it sorts in ascending order and DESC means it sorts in descending order

7

Ans: WHERE last_name LIKE "S%"

It means it lists out all the last names which are starts with 'S'

S% says that string starts with s and next letters can be anything.

8

Ans: dataset

Any thing that we get as output when we execute the query on the tables of database is said to be dataset.

5

Ans: SQL

SQL(Structured Query Language) is used to query many types of data from virtually any source

6

Ans: relational operators

Relational operators like && and || are used to provide multiple

Selections in queries.

For getting data from multiple tables we use these operators and joins. And for using multiple conditions.

2

Ans:data grid view

It means the data set we got through query are displayed in a format called data grid view.

3

Ans: table

A database table is organized into rows and columns.

It means data in a table are organized in rows and columns where each row consists of one entire record and columns used for fields of information like I'd,type,name and gender..