тест selory / 24

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

Incorrect

0.00 points out of 1.00

Question 41

Incorrect

0.00 points out of 1.00

If we have the following table:

customer (custNo, name, street, city, state, zip, telephone, creditLimit) What will this update command do?

update customer

set creditLimit = creditLimit * 1.05

where state = 'MA'

Select one:

a. Insert a new record into the table for each MA customer

b. Set the credit limit of all MA customers to credit limit * 1.05

c. Set the credit limit of all MA customers to credit limit / 1.05

d. Change state to MA where credit limit was increased by 5%

Which of the following are constraints that can be used with the create table command?

Select one:

a. references, alias, check

b. null, primary key, view of

c. primary key, not null, unique

d. primary key, default, between

Question 42

Incorrect

0.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 43

Incorrect

0.00 points out of 1.00

What would this delete operation do? delete from course

where credits = 3

Select one:

a. Add a new row to the course table

b. Delete all records in the course table

c. Delete three credit courses from the course table

d. Delete all records except those with three credits from the course table

Question 45

Correct

1.00 points out of 1.00

What would the following SQL statement produce for output? select top 2 from customers

Select one:

a. The first two records of the customer table

b. The last two records of the customer table

c. The first two customers based on some condition

d. The last two customers ordered by some condition

Question 46

Incorrect

0.00 points out of 1.00

Question 47

Incorrect

0.00 points out of 1.00

Using a course table with the following fields: (cid,description, credits, frequency)

What type of output would you expect from the following SQL command?

select cid from course

where credits = 3 and frequency = null

Select one:

a. Records of 3 credit courses of any frequency

b. The cid of 3 credit courses whose frequency is null

c. The cid of 3 credit courses with no frequency value

d. Records of 3 credit courses with no frequency value

In SQL, the join statement is most commonly used to do which of the following?

Select one:

a. Join two or more tables based upon related fields

b. Join two or more tables based on related column fields

c. Join two or more columns together based on common names

d. Join two or more rows together based on related column fields

Question 49

Incorrect

0.00 points out of 1.00

You are given the following tables:

Student

Registration

What would the following SQL Select statement produce for output? select lname,CourseID, grade

from student

left join registration

on student.sid = registration.sid

Select one:

a. Williams CS101

b. Williams CS101 C

Jones ENGL210 B+

c. Smith null null

Williams CS101 C

Jones ENGL210

d. No output due to a syntax error

Your answer is incorrect.

Question 50

Incorrect

0.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+

c. Computer Science I 362112 C

Elementary Data Structures null null

Technical Writing 28212 B+

d. No results due to syntax error

Your answer is incorrect.