Database interview preparation Quiz 2 Welcome to your Fresher Interview Preparation - Database Skills - 2 Name Email Phone Number 1. PL/SQL offers the ____________ operator for joining two strings.concatenation operatorarithmeticpaddnone2. PERL and PHP scripts provide ______________ functions to retrieve the auto incrementedvalue of the last record.exclusivedatanoneinclusive3. The PL/SQL ________ single-line and multi-line comments.nonesupports only single-linesupportsdo not supports4. There are __________ types of variable scope in PL/SQL4none325. ______________ is a combination of SQL along with the procedural features of programminglanguages.PL/SQLnoneEL/DSATL/SAL6. A subprogram created inside a package is a _______________ subprogram.memorynonedatapackaged7. In PL/SQL ____________ could be either variables or literals.datacharacternonestrings8. By default, all the temporary tables are deleted by MYSQL when your database connection gets________.avaiableterminatednonesubmit9. By default, _____________ are not case-sensitive.datamemorynoneidentifiers10. The __________ is a SQL function, so you can use it from within any client that understandshow to issue SQL statements.noneLASTLAST_INSERT_ID()DATE11. PL/SQL offers __________ kinds of strings43none212. When a subprogram calls itself, it is referred to as a recursive call and the process is known as_____________.recursiverecursionnoneredo13. PL/SQL provides high _________ leveldatanonememorysecurity14. In PL/SQL, a _________ is same as a procedure except that it returns a value.functionmemorydatanone15. An ___________ is an error condition during a program execution.noneprocedurecompliationexception16. PL/SQL provides ________ kinds of subprograms:13none217. The _____________ attribute enables a programmer to create table-based and cursorbasedrecords.%datanone%ROWTYPE%COLUMNTYPE18. Multiplication operator has __________ precedence than the addition operator.lowersamehighernone19. PL/SQL can handle __________ types of records:none24320. Maximum size of a varray can be changed using the ____________ statement.nonealter typedropcreate21. In PL/SQL, a standalone function is created using the _____________ statementalter procedurenoneprocedureCREATE FUNCTION22. varrays are ____________ arraysone-dimensionalnonethree-dimensionaltwo-dimensional23. PL/SQL provides a ____________ record type that allows you to define the different recordstructures.data-definednoneuser-definedmemory-defined24. The ______________ program is used to copy or back up tables and databases.mysqldumpdumpmysqlnone25. In PL/SQL, a _____________ is a data structure that can hold data items of different kinds.procedurenonerecordclass26. ____________ that acts as a wrapper around load data so that you can load the input filesdirectly from the command line.nonemysqlmysqlimportsql27. If you take user input through a webpage and insert it into a MySQL database, there's a chancethat you have left yourself wide open for a security issue known as _____________.DatabaseInjectionSQL Injectionnone28. If the record is a duplicate, then the ___________ keyword tells Mysql to discard it silentlywithout generating an error.nonekeyworddataIGNORE29. _____________ are programmers-defined cursors for gaining more control over the contextarea.Implicit cursorsnoneExplicit cursorsprocedure30. PL/SQL can also directly be called from the command-line ___________.PlusSQLnoneSQL*Plus interface.31. We can use the ______________ command along with the select statement to find out uniquerecords available in a table.DISTINCTnonedropAlter32. _____________ is a subprograms return a single value; mainly used to compute and return avalue.noneFunctionsdatamemory33. In PL/SQL Operator precedence determines the grouping of terms in an ___________.nonestatementexpressionexperimental34. A standalone procedure can be called in _______ waysre34none235. We can use a ___________ or a _____________ on a table with the appropriate fields to stopduplicate records.Primary key and unique indexvalue and functiondata and memorynone36. The simplest way of exporting a table data into a text file is by using the _________________.SELECT ..INTO STATEMENTstatementnoneInto37. .We can use the ___________ statement of sql to assign values to PL/SQL variables.noneintoSelectSELECT INTO38. The PL/SQL programming language provides a data structure called the ___________ whichcan store a fixed-size sequential collection of elements of the same type.noneDARRAYVARRAYARRAY39. The PL/SQL single-line comments start with the delimiter ___________double hyphen (--)single hyphen (-)nonedata40. A standalone procedure is deleted with the _____________ statement.nonealter proceduredata proceduredrop procedure41. ____________ are automatically created by oracle whenever an SQL statement is executed,when there is no explicit cursor for the statement.Explicit cursorsImplicit cursorsprocedurenone42. The starting index for varrays is always _______2none1043. PL/SQL controls the context area through a _________.nonerowscolumnscursor44. The simplest way in Mysql to use sequences is to define a column as ________________.noneAUTO_INCREMENTAUTOINCREMENT45. A procedure is created with the __________________________ statement.drop procedurecreate or replace proceduredata procedurenone46. The set of rows the cursor holds is referred to as the _____________.passive setnoneactive setprocedure47. There are _______ types of cursor4none3248. A varray type is created with the ___________________ statement.nonetypecreateCREATE TYPE49. PL/SQL was developed by ______________ corporation.noneAppleoracleIBM50. ____________ is a subprograms which do not return a value directly; mainly used to performan action.noneProceduresmemoryfunctionsPlease fill in the comment box below. Time is Up!