INF503 Week 4 Quize's

Started on	Sunday, February 6, 2022, 10:37 PM
State	Finished
Completed on	Sunday, February 6, 2022, 10:44 PM
Time taken	7 mins 9 secs
Grade	18.00 out of 20.00 (90%)

Question 1

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.

Select one:

inner

cross

outer

Correct

equi-

Feedback

The correct answer is: outer

Question 2

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.

Select one:

UPDATE

SELECT

Correct

COMMIT

INSERT

Feedback

The correct answer is: SELECT

Question 3

Correct

1.00 points out of 1.00

Flag question

Question text

SQL requires the use of the _____ command to enter data into a table.

Select one:

COMMIT

SELECT

NOT NULL

INSERT

Correct

Feedback

The correct answer is: INSERT

Question 4

Correct

1.00 points out of 1.00

Flag question

Question text

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

Select one:

144

Correct

Feedback

The correct answer is: 144

Question 5

Incorrect

0.00 points out of 1.00

Flag question

Question text

A(n) _____ join will select only the rows with matching values in the common attribute(s).

Select one:

natural

cross

Incorrect

outer

full

Feedback

The correct answer is: natural

Question 6

Correct

1.00 points out of 1.00

Flag question

Question text

In Oracle, _____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.

Select one:

Procedural Language SQL

Correct

embedded SQL

dynamic SQL

stored procedures

Feedback

The correct answer is: Procedural Language SQL

Question 7

Incorrect

0.00 points out of 1.00

Flag question

Question text

A(n) _____ join performs a relational product (also known as the Cartesian product) of two tables.

Select one:

full

cross

natural

Incorrect

equi-

Feedback

The correct answer is: cross

Question 8

Correct

1.00 points out of 1.00

Flag question

Question text

No matter what language you use, if it contains embedded SQL statements, it is called the _____ language.

Select one:

view

base

host

Correct

static

Feedback

The correct answer is: host

Question 9

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ is a query that is embedded (or nested) inside another query.

Select one:

operator

subquery

Correct

alias

view

Feedback

The correct answer is: subquery

Question 10

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is a relational set operator.

Select one:

EXCEPT

Correct

ALL

EXISTS

PLUS

Feedback

The correct answer is: EXCEPT

Question 11

Correct

1.00 points out of 1.00

Flag question

Question text

According to the rules of precedence, which of the following computations should be completed first?

Select one:

Multiplications and divisions

Additions and subtractions

Operations within parentheses

Correct

Power operations

Feedback

The correct answer is: Operations within parentheses

Question 12

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.

Select one:

cursor-style process

persistent storage module (PSM)

Correct

base table

statement-level trigger

Feedback

The correct answer is: persistent storage module (PSM)

Question 13

Correct

1.00 points out of 1.00

Flag question

Question text

All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make.

Select one:

COMMIT

UPDATE

ALTER

Correct

ROLLBACK

Feedback

The correct answer is: ALTER

Question 14

Correct

1.00 points out of 1.00

Flag question

Question text

In Oracle, _____ retrieves the current value of a sequence.

Select one:

NEXTVAL

VARCHAR

CURRVAL

Correct

VARCHAR2

Feedback

The correct answer is: CURRVAL

Question 15

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ cursor is automatically created in procedural SQL when the SQL statement returns only one value.

Select one:

explicit

dynamic

static

implicit

Correct

Feedback

The correct answer is: implicit

Question 16

Correct

1.00 points out of 1.00

Flag question

Question text

A table can be deleted from the database by using the _____ TABLE command.

Select one:

MODIFY

DELETE

DROP

Correct

ERASE

Feedback

The correct answer is: DROP

Question 17

Correct

1.00 points out of 1.00

Flag question

Question text

Oracle recommends _____ for creating audit logs.

Select one:

triggers

Correct

tables

stored functions

stored procedures

Feedback

The correct answer is: triggers

Question 18

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is a cursor attribute that returns TRUE if the last FETCH returned a row, and FALSE if not.

Select one:

%ROWCOUNT

%ISOPEN

%FOUND

Correct

%NOTFOUND

Feedback

The correct answer is: %FOUND

Question 19

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is a string function that returns the number of characters in a string value.

Select one:

LENGTH

Correct

UCASE

CONCAT

SUBSTRING

Feedback

The correct answer is: LENGTH

Question 20

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ is an alternate name given to a column or table in any SQL statement.

Select one:

alias

Correct

data type

stored function

trigger

Feedback

The correct answer is: alias

Finish review

Comments

IS5203 Type 2 Post Assessment and Final Quiz

Carlos has just created a new subnet for the finance department. He needs to be able to allow the employees in finance to retrieve files from the sales server, which is located in another subnet. Which of the following OSI model layers would it be necessary to categorize the device into? a. Layer 4 b. Layer 6 c. Layer 2 d. Layer 3 All of the cubicles in a company's office have cables that run up to the ceiling and across to an IDF. Inside the IDF, they connect directly to the latest generation switch available from the networking equipment vendor that they have chosen. Which of the following describes the physical topology most likely in use? a. mesh

GE5103-2 Project Management [Aug 23 Syllabus]

Some of the advantages of using time boxes and cycles in project coordination efforts include creating urgency, measuring progress, and allowing for predictable measurements. A) True 2. Even though most project managers are not contract specialists, they need to understand the process well enough to coordinate with the team. For the current assignment, you are looking at a short-term and small effort with a contractor of just a few hours without significant clarity. Which of the following would be the most applicable contract to use in this situation? A) Time and materials 3. The project you are working on has had modifications to the plan from the start and even how the project is run. Project governance covers all of the 3 following except: A) Naming The project manager 4. Of the following, which is most likely a trigger condition defined early in the project? A) Alerting Governance board if 10 percent over schedule 5. Of the following options, which stand

GE5163 Week8 ( Final Exam ) Quize's

A process or product that is insensitive to normal variation is referred to as being Select one: a. in specification b. capable c. robust d. out of control Feedback Your answer is correct. A completed failure mode and effects analysis (FMEA) results in the following assessment rating. Occurrence = 4 Severity = 8 Detection = 10 What is the risk priority number (RPN) for this FMEA? Select one: a. 42 b. 22 c. 320 d. 120 Feedback Your answer is correct. In a visual inspection situation, one of the best ways to minimize deterioration of the quality level is to: Select one: a. have a program of frequent eye exams. b. retrain the inspector frequently. c. add variety to the task. d. have a standard to compare against as an element of the operation. Feedback Your answer is correct. Which of the following elements is least necessary to a good corrective action feedback report? Select one: a. What caused the failure b. Who caused the failure c. What correction has been made d. Wh

US-India Student Support Services