UNIT – I
1) RDBMS Stands for ______
a) Relational Data Base Management System b) Relational Data Base Managing System
c) Relational Data Base Manager System d) None
2) Attribute means _______
a) Columns b) Rows c) Table d) None
3) Relation means _____________
a) Columns b) Rows c) Table d) None
4) Tupple means ________
a) Columns b) Rows c) Table d) None
5) ANSI stands for _______
a) American National Standards Institute b) American National Standards Information
c) American National Structured Institute. d) None
6) SQL Stands for ____________
a) Structured Query Language b) Structured Quality Language
c) Structured Quantity Language d) None
7) Oracle is a ________
a) Language b) Package c) Group of tools d) None
8) Alerts are ___________
a) Procedure b) Functions c) Critical error Messages d) None
9) DBA Stands for ________
a) Data Base Access b) Data Base Administrator c) Data Base Alternator d) none
10) Server is referred as __________
a) Back end b) Front end c) Table d) None
11) Client is referred as __________
a) Back end b) Front end c) Table d) None
12) SGA stands for _________
a) Structured Global Area b) System Global Area c) System Global Access d) None
13) Oracle support ________ operating systems.
a) many b) single c) two d) None
14) Triggers are written by user for _____________
a) Specific Table b) for Multiple Tables c) for Columns d) None
15) Client and Server can communicate by using __________
a) PL/SQL b) PROC c) SQLNet d) None
16) DDL stands for _____________
a) Data Definition Language b) Data Dictionary Language c) Data Definition Load d) None
17) DML Stands for _____________
a) Data Mathematical Language b) Data Multiple Language
c) Data Manipulation Language d) None
18) DCL Stands for ______
a) Data Connect Language b) Data Control Language c) Data Combine Language d) None
19) UPDATE command is using for ___________
a) add new rows b) change the column values c) delete the rows d) None
20) DELETE command is using for ___________
a) delete the columns b) change the column values c) delete the rows d) None
21) Character values are types within _______ .
a) Single quotes b) Double Quotes c) Exclamatory d) None
22) If WHERE condition is not given, then ______ rows in the table will be updated.
a) All b) Only One c) No d) None
23) For Date Type of data, width _______ specified.
a) must not be b ) must be c) 8 d) None
24) ________ symbol is the concatenation operator.
a) “ b) & c) | | d) none
25) By default , data is sorted in _______ order.
a) Descending b) Random c) Ascending d) None
26) _________ is the command to change the table name.
a) Update b) Insert c) Rename d) None
27) _______ property that guarantees that values from one column depend on values in another column.
a) Referential Integrity b) Foreign Key c) Primary key d) None
28) Column in the child table, which reference a primary key on the parent table is referred as _____.
a) Transaction Key b) Null key c) Foreign key d) None
29) _________ referential integrity rule which allows the user to delete rows from the master and at the same time delete the dependent rows in the child table.
a) On update b) On Insert c) On delete cascade d) None
30) Join means to across rows from _______ tables
a) only one b) two only c0 two or more d) None
31) When matching records only are displayed from both the tables. It is called ______ join.
a) Equi Join b) Non-equi c) Outer join d) None
32) _________ command is used to release the formatting.
a) column cleared b) column off c) clear column d) None
33) _______ function is used to substitute any NULL value with a user specified value.
a) ABS() b) NVL() c) MAX() d) None
34) _________ function can be used to expand any abbreviations used in the table.
a) NVL b) MIN c) DECODE d) None
35) __________ function is convert a string into an oracle date.
a) Months_Between b) To_Date() c) NVL d) None
36) _______ columns are like table columns, but not actually stored in thee table.
a) User b) Built-in c) Pseudo d) None
37) In SQL, the _____ statement is used to query at a table in different ways.
a) SELECT b) UPDATE c) INSERT d) None
38) _____language is used to store and retrieve data from a database.
a) Database b) Table c) SQL d) None
39) ________ function can be used to convert a date or number to a character string.
a) T0_CHAR() b) TO_NUMBER() c) CONVERT() d) None
40) ________ function is display the greatest value from a group of values or expressions.
a) MAX() b) GREATEST() c) BIG() d) None
2 Mark Questions
1) Many tables can be _____ and _________ to each other.
a) created , related b) created, used c) related, Created d) None
2) Network is communication between ________ & ____________.
a) Data & Information b) Server & Client c) Table & Columns d) None
3) Example of DDL Commands are ________ and __________.
a) CREATE & ALTER b) INSERT & DELETE c) GRANT & REVOKE d) None
4) Example of DML Commands are ________ and __________.
a) CREATE & ALTER b) INSERT & DELETE c) GRANT & REVOKE d) None
5) Example of DCL Commands are ________ and __________.
a) CREATE & ALTER b) INSERT & DELETE c) GRANT & REVOKE d) None
6) Maximum table name is ______ and Maximum database name is ________.
a) 30 , 8 b) 8,30 c) No limit d) None
7) Delete from _____ where _______.
a) Condition , Table Name b) Table Name, Condition c) Table Name, value d) None
8) Select _______ from ____________;
a) Column Name, Table Name b) Table Name, Column Name
c) Table Name, Value d) None
9) Transaction commands are ______ & __________.
a) SELECT, DELETE b) UPDATE , COMMIT c) ROLLBACK, COMMIT d) None
10) _________ table will contain only one record and _______ table will contain record.
a) Transaction, Master b) Master, Transaction c) Master, Master d) None
11) Maximum size of Char data type is ______ and varchar2(w) maximum width is ______ bytes.
a) 255 & 2000 b) 2000 & 255 c) 255 & 1 d) None
4 Mark Questions
1) Match the following
1. Relation a) Columns
2. Attributes b) Rows
3. Tuples c) Table
a) 1-a 2-b 3-c b) 1-c 2-a 3-b c) 1-a 2-c 3-b d) None
2) Find out the technical names in the place of Question Mark symbols
STUDENT 1
RNO NAME FEE 2
101 3 AAA 3400
a) 1-Table 2-Columns 3-value b) 1-Columns 2-Table 3-value
c) 1-value 2-Columns 3-table d) None
3) Oracle tools are ______ , ____________ , __________ and ___________.
a) SQL PLUS, SQL Reprot Writer , SQL Forms , Pro c
b ) SQL , MS-ACCESS, PL/SQL , Dbase
c) C, JAVA, ORACLE, SAP
d) SQL PLUS , SQLReport Writer , SQL Forms, PROC
4) Match the following
1) DBWR a) Managing various process with the database
2) LGWR b) Managing the user process connected to the database
3) PMON c) Responsible for writing data from buffer to secondary storage
4) SMON d) Write data in the Redo buffers to Redo log files
a) 1-d 2-b 3-c 4-a b)1-c 2-d 3-b 4-a c) 1-a 2-b 3-c 4-d d) None
5) Data Constraints are ________ , __________ and ___________.
a) Primary Key, Not Null, Check b) Insert, Delete , Update
c) Create , Alter , Drop d) None
6) Update ____ set ____= ___________.
a) Table Name , Column Name, Value b) Column Name, Value, Table name
c) Value, Column Name, Table Name d) None
7) Match the following
1) MAX a) Display the greatest value from group of expressions
2) MIN b) Display the least value from a group of expressions.
3) GREATEST c) Maximum value of entire column
4) LEAST d) Minimum value of entire column
a) 1-c, 2-d, 3-a, 4-b b) 1-a , 2-b , 3-c, 4-d c) 1-c,2-a,3-b,4-d d) None
8) Match the following :
1) CURRVAL a) Row Number
2) NEXTVAL b) Row Identification
3) ROWID c) Current value
4) ROWNUM d) Next Value
a) 1-a 2-b 3-c 4-d b) 1-c 2-d 3-b 4-a c) 1-d 2-a 3-b 4-c d) None
9) Match the following:
1) MOD a) returns remainder value
2) POWER b) returns the data raised to the power of value
3) ROUND c) n number of decimal places , data is rounded
4) SQRT d) returns the square root of data
a) 1-a 2-b 3-c 4-d b) 1-c 2-d 3-b 4-a c) 1-d 2-a 3-b 4-c d) None
----
ORACLE KEY (UNIT-1)
1-MARK QUESTION
1 A 2 A 3 C 4 B 5 A
6 A 7 C 8 C 9 B 10 A
11 B 12 A 13 A 14 A 15 C
16 A 17 C 18 B 19 B 20 C
21 A 22 A 23 A 24 C 25 C
26 C 27 A 28 C 29 C 30 C
31 A 32 C 33 B 34 C 35 B
36 C 37 A 38 C 39 A 40 B
2-MARKS QUESTIONS
1 A 2 B 3 A 4 B 5 C
6 A 7 B 8 A 9 C 10 B
11 A
4-MARKS QUESTIONS
1 B 2 A 3 D 4 B 5 A
6 A 7 A 8 B 9 A
---
UNIT - 2
1) _______ command is used to modify the structure of a table.
a) Alter b) Update c) Modify d) None
2) __________ command is used to produce summary information for the rows of a table.
a) Update b) Delete c) Group By d) None
3) ___________ table is a logical table.
a) View b) Database c) Sequence d) None
4) ALTER command is fall in _______ category.
a) DML b) DCL c) DDL d) None
5) ____________ is the command to change the SEQUENCE increment by 2.
a) ALTER SEQUENCE acme INCREMENT BY 2;
b) ALTER TABLE SEQUNCE acme INCREMENT BY 2;
c) ALTER SEQUENCE acme ADDING BY 2;
d) None
6) All constraints are stored in _________ table.
a) ORACLE_CONSTRAINTS b) DBA_CONSTRAINTS c) USER_CONSTRAINTS d) None
7) __________ is the command to change the password.
a) ALTER b) CHANGE c) UPDATE d) None
8) The __________ clause does not sort the data.
a) GROUP BY b) WHERE c) SELECT d) None
9) _________ is the command to create a SEQUENCE named acme .
a) CREATE TABLE SEQUENCE acme START WITH 2000 INCREMENT BY 1;
b) CREATE SEQUENCE acme START WITH 2000 INCREMENT BY 1;
c) CREATE SEQUENCE acme STARTING WITH 2000 INCREMENT BY 1;
d) None
10) _________ will generate the next number in sequence acme.
a) NEXTVAL b) CURVAL c) LEVEL d) None
11) A ________ is a query within a query.
a) sub query b) condition c) both d) None
12) The nested query must return a _________ column.
a) Single b) Multiple c) No values d) None
13) The ________ operator can not be used with a sub query.
a) BETWEEN b) IN c) AND d) None
14) The _________ command is used to copy the rows from one new table to another table.
a) CREATE TABLE SALDUP AS SELECT FROM SALARY;
b) INSERT INTO SALDUP AS SELECT FROM SALARY;
c) CREATE TABLE SALDUP AS CREATE FROM SALALRY;
d) None
15) _________ returns all rows returned by either query-eliminates duplicate rows.
a) UNION b) INTERSECT c) MINUS d) None
16) _________ returns all rows returned by either query-does not eliminates duplicate rows.
a) UNION b) INTERSECT c) UNION ALL d) None
17) _________ returns all distinct rows returned by both queries. i.e a row must exist in both query outputs to be returned in the final result.
a) UNION b) INTERSECT c) UNION ALL d) None
18) __________ produces rows returned by the first query but not the second.
a) UNION b) INTERSECT c) MINUS d) None
19) Formatted reorts can be generated by storing the _________ commands in a file.
a) SQLPLUS b) SQL c) PROC d) None
20) _________ command is to execute the file to get the report.
a) START file name b) GET filename c) LOAD filename d) None
21) Set pagesize default value is ______________
a) 14 b) 20 c) 50 d) None
22) Set linesize default value is _______
a) 14 b) 80 c) 50 d) None
23) Set wrap default value is ___________
a) ON b) OFF c) NULL d) None
24) ________ tells SQL plus that the words to follow to be treated as comments and not as instructions.
a) REMARK b) Note c) d) None
25) _______ makes SQL plus calculate subtotals.
a) compute sum b) compute total c) calculate sum d) None
26) _______ set the top title for each page of the report.
a) T title b) B title c) Break on d) None
27) _______ set the bottom title for each page of the report.
a) T title b) B title c) Break on d) None
28) _______ move a report into a file , which can be later printed.
a) Spool b) Save c) Host d) None
29) _________ saves the SQL query have created into the file .
a) Spool b) Save c) Host d) None
30) ___________ is the command to suppressed the feedback message. Ex. 10 rows selected.
a) Set feedback off b) Set heading off c) Set t title off d) None
31) SET FEEDBACK OFF statement is typed at the ____________ of the program.
a) End b) Beginning c) Center d) None
32) SET FEEDBACK ON statement is typed at the ____________ of the program.
a) End b) Beginning c) Center d) None
33) The _________ option will print a blank one line after group of related rows are printed and before printing the rows for the next group.
a) SKIP 1 b) JUMP 1 c) MOVE 1 d) None
34 ) __________ are logical tables of data extracted from the existing table.
a) Views b) Database c) Sequence d) None
35) _____________ is the command to create a view table.
a) Create table view acme as select from emp; b) Create view acme as select from emp;
c) Create view table acme as select from emp; d) None
36) ___________ is the command to see the all view tables.
a) USER_VIEWS b) VIEW_TABLE c) TABLE_VIEW d) None
37) ________ is used to store the data in a variable.
a) Prompt b) Accept c) Store d) None
38) __________ is used to display message to the user.
a) Prompt b) Accept c) Store d) None
39) _______ is suppresses the display as we type the reply.
a) Hide b) secret c) a & b d) None
40) The SQLPLUS variable can be created using the ______ command.
a) Define b) Store c) Prompt d) None
41) ________ symbol is used for passing the parameters to command files from the command line.
a) & b) + c) % d) None
42) ___________ variables are variables which can be used to communicate from a PL/SQL block to SQL PLUS.
a) Bind Variable b) Local Variable c) Global Variable d) None
43) _____________ is the command to display the list of bind variables.
a) Variable
c) Define
2 MARK BITS
1) By using ALTER command , we can _______ and ________ columns.
a) Add and Modify b) Delete and Add c) a & b d) None
2) _________ and ___________ statements which allows interactive input.
a) ACCEPT and INPUT b) ACCEPT and PROMPT c) CURSOR and PRINT d) None
3) We can not ________ and _____________ columns of the table.
a) DELETE and RENAME b) ADD and DROP c) MODIFY and DELETE` d) None
4) __________ is the command to remove the PRIMARY KEY .
a) ALTER -- DROP b) UPDATE – DROP c) MODIFY - DELETE d) None
5) _____________ is the command to add NOT NULL constraint to EMP table.
a) ALTER TABLE EMP MODIFY NAME NOT NULL;
b) ALTER TABLE EMP UPDATE NAME NOT NULL;
c) ALTER TABLE EMP CHANGE NAME NOT NULL;
d) None
6) ____________ is the command to drop the check constraint named 'acme of the EMP table.
a) ALTER TABLE EMP DROP CONSTRAINT acme;
b) ALTER TABLE EMP DELETE CONSTRAINT acme;
c) ALTER TABLE EMP REMOVE CONSTRAINT acme;
d) None
7) ________ is useful for specifying a condition for the group . ______ is used to specify conditions to retrieve rows of a table.
a) HAIVNG, WHERE b) WHERE, HAVING c) ORDER BY , WHERE d) None
8) By default TTITLE is _______ aligned and BTITLE is _______ aligned.
a) left, centered b) Centered , Left c) left, right d) None
9) VIEW can not be updated if it contains ____________ and __________.
a) Group functions and Joins b) update and select
c) Distinct and order by d) None
.
4 MARK BITS
1) _______ , ___________ and ___________ constraint type is a single character in USER_CONTRAINT Table.
a) P , R and C b) A, B and C c) C, U and D d) None
2) ___________ is the command to display the sum salary of Each employee.
a) SELECT SUM(SAL) FROM EMP GROUP BY EMPNO;
b) SELECT TOTAL(SAL) FROM EMP GROUP BY EMPNO;
c) SELECT SUM(SAL) FROM EMP HAVING EMPNO;
d) None
3) The nested query must return a single row when a standard operator such as ____, _______ and ______ is used.
a) = , > , < b) and , or , in c) and , between, or d) None
4) Sub queries can also be used in ________, ___________ and ________ Statements.
a) INSERT, UPDATE, DELETE b) ALTER , DROP , COMMIT
c) CREATE, INSERT, DROP d) None
5) Match the following :
Command Definition
1. Set Linesize a) Set the maximum no. of characters on any line
2. Set pagesize b) Set the maximum no. of lines per page.
3. Set newpage c) Set the no. of blank lines between pages.
4. Set headsep d) Set the heading separator identifies the single character.
a) 1-a 2-b 3-c 4-d b) 1-b 2-c 3-a 4-d c) 1-d 2-a 3-c 4-b d) None
---
Key For Unit 2
1 a 2 c 3 a 4 c 5 a 6 c
7 a 8 a 9 b 10 a 11 a 12 a
13 a 14 a 15 a 16 c 17 b 18 c
19 a 20 a 21 a 22 b 23 a 24 a
25 a 26 a 27 b 28 a 29 b 30 b
31 b 32 a 33 34 A 35 B 36 a
37 b 38 a 39 a 40 a 41 a 42 a
43 a
2-marks
1 a 2 b 3 a 4 a 5 a 6 a
7 a 8 9 a
4-mark
1 a 2 a 3 4 a 5 a
1) In PL/SQL, PL stands for ______________
a) Programming Language b) Procedural Language c) Pascal Language d) None
2) In PL/SQL code is grouped into structures called __________.
a) Block b) Body c) Structure d) None
3) __________ provides customized handling of error conditions.
a) Exception Handling b) Error Handling c) Mistakes Handling d) None
4) If a SELECT statement is used in a PL/SQL program, __________ rows can be retrieved .
a) Only one b) Multiple c) Two d) None
5) In ORACLE, __________ are used to retrieve an arbitrary number of rows with a SELECT statement.
a) SELECT b) CURSORS c) UPDATE d) None
6) A __________ defines an action the database should take when some database related even occurs.
a) Trigger b) Function c) Procedure d) None
7) ___________ are executed by the database when commands like insert , update and delete are used on the tables.
a) Trigger b) Function c) Procedure d) None
8) PL/SQL support the use of sub programs named ________ and _______.
a) Procedures and Functions b) oracle tools c) a &b d) None
9) A PL/SQL ___________ performs some action and accept optional parameters.
a) Function b) Procedure c) Cursors d) None
10) A PL/SQL ____________ returns a value of some specified datatype and can also accept optional parameters.
a) Function b) Procedure c) Cursors d) None
11) Groups of procedures and functions ,variables and other PL/SQL commands are called _____.
a) Language b) Package c) Report d) None
12) _______ provide for variable definition , assignment, selection and looping constructs for programming.
a) SQL b) SQL Report c) PL/SQL d) None
13) In __________ part , where all variables and constant declarations are made.
a) DECLARE b) BEGIN c) EXCEPTION d) None
14) In _________ area, PL/SQL statements and SQL DML statements are used.
a) DECLARE b) BEGIN c) EXCEPTION d) None
15) In _________ area, statements to be executed in case of errors.
a) DECLARE b) BEGIN c) EXCEPTION d) None
16) ___________ commands may be added, but outside the PL/SQL block.
a) SQL commands b) PL/SQL commands c) SQL PLUS commands d) None
17) In oracle , the PL/SQL block can be created by using ______ editor default.
a) EDIT b) WORDPAD c) NOTEPAD d) None
18) When we are using DBMS_OUTPUT.PUT_LINE, _________ must be ON.
a) SET SERVER ON b) SET SERVERINPUT ON c) SET SERVEROUTPUT ON d) None
19) The __________ statement is used to retrieve SINGLE ROW from a table for processing.
a) SELECT INTO b) UPDATE Table c) DELETE FROM d) None
20) In PL/SQL, Each IF statement end with ___________-.
a) END LOOP b) END IF c) END d ) None
21) __________statement is used for multiple conditions.
a) ELSIF b) LOOP c) SELECT d) None
22) The ____________ structure is used to repeatedly execute a set of statements for a certain number of times specified by a starting number and ending number.
a) FOR b) WHILE c) LOOP d) None
23) In FOR LOOP , variable incrementing automatically by _________-
a) one b) Two c) Three d) None
24) __________ is the statement to get the numbers in Reverse Order.
a) FOR I IN REVERSE 1..10 LOOP b) FOR I IN REVERSE 10..1 LOOP
c) FOR I IN 1..10 LOOP REVERSE d) None
25) In FOR loop, loop variable no need to declared
a) True b) False c) Statement is in complete d) None
26) There must be exist statement in _______ types of loop other wise it is infinity loop.
a) FOR LOOP b) LOOP – END LOOP c) WHILE LOOP d) None
27) ___________ is used in PL/SQL to declare a variable to be of the same type as a previously declared variable or to be of the same type as a column in a table.
a) %ROWTYPE b) %COLUMNTYPE c) %TYPE d) None
28) _____________ declare a variable which is actually a record which is the same structure as a row from a table .
a) %ROWTYPE b) %COLUMNTYPE c) %TYPE d) None
29) Objects of type TABLE are called _____________________.
a) PL/SQL TABLES b) SQL Tables c) TRIGGERS d) None
30) PL/SQL tables use a primary key to give you ____________access to rows.
a) Array-like b) Row-like c) Column-like d) None
31) The size of PL/SQL table is _____________.
a) Constrained b) Unconstrained c) Constant d) None
32) We can not delete individual rows from a ________ table.
a) SQL Table b) PL/SQL c) ROW table d) None
33) __________ is used to suppress the messages OLD and NEW when the program is executed.
a) SET SERVEROUTPUT OFF b) SET PROMPT OFF
c) SET VERIFY OFF d) None
34) ______________ returns the number of rows retrieved after an insert, update, delete statements.
a) SQL%ROWCOUNT b) PLSQL%ROWCOUNT c) SQL%TYPECOUNT d) None
35) ________________ system exception which are automatically raised , when the user tries to open a cursor that is already open.
a) CURSOR_ALREADY_OPEN b) STORAGE_ERROR
c) TOO_MANY_ROWS d) None
36) ________________ system exception which are automatically raised , when the user tries to insert a duplicate value into a unique column.
a) DUP_VAL_ON_INDEX b) STORAGE_ERROR c) TOO_MANY_ROWS d) None
37) ________________ system exception which are automatically raised , when the user tries to open invalid cursor or attempt an illegal cursor operation.
a) PROGRAM_ERROR b) STORAGE_ERROR c) INVALID_CURSOR d) None
38) _____________ flag become TRUE when SQL select statement failed to retrieve any rows.
a) NOT_LOGGED_ON b) PROGRAM_ERROR c) NO_DATA_FOUND d) None
39) ________________ system exception which are automatically raised , when the user hits a PL/SQL memory error.
a) STORAGE_ERROR b) PROGRAM_ERROR c) TIMEOUT_ON_RESOURCE d) None
40) ________________ system exception which are automatically raised , when the SQL select statement retrieved more than one row and it was suspended to retrieve only one row.
a) DUP_VAL_ON_INDEX b) STORAGE_ERROR c) TOO_MANY_ROWS d) None
41) ________________ system exception which are automatically raised , when the user encounters an arithmetic , conversion , truncation or constraint error.
a) DUP_VAL_ON_INDEX b) STORAGE_ERROR c) VALUE_ERROR d) None
42) ________________ system exception which are automatically raised , when the SQL select statement tries to divide a number by zero.
a) DUP_VAL_ON_INDEX b) ZERO_DIVIDE c) VALUE_ERROR d) None
43) ____________ system exception which are automatically raised to catch any error situations not coded by the programmer in the EXCEPTION section.
a) OTHERS b) VALUE_ERROR
c) PROGRAM_ERROR d) NO_DATA_FOUND
44) _______________ returns the number of rows retrieved after an insert, update , delete or a single-row select statement.
a) SQL%COLUMNCOUNT b) SQL%ROWCOUNT c) SQL%RECORDCOUNT d) None
45) _____________ are used when the SQL select statement is expected to return more than one row.
a) CURSORS b) Function c) PL/SQL TABLE d) None
46) __________ statement is to open the cursor .
a) OPEN b) BEGIN c) Automatically Open d) None
47) __________ statement is to close the cursor .
a) End cursor name b) Close cursor name c) Stop cursor name d) None
48) _____________ attribute is to determine if a row was retrieved .
a) %FOUND b) %READ c) %WRITE d) None
49) ____________ attribute returns the number of rows retrieved.
a) %ROWCOUNT b) %COUNT c) %COLUMNCOUNT d) None
50) ___________ attribute is to find if a cursor is open or not.
a) %OPEN b) %ISOPEN c) %WASOPEN d) None
51) The ___________ statement will lock the rows of that table so that another user cannot change the row before the update.
a) BEFORE UPDATE b) FOR UPDATE c) LOCKUPDATE d) None
52) The cursor for loop can be used to process __________ records.
a) Single b) two c) Multiple d) None
53) A ______________ consists of PL/SQL code, which defines some action that the database should take when some database-related event occurs.
a) Procedure b) Function c) Trigger d) None
54) _____________ is the command to create a Trigger.
a) CREATE TRIGGER b) CREATE TABLE TRIGGER
c) CREATE TRIGGERS d) None
55) __________ option crates a trigger which will be fired once for each row that is updated.
a) FOR MANY ROWS b) FOR SINGLE ROW c) FOR EACH ROW d) None
56) _________ clause is using for condition in triggering event.
a) WHERE b) WHEN c) HOW d) None
57) There can be _______ Trigger of a particular type.
a) Only One b) Many c) Two Only d) None
58) ___________ table/tables can be specified in the triggering statement.
a) Only one b) Many c) Two d) None
59) ______________ statement is used to execute the trigger.
a) RUN trigger name b) EDIT Trigger Name c) EXECUTE Trigger name d) None
60) ___________ is the command to delete the trigger.
a) DELETE TRIGGER trigger name b) ERASE TRIGGER trigger name
c) DROP TRIGGER trigger name d) None
61) ______________ is the command to disable the trigger .
a) ALTER TRIGGER trigger name DISABLE; b) UPDATE TRIGGER trigger name DISABLE;
c) MODIFY TRIGGER trigger name DISABLE; d) None
62) _____________ is the command to execute the procedure from SQL Plus.
a) RUN procedure name b) EXCECUTE PROCEDURE procedure name
c) EXECUTE procedure name d) None
63) ______________ is the command to execute procedure along with parameters.
a) RUN procedure name parameter b) EXECUTE procedure name parameter
c) OUT prcoedrename parameter d) None
64) The _________ parameter is used to pass values to the Procedure being called .
a) IN b) OUT c) IN OUT d) None
65) The _______ parameter is used to pass values out of a procedure to the caller of the procedure .
a) IN b) OUT c) IN OUT d) None
66) The ___________ parameter is used to pass values to the procedure being called and it is also used to pass values out to the called of the Procedure .
a) IN b) OUT c) IN OUT d) None
67) __________ is used to display the line number and error of the most recent compilation errors.
a) DISPLAY ERRORS b) SHOW ERRORS c) RAISE ERRORS d) None
68) The ________ are collection of SQL and PL/SQL code which can return a value to the caller.
a) PROCEDURE b) TRIGGER c) FUNCTION d) None
69) _____________ are groups of procedures , functions , variables and SQL statements in one unit.
a) Packages b) Triggers c) Exception d) None
70) Private objects may only be called by other objects within the _________.
a) same package body b) different package body c) Package specification d) None
71) The name of the package body should be the same as the name of the ______________.
a) Function b) Procedure c) package specification d) None
72) The actual code for the procedures and the function will be stored in the __________ of the package.
a) Specification b) Body c) Database d) None
73) Once a ____________ is created , the functions or procedures included in it can be executed any time until it is deleted.
a) Package b) database c) Trigger d) None
74) _____________ command is to delete the package .
a) DELETE PACKAGE packagename b) DROP PACKAGE packagename
c) ERASE PACKAGE packagename d) None
75) The source code for existing procedures, functions , packages and package bodies can be queried from the data dictionary view named ________________.
a) USER_SERVER b) USER_DATABASE c) USER_SOURCE d) None
2 MARKS QUESTIONS
1) SQL statements are used for ________ and ______________.
a) Data Manipulation and Transaction Processing b) Data modification and Data processing
c) Data removing and Data displaying d) None
2) Terminate the PL/SQL block with a ________ on a line by itself and press _________ Key.
a) / and Enter Key b) & and Ctrl Key c) @ and press Alt Key d) None
3) At the SQL prompt , execute the program by using __________ and ____________.
a) Start and Run b) / and Run
c) Start filename and @ filename d) None
4) In DBMS_OUTPUT.PUT_LINE, DBMS_OUTPUT is _________ and PUT_LINE is _______.
a) Procedure and Function b) Trigger and Function
c) System Package and Procedure name d) None
5) TOTBASIC SALARY.BASIC%TYPE ; means ________________
a) TOTBASIC will now be of the same type as BASIC column from the table SALARY.
b) TOTBASIC will now be of the same type as BASIC row from the table SALARY.
c) TOTBASIC will now be of the different type as BASIC row from the table SALARY.
d) None
6) SALREC SALARY%ROWTYPE means ______________.
a) SALREC is a record variable equivalent to the row from the table , SALARY.
b) SALREC is a record variable equivalent to the column from the table , SALARY.
c) SALREC is a record variable equivalent to the variable from the table , SALARY.
d) None
7) TYPE _______ IS TABLE OF ___________ .
a) Type name , variable %type b) Table name, %row type
c) Column name , Table name d) None
8) A cursor must be _________ before processing and __________ after processing.
a) read , write b) Open , write c) open, close d) None
9) A Trigger code can be typed at ___________ and ________________.
a) SQL Prompt, Note pad b) SQL prompt only c) Note pad only d) None
10) _______ and __________ can be made use of to refer to data on the command line and data in the table .
a):new and :old b):start , : end c):fresh, :previous d) None
11) ________ and __________ are also referred to as sub-programs as they can take parameters and be invoked.
a) Procedures and Functions b) SQL and PL/SQL c) Triggers and Exceptions d) None
12) __________ are sub programs , which will perform an action , and __________ are subprograms that are generally coded to compute some value.
a) Function and Procedures b) Triggers and Exceptions c) Procedures and Functions d) None
13) _________ is the command to Grant the execute privilege to the User.
a) GRANT EXECUTE ON procedure name TO user name
b) GRANT ON procedure name TO user name
c) PRIVILEGE EXECUTE ON procedure name TO user name
d) None
14) The RAISE_APPLICATION_ERROR takes two input parameters. They are _______ and _________.
a) function name, trigger name b) GRANT and REVOKE
c) Error number, error message d) None
15) The error number must be between _______ and _____________.
a) -1 to 2000 b) -2000 to –2099 c) -20000 and –20999 d) None
16) Advantage of creating Function and Procedures are _________ and __________.
a) Security, Performance b) easy, redundancy c) Integrity, Hiding d) None
17) To execute a procedure within a package , first line the ___________ then the _______ .
a) function name , package name b) package name , procedure name
c) function name , procedure name d) None
18) When creating package , the _________ and the ____________ are created separately.
a) Function , procedures b) Triggers, SQL commands
c) package specification, package body d) None
19) ___________ command is used for create package and __________ command is used for package specification.
a) create package , create package body b) create package new, create body of package
c) create package , create package specification d) None
20) A package specification consists of the list of _____, _______, _________ and ________ that will be available to users of the package.
a) triggers, SQL commands, PL/SQL , SQL plus commands
b) SQL commands, editor commands, SQL plus commands, pl/SQL
c) functions, procedures, cursors, exceptions
d) none
21) A package body contains the ____________ and ___________________.
a) Functions, procedures
b) Triggers, SQL commands
c) PL/SQL Block, specifications for all of the public objects listed in the package specification
d) None
4 MARKS BITS
1) A PL/SQL block is made up of 3 parts. They ______, __________ and _______________.
a) Declaration Part, Executable Part and Exception handling part
b) SQL, PL/SQL and SQL Report
c) Functions, procedure and Triggers
d) None
2) What is output of the following program.
SET SERVEROUTPUT ON
BEGIN
FOR I IN 1..10 LOOP
DBMS_OUTPUT.PUT_LINE(I);
END LOOP;
END;
a) Display 1 to 10 numbers b) Display even numbers c) Display ODD numbers d) None
3) What is output of the following program.
SET SERVEROUTPUT ON
BEGIN
FOR I IN 1..10 LOOP
IF (MOD(I,2)=0) THEN
DBMS_OUTPUT.PUT_LINE(I);
END IF;
END LOOP;
END;
a) Display 1 to 10 numbers b) Display even numbers between 1 to 10
C) Display ODD numbers between 1 to 10 D) None
4) What is output of the following program.
SET SERVEROUTPUT ON
DECLARE
I NUMBER(4) := 0;
BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE(I);
END LOOP;
END;
a) Display 1 to 10 numbers b) Display error c) Display infinite numbers d) None
5) Match the following :
Exception Meaning
1) NO_DATA_FOUND a) This flag become TRUE when SQL select statement
failed to retrieve any rows.
2) TOO_MANY_ROWS b) This flag becomes TRUE when SQL Select statement
retrieved more than one row and it was supposed to
retrieve only one row.
3) VALUE_ERROR c) This flag becomes TRUE when SQL select statement
tries to divide a number by zero.
4) ZERO_DIVIDE d) User encounter an arithmetic conversion , truncation or
constraint error.
a) 1-a 2-b 3-c 4-d b) 1-c 2-a 3-b 4-d c) 1-a 2-b 3-d 4-c d) None
6) Trigger events are __________, __________ and ___________ issued against the table.
a) Insert, delete, update b) Alter, Drop, Desc c) Create, Select, Column d) None
7) Trigger are associated with a table and are automatically fired(executed) when the user performs any ________ statement on the table.
a) DCL b) DDL c) DML d) None
8) Trigger CANNOT include __________, _____________ and ______________.
a) INSERT, UPDATE, SELECT b) COMMIT, ROLLBACK, SAVEPOINT
c) DROP , ALTER, CREATE d) None
----
Key for Unit 3
1 a 2 a 3 a 4 a 5 b 6 a
7 a 8 a 9 b 10 a 11 b 12 c
13 a 14 b 15 c 16 c 17 c 18 c
19 a 20 b 21 a 22 a 23 a 24 a
25 a 26 b 27 c 28 a 29 a 30 a
31 b 32 b 33 c 34 a 35 a 36 a
37 c 38 c 39 a 40 c 41 c 42 b
43 a 44 b 45 a 46 a 47 b 48 a
49 a 50 b 51 b 52 c 53 c 54 a
55 c 56 b 57 a 58 a 59 c 60 c
61 a 62 63 b 64 a 65 b 66 c
67 b 68 c 69 70 a 71 c 72 b
73 a 74 b 75 c
Answer- 2-marrks
1 a 2 a 3 c 4 c 5 a 6 a
7 a 8 c 9 10 a 11 a 12 c
13 a 14 15 16 a 17 b 18 c
19 a 20 c 21 c
Answer- 4-marks
1 a 2 a 3 b 4 c 5 c 6 a
7 c 8 b
UNIT – 4
OBJECTS/ BASIC DATABASE ADMINISTRATION / REMOTE DATA ACCESS
1) ORDBMS stands for ________________.
a) Object Relational Database Management System
b) Oracle Relational Database Management System
c) Object Relational Database Management Software
d) None
2) A database Administrator Responsible is _____________.
a) security and tuning of an oracle database b) creating the database user files
c) Renaming the user files d) None
3) A database Administrator commands are ______________
a) UPDATE, DELETE, CREATE b) ENAME, DROP , ALTER
c) CRETE USER, CREATE ROLE, GRANT d) None
4) _____________ stores all of the information that is used to manage objects in the database.
a) oracle data table b) Oracle Data Dictionary c) Oracle Table Space d) None
5) ___________ tell Oracle how to get from one database to another.
a) Database Links b) Database Space c) Oracle Linker d) None
6) __________ can extend relational database is include object oriented concepts & structures.
a) Oracle 6 b) Oracle 7 c) Oracle 8 d) None
7) __________ are data types that consist of one or more sub types.
a) Abstract Data Types b) Nested Table c) Varying Arrays d) None
8) A _________ is table within a tables.
a) Abstract Data Types b) Nested Table c) Varying Arrays d) None
9) A________ is a set of objects each with the same data types.
a ) Abstract Data Types b) Nested Table c) Varying Arrays d) None
10) A _________ is capable of storing large volume of data.
a) LOB b) File c) Table d) None
11) ___________ data type is used to store CLOB data for multi byte character set.
a) BLOB b) CLOB c) NCLOB d) None
12) ___________ data types is used to store character data up to 4 GB.
a) BLOB b) CLOB c) NCLOB d) None
13) ___________ data type is used for binary data.
a) BLOB b) CLOB c) NCLOB d) None
14) ___________ is pointer to an external file.
a) BLOB b) CLOB c) BFILE d) None
15) The size of the external file is limited only by ____________.
a) 2 GB b) 4 GB c) Operating System d) None
16) The column of an abstract data type are referred to as its ___________
a) attribute b) Abstract Column c) Column d) None
17) The __________ system table displays information about the attributes of a user’s abstract data types.
a) USER_TYPE_ATTRS b) USER_TAB_COLUMNS
c) USER_TYPE_ATTRIBUTES d) None
18) The __________ system table is containing about the columns within the tables and views owned by the user .
a) USER_TYPE_ATTRS b) USER_TAB_COLUMNS c) USER_TYPE_ATTRIBUTES d) None
19) A _________ method is a program that is named after the data type, its parameters are the names of the attributes defined for the data types.
a) Constructor b) Destructor c) Polymorphism d) None
20) ___________ allows us to create abstract data types within the table that already exist.
a) Object Views b) Table Views c) Data Views d) None
21) To create an object view , start with the _________ command.
a) CREATE VIEW b) CREATE TABLE VIEW c) CRATE VIEWS d) None
22) A _________ is a block of PL/SQL code used to encapsulate the data access method for an object .
a) Methods b) Trigger c) Function d) None
23) ___________ are sets of elements that are treated as part of a single row.
a) Methods b) Trigger c) Collectors d) None
24) A ____ allows us to store repeating attributes of a record in a single row.
a) Varying Arrays b) Abstract Data type c) Nested Table d) none
25) CREATE OR REPLACE TYPE COURSE_VA AS VARRAY(5) OF VARCHARS(20);
The above command is example for ___________.
a) Varying Arrays b) Abstract Data type c) Nested Table d) none
26) _________ allows repeating only those column values that change , potentially saving storage space.
a) Varying Arrays b) Abstract Data type c) Nested Table d) none
27) ____________ system table is used to view the structure along with data type.
a) USER_TAB_COLUMNS b) USER_TYPES c) USER_COLL_TYPES d) None
28) ____________ system table is used to view the abstraction data type.
a) USER_TAB_COLUMNS b) USER_TYPES c) USER_COLL_TYPES d) None
29) ____________ system table is used to view the characteristics of the varying array.
a) USER_TAB_COLUMNS b) USER_TYPES c) USER_COLL_TYPES d) None
30) To support queries of the columns and rows of a nested table, ORACLE provides a new key word ____________.
a) HAVING b) BETWEEIN c) THE d) None
31) LOB stands for ______________.
a) Large Objects b) Large Object Based c) Large Oracle Base d) None
32) Multiple LOBs can be created on a table.
a) True b) False c) Statement is not completed d) None
33) The data for ________ columns whether stored inside or outside the database, is not physically stored within the base table.
a) view b) synonym c) LOB d) None
34) LOB data can be selected and manipulated by using ______ package.
a) DBMS_OUTPUT.PUT_LINE() b) DBMS_LOB()
c) DBMS_OUTPUT.READ() d) None
35) API stand for __________
a) Application Programming Interface b) Application Package Interface
c) Application Programming Interchange d) None
36) OCI stands for __________
A )Oracle Create Interface b) Oracle Call Interface c) Oracle Column Interface d) None
37) When inserting a record into a table that consist of LOBs , use _________ package to tell ORACLE to create an empty location value for internally stored LOB columns.
a) DBMS_LOB b) DBMS_OUTPUT c) DBMS_BLOB d) None
38) _________ function is using to store empty locator value in LOB type .
a) NULL b) EMPTY_BLOB() c) EMPTY() d) None
39) The _________ function tells ORACLE exactly where to find the document file.
a) BFILE_NAME() b) FILE_NAME() c) TEXT_FILE_NAME() d) None
40) The _______ package can be used to change or select LOB values.
a) DBMS_LOB b) DBMS_OUTPUT c) DBMS_BLOB d) None
41) _______ function is used to write data into the LOB value at a specified point with in the LOB value.
a) WRITE b) scanf () c) READ d) None
42) ___________ function is used to compare two LOB values.
a) SUBSTR() b) READ() c) COMPARE d) None
43) ________ function is used to find out the length of LOB value.
a) SETLENGTH() b) GETLENGTH() c) FINDLENGTH() d) None
44) _____ procedure is used to add the contents to one LOB to another LOB.
a) APPEND b) ERASE c) TRIM d) COPY
45) ________ procedure is to remove all or part of LOB value.
a) TRIM b) ERASE c) DELETE d) None
46) _______ procedure is to remove leading spaces in LOB
a) TRIM b) ERASE c) DELETE d) None
47) __________ procedure used to open files for reading.
a) FILEOPEN b) FILESOPEN c) FILESGETNAME d) None
48) ___________ is used to open files for reading.
a) FILESOPEN b) FILESOPEN c) OPNEFILE d) None
49) __________ is used to close specific files.
a) FILECLOSEALL b) FILECLOSE c) CLOSEFILE d) None
50) ___________ procedure is to close all open files.
a) FILECLOSEALL b) FILECLOSE c) CLOSEFILE d) None
51) The _________ procedure reads a piece of a LOB value.
a) READ b) FILEREAD c) READFILE d) None
52) A _______ is an area of disk consisting of one or more disk files.
a) Table Space b) Database c) Table d) None
53) A table space can contain many ___________.
a) Tables b) indexes c) clusters d) ALL
54) Table space can be expanded by ____________
a) DBA b) Who has DBA authority c) a & b d) None
55) One or more table spaces together make up a ___________
a) Clusters b) Databases c) Table space d) None
56) Each table has a single area of disk space called __________.
a) Partition b) Table c) segment d) None
57) Every database also contains a ____________ , where the ownership records and addresses are kept.
a) Cluster b) System table space c) user table space d) None
58) The names and locations of all of the table spaces, tables , indexes , and clusters for the database is called __________.
a) Data dictionary b) View Data c) Table spaces d) None
59) The database is created and named by the ____________.
a) User b) System Administrator c) Customer d) None
60) The create ________ command allows one or more files to be assigned immediately to the table space.
a) table space b) Table c) User d) None
61) The ________ must create the users before anybody can access the database.
a) User b) DBA c) Customer d) None
62) A collection of privileges is called _________.
a) DBA b) TABLESPACE c) ROLE d) None
63) The _________ command is to give the roles to the user.
a) GRANT b) REVOKE c) ALTER d) None
64) To perform triggers and procedures , the _______ role is required.
a) Connect b) Resource c) a & b d) None
65) The Roles that are granted to any user can be revoked by the use of the _____command.
a) REMOVE b) ERASE c) REVOKE d) None
66) _______ is the command to remove the user from the database.
a) DELETE USER username b) DROP USER username
c) ERASE USER username d) None
67) __________ command is to create a substitute file name for any table.
a) SYNONYM b) VIEW c) SEQUENCE d) None
68) _______ special option is using privileges can be granted to other users.
a) WITH PREVILIGES b) WITH GRANT OPTION c) REVOKE d) None
69) ___________ command is used to connect to another user .
a) CONNECT b) GRANT c) REVOKE d) None
70) The _______ command can be used to copy a table from one schema to another.
a) CREATE b) COPY c) GRANT d) None
71) The ___________ is a set of tables and views owned by the DBA users.
a) Table Space b) Clusters c) Data Dictionary d) None
72) The _________ is a central pool of information for the ORACLE RDBMS and for the users.
a) Table Space b) Clusters c) Data Dictionary d) None
73) The __________ System table contains all users of the database.
a) ALL_USERS b) USER_CONSTRINTS c) USER_CON_COLUMNS d) None
74) The __________ System table contains all constraints of the tables.
a) ALL_USERS b) USER_CONSTRINTS c) USER_CON_COLUMNS d) None
75) The __________ System table contains name of the columns which is the primary key .
a) ALL_CONSTRAINTS b) USER_CONSTRINTS c) USER_CON_COLUMNS d) None
76) The __________ System table contains to display all tables , views, synonyms and sequence for which user is the owner.
A ) USER_CATALOG b) USER_OBJECTS c) ALL_TABLES d) None
77) The __________ System table contains to display all types of objects . i.e. clusters, database links , functions, indexes, packages, package bodies, package procedures, sequences, synonyms, tables , triggers and views.
a) USER_CATALOG b) USER_OBJECTS c) ALL_TABLES d) None
78) The ________ System table is to display in bytes the size of PL/SQL objects.
a) USER_CATALOG b) USER_OBJECTS c) USER_OBJECT_SIZE d) None
79 ) The _________ system table is to display the synonyms created by the user.
a) USER_SOURCE b) USER_SYNONYMS c) USER_TABLES d) None
80) The _______ system table is to display the text of views owned by the user.
a) USER_VIEWS b) USER_VIEW_TABLES c) USER_CATALOG d) None
81) Data base Links require _________ to be running on each of the machine involved in the remote Data access.
a) SQL Report b) SQL CALC c) SQLNET d) None
82) ________ can represent all or parts of a single table , or the result of a query against multiple tables.
a) Snapshots b) View c) Synonym d) None
83) Local copies of remote tables can be made which will improve the performance of the applications. Such local copies of remote tables is called _____.
a) Snapshots b) View c) Synonym d) None
2 MARKS QUESTIONS
1) We can enter the data into view object table in two methods . They are _______ and _____________.
a) By using Base Table b) By using Object View c) Both a & b d) None
2) Two types of collectors are available are called _______ and ____________.
a) Constructor and Destructor b) Nested Tables and Varying arrays
c) Function and Method d) None
3) The ___________ and ___________ is only maintained for internally stored outside the database.
a) Data Integrity, Data concurrency b) Data manipulation, Data removal
c) Data updating, Data dictionary d) None
4) The _________ and ___________ which must be given to users so that they can login to ORACLE.
a) SELECT, UPDATE b) DELETE , ALTER c) CONNECT, RESOURCE d) None
4 MARKS QUESTIONS
1) The Large Object datatypes available are ___, ___________ , ________ and ___________.
a) BLOB, CLOB, NCLOB , BFILE b) CREATE, ALTER , DROP , RENAME
c) DDL, DML, DCL, DTL d) None
2) MATCH THE FOLLOWING :
Data types Meaning
1) BLOB a) data type is used to store CLOB data for multi byte
character set.
2) CLOB b) data types is used to store character data up to 4 GB.
3) NCLOB c) data type is used for binary data.
4) BFILE d) pointer to an external file.
a) 1-c 2-b 3-a 4-d b) 1-a 2-b 3-c 4-d c) 1-a 2-c 3-d 4-b d) None
3) Match the following :
Function name Description
1) WRITE a) To find string in LOB
2) READ b) Writing data into LOB
3) GETLENGTH c) To read a piece of LOB value
4) INSTR d) To find out the length of LOB
a) 1-b 2-c 3-d 4-a b) 1-a 2-b 3-c 4-d c) 1-a 2-d 3-b 4-c d) None
4) Match the following :
Procedure Name Description
1) APPEND a) to remove leading spaces in LOB
2) ERASE b) to copy all or part of LOB value from one LOB column to
another .
3) TRIM c) to remove all or part of LOB value.
4) COPY d) to add the contents to one LOB to another LOB.
a) 1-d 2-c 3-a 4-b b) 1-a 2-b 3-c 4-d c) 1-b 2-a 3-d 4-c d) None
5) Match the following :
Procedure/Function Description
1) FILEOPEN a) to close the specific file.
2) FILESOPEN b) to open files for reading.
3) FILECLOSE c) to close all opened files.
4) FILECLOSEALL d) to determine if the external file is open
a) 1-d 2-c 3-a 4-b b) 1-b 2-d 3-a 4-c c) 1-b 2-a 3-d 4-c d) None
6) A collection of privileges is called a Role. There are 3 standard roles. They are ____, _________ and _________.
a) Connect, Resource, DBA b) UPDATE, DELETE, SELECT
c) DROP, ALTER, CREATE d) None
7) ___________ , __________ , __________- and ________ privileges for tables only (not for views).
a) INSERT , DELETE, SELECT , UPDATE
b) GRANT, REVOKE , DROP ,ALTER
c) ALTER, REFERENCES , INDEX, ALL
d) none
8) ___________ , __________ , __________- and ________ privileges for tables and views .
a) INSERT , DELETE, SELECT , UPDATE
a) GRANT, REVOKE , DROP ,ALTER
b) ALTER, REFERENCES , INDEX, ALL
c) None
9) Match the following :
System Table Description
1. ALL_USERS a) To find out the name of the column
which is the primary key .
2. USER_CONSTRAINTS b) To display names of all users of the database
3. USER_CONS_COLUMNS c) To display all tables, views, synonyms and
sequence of which user is the owner.
4. USER_CATALOG d) To find out it the table has a primary key .
a) 1-a 2-b 3-c 4-d b) 1-b 2-a 3-d 4-c c) 1-b 2-d 3-a 4-c d) None
-------
Key for Unit 4
1 a 2 a 3 c 4 b 5 a 6 c
7 a 8 b 9 c 10 a 11 c 12 b
13 a 14 c 15 c 16 a 17 a 18 b
19 a 20 a 21 a 22 a 23 c 24 a
25 a 26 a 27 a 28 b 29 c 30
31 a 32 a 33 c 34 b 35 a 36 b
37 a 38 a 39 a 40 a 41 c 42 b
43 a 44 b 45 a 46 a 47 a 48 b
49 a 50 a 51 a 52 d 53 c 54 b
55 c 56 b 57 a 58 b 59 a 60 b
61 c 62 a 63 b 64 c 65 b 66 a
67 b 68 a 69 b 70 c 71 c 72 a
73 b 74 c 75 a 76 b 77 c 78 a
79 c 80 a 81 a
Answers-2-marks
1 c 2 b 3 a 4 c
Answers-4-marks
1 a 2 a 3 a 4 a 5 b 6 a
7 c 8 a 9 c