тест selory / 70
.pdfCS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 37
Incorrect
0.00 points out of 1.00
Question 38
Correct
1.00 points out of 1.00
Question 39
Correct
1.00 points out of 1.00
Consider the following database table:
PartNo |
Description |
CustID |
Name |
QuantityOrdered |
|
|
|
|
|
2361 |
Pens |
7810 |
J. Smith |
22 |
|
|
|
|
|
2371 |
Paper Clips |
7810 |
J. Smith |
1000 |
|
|
|
|
|
2914 |
Pens |
7914 |
K. Jones |
900 |
|
|
|
|
|
Since the primary key is made up of PartNo and CustID, we cannot insert a new part without adding an associated customer. Which of the following is this an example of?
Select one:
a. A non-normal form b. A deletion anomaly
c. An update anomaly
d. An insertion anomaly
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 manipulation command?
Select one:
a. |
Alter |
b. |
Create |
c. |
Drop |
d. |
Select |
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
11 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 41 |
|
Which of the following are constraints that can be used with the create table command? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
references, alias, check |
|
|
||
|
|
b. |
null, primary key, view of |
|
|
c. |
primary key, not null, unique |
|
|
d. |
primary key, default, between |
|
|
|
|
Question 42
Correct
1.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 43 |
|
What is the select statement used to do? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
Query a table |
|
|
||
|
|
b. |
Create a new table |
|
|
c. |
Insert data into a table |
|
|
d. |
Delete rows from a table |
|
|
|
|
Question 44
Correct
1.00 points out of 1.00
What would the following query produce for results?
select count(*) from customer
where credit_limit > 500
Select one:
a. A listing of all customers
b. A listing of all customers with a credit limit greater than 500
c. A count of all customers
d. A count of all customers with a credit limit greater than 500
12 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 45
Correct
1.00 points out of 1.00
Question 46
Correct
1.00 points out of 1.00
What will the following query return for results?
select lname from customer
where credit_limit in (1000,2000,3000)
Select one:
a. All last names and credit limits from 1000 to 2000, and 2000 to 3000
b. The last name of all customers with a credit limit of 1000, 2000, or 3000
c. All last names and credit limits where the credit limit is 1000, 2000, 3000
d. The last name of all customers with a credit from 1000 to 2000, and 2000 to 3000
Which of the following is a SQL aggregate function?
Select one:
a. average b. avg
c. mean
d. sqrt
Question 47 |
|
In SQL, the join statement is most commonly used to do which of the following? |
|
|
|
Incorrect |
|
|
0.00 points out |
|
Select one: |
of 1.00 |
|
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 48 |
|
What is the SQL 'group by' statement used to do? |
|
|
|
Incorrect |
|
|
0.00 points out |
|
Select one: |
of 1.00 |
|
a. Sort the results in group order |
|
|
|
|
|
b. List the rows ordered by group |
|
|
c. List a single row for each group |
|
|
d. Insert new records into the table |
|
|
|
13 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 49
Incorrect
0.00 points out of 1.00
You are given the following tables:
Course
CourseID |
Description |
Credits |
|
|
|
CS101 |
Computer Science I |
3 |
|
|
|
CS201 |
Elementary Data Structures |
3 |
|
|
|
ENGL210 |
Technical Writing |
3 |
|
|
|
Registration
SID |
CourseID |
SemID |
Instructor |
Grade |
|
|
|
|
|
282712 |
ENGL210 |
201701 |
H. Zacny |
B+ |
|
|
|
|
|
362112 |
CS101 |
201701 |
K. Ross |
C |
|
|
|
|
|
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.
14 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 50
Incorrect
0.00 points out of 1.00
You are given the following tables:
Student
SID |
Lname |
Fname |
Major |
|
|
|
|
986223 |
Smith |
Janet |
Chemistry |
|
|
|
|
362112 |
Williams |
Henry |
Computer Science |
|
|
|
|
282712 |
Jones |
John |
English Literature |
|
|
|
|
Registration
SID |
CourseID |
SemID |
Instructor |
Grade |
|
|
|
|
|
282712 |
ENGL210 |
201701 |
H. Zacny |
B+ |
|
|
|
|
|
362112 |
CS101 |
201701 |
K. Ross |
C |
|
|
|
|
|
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.
Previous |
|
...Jump to |
|
|
|
15 of 15 |
4/24/22, 15:23 |