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

IS5213 Data Science and Big Data Solutions

WEEK- 2 code install.packages("dplyr") library(dplyr) Rajeshdf = read.csv('c:\\Insurance.csv') str(Rajeshdf) str(Rajeshdf) summary(Rajeshdf) agg_tbl <- Rajeshdf %>% group_by(Rajeshdf$JOB) %>% summarise(total_count=n(), .groups = 'drop') agg_tbl a = aggregate( x=Rajeshdf$HOME_VAL, by=list( Rajeshdf$CAR_TYPE), FUN=median, na.rm=TRUE ) a QUIZ 2. What famous literary detective solved a crime because a dog did not bark at the criminal? A). Sherlock Holmes 1. In the Insurance data set, how many Lawyers are there? A). 1031 3. What two prefixes does the instructor use for variables when fixing the missing values? Select all that apply. A). IMP_ M_ 4. What is the median Home Value of a person who drives a Van? A). 204139 5. In the insurance data set, how many missing (NA) values does the variable AGE have? A) 7 1. What...

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 t...

GE5093 Design Thinking All Quizzes

GE---5093-1D2-FA-2021 - Design Thinking Home My courses 2021-FA GE---5093-1D2-FA-2021 Week 1 Reading Quiz 1 Started on Sunday, October 31, 2021, 2:04 PM State Finished Completed on Sunday, October 31, 2021, 2:30 PM Time taken 25 mins 58 secs Grade 8.00 out of 10.00 ( 80 %) Top of Form Question 1 Correct 1.00 points out of 1.00 Flag question Question text A critical finding of Edward Lorenz related to Design Thinking was: Select one: a. An application of the caterpillar effect b. The idea of deterministic chaos or the "Butterfly Effect" c. Business leaders enjoy chaos d. Statistical modeling of weather was fairly accurate in the long term Feedback Your answer is correct. The correct answer is: The idea of deterministic chaos or the "Butterfly Effect" Question 2 Incorrect 0.00 point...

US-India Student Support Services