Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
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
Normal Size Small Size show me how
CCS0029
FA1
| Question | Answer |
|---|---|
| The INTO clause occurs between the SELECT and _______ clauses | FROM |
| The _________ cursors are defined by the PL/SQL programmer. | EXPLICIT |
| The use of INTO clause in PL/SQL select statement is to specify the name of ________. | VARIABLES |
| The use of INTO clause in PL/SQL select statement is to specify the name of: ____________. Group of answer choices TABLE VARIABLE CURSOR VIEW | VARIABLE |
| 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 FALSE. Group of answer choices True False | False |
| A counter variable is an expression that returns true, false, or null. Group of answer choices True False | False |
| Refer to M1S2-code reference#3, is the symbol used for the assignment operator correct? | True |
| Refer to M1S2-code reference#3, data type for vmesg variable must be CHAR. | False |
| Consider the given code fragment below. The condition will return a true value. A:=null; B:=null; If A = B then . . . . . Group of answer choices True False | False |
| Refer to M1S2-code reference#3, what is missing in the creation of the implicit cursor? Group of answer choices Airports Country_code Country_name Airport | Country_name |
| Refer to M1S2-code reference#2, what is the missing condition in (2)? Group of answer choices vpop <= 0 vpop >= 0 vpop = 0 vpop < 0 | vpop = 0 |
| What is missing in the given code? DECLARE v_myage NUMBER := 31; BEGIN IF v_myage < 11 DBMS_OUTPUT.PUT_LINE('I am a child'); END IF; END; Group of answer choices Nothing is missing ELSE Not in the options ; | Not in the options |
| Refer to M1S2-code reference#3, what is missing in the given CASE structure? Group of answer choices Begin Nothing is missing Case () | Case |
| Refer to M1S3-code reference#2, what is missing in the SELECT statement? _________ | V_LOC_ID |
| Refer to M1S3-code reference#1, what should be the initial value of vctr? | 51 |
| A ________ is used in order to come out of from the outer loop within an inner loop. | EXIT |
| A ________ is used in order to come out of from the outer loop within an inner loop. | LOOP LABELS |
| Refer to M1S3-code reference#2, the VLOC_ID is missing in the SELECT statement? Group of answer choices True False | True |
| In BASIC and WHILE loop, the iteration will terminate when the counter value meets the upper bound value. Group of answer choices True False | False |
| The lower and upper bound of a for loop must be a numeric literals. | False |
| In BASIC and WHILE loop, the iteration will terminate when the counter is < than the upper bound. | False |
| The ______ is a Boolean attribute that evaluates to True if the most recent SQL statement returned at least one row. | SQL%FOUND |
| The memory area allocated by Oracle server to store the SQL statement and the data that it uses in known as __________. | IMPLICIT CURSOR |
| The _________ cursors are defined by the PL/SQL programmer. | EXPLICIT |
| The _________ SQL Rule: queries must return only one row. | EMBEDDED* |
| The _____ statement selects rows from one table to update and/or insert into another table. | MERGE |
| 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 where employee_id = 100; DBMS_OUTPUT.PUT_LINE(' Salary is : ' || v_salary); END; | NO ERROR |
| The memory area allocated by Oracle server to store the SQL statement and the data that it uses in known as: Group of answer choices Cursor Implicit Cursor View Explicit Cursor | Implicit Cursor |
| Which DML statement make changes to the database? Group of answer choices All the options DELETE INSERT UPDATE | All the options |
| The _______ statement selects rows from one table to update and/or insert into another table. Group of answer choices SELECT, INSERT, UPDATE DML MERGE COMBINE | MERGE |
| 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 |
| Refer to M1S2-code reference#3, the table name AIRPORT is missing in the creation of the implicit cursor. Group of answer choices True False | False |
| Applying the logical operator NOT to a null yields NULL. Group of answer choices True False | True |
| Consider the given code fragment below. The condition will return a false value. A:=null; B:=null; If A = B then . . . . . Group of answer choices True False | True |
| Refer to M1S2-code reference#3, what must be displayed in the dbms_output? Group of answer choices VMESG V_APORT | VMESG |
| The ______ is the symbol used for the assignment operator. Group of answer choices = := | = (?????) |
| Refer to M1S2-code reference#1, what is the missing element in the select statement? __________ Group of answer choices Not in the options VPOP VARIABLE No need to put INTO clause | VPOP |
| Refer to M1S3-code reference#1, how many time the loop body will be performed? __________ | 5 |
| Refer to M1S3-code reference#2, what is missing in the FOR … LOOP section? _________ | IN |
| Use the ______ loop when the statement inside the loop must execute at least once. | BASIC |
| In for loop, counter variable is declared _______. | IMPLICITLY |
| Without the EXIT statement, the loop would never end (an infinite loop). Group of answer choices True False | True |
| Use a DO..WHILE loop when the statement inside the loop must execute at least once. Group of answer choices True False | False |
| In for loop, counter must be explicitly declared. Group of answer choices True False | False |
| The DML statement: INSERT, DELETE, ________ make changes to the database. | UPDATE |
| The INTO clause occurs between the _______ and FROM clauses. | SELECT |
| The DDL and _______ SQL statements cannot be used directly in PL/SQL. | DCL |
| 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 |
| Control structures are used to change the logical flow of statements within the PL/SQL block. Group of answer choices True False | True |
| A condition is an expression that returns true, false, or null. Group of answer choices True False | True |
| Refer to M1S2-code reference#2, what should be the condition in (3)? Group of answer choices vpop > 1000000000 vpop >= 1000000000 vpop between 1 and 1000000000 vpop => 1000000000 | vpop > 1000000000 |
| Refer to M1S2-code reference#3, what is the missing element in the where clause? (UPPER) Group of answer choices UPPER Nothing is missing VARIABLE Not in the options | UPPER |
| Refer to M1S3-code reference#1, what type of looping is used in the code? ________ | BASIC LOOP |
| Refer to M1S3-code reference#1, what value must be stored in vctr inside the loop body? ______________ Note: Do not put space in your answer. | VCTR+1 |
Created by:
AdoKwatro