Database interview preparation Quiz 2 Welcome to your Fresher Interview Preparation - Database Skills - 2 Name Email Phone Number 1. In PL/SQL Operator precedence determines the grouping of terms in an ___________.expressionexperimentalnonestatement2. The ______________ program is used to copy or back up tables and databases.mysqldumpdumpnonemysql3. PL/SQL can also directly be called from the command-line ___________.SQL*Plus interface.PlusSQLnone4. PL/SQL can handle __________ types of records:none2345. A subprogram created inside a package is a _______________ subprogram.nonepackageddatamemory6. varrays are ____________ arraysone-dimensionalthree-dimensionaltwo-dimensionalnone7. PL/SQL offers the ____________ operator for joining two strings.paddarithmeticnoneconcatenation operator8. A procedure is created with the __________________________ statement.drop procedurecreate or replace procedurenonedata procedure9. ____________ are automatically created by oracle whenever an SQL statement is executed,when there is no explicit cursor for the statement.Explicit cursorsprocedureImplicit cursorsnone10. The PL/SQL single-line comments start with the delimiter ___________single hyphen (-)datadouble hyphen (--)none11. In PL/SQL, a standalone function is created using the _____________ statementalter procedureCREATE FUNCTIONnoneprocedure12. We can use the ______________ command along with the select statement to find out uniquerecords available in a table.noneAlterDISTINCTdrop13. ____________ that acts as a wrapper around load data so that you can load the input filesdirectly from the command line.nonemysqlmysqlimportsql14. _____________ are programmers-defined cursors for gaining more control over the contextarea.Explicit cursorsprocedureImplicit cursorsnone15. .We can use the ___________ statement of sql to assign values to PL/SQL variables.noneSELECT INTOintoSelect16. PL/SQL was developed by ______________ corporation.oraclenoneAppleIBM17. In PL/SQL ____________ could be either variables or literals.datacharacternonestrings18. Multiplication operator has __________ precedence than the addition operator.nonelowerhighersame19. A standalone procedure is deleted with the _____________ statement.data procedurealter proceduredrop procedurenone20. The set of rows the cursor holds is referred to as the _____________.active setprocedurenonepassive set21. PL/SQL provides high _________ levelnonesecuritydatamemory22. _____________ is a subprograms return a single value; mainly used to compute and return avalue.memorynoneFunctionsdata23. PL/SQL offers __________ kinds of strings3none4224. The simplest way in Mysql to use sequences is to define a column as ________________.AUTOnoneAUTO_INCREMENTINCREMENT25. In PL/SQL, a _________ is same as a procedure except that it returns a value.nonefunctionmemorydata26. The simplest way of exporting a table data into a text file is by using the _________________.IntononestatementSELECT ..INTO STATEMENT27. PERL and PHP scripts provide ______________ functions to retrieve the auto incrementedvalue of the last record.noneinclusivedataexclusive28. If the record is a duplicate, then the ___________ keyword tells Mysql to discard it silentlywithout generating an error.keyworddatanoneIGNORE29. 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 _____________.InjectionSQL InjectionDatabasenone30. By default, all the temporary tables are deleted by MYSQL when your database connection gets________.submitavaiableterminatednone31. The __________ is a SQL function, so you can use it from within any client that understandshow to issue SQL statements.DATEnoneLAST_INSERT_ID()LAST32. When a subprogram calls itself, it is referred to as a recursive call and the process is known as_____________.noneredorecursionrecursive33. PL/SQL controls the context area through a _________.nonecursorrowscolumns34. ____________ is a subprograms which do not return a value directly; mainly used to performan action.functionsnonememoryProcedures35. The PL/SQL ________ single-line and multi-line comments.supports only single-linedo not supportssupportsnone36. PL/SQL provides ________ kinds of subprograms:none21337. There are __________ types of variable scope in PL/SQL42none338. PL/SQL provides a ____________ record type that allows you to define the different recordstructures.nonememory-defineduser-defineddata-defined39. A standalone procedure can be called in _______ waysrenone34240. In PL/SQL, a _____________ is a data structure that can hold data items of different kinds.classprocedurerecordnone41. By default, _____________ are not case-sensitive.memorynoneidentifiersdata42. ______________ is a combination of SQL along with the procedural features of programminglanguages.PL/SQLEL/DSAnoneTL/SAL43. We can use a ___________ or a _____________ on a table with the appropriate fields to stopduplicate records.data and memoryvalue and functionPrimary key and unique indexnone44. An ___________ is an error condition during a program execution.compliationprocedurenoneexception45. There are _______ types of cursor3none4246. The PL/SQL programming language provides a data structure called the ___________ whichcan store a fixed-size sequential collection of elements of the same type.VARRAYARRAYnoneDARRAY47. A varray type is created with the ___________________ statement.createnonetypeCREATE TYPE48. Maximum size of a varray can be changed using the ____________ statement.createalter typenonedrop49. The _____________ attribute enables a programmer to create table-based and cursorbasedrecords.%COLUMNTYPEnone%data%ROWTYPE50. The starting index for varrays is always _______1none02Please fill in the comment box below. Time is Up!