1. MPPSC DBMS MCQ

Some Objective Que and Ans.

QuestionID  :  17836         Subject Name  DBT

Q1. UPDATE OR DELETE ON SOCCER_FAN_SNACKS. Which two of the following keywords may be useful in your trigger source code to distinguish what should run, and when?

1.  truncating

2.  updating

3.  deleting

4.  B) and C)

Correct Answer : 4

4

QuestionID  :  17867         Subject Name  DBT

Q2. Consider the following where clause WHERE A.no=B.no(+) The above outer join lists

1.  All matching and non-matching rows of table B

2.  All matching and non-matching rows of table A

3.  All non-matching rows of table B

4.  All non-matching rows of table A

Correct Answer : 2

4

QuestionID  :  17875         Subject Name  DBT

Q3. The address of the Oracle name server is contained in

1.  listener.ora

2.  tnsnames.ora

3.  init.ora

4.  sqlnet.ora

Correct Answer : 4

QuestionID  :  17977         Subject Name  DBT

Q4. Level of Abstraction,describes what data are stored in database and what relationship among these data.

1.  Physical

2.  Logical

3.  View

4.  None of above

Correct Answer : 2

QuestionID  :  18052         Subject Name  DBT

Q5. Which is not a built-in package in Oracle

1.  DBMS_STANDARD

2.  DBMS_BFILE

3.  DBMS_LOB

4.  DBMS_OUTPUT

Correct Answer : 2

QuestionID  :  18076         Subject Name  DBT

Q6. The limit of level of nesting is _________ subqueries in SQL

1.  255

2.  1024

3.  1000

4.  2000

Correct Answer : 1

QuestionID  :  18094         Subject Name  DBT

Q7. Which of the following operation cannot be performed on VIEWS defined from Multiple Tables(which have been created with referencing clause)

1.  INSERT

2.  DELETE

3.  UPDATE

4.  MODIFY

Correct Answer : 1

QuestionID  :  18113         Subject Name  DBT

Q8. A Sub-Query can not have a _______ clause and a ________ of selects.

1.  groupby,For update

2.  orderby,having

3.  orderby,For update

4.  orderby,groupby

Correct Answer : 3

QuestionID  :  18151         Subject Name  DBT

Q9. Raw data type can store maximum up to

1.  1024 bytes

2.  255 bytes

3.  2 GB

4.  None of Above

Correct Answer : 2

QuestionID  :  18182         Subject Name  DBT

Q10. Words used in PL/SQL block are called_______.

1.  Lexical Units

2.  block units

3.  grammer

4.  non of these

Correct Answer : 1

QuestionID  :  18227         Subject Name  DBT

Q11. A ________ can be used to provide a surrogate key in a table that doesnot have a primary key of its own.

1.  procedure

2.  sequence

3.  function

4.  reference key

Correct Answer : 2

QuestionID  :  18237         Subject Name  DBT

Q12. __________ is used for error trapping in PL/SQL blocks.

1.  Error handling section

2.  Exception_init()

3.  Exception section

4.  None

Correct Answer : 3

QuestionID  :  18252         Subject Name  DBT

Q13. The NOWAIT optional Keyword works for

1.  Implicit cursors only

2.  Explicit cursor only

3.  Both 1) and 2)

4.  None of the above

Correct Answer : 1

QuestionID  :  18264         Subject Name  DBT

Q14. -----puts piece of information in package buffer followed by an end of line marker.

1.  DBMS_OUTPUT

2.  PUT_LINE

3.  serveroutput

4.  none

Correct Answer : 2

QuestionID  :  18308         Subject Name  DBT

Q15. type of data in database

1.  actual data

2.  system data

3.  overhed data

4.  all

Correct Answer : 4

QuestionID  :  18391         Subject Name  DBT

Q16. When a TRIGGER is fired the statement inside the TRIGGERs PL/SQL code block can also fire same or some other TRIGGER .

Correct Answer : T

QuestionID  :  18398         Subject Name  DBT

Q17. The ORDER BY clause whenever used should always be the last clause of an SQL query

Correct Answer : T

QuestionID  :  18442         Subject Name  DBT

Q18. dbms is interface between data and application program

Correct Answer : T

QuestionID  :  18451         Subject Name  DBT

Q19. An attribute that functionally determines all the other attributes of the table is necessarily a Candidate key for that table.

Correct Answer : T

QuestionID  :  18462         Subject Name  DBT

Q20. It is required to resolve all the tertiary relations into binary relations while mapping the entities into tables in case of ER Diagram

Correct Answer : T

QuestionID  :  18501         Subject Name  DBT

Q21. The name of the table can be changed with ALTER command.

Correct Answer : F

QuestionID  :  18553         Subject Name  DBT

Q22. In SQL identifiers can contain up to 30 characters and start with an alphabetic character.

Correct Answer : T

QuestionID  :  18555         Subject Name  DBT

Q23. Function SYSTIMESTAMP report the system date with time jone of the database

Correct Answer : T

QuestionID  :  18564         Subject Name  DBT

Q24. primary key is Compulsory in Table

Correct Answer : F

QuestionID  :  18571         Subject Name  DBT

Q25. In oracle to test a condition not equal to which operator is used

Correct Answer : T

QuestionID  :  18590         Subject Name  DBT

Q26. union clause can be used in sub-queries.

Correct Answer : F

QuestionID  :  18597         Subject Name  DBT

Q27. ROOT function returs square root of a numeric value

Correct Answer : F

QuestionID  :  18599         Subject Name  DBT

Q28. the LENGTH function return the length of a word

Correct Answer : T

QuestionID  :  18607         Subject Name  DBT

Q29. user data in oracle database is logically strored in data files

Correct Answer : F

QuestionID  :  18612         Subject Name  DBT

Q30. Truncate is a DDL command and delete is a DML command

Correct Answer : T

QuestionID  :  18688         Subject Name  DBT

Q31. PL/SQL extends SQL by adding control structures found in other procedural language.

Correct Answer : T

QuestionID  :  18712         Subject Name  DBT

Q32. If a variable or a cursor is declared in package specification then it is global.

Correct Answer : T

QuestionID  :  18743         Subject Name  DBT

Q33. DDL commands can be used in PL/SQL block.

Correct Answer : F

QuestionID  :  18775         Subject Name  DBT

Q34. server places commit record in the log buffer.

Correct Answer : T

QuestionID  :  18814         Subject Name  DBT

Q35. The Oracle engine will process all rows in a table and display the result only when none of the condition specified using the NOT operator are satisfied.

Correct Answer : T

QuestionID  :  18817         Subject Name  DBT

Q36. COUNT(expr) function returns the number of rows where expr is not null.

Correct Answer : T

QuestionID  :  18844         Subject Name  DBT

Q37. The DBMS_LOBpackage is used to manipulate LOBs.

Correct Answer : T

QuestionID  :  18872         Subject Name  DBT

Q38. Only one exclusive lock can be placed on a resourse at a time.

Correct Answer : T

QuestionID  :  18879         Subject Name  DBT

Q39. Oracle detects the dedlock automatically and solves the problem by aborting one of the two transactions.

Correct Answer : T

QuestionID  :  18901         Subject Name  DBT

Q40. It is not possible to manipulate index partitions.

Correct Answer : F

QuestionID  :  18904         Subject Name  DBT

Q41. Packages enable the overloading of procedures and functions when required.

Correct Answer : T

QuestionID  :  18919         Subject Name  DBT

Q42. Clusters can reduce the performance of UPDATE statements as compared with storing a table separately with its own index.

Correct Answer : F

QuestionID  :  18923         Subject Name  DBT

Q43. User data in an Oracle database is logically stored in the data files.

Correct Answer : F

QuestionID  :  18927         Subject Name  DBT

Q44. The NOCYCLE keyword specifies that a sequence can generate more values after reaching the maximum value.

Correct Answer : F

QuestionID  :  18948         Subject Name  DBT

Q45. In an SQL syntax the AUTOTRACE report is printed before the statement has successfully completed.

Correct Answer : F

QuestionID  :  18966         Subject Name  DBT

Q46. An abstract datatype cannot be used to create an object table.

Correct Answer : F

QuestionID  :  18975         Subject Name  DBT

Q47. Nested tables and varying arrays are not embedded objects.

Correct Answer : F

QuestionID  :  18977         Subject Name  DBT

Q48. The DISPLAY[MODE] attribute controls whether SQL*PLUS lists the old and new settings of a SQL*PLUS systems variable when user changes the setting with SET.

Correct Answer : F

QuestionID  :  18981         Subject Name  DBT

Q49. Object views allow the development of OO features within a relational database.

Correct Answer : T

QuestionID  :  18985         Subject Name  DBT

Q50. In the TRIMS[POOL] attribute OFF parameter disallows SQL*PLUS to include trailing blanks.

Correct Answer : F

QuestionID  :  17813         Subject Name  DBT

Q1. Which statement most accurately describes the result of not creating an exception handler for a raised exception?

1.  The program will continue without raising the exception.

2.  There will be a memory leak.

3.  Control will pass to the PL/SQL block caller’s exception handler.

4.  The program will return a %notfound error.

Correct Answer : 3

3

QuestionID  :  17858         Subject Name  DBT

Q2. The default parameter type in stored procedures is

1.  IN

2.  OUT

3.  INOUT

4.  There is no default type

Correct Answer : 1

4

QuestionID  :  17870         Subject Name  DBT

Q3. When both the Oracle name server as well as tnsnames.ora file is used simultaneously, the priority between the two is resolved by

1.  listener.ora

2.  tnsnames.ora

3.  init.ora

4.  sqlnet.ora

Correct Answer : 4

QuestionID  :  17871         Subject Name  DBT

Q4. Consider a table OLD with few rows. The statement CREATE TABLE new AS SELECT * FROM OLD WHERE 1=2

1.  copies all the rows from OLD to NEW

2.  creates a dummy NEW table

3.  creates an empty NEW table with column definitions same as OLD

4.  creates a table NEW that acts as a synonym for OLD

Correct Answer : 3

QuestionID  :  17943         Subject Name  DBT

Q5. Choose the Incorrect option related to DBMS

1.  There is no Security of data

2.  Not support distributed database

3.  satisfy more than 8 rule of Dr. E.F. Codd

4.  None

Correct Answer : 3

QuestionID  :  17947         Subject Name  DBT

Q6. Latest version of ORACLE is called

1.  ORACLE 9i

2.  ORACLE 10i

3.  ORACLE 11i

4.  ORACLE 10G

Correct Answer : 4

QuestionID  :  17987         Subject Name  DBT

Q7. The Maximum size of Raw Datatype is:

1.  1000 bytes

2.  2000 bytes

3.  4000 bytes

4.  8000 bytes

Correct Answer : 2

QuestionID  :  18019         Subject Name  DBT

Q8. Choose correct one

1.  rollup and cube are grouping type of statements for sql query

2.  rollup and cube are inbuilt functions for sql query

3.  rollup and cube are not related to oracle

4.  none of the above

Correct Answer : 1

QuestionID  :  18025         Subject Name  DBT

Q9. The number of BLOB column allowed in Oracle table is

1.  1

2.  255

3.  1024

4.  Unlimited

Correct Answer : 1

QuestionID  :  18041         Subject Name  DBT

Q10. Choose the correct pattern Matching sign for matching a single character.

1.  _

2.  ?

3.  *

4.  %

Correct Answer : 1

QuestionID  :  18075         Subject Name  DBT

Q11. The correct syntax of DECODE stament is...

1.  DECODE(if1,then1,if2,then2...else)

2.  DECODE(if1,then1,else1,if2,then2,else2...)

3.  DECODE(value,if1,then1,else1,if2,then2,else2....)

4.  none of the above

Correct Answer : 4

QuestionID  :  18078         Subject Name  DBT

Q12. Which operator, when used along with special operators, reverts their output?

1.  NOT

2.  AND

3.  OR

4.  JOIN

Correct Answer : 1

QuestionID  :  18088         Subject Name  DBT

Q13. Which lock allows multiple users to see the data but not change it

1.  exclusive locks

2.  mutative locks

3.  shared locks

4.  table locks

Correct Answer : 3

QuestionID  :  18170         Subject Name  DBT

Q14. A procedure which return a value is called as...

1.  Procedure

2.  Function

3.  Package

4.  None of these

Correct Answer : 2

QuestionID  :  18183         Subject Name  DBT

Q15. Data stored in the curser is called as ------.

1.  active data

2.  stored data

3.  active data set

4.  user defined data

Correct Answer : 2

QuestionID  :  18189         Subject Name  DBT

Q16. In which areas of PL/SQL block must code be placed in order to handle Oracle-defined exceptions?

1.  Declaration section only

2.  Declaration and executable section only

3.  Exception handler only

4.  Declaration,executable and exception handler sections

Correct Answer : 3

QuestionID  :  18192         Subject Name  DBT

Q17. Which procedure can be used to create a customised error message.

1.  RAISE_ERROR

2.  SQLERRM

3.  RAISE_APPLICATION_ERROR

4.  RAISE_SERVER_ERROR

Correct Answer : 3

QuestionID  :  18197         Subject Name  DBT

Q18. procedure and functions are explicitely executed.This is different from database trigger.When is a database trigger executed

1.  when transaction is commited

2.  during the data manipulation statement

3.  when an oracle supplied package references the trigger

4.  during a data manipulation statement and when transaction is commited

Correct Answer : 2

QuestionID  :  18238         Subject Name  DBT

Q19. _________ Collection of stored procedures and functions.

1.  Functions

2.  Procedures

3.  Triggers

4.  Package

Correct Answer : 4

QuestionID  :  18244         Subject Name  DBT

Q20. A procedure declares a user defined exception but does not raise it explicitly. Which of the following statements is true about this function?

1.  User defined exception will never be raised.

2.  User defined exception will be handled by a WHEN OTHERS exception handler.

3.  The procedure will fail on compile

4.  A user defined exception is defined incorrectly

Correct Answer : 1

QuestionID  :  18335         Subject Name  DBT

Q21. Cleaning up temporary segments that are no longer in in use is done by __________

1.  LGWR

2.  PMON

3.  DBWR

4.  SMON

Correct Answer : 4

QuestionID  :  18339         Subject Name  DBT

Q22. Actual data of oracle is stored in ________

1.  SYSTEM tablespace

2.  DATA tablespace

3.  USER tablespace

4.  TOOL tablespace

Correct Answer : 2

QuestionID  :  18381         Subject Name  DBT

Q23. System Recovery and System Restore are same

Correct Answer : F

QuestionID  :  18409         Subject Name  DBT

Q24. Both an SQL query as well as a PL/SQL code is interpreted in Oracle

Correct Answer : F

QuestionID  :  18426         Subject Name  DBT

Q25. The inner joins(or equi joins) is same as natural joins.

Correct Answer : T

QuestionID  :  18443         Subject Name  DBT

Q26. The data Structure used in Hierachical Model of DBMS is "tree".

Correct Answer : T

QuestionID  :  18502         Subject Name  DBT

Q27. Char conserves memory as compared to varchar.

Correct Answer : T

QuestionID  :  18524         Subject Name  DBT

Q28. oracle by default creates an index on every unique column of a table

Correct Answer : T

QuestionID  :  18542         Subject Name  DBT

Q29. The date function that returns a numerical value is ADD_MONTHS

Correct Answer : F

QuestionID  :  18564         Subject Name  DBT

Q30. primary key is Compulsory in Table

Correct Answer : F

QuestionID  :  18576         Subject Name  DBT

Q31. All table columns belong to a single record.

Correct Answer : T

QuestionID  :  18581         Subject Name  DBT

Q32. Group function can not be use in WHERE clause.

Correct Answer : T

QuestionID  :  18582         Subject Name  DBT

Q33. we can perform Insert,Update,Delete operation on Views defined from Multiple Tables(which have no referencing clause).

Correct Answer : F

QuestionID  :  18583         Subject Name  DBT

Q34. A new coloumn can always be added in a table but a coloumn can be drop only oracle8i onwards.

Correct Answer : T

QuestionID  :  18594         Subject Name  DBT

Q35. the oracle engine will process all rows in a table and dispaly the result only when none of the conditions specified using the NOT operator are satisfied

Correct Answer : T

QuestionID  :  18610         Subject Name  DBT

Q36. the autoexted attribute enables or disables the automatic extension of the data files

Correct Answer : T

QuestionID  :  18617         Subject Name  DBT

Q37. State true or false. EXISTS,SOME,ANY are operators in SQL

Correct Answer : T

QuestionID  :  18664         Subject Name  DBT

Q38. the put_line function is available in IO package in oracle

Correct Answer : F

QuestionID  :  18714         Subject Name  DBT

Q39. COUNT(expr)function returns the number of rows where expr is not null

Correct Answer : T

QuestionID  :  18733         Subject Name  DBT

Q40. The "%FOUND" , "%NOTFOUND" and "%ISOPEN" attribute of cursors are boolean.

Correct Answer : T

QuestionID  :  18769         Subject Name  DBT

Q41. The "i" in oracle8i stands for "improved".

Correct Answer : F

QuestionID  :  18785         Subject Name  DBT

Q42. user can do DML action on synonym but can not perform DDL action except Dropping synonym

Correct Answer : T

QuestionID  :  18788         Subject Name  DBT

Q43. data files,control files,redo log files are physical files

Correct Answer : T

QuestionID  :  18831         Subject Name  DBT

Q44. NOT NULL causes creation of variable or constant that can not have null value.

Correct Answer : T

QuestionID  :  18852         Subject Name  DBT

Q45. A ROLLBACK statement at the SQL prompt is used to make permanent changes.

Correct Answer : F

QuestionID  :  18856         Subject Name  DBT

Q46. A Rollback statement cannot be used to close a transaction.

Correct Answer : F

QuestionID  :  18865         Subject Name  DBT

Q47. The close statement disables the cursor and the active set becomes undefined.

Correct Answer : T

QuestionID  :  18872         Subject Name  DBT

Q48. Only one exclusive lock can be placed on a resourse at a time.

Correct Answer : T

QuestionID  :  18931         Subject Name  DBT

Q49. The OFFLINE attribute makes the table space available immediately after creation to users who have been granted access to table spacs.

Correct Answer : F

QuestionID  :  18951         Subject Name  DBT

Q50. If the user wants to grant privileges to other user, the user need not be the owner of the object.

Correct Answer : F

QuestionID  :  17811         Subject Name  DBT

Q1. The Tool used to create package is called as ____

1.  SQL

2.  SQL *PLUS

3.  Both

4.  Nono of the above

Correct Answer : 2

QuestionID  :  17822         Subject Name  DBT

Q2. After executing an UPDATE statement, the developer codes a PL/SQL block to perform an operation based on SQL%ROWCOUNT. What data is returned by the SQL%ROWCOUNT operation?

1.  A Boolean value representing the success or failure of the update

2.  A numeric value representing the number of rows updated

3.  A VARCHAR2 value identifying the name of the table updated

4.  A LONG value containing all data from the table

Correct Answer : 2

QuestionID  :  17853         Subject Name  DBT

Q3. Rollback and Commit affect

1.  Only DML statements

2.  Only DDL statements

3.  Both (a) and (b)

4.  All statements executed in SQL*PLUS

Correct Answer : 1

QuestionID  :  17864         Subject Name  DBT

Q4. The value of INSTR(‘CALIFORNIA’,’A’,1,2) is

1.  2

2.  1

3.  10

4.  9

Correct Answer : 3

QuestionID  :  17879         Subject Name  DBT

Q5. The number of users that can be handled by Oracle 8i server is approximately

1.  5000

2.  10000

3.  1000

4.  100000

Correct Answer : 2

QuestionID  :  17939         Subject Name  DBT

Q6. An entity is an

1.  object with physical existence

2.  object with conceptual existence

3.  both

4.  none

Correct Answer : 3

QuestionID  :  17962         Subject Name  DBT

Q7. A table having only one attribute as a key is always in ______________.

1.  First Normal Form

2.  Second Normal Form

3.  Third Normal Form

4.  None of these

Correct Answer : 2

QuestionID  :  17981         Subject Name  DBT

Q8. Needs of Normalisation are

1.  Improves database design

2.  Ensures minium redundancy of data

3.  Removes anomalies

4.  All above

Correct Answer : 4

QuestionID  :  17984         Subject Name  DBT

Q9. In E-R Notation, multivalued attribute is represented by _______.

1.  Ellipse

2.  Dotted-Ellipse

3.  Double-Ellipse

4.

Correct Answer : 3

QuestionID  :  17999         Subject Name  DBT

Q10. A view of database that appears to an application program is known as?

1.  Report

2.  subscheme

3.  structure

4.  Meta Data

Correct Answer : 2

QuestionID  :  18000         Subject Name  DBT

Q11. Which of the following statement is not valid for the view in SQL.

1.  All view can not be updated

2.  The view may be referenced in an SQL statement whenever tables are referenced

3.  The views are instatiated at the time they are referenced and not when they are defined

4.  The definition of the view should not inclued the GROUP BY clause.

Correct Answer : 4

QuestionID  :  18074         Subject Name  DBT

Q12. What is the difference between SQL99 and SQL3.

1.  SQL99 is a predecessor of SQL3

2.  SQL99 is a successor of SQL3

3.  both are one and the same

4.  none of the above

Correct Answer : 3

QuestionID  :  18079         Subject Name  DBT

Q13. Oracle can handle queries with depth of up to 255 levels.

1.  TRUE

2.  FALSE

3.

4.

Correct Answer : 1

QuestionID  :  18149         Subject Name  DBT

Q14. What is the order of execution of SQL clauses 1.having 2.group by 3.where 4.orderby

1.  1 2 3 4

2.  3 2 1 4

3.  2 3 4 1

4.  4 3 1 2

Correct Answer : 2

QuestionID  :  18178         Subject Name  DBT

Q15. The max length of varchar2 when used in table is

1.  16k

2.  32k

3.  4k

4.  either B or C

Correct Answer : 3

QuestionID  :  18180         Subject Name  DBT

Q16. Implicit and Explicit cursor has attribute

1.  %ISOPEN

2.  %WASFOUND

3.  %COLCOUNT

4.  none of these

Correct Answer : 1

QuestionID  :  18241         Subject Name  DBT

Q17. Which of the following trigger types will be impacted by constraining factors brought on by mutating tables

1.  row triggers only

2.  statement trigger only

3.  both statement and row triggers

4.  neither row or statement triggers

Correct Answer : 1

QuestionID  :  18265         Subject Name  DBT

Q18. DBMS does not have --- model

1.  hierarchical model

2.  network model

3.  relational model

4.  hybrid model

Correct Answer : 4

QuestionID  :  18268         Subject Name  DBT

Q19. Which of the following statement is true about implicit cursors

1.  implicit cursors are used for SQL statements that are not named.

2.  implicit cursors are no longer a feature in oracle

3.  both

4.  all

Correct Answer : 1

QuestionID  :  18275         Subject Name  DBT

Q20. The maximum number of triggers(of different types) that can be created in Oracle 8i is

1.  12

2.  >13

3.  13

4.  >12

Correct Answer : 2

QuestionID  :  18324         Subject Name  DBT

Q21. A block from database buffer cache is marked as --- when modified.

1.  Dirty

2.  Modified

3.  Mod

4.  none of above

Correct Answer : 1

QuestionID  :  18338         Subject Name  DBT

Q22. Data Dictionary is also known as _________

1.  SYSTEM tablespace

2.  USER tablespace

3.  DATA tablespace

4.  TOOL tablespace

Correct Answer : 1

QuestionID  :  18382         Subject Name  DBT

Q23. All binary relations are in BCNF

Correct Answer : T

QuestionID  :  18414         Subject Name  DBT

Q24. A single trigger can be used for handling Insert/delete/update on a table

Correct Answer : T

QuestionID  :  18438         Subject Name  DBT

Q25. The most serious drawback in the ER model is that it can not depict relationships

Correct Answer : T

QuestionID  :  18446         Subject Name  DBT

Q26. The size of column in table cannot be decreased once a value is inserted in it

Correct Answer : T

QuestionID  :  18463         Subject Name  DBT

Q27. When there are overlapping CANDIDATE KEYS in a relation then the relation is said to be in BCNF(Boyce Codd Normal Form).

Correct Answer : T

QuestionID  :  18478         Subject Name  DBT

Q28. In Oracle, When U type a query, it instantly converts the table and column names to uppercase,& then checks for them in the dictionary.

Correct Answer : T

QuestionID  :  18522         Subject Name  DBT

Q29. The UNIQUE and FOREGIN keys cannot have NULL values

Correct Answer : F

QuestionID  :  18577         Subject Name  DBT

Q30. count(expr) returns the number of rows where expr is not null

Correct Answer : T

QuestionID  :  18579         Subject Name  DBT

Q31. A subquery can contain order by and for update of clauses.

Correct Answer : F

QuestionID  :  18589         Subject Name  DBT

Q32. Is it possible to create SYNONYM for function

Correct Answer : T

QuestionID  :  18674         Subject Name  DBT

Q33. PL/SQL supports boolean data type.

Correct Answer : T

QuestionID  :  18698         Subject Name  DBT

Q34. the NOCACHE attribute is used for specifying LOB storage area

Correct Answer : F

QuestionID  :  18702         Subject Name  DBT

Q35. A Cursor is a handle,or pointer to the context area.

Correct Answer : T

QuestionID  :  18723         Subject Name  DBT

Q36. Procedures and functions can be overloaded inside package

Correct Answer : T

QuestionID  :  18736         Subject Name  DBT

Q37. Triggers are fired implicitly

Correct Answer : T

QuestionID  :  18760         Subject Name  DBT

Q38. Database service information is avilable in listners.ora file

Correct Answer : T

QuestionID  :  18775         Subject Name  DBT

Q39. server places commit record in the log buffer.

Correct Answer : T

QuestionID  :  18826         Subject Name  DBT

Q40. The LENGTH function returns the length of a word.

Correct Answer : T

QuestionID  :  18854         Subject Name  DBT

Q41. The SAVEPOINT attribute in the ROLLBACK statement is optional and is used to rollback partial transaction,as far as the specified savepoint.

Correct Answer : T

QuestionID  :  18875         Subject Name  DBT

Q42. The select...for update can be used with set operators and group by clause.

Correct Answer : F

QuestionID  :  18893         Subject Name  DBT

Q43. An Oracle Exception handler can be redirected to the executable section of the procedure or function.

Correct Answer : F

QuestionID  :  18898         Subject Name  DBT

Q44. A function or a procedure can return only one value to the calling PL/SQL code block.

Correct Answer : F

QuestionID  :  18908         Subject Name  DBT

Q45. Trigers are fired implicitly.

Correct Answer : T

QuestionID  :  18917         Subject Name  DBT

Q46. Clusters can used to store data from different tables in the same physical data blocks.

Correct Answer : T

QuestionID  :  18918         Subject Name  DBT

Q47. The PL/SQL block in the trigger can not contain transaction control SQL statements i.e. COMMIT,ROLLBACK,and SAVEPOINT.

Correct Answer : T

QuestionID  :  18965         Subject Name  DBT

Q48. The FLAGGER checks to make sure that SQL statements conform to the ANSI/ISO SQL92 standard.

Correct Answer : T

QuestionID  :  18978         Subject Name  DBT

Q49. The data for BLOB,CLOB and NCLOB datatype is stored outside the database.

Correct Answer : F

QuestionID  :  18982         Subject Name  DBT

Q50. The TRIMS[POOL] attribute determines whether SQL*PLUS allows trailing blanks at the end of each spooled line.

Correct Answer : T

QuestionID  :  17836         Subject Name  DBT Q1. UPDATE OR DELETE ON SOCCER_FAN_SNACKS. Which two of the following keywords may be useful in your trigger source code to distinguish what should run, and when?      1.  truncating      2.  updating      3.  deleting      4.  B) and C)      Correct Answer : 4       4 QuestionID  :  17843         Subject Name  DBT Q2. The keys that can have NULL values are      1.  Primary Key      2.  Unique Key      3.  Foreign Key      4.  Both b and c      Correct Answer : 4       QuestionID  :  17860         Subject Name  DBT Q3. Oracle 8i can be best described as      1.  Object-based DBMS      2.  Object-oriented DBMS      3.  Object-relational DBMS      4.  Relational DBMS      Correct Answer : 3       QuestionID  :  17864         Subject Name  DBT Q4. The value of INSTR(‘CALIFORNIA’,’A’,1,2) is      1.  2      2.  1      3.  10      4.  9      Correct Answer : 3       QuestionID  :  17872         Subject Name  DBT Q5. Oracle 8i runs on      1.  Windows NT      2.  UNIX      3.  Solaris      4.  (a), (b) and (c)      Correct Answer : 4       QuestionID  :  17879         Subject Name  DBT Q6. The number of users that can be handled by Oracle 8i server is approximately      1.  5000      2.  10000      3.  1000      4.  100000      Correct Answer : 2       QuestionID  :  17883         Subject Name  DBT Q7. The name of the only column in the DUAL table is      1.  X      2.  C      3.  DUMMY      4.  None of these      Correct Answer : 3       QuestionID  :  17911         Subject Name  DBT Q8. we need Denormalization mainly for      1.  better performance      2.  memory wastage      3.  reduce time complexity      4.  reduce space complexity      Correct Answer : 1       QuestionID  :  17926         Subject Name  DBT Q9. _______________ Edition of ORACLE is used for Notebook computers(Laptops).      1.  Personal Edition      2.  Standard Edition      3.  Enterprise Edition      4.  Oracle Lite      Correct Answer : 4       QuestionID  :  17927         Subject Name  DBT Q10. Symbol used to denote derived attribute in ER Diagram is      1.  Diamond      2.  Ellipse      3.  Dotted Ellipse      4.  Rectangle      Correct Answer : 3       QuestionID  :  17932         Subject Name  DBT Q11. The Candidate key which is not a Primary key is called as_______      1.  Super Key      2.  Froeign Key      3.  Alternate Key      4.  None of above      Correct Answer : 3       QuestionID  :  17934         Subject Name  DBT Q12. DML statements in a query language are translated into low level instruction by_________.      1.  Embeded DML Compiler      2.  DML Compiler      3.  Query Processor      4.  Query Evaluation Engine      Correct Answer : 2       QuestionID  :  17955         Subject Name  DBT Q13. Microsoft Access identifies the columns(attributes) as:      1.  table      2.  record      3.  field      4.  tuples      Correct Answer : 3       QuestionID  :  17962         Subject Name  DBT Q14. A table having only one attribute as a key is always in ______________.      1.  First Normal Form      2.  Second Normal Form      3.  Third Normal Form      4.  None of these      Correct Answer : 2       QuestionID  :  17971         Subject Name  DBT Q15. -----requires no transitive dependaecy.      1.  First normal form      2.  second normal form      3.  Third normal form      4.  BCNF      Correct Answer : 3       QuestionID  :  17977         Subject Name  DBT Q16. Level of Abstraction,describes what data are stored in database and what relationship among these data.      1.  Physical      2.  Logical      3.  View      4.  None of above      Correct Answer : 2       QuestionID  :  17981         Subject Name  DBT Q17. Needs of Normalisation are      1.  Improves database design      2.  Ensures minium redundancy of data      3.  Removes anomalies      4.  All above      Correct Answer : 4       QuestionID  :  18012         Subject Name  DBT Q18. Which is not a Set operator.      1.  Union      2.  Intersect      3.  Join      4.  Minus      Correct Answer : 3       QuestionID  :  18015         Subject Name  DBT Q19. Which command is used to change or modify data values in a table?      1.  modify      2.  alter      3.  change      4.  None of above      Correct Answer : 1       QuestionID  :  18024         Subject Name  DBT Q20. In a query with GROUP BY clause , the column in SELECT clause      1.  must be aggregate function      2.  must appear in GROUP BY clause      3.  both (1) and (2)      4.  can be selected arbitrarily      Correct Answer : 3       QuestionID  :  18038         Subject Name  DBT Q21. Which of the following operators has the highest precedence?      1.  Arithmetic      2.  Comparison      3.  Logical      4.  All have same precedence      Correct Answer : 2       QuestionID  :  18048         Subject Name  DBT Q22. How many types of join are there      1.  3      2.  6      3.  5      4.  4      Correct Answer : 4       QuestionID  :  18049         Subject Name  DBT Q23. which of the following is auto committed      1.  insert      2.  delete      3.  update      4.  truncate      Correct Answer : 4       QuestionID  :  18056         Subject Name  DBT Q24. Which SQL commands are used to create,modify and delete database structure but not data?      1.  DDL      2.  DML      3.  DCL      4.  DQL      Correct Answer : 1       QuestionID  :  18063         Subject Name  DBT Q25. the SQL*pluse environment variable are grouped according to their __________      1.  functionaly      2.  both      3.  portable      4.  none      Correct Answer : 1       QuestionID  :  18087         Subject Name  DBT Q26. EDIT or ED command places the contents of the query buffer in a file named _____ by default      1.  AFEIDT.BUF      2.  ATFIED.BUF      3.  AFIEDT.BUF      4.  AETIED.BUF      Correct Answer : 3       QuestionID  :  18091         Subject Name  DBT Q27. Which constraint state prevents new data that violates the constraint from being entered, but allows invalid data to exist in the table?      1.  ENABLE VALIDATE      2.   DISABLE VALIDATE      3.  ENABLE NOVALIDATE      4.  DISABLE NOVALIDATE      Correct Answer : 3       QuestionID  :  18100         Subject Name  DBT Q28. The table that defines the primary key and is referenced by the foreign key is called _____________      1.  primary table      2.  master table      3.  all of the above      4.  none of the above.      Correct Answer : 3       QuestionID  :  18102         Subject Name  DBT Q29. INITCAP(sunbeam) returns      1.  sUNBEAM      2.  SUNBEAM      3.  SunBEAM      4.  Sunbeam      Correct Answer : 4       QuestionID  :  18165         Subject Name  DBT Q30. The SOCCER_FANS table has a trigger associated with it that inserts data into SOCCER_FANS_SNACKS whenever rows are inserted into SOCCER_FANS. A foreign key constraint exists between FAN_ID on SOCCER_FANS and SOCCER_FANS_SNACKS. What happens when the trigger fires?      1.  The trigger processes normally      2.  The trigger invalidates      3.  The trigger execution fails because of a mutating or constraining table      4.  The trigger execution succeds because the trigger is a statement trigger      Correct Answer : 3       QuestionID  :  18180         Subject Name  DBT Q31. Implicit and Explicit cursor has attribute      1.  %ISOPEN      2.  %WASFOUND      3.  %COLCOUNT      4.  none of these      Correct Answer : 1       QuestionID  :  18192         Subject Name  DBT Q32. Which procedure can be used to create a customised error message.      1.  RAISE_ERROR      2.  SQLERRM      3.  RAISE_APPLICATION_ERROR      4.  RAISE_SERVER_ERROR      Correct Answer : 3       QuestionID  :  18203         Subject Name  DBT Q33. For which trigger timing can U reference NEW and OLD qualifiers      1.  statement and Row      2.  Statment only      3.  Row only      4.  Oracle forms Trigger      Correct Answer : 3       QuestionID  :  18209         Subject Name  DBT Q34. The RAISE_APPLICATION_ERROR() procedure defines error returned in which of the following numeric ranges.      1.  -00000 and -99999      2.  -01200 and -01299      3.  -00030 and -00039      4.  -20000 and -20999      Correct Answer : 4       QuestionID  :  18219         Subject Name  DBT Q35. Procedure have parameters like      1.  IN      2.  OUT      3.  INOUT      4.  ALL OF ABOVE      Correct Answer : 4       QuestionID  :  18222         Subject Name  DBT Q36. _________ are masks placed upon tables.      1.  Views      2.  Sequences      3.  Tables      4.  Indexes      Correct Answer : 1       QuestionID  :  18259         Subject Name  DBT Q37. SGA stands For --------      1.  Source Group Area      2.  Shared Group Area      3.  Shared Global Area      4.  Source Group Area      Correct Answer : 3       QuestionID  :  18268         Subject Name  DBT Q38. Which of the following statement is true about implicit cursors      1.  implicit cursors are used for SQL statements that are not named.      2.  implicit cursors are no longer a feature in oracle      3.  both      4.  all      Correct Answer : 1       QuestionID  :  18295         Subject Name  DBT Q39. The number of user that can be handled by Oracle 8i server is approximately      1.  5000      2.  10000      3.  1000      4.  100000      Correct Answer : 2       QuestionID  :  18297         Subject Name  DBT Q40. Background process used to recover process failure is ________      1.  lgwr      2.  smon      3.  pmon      4.  arch      Correct Answer : 3       QuestionID  :  18309         Subject Name  DBT Q41. store procedure is store in ____________      1.  data dictionary      2.  library cache      3.  log buffer chache      4.  none      Correct Answer : 2       QuestionID  :  18345         Subject Name  DBT Q42. Standard port number at which oracle server listens for client request is      1.  8080      2.  7071      3.  1521      4.  1999      Correct Answer : 4       QuestionID  :  18365         Subject Name  DBT Q43. 2NF applies only to the tables with composite primary keys      Correct Answer : T       QuestionID  :  18378         Subject Name  DBT Q44. Reserved words of SQL can be used.      Correct Answer : T       QuestionID  :  18394         Subject Name  DBT Q45. Predefined exceptions need not be declared but need to be raised explicitly.      Correct Answer : F       QuestionID  :  18399         Subject Name  DBT Q46. The size of a column in a table cannot be decreased once a value is inserted in it      Correct Answer : T       QuestionID  :  18403         Subject Name  DBT Q47. ROWID is the only pseudo column in any Oracle table      Correct Answer : F       QuestionID  :  18429         Subject Name  DBT Q48. The database files are fixed in size and never grow bigger than the size at which they were created      Correct Answer : T       QuestionID  :  18430         Subject Name  DBT Q49. The Redo log files are fixed in size and never grow bigger than the size at which they were created      Correct Answer : T       QuestionID  :  18433         Subject Name  DBT Q50. Oracle reserved words can be used for naming a table.      Correct Answer : F       QuestionID  :  18440         Subject Name  DBT Q51. Two oracle blocks have same address      Correct Answer : T       QuestionID  :  18441         Subject Name  DBT Q52. Truncate removes all records from a table,including all spaces allocated for the records are removed.      Correct Answer : T       QuestionID  :  18456         Subject Name  DBT Q53. Business rules, which are enforced on data begin stored in a table are called Constraints.      Correct Answer : T       QuestionID  :  18469         Subject Name  DBT Q54. Attribute is a property which describe the entity      Correct Answer : T       QuestionID  :  18470         Subject Name  DBT Q55. When implementing object relational database applications,the relational database design methods are first used      Correct Answer : T       QuestionID  :  18481         Subject Name  DBT Q56. Referential Integrity states that primary key cannot have Null value.      Correct Answer : F       QuestionID  :  18521         Subject Name  DBT Q57. the join that combines every row(no matter matching or nonmatching)of both the tables is a full join      Correct Answer : T       QuestionID  :  18531         Subject Name  DBT Q58. DECODE is a value by value substitution      Correct Answer : T       QuestionID  :  18535         Subject Name  DBT Q59. user can not do DDL actions on synonym      Correct Answer : T       QuestionID  :  18543         Subject Name  DBT Q60. !=,<>,^= all denote same operation      Correct Answer : T       QuestionID  :  18544         Subject Name  DBT Q61. In order to select data that is within a range of values, the "IN BETWEEN" operator is used      Correct Answer : F       QuestionID  :  18547         Subject Name  DBT Q62. Minus operator returns all distinct rows selected by first query.      Correct Answer : T       QuestionID  :  18552         Subject Name  DBT Q63. SQL is a language that provides an interface to relational database systems.      Correct Answer : T       QuestionID  :  18580         Subject Name  DBT Q64. Generally Denormalisation is used when there is data warehousing      Correct Answer : T       QuestionID  :  18597         Subject Name  DBT Q65. ROOT function returs square root of a numeric value      Correct Answer : F       QuestionID  :  18646         Subject Name  DBT Q66. In Oracle all group functions ignore nulls.      Correct Answer : F       QuestionID  :  18681         Subject Name  DBT Q67. Scope of cursor parameters is local to that cursor only.      Correct Answer : T       QuestionID  :  18691         Subject Name  DBT Q68. Can PL/SQL application work on window if there is no oracle installed      Correct Answer : F       QuestionID  :  18713         Subject Name  DBT Q69. Row level trigger execute once for any number of rows executed.      Correct Answer : F       QuestionID  :  18719         Subject Name  DBT Q70. Userdefined cursors are called as implicit cursors.      Correct Answer : F       QuestionID  :  18732         Subject Name  DBT Q71. If PL/SQL code block are used for loading and calculating variables, then the power of oracle engine is used .      Correct Answer : F       QuestionID  :  18737         Subject Name  DBT Q72. You can even create trigger to prevent users from dropping their own tables      Correct Answer : T       QuestionID  :  18738         Subject Name  DBT Q73. You can call strored procedures within the triggers      Correct Answer : T       QuestionID  :  18751         Subject Name  DBT Q74. Only INSTEAD OF Trigger can be applied to view      Correct Answer : T       QuestionID  :  18777         Subject Name  DBT Q75. BEFORE and AFTER apply to only the statement triggers.      Correct Answer : F       QuestionID  :  18793         Subject Name  DBT Q76. All table columns belong to a single record.      Correct Answer : T       QuestionID  :  18794         Subject Name  DBT Q77. In the insert into SQL sentence table columns & values have a one to many relationship.      Correct Answer : F       QuestionID  :  18795         Subject Name  DBT Q78. The SELECT DISTINCT SQL syntax scans through entire rows, & eliminates rows that have exactly the same contents in each column .      Correct Answer : T       QuestionID  :  18798         Subject Name  DBT Q79. The MODIFY command is used to change or modify data values in a table.      Correct Answer : F       QuestionID  :  18805         Subject Name  DBT Q80. Oracle ignores any UNIQUE ,FOREIGN KEY ,CHECK constraints on a NULL value.      Correct Answer : T       QuestionID  :  18810         Subject Name  DBT Q81. The USER_CONSTRAINTS command displays only the column names,data type ,size and the NOT NULL constraint.      Correct Answer : T       QuestionID  :  18820         Subject Name  DBT Q82. The second parameter in the ROUND function specifies the number of digits after the decimal point.      Correct Answer : T       QuestionID  :  18827         Subject Name  DBT Q83. Actual data manipulation,retrieval,looping and branching constructs are specified in the declare section.      Correct Answer : F       QuestionID  :  18831         Subject Name  DBT Q84. NOT NULL causes creation of variable or constant that can not have null value.      Correct Answer : T       QuestionID  :  18832         Subject Name  DBT Q85. The string literals should not be enclosed with in single quotes.      Correct Answer : F       QuestionID  :  18870         Subject Name  DBT Q86. The Oracle engine places shared lock on a table or a specific sections of the tables resourses when data is being return to a table.      Correct Answer : F       QuestionID  :  18875         Subject Name  DBT Q87. The select...for update can be used with set operators and group by clause.      Correct Answer : F       QuestionID  :  18883         Subject Name  DBT Q88. Data files are the files used by the Oracle engine to store user data.      Correct Answer : T       QuestionID  :  18907         Subject Name  DBT Q89. Recompiling a package does not recompile all objects defined within package.      Correct Answer : F       QuestionID  :  18908         Subject Name  DBT Q90. Trigers are fired implicitly.      Correct Answer : T       QuestionID  :  18912         Subject Name  DBT Q91. The order in which data is retrieved is dependent upon the indexes created on the table.      Correct Answer : T       QuestionID  :  18934         Subject Name  DBT Q92. The NOCACHE attribute is used for specifying LOB storage area.      Correct Answer : F       QuestionID  :  18939         Subject Name  DBT Q93. In ALTER SNAPSHOT the FORCE parameter causes the system to first try a FAST , and if this is not possible,then a COMPLETE.      Correct Answer : T       QuestionID  :  18945         Subject Name  DBT Q94. The AUTOT[RACE] {OFF|TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]] attributes displays report on execution of sucessful SQL DML statemnt(SELECT ,INSERT,UPDATE OR DELETE).      Correct Answer : T       QuestionID  :  18949         Subject Name  DBT Q95. BLO[CKTERMINATOR] sets the non-alphanumeric character used to end PL/SQL blocks to character expression.      Correct Answer : T       QuestionID  :  18957         Subject Name  DBT Q96. SQLBL[ANKLINES] attributes controls whether SQL*Plus blank lines within a SQL command.      Correct Answer : T       QuestionID  :  18959         Subject Name  DBT Q97. SQLN[UMBER] attribute sets the prompt for the second and subsequent lines of a SQL command or PL/SQL block.      Correct Answer : T       QuestionID  :  18979         Subject Name  DBT Q98. A row object is same as a column objects.      Correct Answer : F       QuestionID  :  18986         Subject Name  DBT Q99. A datatype describes data, it does not store data.      Correct Answer : T       QuestionID  :  18989         Subject Name  DBT Q100. When implementing object-relational database application, the relational database design methods are first used.      Correct Answer : T       QuestionID  :  17815         Subject Name  DBT Q1. If left out, which of the following would cause an infinite loop to occur in a simple loop?      1.  loop      2.  end loop      3.  if-then      4.  exit      Correct Answer : 4       QuestionID  :  17858         Subject Name  DBT Q2. The default parameter type in stored procedures is      1.  IN      2.  OUT      3.  INOUT      4.  There is no default type      Correct Answer : 1       QuestionID  :  17875         Subject Name  DBT Q3. The address of the Oracle name server is contained in      1.  listener.ora      2.  tnsnames.ora      3.  init.ora      4.  sqlnet.ora      Correct Answer : 4       QuestionID  :  17885         Subject Name  DBT Q4. Comments in a PL/SQL code are inserted using      1.  –      2.  /* */      3.  Both (a) and (b)      4.  #      Correct Answer : 3       QuestionID  :  17895         Subject Name  DBT Q5. The DUAL table has      1.  One row many columns      2.  One column and many Rows      3.  One row and One Column      4.  Many Rows and many columns      Correct Answer : 3       QuestionID  :  17933         Subject Name  DBT Q6. Table whice contain Foreign Key is called Master table      1.  True      2.  False      3.        4.        Correct Answer : 2       QuestionID  :  17944         Subject Name  DBT Q7. Behaviour "Either all ... or nothing" is given by      1.  Aggregation      2.  Atomicity      3.  Integrity      4.  Durability      Correct Answer : 2       QuestionID  :  17958         Subject Name  DBT Q8. Which of the following is not correct regarding E-R notations.      1.  Diamond is used for Entity.      2.  Ellipse is used for Attribute.      3.  Line is used for link.      4.  Dotted Ellipse is used for Derived Attributes.      Correct Answer : 1       QuestionID  :  17980         Subject Name  DBT Q9. Number of Tuples present in Table at any Instance is called      1.  Record      2.  Intension      3.  Extension      4.  count      Correct Answer : 4       QuestionID  :  17986         Subject Name  DBT Q10. Which is the highest level of abstraction      1.  Physical      2.  Logical      3.  View      4.  None of the above      Correct Answer : 3       QuestionID  :  18004         Subject Name  DBT Q11. The pricipal means of identifying entities whin an entity set in a relational dataset is?      1.  Tuples      2.  Pointer      3.  Primary Key      4.  Record      Correct Answer : 3       QuestionID  :  18006         Subject Name  DBT Q12. ____________ makes a string of certain length by adding a certain set of charcters to the left      1.  LTRIM      2.  LPAD      3.  SUBSTR      4.  INSTR      Correct Answer : 2       QuestionID  :  18012         Subject Name  DBT Q13. Which is not a Set operator.      1.  Union      2.  Intersect      3.  Join      4.  Minus      Correct Answer : 3       QuestionID  :  18033         Subject Name  DBT Q14. which of following is not a set operator      1.  union      2.  union all      3.  subtract      4.  Intersect      Correct Answer : 3       QuestionID  :  18060         Subject Name  DBT Q15. Identifiers in SQL can contain upto ____ characters.      1.  255      2.  30      3.  1000      4.  none      Correct Answer : 2       QuestionID  :  18069         Subject Name  DBT Q16. The sql query to retrieve current time in oracle is....      1.  select systime from dual      2.  select sysdata from dual      3.  select To_Char(sysDate,hh:m!:ss) from dual      4.  select To_Char(sysDate,hh:mm:ss) from dual      Correct Answer : 4       QuestionID  :  18075         Subject Name  DBT Q17. The correct syntax of DECODE stament is...      1.  DECODE(if1,then1,if2,then2...else)      2.  DECODE(if1,then1,else1,if2,then2,else2...)      3.  DECODE(value,if1,then1,else1,if2,then2,else2....)      4.  none of the above      Correct Answer : 4       QuestionID  :  18084         Subject Name  DBT Q18. Whenever a coloum on which the indexing is done is used in WHERE clause, oracle autometically uses _________ search method.      1.  Sequential      2.  Birary      3.  Any of these      4.  None      Correct Answer : 2       QuestionID  :  18097         Subject Name  DBT Q19. Using ALTER TABLE which of the following operation on table is not possible      1.  ADD      2.  MODIFY      3.  DROP      4.  All are possible      Correct Answer : 4       QuestionID  :  18116         Subject Name  DBT Q20. SQL command can be terminated by ________________.      1.  semicolon      2.  slash      3.  blank line      4.  All of the above      Correct Answer : 4       QuestionID  :  18144         Subject Name  DBT Q21. when you create a synonym, when does oracle check for the validity of the object for which you are creating the synonym?      1.  at the time of before creation of the synonym      2.  after creation of the synonym      3.  when the object is accessed via the synonym      4.  only when you alter the synonym      Correct Answer : 3       QuestionID  :  18158         Subject Name  DBT Q22. what are the symbols that have special meaning to PL/SQL      1.  Delimiters      2.  block      3.  begin      4.  end      Correct Answer : 1       QuestionID  :  18160         Subject Name  DBT Q23. Which of the following Is not a command used to control the the cursor      1.  open      2.  process      3.  fetch      4.  close      Correct Answer : 2       QuestionID  :  18164         Subject Name  DBT Q24. Procedure and function are store in _____________      1.  oracle database      2.  RAM      3.  HDD      4.  none      Correct Answer : 1       QuestionID  :  18165         Subject Name  DBT Q25. The SOCCER_FANS table has a trigger associated with it that inserts data into SOCCER_FANS_SNACKS whenever rows are inserted into SOCCER_FANS. A foreign key constraint exists between FAN_ID on SOCCER_FANS and SOCCER_FANS_SNACKS. What happens when the trigger fires?      1.  The trigger processes normally      2.  The trigger invalidates      3.  The trigger execution fails because of a mutating or constraining table      4.  The trigger execution succeds because the trigger is a statement trigger      Correct Answer : 3       QuestionID  :  18182         Subject Name  DBT Q26. Words used in PL/SQL block are called_______.      1.  Lexical Units      2.  block units      3.  grammer      4.  non of these      Correct Answer : 1       QuestionID  :  18184         Subject Name  DBT Q27. An Oracle-defined exception is raised by      1.  the PL/SQL raise statement      2.  In the PL/SQL exception handler      3.  Automatically by Oracle      4.  By the user      Correct Answer : 3       QuestionID  :  18194         Subject Name  DBT Q28. The data that is stored in the cursor is called ________      1.  RecordSet      2.  ActiveDataSet      3.  Both A and B      4.  None of the Above      Correct Answer : 2       QuestionID  :  18218         Subject Name  DBT Q29. ___________ level triggers are the default type of trigger created via create trigger command      1.  row      2.  statement      3.  schema      4.  database      Correct Answer : 2       QuestionID  :  18222         Subject Name  DBT Q30. _________ are masks placed upon tables.      1.  Views      2.  Sequences      3.  Tables      4.  Indexes      Correct Answer : 1       QuestionID  :  18224         Subject Name  DBT Q31. ________ File contains the no. of failed login attempts after which the SQL * PLUS application shut down.      1.  init.ora      2.  ora.ini      3.  ora.dll      4.  none of the above      Correct Answer : 1       QuestionID  :  18237         Subject Name  DBT Q32. __________ is used for error trapping in PL/SQL blocks.      1.  Error handling section      2.  Exception_init()      3.  Exception section      4.  None      Correct Answer : 3       QuestionID  :  18243         Subject Name  DBT Q33. Handling unnamed exception can be achieved by exception handler _____      1.  OTHERS      2.  TOO_MANY_ROWS      3.  INVALID_CURSOR      4.  INVALID_NUMBER      Correct Answer : 1       QuestionID  :  18257         Subject Name  DBT Q34. following key is a key which is primary key but an added column in the table      1.  candidate key      2.  super key      3.  surrogate key      4.  foreign key      Correct Answer : 3       QuestionID  :  18311         Subject Name  DBT Q35. DBWR,LGWR,SMON & _________ are the four oracle system proccess that must always be up & running for the database to be usable.      1.  Recoverer      2.  Archiver      3.  Lock      4.  PMON      Correct Answer : 4       QuestionID  :  18313         Subject Name  DBT Q36. _________ is not a shutdown option of ORACLE.      1.  shutdown normal      2.  shutdown mount      3.  shutdown immediate      4.  shutdown abort      Correct Answer : 2       QuestionID  :  18330         Subject Name  DBT Q37. The purpose of back-up is to-      1.  increase mean time to recover      2.  reduce mean time to recover      3.  both are true      4.  both are wrong      Correct Answer : 2       QuestionID  :  18335         Subject Name  DBT Q38. Cleaning up temporary segments that are no longer in in use is done by __________      1.  LGWR      2.  PMON      3.  DBWR      4.  SMON      Correct Answer : 4       QuestionID  :  18338         Subject Name  DBT Q39. Data Dictionary is also known as _________      1.  SYSTEM tablespace      2.  USER tablespace      3.  DATA tablespace      4.  TOOL tablespace      Correct Answer : 1       QuestionID  :  18349         Subject Name  DBT Q40. oracle does not contain following      1.  software code area      2.  system global area      3.  program global area      4.  file global area      Correct Answer : 4       QuestionID  :  18350         Subject Name  DBT Q41. Which of the following are the components of SGA?      1.  The database buffer cache      2.  Redo log buffer      3.  The data dictionary cache      4.  all of the above      Correct Answer : 4       QuestionID  :  18357         Subject Name  DBT Q42. A single query cannot have WHERE, GROUP BY, HAVING and ORDER BY clauses simultaneously      Correct Answer : F       QuestionID  :  18385         Subject Name  DBT Q43. A DataBase is madeup of one or more tablespace      Correct Answer : T       QuestionID  :  18403         Subject Name  DBT Q44. ROWID is the only pseudo column in any Oracle table      Correct Answer : F       QuestionID  :  18425         Subject Name  DBT Q45. The structure of data store in data dictionary.      Correct Answer : T       QuestionID  :  18438         Subject Name  DBT Q46. The most serious drawback in the ER model is that it can not depict relationships      Correct Answer : T       QuestionID  :  18456         Subject Name  DBT Q47. Business rules, which are enforced on data begin stored in a table are called Constraints.      Correct Answer : T       QuestionID  :  18480         Subject Name  DBT Q48. The "i" in Oracle 9i stands for "improved"      Correct Answer : F       QuestionID  :  18487         Subject Name  DBT Q49. GROUP BY clause can not be used in view      Correct Answer : F       QuestionID  :  18490         Subject Name  DBT Q50. Drop table name command deletes the table temporarily.      Correct Answer : F       QuestionID  :  18499         Subject Name  DBT Q51. !=,<>,^= all denote same operation.      Correct Answer : T       QuestionID  :  18521         Subject Name  DBT Q52. the join that combines every row(no matter matching or nonmatching)of both the tables is a full join      Correct Answer : T       QuestionID  :  18531         Subject Name  DBT Q53. DECODE is a value by value substitution      Correct Answer : T       QuestionID  :  18535         Subject Name  DBT Q54. user can not do DDL actions on synonym      Correct Answer : T       QuestionID  :  18551         Subject Name  DBT Q55. Null values can be inserted in primary key but not in Unique key      Correct Answer : F       QuestionID  :  18579         Subject Name  DBT Q56. A subquery can contain order by and for update of clauses.      Correct Answer : F       QuestionID  :  18607         Subject Name  DBT Q57. user data in oracle database is logically strored in data files      Correct Answer : F       QuestionID  :  18630         Subject Name  DBT Q58. pseudo column such as curval ,nextval,rownum and subqueries are not allowed in condition given by CHECK constraint      Correct Answer : T       QuestionID  :  18632         Subject Name  DBT Q59. By using ALTER TABLE clause we add,modify and delete any column containing data within them.      Correct Answer : F       QuestionID  :  18648         Subject Name  DBT Q60. You can refer to a table in Remote Database in the reference clause while mentioning the forienge key.      Correct Answer : F       QuestionID  :  18658         Subject Name  DBT Q61. if there are triggers that delete rows that depend on rows in the table,truncating does not execute those triggers.      Correct Answer : T       QuestionID  :  18679         Subject Name  DBT Q62. Variable for loop should always be declared.      Correct Answer : F       QuestionID  :  18683         Subject Name  DBT Q63. The 4 phases of processing a cursor are Declare, Open, Fetch & Close.      Correct Answer : T       QuestionID  :  18685         Subject Name  DBT Q64. PL/SQL programs residing at the client side are called named PL/SQL blocks.      Correct Answer : F       QuestionID  :  18688         Subject Name  DBT Q65. PL/SQL extends SQL by adding control structures found in other procedural language.      Correct Answer : T       QuestionID  :  18706         Subject Name  DBT Q66. The DBMS_LOB pach=kage is used to manipulate LOBs.      Correct Answer : T       QuestionID  :  18707         Subject Name  DBT Q67. DDL statements can be used inside PL/SQL blocks.      Correct Answer : F       QuestionID  :  18715         Subject Name  DBT Q68. DDL statements are allowed in PL/SQL code.      Correct Answer : F       QuestionID  :  18741         Subject Name  DBT Q69. predefined exception are raised automaticlly whenever a PL/SOL program violates an Oracle rule.      Correct Answer : T       QuestionID  :  18742         Subject Name  DBT Q70. In PL/SQL,a procedure named raise_application_error is used to define error mesages.      Correct Answer : T       QuestionID  :  18753         Subject Name  DBT Q71. you can not define trigger on a view      Correct Answer : T       QuestionID  :  18754         Subject Name  DBT Q72. It is necessary in case of cursor for loop to declare and open a cursor explicitly      Correct Answer : F       QuestionID  :  18768         Subject Name  DBT Q73. For update clause is required when the table has a primary key      Correct Answer : F       QuestionID  :  18770         Subject Name  DBT Q74. Schema is a physical part of oracle architecture      Correct Answer : F       QuestionID  :  18778         Subject Name  DBT Q75. The software code area contains data and control information for a single process      Correct Answer : F       QuestionID  :  18798         Subject Name  DBT Q76. The MODIFY command is used to change or modify data values in a table.      Correct Answer : F       QuestionID  :  18811         Subject Name  DBT Q77. Drop the constraint using DROP TABLE command with the DELETE clause.      Correct Answer : F       QuestionID  :  18813         Subject Name  DBT Q78. If a column level constraint is defined on the column with a default value clause must precede the constraint definition.      Correct Answer : T       QuestionID  :  18823         Subject Name  DBT Q79. SQL has facility for programmed handling of errors that arise during manipulation of data.      Correct Answer : F       QuestionID  :  18829         Subject Name  DBT Q80. TRUE,FALSE,NULL can not be assigned to logical literals.      Correct Answer : F       QuestionID  :  18832         Subject Name  DBT Q81. The string literals should not be enclosed with in single quotes.      Correct Answer : F       QuestionID  :  18833         Subject Name  DBT Q82. The TO_CHAR (date conversion) converts a values of a NUMBER datatypes to a character datatype, using the optional format string.      Correct Answer : F       QuestionID  :  18836         Subject Name  DBT Q83. The TO_DATE() function also disallows part insertion of a DATE values into a column.      Correct Answer : F       QuestionID  :  18838         Subject Name  DBT Q84. Raw is used to store ASCII data.      Correct Answer : F       QuestionID  :  18841         Subject Name  DBT Q85. The TO_DATE function allows a user to insert date into a date column in any required format, by specifying the character value of the date to be inserted and its format.      Correct Answer : T       QuestionID  :  18843         Subject Name  DBT Q86. DBMS_PROC is a package that includes a number of procedures and functions that accumulate information in a buffer so that it can be retrieved later.      Correct Answer : F       QuestionID  :  18855         Subject Name  DBT Q87. Union can be used in subqueries.      Correct Answer : F       QuestionID  :  18866         Subject Name  DBT Q88. Only constant values can be passed as a parameters to parameterized cursors.      Correct Answer : F       QuestionID  :  18881         Subject Name  DBT Q89. To handle very common and repetitive exception conditions the Oracle engine uses Named Exception Handlers.      Correct Answer : T       QuestionID  :  18890         Subject Name  DBT Q90. The exception once raised is then handled in the Exception handling section of the PL/SQL code block.      Correct Answer : T       QuestionID  :  18894         Subject Name  DBT Q91. In adhoc queries or similar situations, bitmap indexes adversely affect the performance of queries.      Correct Answer : F       QuestionID  :  18929         Subject Name  DBT Q92. Snapshots are used to dynamically replicate data between distributed databases.      Correct Answer : T       QuestionID  :  18934         Subject Name  DBT Q93. The NOCACHE attribute is used for specifying LOB storage area.      Correct Answer : F       QuestionID  :  18938         Subject Name  DBT Q94. FREELISTS specifies a number of freelists for each of the freelist groups for the table,index or cluster including tablespace.      Correct Answer : F       QuestionID  :  18940         Subject Name  DBT Q95. Multiple Datafiles can be added to the table by typing the file name in the blank row provided within the table.      Correct Answer : T       QuestionID  :  18961         Subject Name  DBT Q96. Even if a standard datatype is created and used for all adddress, allthe address in the database will use the different internal formats.      Correct Answer : F       QuestionID  :  18973         Subject Name  DBT Q97. The NCLOB datatype is used to store CLOB data for multibyte character sets.      Correct Answer : T       QuestionID  :  18977         Subject Name  DBT Q98. The DISPLAY[MODE] attribute controls whether SQL*PLUS lists the old and new settings of a SQL*PLUS systems variable when user changes the setting with SET.      Correct Answer : F       QuestionID  :  18988         Subject Name  DBT Q99. If multipule words are entered,it must enclose text in double quotes.      Correct Answer : F       QuestionID  :  18993         Subject Name  DBT Q100. HEADS[EP] attribute defines the character that a user enters as the heading seperator caharacter.      Correct Answer : T