тест selory / 28
.pdfCS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 37 |
|
When is a relation considered to be in second normal form (2NF)? (Select the best answer.) |
|
|
|
||
Incorrect |
|
|
|
0.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
When there are no repeating groups in a relation |
|
|
||
|
|
b. |
When there are no transitive functional dependencies |
|
|
c. |
When there are no dependencies on part of the primary key |
|
|
d. |
When there are no dependent attributes in transitive relation |
|
|
|
|
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 manipulation command?
Select one:
a. Alter
b. Create
c. Drop
d. Select
Question 40
Incorrect
0.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 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 41 |
|
Which of the following are constraints that can be used with the create table command? |
|
|
|
||
Incorrect |
|
|
|
0.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 |
|
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 43 |
|
What is the delete statement used to do? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
Delete table rows that match a condition |
|
|
||
|
|
b. |
Truncate parts of a table that are too long |
|
|
c. |
Remove table columns that match a condition |
|
|
d. |
Insert a mark to indicate that a table is deleted |
|
|
|
|
Question 44
Incorrect
0.00 points out of 1.00
Question 45
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
What will this SQL statement produce for output? select distinct lname,fname,dob
from customer
Select one:
a. Customer data rows so that there are no duplicates
b. Customer rows so that there are no duplicate records
c. Customer rows so that there are no duplicate customers
d. Customer data rows so that there are no duplicate names
12 of 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 46
Incorrect
0.00 points out of 1.00
Question 47
Incorrect
0.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
What does an inner join do?
Select one:
a. Return all rows in all tables
b. Return only those rows with a matching row in the corresponding table
c. Return all rows in the right table regardless of whether there is a match in the left table
d. Return all rows in the left or right table regardless of whether there is a match in the corresponding table
13 of 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 48
Incorrect
0.00 points out of 1.00
You are given this table:
Registration
SID |
CourseID |
SemID |
Instructor |
Grade |
|
|
|
|
|
282712 |
ENGL210 |
201701 |
H. Zacny |
B+ |
|
|
|
|
|
362112 |
CS101 |
201701 |
K. Ross |
C |
|
|
|
|
|
652123 |
CS403 |
201701 |
K. Ross |
A |
|
|
|
|
|
362112 |
CS403 |
201701 |
K. Smith |
C+ |
|
|
|
|
|
282712 |
BIO101 |
201601 |
I. Olsen |
C |
|
|
|
|
|
What will the result of the following query be? select sid, count(*)
from registration
group by sid
Select one:
a. The entire table sorted by sid
b. No results due to an error
c. 282712 2 362112 2
652123 1
d. 282712 1 362112 1
652123 1
Your answer is incorrect.
14 of 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&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 |
|
|
|
|
|
652123 |
CS403 |
201603 |
K. Ross |
A |
|
|
|
|
|
Student
SID |
Lname |
Fname |
Major |
|
|
|
|
986223 |
Smith |
Janet |
Chemistry |
|
|
|
|
362112 |
Williams |
Henry |
Computer Science |
|
|
|
|
282712 |
Jones |
John |
English Literature |
|
|
|
|
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
d. Technical Writing 282712 B+ Jones
Computer Science I 362112 Williams C
Null 652123 Null A
Your answer is incorrect.
15 of 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 50
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 |
|
|
|
|
|
652123 |
CS403 |
201603 |
K. Ross |
A |
|
|
|
|
|
What would the following SQL Select statement produce for output? select course.Description,registration.SID,registration.grade
from registration
full join course
on registration.courseID = course.courseID
Select one:
a. Technical Writing 28212 B+
b. Technical Writing 28212 B+
Computer Science I 362112 C
Null 652123 A
c. Technical Writing 28212 B+
Computer Science I 362112 C
Elementary Data Structures null null
d. Technical Writing 28212 B+
Computer Science I 362112 C
Null 652123 A
Elementary Data Structures null null
Your answer is incorrect.
Previous |
|
...Jump to |
|
|
|
16 of 16 |
4/24/22, 12:24 |