тест selory / 74

Question 38

Correct

1.00 points out of 1.00

Question 39

Incorrect

0.00 points out of 1.00

What is the difference between data definition language and data manipulation language?

Select one:

a. It is used to create tables, views, etc., and data manipulation language is only used for inserts

b. It is used for queries and data manipulation language is used for updating and deleting tables only

c. It is used to create the files that store tables whereas data manipulation language is used to update data

d. It is used to create tables, indexes, etc., whereas data manipulation language is used to query the database

Your answer is correct.

Which of the following is a data definition command?

Select one:

a. Insert b. Select

c. Update

d. Create table

Question 40

Correct

1.00 points out of 1.00

Assume that we have a table called student with the following columns: (sid,fname,lname,major)

What is wrong with this insert command?

insert into student ('s2234','John','Smith','Chemistry')

Select one:

a. It is missing a left parenthesis

b. It is missing a right parenthesis

c. It is missing a value before the parenthesis

d. There are not enough fields in the statement

Question 42

Correct

1.00 points out of 1.00

Which of the following is true about a select statement?

Select one:

a. It can only be used by itself.

b. It can be included as part of an insert only.

c. It can be included as part of an update but not as part of a delete.

d. It can be included as part of an update, delete, or insert statement.

Question 44

Correct

1.00 points out of 1.00

Question 45

Correct

1.00 points out of 1.00

What would this statement produce for output?

select lname, fname from customer where state like '%M'

Select one:

a. Customers' last and first names who live in a state that ends with an M

b. Customers' last and first names who live in a state that begins with an M

c. a list of all customers in the table who live in a state that ends with an M

d. A list of all customers in the table who live in a state that begins with an M

Which of the following describes the order by clause?

Select one:

a. It is always the first part of an SQL select statement

b. It sorts the entire table by ordering the values of a column(s)

c. It sorts the result set from a query by ordering column values

d. It uses descending when the order for sorting is not specified

Question 49

Correct

1.00 points out of 1.00

You are given the following tables:

Course

Registration

What would the following SQL Select statement produce for output? select course.description, registration.SID,registration.grade

from registration

right join course

on registration.courseID = course.courseID

Select one:

a. Computer Science I 362112 C

b. Computer Science I 362112 C

Technical Writing 28212 B+

Elementary Data Structures null null

Technical Writing 28212 B+

d. No results due to syntax error

Your answer is correct.

Question 50

Correct

1.00 points out of 1.00

You are given the following tables:

Course

Registration

Student

What would the following SQL Select statement produce for output?

select course.Description,registration.SID,registration.grade, student.lname

from registration

inner join course

on registration.courseID = course.courseID

inner join student on registration.sid = student.sid

Select one:

a. No output, since this query cannot be performed

b. Technical Writing 282712 B+ Jones

c. Technical Writing 282712 B+ Jones

Computer Science I 362112 Williams C

Computer Science I 362112 Williams C

Null 652123 Null A

Your answer is correct.