DBM 405 DBM405 DBM/405 ENTIRE COURSE HELP – DEVRY UNIVERSITY

Description

DBM 405 DBM405 DBM/405 ENTIRE COURSE HELP – DEVRY UNIVERSITY

DBM 405 Week 1 quiz

DBM 405 Week 2 quiz

DBM 405 Week 3 quiz

DBM 405 Week 4quiz

DBM 405 Week 5 quiz

DBM 405 Week 6 quiz

DBM 405 Week 7 quiz

DBM 405 DBM405 DBM/405 ENTIRE COURSE HELP – DEVRY UNIVERSITY

DBM 405 Week 1 quiz

1. TCO 1 – Which of the following statements is unique to the three-tier application model?

2. TCO 1 – Which of the following is an example of an event?

3. TCO 1 – The ____ section of a PL/SQL block contains code that creates variables, cursors, and types

4. TCO 1 – The only required sections of a PL/SQL block are the ____ sections.

5. TCO 1 – Which of the following code fragments contains a host variable?

6. TCO 1 – Which of the following typically returns only one value?

7. TCO 1 – Which of the following serves as a visual representation of a database?

8. TCO 1 – ____ are named memory areas that hold values to allow the retrieval and manipulation of values in a program.

9. TCO 1 – What is the purpose of the BEGIN section of a PL/SQL block?

DBM 405 DBM405 DBM/405 ENTIRE COURSE HELP – DEVRY UNIVERSITY

DBM 405 Week 2 quiz

1. TCO 4 – Which of the following clauses indicates the variable that is to hold the values that are retrieved from the database?

2. TCO 4 – _____ are declared and manipulated in the PL/SQL block code for handling a set of rows returned by a SELECT statement

3. TCO 4 – A(n) _____ is a variable that can store and handle multiple values of the same data type as one unit

4. TCO 4 – A(n) _____ represents a work area or section of memory in which an SQL statement is being processed in the Oracle server.

5. TCO 2 – Which of the following refers to an attempted violation of a unique or primary key column constraint?

6. TCO 2 – Which of the following refers to a SELECT statement in a PL/SQL block that retrieves more than one row?

7. TCO 2 – Which of the following returns the Oracle error number?

8. TCO 2 – Which of the following refers to a SELECT statement in a PL/SQL block that retrieves no rows?

9. TCO 2 – What is the difference between a predefined exception and a user-defined exception?

DBM 405 DBM405 DBM/405 ENTIRE COURSE HELP – DEVRY UNIVERSITY

DBM 405 Week 3 quiz

1. TCO 7 – Which of the following is an acceptable error number for the RAISE_APPLICATION_ERROR function?

2. TCO 7 – Which of the following is saved in an Oracle application or library on the client-side?

3. TCO 7 – One important item that needs to be considered when creating stored procedures is to make them flexible so that they can be ____.

4. TCO 7 – A(n) ____ must be assigned one of three available modes: IN, OUT, IN OUT

5. TCO 5 – Which of the following commands is used to delete a program unit?

6. TCO 5 – In the code below, which of the following is the parameter variable?

CREATE OR REPLACE FUNCTION fct_test1_sf (p_num IN NUMBER)
RETURN NUMBER
IS
BEGIN
UPDATE bb_test1
SET col1 = p_num;
RETURN p_num;
END;

7. TCO 5 – Which of the following statements is true?

8. TCO 5 – Functions used in SQL statements must meet all of the following requirements, except ____.

9. TCO 7 – What information must be provided in the header section of a PL/SQL block for each parameter?

DBM 405 DBM405 DBM/405 ENTIRE COURSE HELP – DEVRY UNIVERSITY

DBM 405 Week 4quiz

1. TCO 6 – Which of the following views can be used to review the source code of a procedure, function, or package?

2. TCO 6 – If a dependent object has an older ____ than the referenced object when called, the dependent object is flagged as INVALID and needs to be recompiled.

3. TCO 6 – A program unit is said to contain ____ when it includes references to database objects that in turn references other database objects.

4. TCO 6 – When a procedure is compiled, it stores the ____ of any referenced objects.

5. TCO 6 – The ____ directive needs to be included in the package specification to clearly state the purity levels applicable to the function.

6. TCO 6 – Which of the following views allows the user to review direct and indirect dependencies of an object in either a numeric order or indented format?

7. TCO 6 – Package elements are considered ____if they can be called only from other program units within the same package

8. TCO 6 – ____ are used to link to another database and to call objects that exist on that database.

9. TCO 6 – Discuss two situations in which parameter modifications are not viewed as signature modifications and, therefore, do not prompt recompilation