Save
Upgrade to remove ads
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

DATABASE

Module 1

QuestionAnswer
The ______ is a Boolean attribute that evaluates to TRUE if the most recent SQL statement did not return even one row. SQL%NOTFOUND
The INTO clause occurs between the SELECT and _______ clauses. FROM
The ______ clause is used in DML statement to specify variable(s) that will hold the value(s) that SQL returns from the SELECT clause. INTO
The INTO clause occurs between the _______ and FROM clauses. SELECT
The memory area allocated by Oracle server to store the SQL statement and the data that it uses in known as __________. CURSOR
The ______ are automatically declared variables that allow you to evaluate what happened when a cursor was last used. Cursor attributes Explicit attributes Attributes Implicit attributes CURSOR ATTRIBUTES
The use of INTO clause in PL/SQL select statement is to specify the name of: ____________. VIEW TABLE VARIABLE CURSOR VARIABLE
What could be the possible error of the given code below? DECLARE v_sal_increase employees.salary%TYPE := 800; BEGIN UPDATE copy_emp SET salary = salary + v_sal_increase WHERE job_id = 'ST_CLERK'; END; NO ERROR
A counter variable is an expression that returns true, false, or null. [T/F] FALSE
Applying the logical operator NOT to a null yields FALSE. [T/F] FALSE
The use of CASE statement to test conditions such as <, >, >=, <= is know as case expression. [T/F] FALSE
The ______ is the symbol used for the assignment operator. =
The _______ is an expression that returns true, false, or null. CONDITION Counter variable CASE STATEMENT IF STATEMENT CONDITION
The _______ are used to change the logical flow of statements within the PL/SQL block. Control Structures CASE statement Conditional statement Looping statement CONTROL STRUCTURES
The type of loop where the statement inside the loop must execute at least once. BASIC
What is missing in the given WHILE loop syntax? ________ WHILE condition statement1; statement2; . . . END ; LOOP
Without the EXIT statement, the loop would never end (an infinite loop). [T/F] TRUE
In BASIC and WHILE loop, initialization of counter variable is necessary. [T/F] TRUE
In BASIC and WHILE loop, the iteration will terminate when the counter is > than the upper bound. [T/F] FALSE
In BASIC and WHILE loop, the iteration will terminate when the counter value meets the upper bound value. [T/F] FALSE
The _____ is an integer value that represents the number of rows affected by the most recent SQL statement. SQL%ROWCOUNT
The _______cursor are automatically defined by Oracle. IMPLICIT
The _____ statement selects rows from one table to update and/or insert into another table. MERGE
Which SQL statements cannot be used directly in PL/SQL? DML TCL DDL, DCL DML, TCL DDL, DCL
Which DML statement make changes to the database? DELETE All the options UPDATE INSERT ALL THE OPTIONS
What could be the possible error of the given code below? DECLARE v_salary employees.salary%TYPE; BEGIN SELECT salary INTO v_salary FROM employees; DBMS_OUTPUT.PUT_LINE(' Salary is : ' || v_salary); END; QUERY RETURNS MORE THAN 1 ROW
Applying the logical operator NOT to a null yields NULL. [T/F] TRUE
Consider the given code fragment below. The condition will return a false value. A:=null; B:=null; If A = B then . . . . . [T/F] TRUE
In for loop, counter variable is declared _______. IMPLICITLY
In for loop, counter must be explicitly declared. [T/F] FALSE
The lower and upper bound of a for loop must be a numeric literals. [T/F] FALSE
An EXIT statement is used in order to come out of from the outer loop within an inner loop. [T/F] FALSE
The use of INTO clause in PL/SQL select statement is to specify the name of ________. VARIABLES
The DML statement: INSERT, DELETE, ________ make changes to the database. UPDATE
An integer value that represents the number of rows affected by the most recent SQL. SQL%COUNT SQL%COUNTROW SQL%NUMROW SQL%ROWCOUNT SQL%ROWCOUNT
All counter variables must be declared at the declaration section. [T/F] FALSE
The _________ cursors are defined by the PL/SQL programmer. EXPLICIT
The ______ are automatically declared variables that allow you to evaluate what happened when a cursor was last used. CURSOR ATTRIBUTES
What is missing in the given code below? DECLARE v_salary employees.salary%TYPE; BEGIN SELECT salary INTO ________ FROM employees where employee_id = 100; DBMS_OUTPUT.PUT_LINE(' Salary is : ' || v_salary); END; V_SALARY
A _______ is an expression with a TRUE or FALSE value that is used to make a decision. Nested-if ELSE Conditional statement Condition CONDITION
The BASIC LOOP control structures are statements that enable you to execute statements in a PL/SQL block repeatedly. [T/F] TRUE
The ______ is a Boolean attribute that evaluates to True if the most recent SQL statement returned at least one row. SQL%FOUND
Control structures are used to change the logical flow of statements within the PL/SQL block. [T/F] TRUE
What could be the possible error of the given code below? DECLARE v_sal_increase employees.salary%TYPE = 800; BEGIN UPDATE copy_emp SET salary = salary + v_sal_increase WHERE job_id = 'ST_CLERK'; END; VARIABLE DECLARATION
What could be the possible error of the given code below? DECLARE v_deptno employees.department_id%TYPE := 10; BEGIN DELETE FROM copy_emp WHERE department_id = v_deptno; END; NO ERROR
Use a DO..WHILE loop when the statement inside the loop must execute at least once. [T/F] FALSE
The use of CASE statement to test conditions such as <, >, >=, <= is know as: Conditional CASE Expression Equality CASE statement Searched CASE statement Non-equality CASE statement SEARCHED CASE STATEMENT
Use the ______ loop when the statement inside the loop must execute at least once. BASIC
A loop structure must have an exit clause. [T/F] TRUE
The memory area allocated by Oracle server to store the SQL statement and the data that it uses in known as: IMPLICIT CURSOR
The _______ statement selects rows from one table to update and/or insert into another table. COMBINE MERGE DML SELECT, INSERT, UPDATE MERGE
You can change the logical flow of statements within the PL/SQL block by using: Looping statements Subprograms Control structures Conditional statements CONTROL STRUCTURES
Created by: seventeenly
 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards