Quiznetik

DataBase Management System (DBMS) | Set 14

1. Which of the following is the default trigger that is created using the CREATE TRIGGER command?

A. Row level Trigger

B. Statement level Trigger

C. BEFORE Trigger

D. AFTER Trigger

Correct : B. Statement level Trigger

2. Which of the following command is used to delete a trigger?

A. DELETE TRIGGER

B. REPLACE TRIGGER

C. DROP TRIGGER

D. None of the above

Correct : C. DROP TRIGGER

3. What is the name of a trigger that initiates another trigger?

A. Triggering Trigger

B. Automatic Initiation Trigger

C. Cascading Trigger

D. None of the above

Correct : C. Cascading Trigger

4. Which of the following specifies a boolean expression that must be true for the trigger to fire?

A. Trigger Action

B. Triggering Event

C. Trigger Restriction

D. None of the above

Correct : C. Trigger Restriction

5. Which of the following trigger will be executed before modifying each row affected by the triggering statement?

A. Before Statement Trigger

B. After Row Trigger

C. Before Row Trigger

D. None of the above

Correct : C. Before Row Trigger

6. Which of the following is not true in case of triggers?

A. Triggers accept parameters.

B. Triggers are executed implicitly

C. Execution of triggers is transparent to the users.

D. A trigger can invoke another trigger.

Correct : A. Triggers accept parameters.

7. A database is divided into logical storage units called as

A. Tables

B. Records

C. Tablespaces

D. None of the above

Correct : C. Tablespaces

8. A file used to govern the initialization of the instance is known as

A. Shared file

B. Parameter file

C. Read-only file

D. None of the above

Correct : B. Parameter file

9. SGA stands for

A. System Go Ahead

B. Software Global Area

C. System Global Area

D. None of the above

Correct : C. System Global Area

10. Under which two circumstances do you design database triggers? (Choose two)

A. To duplicate the functionality of other triggers.

B. To replicate built-in constraints in the Oracle server such as primary key and foreign key.

C. To guarantee that when a specific operation is performed, related actions are perform

Correct : C. To guarantee that when a specific operation is performed, related actions are perform

11. This statement fails when executed: CREATE OR REPLACE TRI GGER CALC_TEAM_AVG AFTER I NSERT ON PLAYER BEGIN INSERT INTO PLAYER_BATSTAT ( PLAYER_I D, SEASON_YEAR, AT_BATS, HI TS) VALUES ( : NEW. I D, 1 997, 0, 0) ; END; To which type must you convert the trigger to correct the error?

A. Row

B. Statement

C. ORACLE FORM trigger

D. Before

Correct : A. Row

12. The OLD and NEW qualifiers can be used in which type of trigger?

A. Row level DML trigger

B. Row level system trigger

C. Statement level DML trigger

D. Row level application trigger

Correct : A. Row level DML trigger

13. Trigger are not supported in

A. Delete

B. Update

C. Views

D. All of the mentioned

Correct : C. Views

14. The CREATE TRIGGER statement is used to create the trigger. THE _ clause specifies the table name on which the trigger is to be attached. The __ specifies that this is an AFTERINSERT trigger.

A. for insert, on

B. On, for insert

C. For, insert

D. Both a and c

Correct : B. On, for insert

15. What are the after triggers ?

A. Triggers generated after a particular operation

B. These triggers run after an insert, update or delete on a table

C. These triggers run after an insert, views, update or delete on a table

D. Both b and c

Correct : B. These triggers run after an insert, update or delete on a table

16. The variables in the triggers are declared using

A. -

B. @

C. /

D. /@

Correct : B. @

17. Which of the following is NOT an Oracle-supported trigger?

A. BEFORE

B. DURING

C. AFTER

D. INSTEAD OF

Correct : B. DURING

18. Which of the following is true concerning triggers?

A. We do not create them with SQL.

B. They execute against only some applications that access a database.

C. They have an event, condition, and action.

D. They cannot cascade (cause another trigger to fire).

Correct : C. They have an event, condition, and action.

19. Which prefixes are available to Oracle triggers?

A. : new only

B. : old only

C. Both :new and : old

D. Neither :new nor : old

Correct : C. Both :new and : old

20. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

A. Supertype entity

B. Subtype entity

C. Archetype entity

D. Instance entity

Correct : C. Archetype entity

21. Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

A. Rollback

B. Rollforward

C. Switch to duplicate database

D. Reprocess transactions

Correct : A. Rollback

22. Concurrency control is important for which of the following reasons?

A. To ensure data integrity when updates occur to the database in a multiuser environment

B. To ensure data integrity when updates occur to the database in a single-user environment

C. To ensure data integrity while reading data occurs to the database in a multiuser environment

D. To ensure data integrity while reading data occurs to the database in a singleuser environment

Correct : A. To ensure data integrity when updates occur to the database in a multiuser environment

23. The transaction log includes which of the following?

A. The before-image of a record

B. The after-image of a record

C. The before and after-image of a record

D. The essential data of the record

Correct : D. The essential data of the record

24. Which of the following is not true of SQL views?

A. Oracle views cannot use the ORDER BY clause in view definitions.

B. Oracle views are created using the standard SQL-92 CREATE VIEW command.

C. Oracle views can by queri

Correct : A. Oracle views cannot use the ORDER BY clause in view definitions.

25. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

A. Full backup

B. Consistent backup

C. Inconsistent backup

D. Differential backup

Correct : B. Consistent backup

26. Which of the following is true concerning a procedure?

A. You do not create them with SQL.

B. They do not need to have a unique name.

C. They include procedural and SQL statements.

D. They are the same thing as a function.

Correct : C. They include procedural and SQL statements.

27. A CASE SQL statement is which of the following?

A. A way to establish an IF-THEN-ELSE in SQL.

B. A way to establish a loop in SQL.

C. A way to establish a data definition in SQL.

D. All of the above.

Correct : A. A way to establish an IF-THEN-ELSE in SQL.

28. Which of the following statements is true concerning routines and triggers?

A. Both consist of procedural code.

B. Both have to be called to operate.

C. Both run automatically.

D. Both are stored in the database.

Correct : A. Both consist of procedural code.

29. How many bytes does each character in the UTF8 encoding take up?

A. 1

B. 2

C. 3

D. All mentioned above

Correct : D. All mentioned above

30. PL/SQL has two types of subprograms, procedures and functions. Which subprogram isused to compute a value?

A. Procedure

B. Function

C. Both A & B

D. None of the above

Correct : B. Function

31. Which datatype is not allowed in the definition of PL/SQL record?

A. A Collection

B. A Scalar

C. Both A & B

D. None of the above

Correct : A. A Collection

32. In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?

A. %ROWCOUNT

B. %FOUND

C. %NOTFOUND

D. %ISOPEN

Correct : B. %FOUND

33. For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?

A. TOO_MANY_ROWS

B. NO_DATA_FOUND

C. VALUE_ERROR

D. DUP_VAL_ON_INDEX

Correct : D. DUP_VAL_ON_INDEX

34. In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;

A. 0

B. 99

C. 1

D. 100

Correct : B. 99

35. Which collection types is also known as index-by tables, lets you look up elements Using arbitrary numbers and strings for subscript values?

A. Associative arrays

B. Nested tables

C. Varrays

D. None of the above

Correct : A. Associative arrays

36. Assigning a value to a collection element can cause exceptions, such as

A. If the subscript is NULL or is not convertible to the right datatype, PL/SQL raises the predefined exception VALUE_ERROR. Usually, the subscript must be an integer. Associative arrays can also be declared to have VARCHAR2 subscripts.

B. If the subscript refers to an uninitialized element, PL/SQL raises SUBSCRIPT_BEYOND_COUNT.

C. If the collection is atomically null, PL/SQL raises COLLECTION_IS_NULL.

D. All mentioned above

Correct : D. All mentioned above

37. Which is a procedural extension of Oracle- SQL that offers language constructs similar tothose in imperative programming languages?

A. PQL

B. Advanced SQL

C. PL/SQL

D. SQL

Correct : C. PL/SQL

38. Which of the following retains duplicate rows in the result of a query or in an Aggregate expression?

A. ALL

B. DISTINCT

C. PRIOR

D. None of the above

Correct : A. ALL

39. Which of the following is an aggregate function in SQL?

A. Union

B. Like

C. Group By

D. Max

Correct : D. Max

40. Which command is used to add a column to an existing table?

A. Create

B. Update

C. Alter

D. None of these

Correct : C. Alter

41. A deadlock exists in the system if and only if the wait for graph:

A. has a cycle in it

B. has a path from first node to last node

C. is a tree

D. none of the above

Correct : A. has a cycle in it

42. Rollback of transactions is normally used to:

A. recover from transaction failure

B. update the transaction

C. retrieve old records

D. repeat a transaction

Correct : A. recover from transaction failure

43. The DBMS language component which can be embedded in a program is

A. The data definition language (DDL).

B. The data manipulation language (DML).

C. The database administrator (DBA).

D. A query language

Correct : B. The data manipulation language (DML).

44. The statement in SQL which allows to change the definition of a table is

A. Alter.

B. Update.

C. Create.

D. select.

Correct : A. Alter.

45. A DBMS query language is designed to

A. support end users who use English-like commands.

B. support in the development of complex applications software.

C. specify the structure of a database.

D. all of the above.

Correct : D. all of the above.

46. Which of the following is correct

A. a SQL query automatically eliminates duplicates.

B. SQL permits attribute names to be repeated in the same relation.

C. a SQL query will not work if there are no indexes on the relations

D. None of these

Correct : D. None of these

47. Which of the following is a valid SQL type?

A. CHARACTER

B. NUMERIC

C. FLOAT

D. All of the above

Correct : D. All of the above

48. Which of the following is a legal expression in SQL?

A. SELECT NULL FROM EMPLOYEE;

B. SELECT NAME FROM EMPLOYEE;

C. SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;

D. none of the above

Correct : B. SELECT NAME FROM EMPLOYEE;

49. If every non-key attribute is functionally dependent on the primary key, then the relation will be in:

A. First normal form

B. Second normal form

C. Third normal form

D. Fourth normal form

Correct : C. Third normal form

50. Given the functional dependencies X →W; X→Y; Y→Z and Z→PQ Which of the following doesn’t hold well?

A. X→Z

B. W→Z

C. X→WY

D. None of the above

Correct : B. W→Z

51. Relations produced from an E-R model will always be in

A. First normal form

B. Second normal form

C. Third normal form

D. Fourth normal form

Correct : C. Third normal form

52. Third normal form is inadequate in situation where the relation

A. Has multiple candidate keys

B. Has candidate keys that are composite

C. Has overlapped candidate keys

D. None of the above

Correct : A. Has multiple candidate keys

53. If a relation scheme is in BCNF, then it is also in

A. First normal form

B. Second normal form

C. Third normal form

D. Fourth normal form

Correct : C. Third normal form

54. A primary key when combined with a foreign key create

A. Parent child relationship between the tables that connect them.

B. Network model between the tables that connect them.

C. Many-to-many relationship between the tables that connect them.

D. None of the above.

Correct : A. Parent child relationship between the tables that connect them.

55. The set of permitted value for each attribute is called its

A. Attribute set

B. Attentive range

C. Domain

D. Group

Correct : C. Domain

56. The airline reservation system, the enables are date, flight number, place of departure, destination, type of plane & seats available. The primary key is

A. Flight number

B. Flight number + place of departure

C. Flight number+ date

D. Flight number + destination

Correct : C. Flight number+ date

57. A functional dependency of the form X→Y is trivial if

A. YC= X

B. Y C X

C. X C =Y

D. X C Y and Y C X

Correct : A. YC= X

58. The concept of locking can be used to solve the problem of

A. Lost update

B. Uncommitted dependency

C. Inconsistent data

D. Deadlock

Correct : A. Lost update

59. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.

A. It will result in a deadlock situation.

B. It will immediately be granted.

C. It will immediately be reject

Correct : B. It will immediately be granted.

60. A schedule S of n transactions is serializable if it is equivalent to some

A. Serial schedule of the same n transactions.

B. Non-serial schedule of the same n transactions.

C. Serial schedule of different n transactions.

D. Non-serial schedule of different n transactions.

Correct : A. Serial schedule of the same n transactions.

61. In two-phase locking protocol.

A. All unlocking operations precede the first lock operation.

B. All locking operations precede the first unlock operation.

C. Locking and unlocking takes place simultaneously.

D. None of the above.

Correct : B. All locking operations precede the first unlock operation.

62. Transaction timestamp is:

A. Not unique for each transaction

B. Larger for older transaction

C. Unique identifier assigned to each transaction.

D. None of the above.

Correct : C. Unique identifier assigned to each transaction.

63. The granularity of a database item can be chosen to be

A. A whole file

B. A database record

C. The whole database

D. All of the above.

Correct : D. All of the above.

64. If the complete execution of the transaction(s) takes the database from one consistent state to the other then that property of transaction is called:

A. Isolation

B. Durability

C. Consistency preservation

D. None of the above

Correct : C. Consistency preservation

65. Which of the following is not the state that the transaction undergoes?

A. Failed

B. Active

C. Partially committed

D. Non active

Correct : D. Non active

66. Timestamp can be generated by:

A. Counter

B. Current date/time

C. None of the above

D. Both (a) and (b)

Correct : D. Both (a) and (b)

67. Which of the following is the formal process for deciding which attributes should be grouped together in a relation?

A. Normalization

B. Performance Tuning

C. Optimization

D. None of the above

Correct : A. Normalization

68. Who developed normalization process?

A. C.J. Date

B. E.F. Codd

C. Donald Chamberlain

D. Collin White

Correct : B. E.F. Codd

69. Who developed the BCNF?

A. Boyd and Cromwell

B. Date and Codd

C. Date and White

D. Boyce and Codd

Correct : D. Boyce and Codd

70. What is the expansion of BCNF?

A. Boyd-Cromwell Normal Form

B. Boyce-Codd Normal Form

C. Boyd-Codd Normal Form

D. All of the above

Correct : B. Boyce-Codd Normal Form

71. Which of the following is the result of a transitive dependency?

A. Insertion anomaly

B. Modification anomaly

C. Deletion anomaly

D. All of the above

Correct : D. All of the above

72. Which of the following is true?

A. Normalized data is the best representation of data.

B. Data stored non-redundantly will be accessed faster than data stored many times.

C. Normalized tables are the best way to store data.

D. All of the above

Correct : D. All of the above

73. How many inference rules are there for functional dependencies?

A. 4

B. 5In t

C. 6

D. 7

Correct : C. 6

74. Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?

A. Dependency preservation property

B. Fully Functional dependency

C. Lossless Join

D. None of the above

Correct : A. Dependency preservation property

75. Every relation in BCNF is also in

A. 3NF

B. 2NF

C. 1NF

D. None of the above

Correct : A. 3NF

76. A table that contains one or more repeating groups is in which normal form?

A. 1NF

B. 2NF

C. 3NF

D. Unnormalized Form

Correct : D. Unnormalized Form

77. A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency

A. i and iii

B. i and iv

C. i and ii

D. ii and iv

Correct : C. i and ii

78. Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address)

A. it is not in 2 NF

B. it does not have composite key

C. non-key attributes course no and course max. marks are functionally dependent

D. it has more than 3 non-key attributes

Correct : C. non-key attributes course no and course max. marks are functionally dependent

79. Given the following relation Student (roll no, name, course no, course max. marks, year of study, address) The corresponding 3 NF relations are

A. student (roll no, name, year of study, address) course (course no, course max. marks)

B. student ( roll no, name, year of study, address) student (roll no, course no) course (course no, course max. marks)

C. student (roll no , name, address) year (roll no, year of study) course (course no, course max. marks)

D. student (roll no, name, address) course (course no, course max. marks, year of study)

Correct : B. student ( roll no, name, year of study, address) student (roll no, course no) course (course no, course max. marks)

80. BoyeCodd Normal Form (BCNF) is needed when

A. two non-key attributes are dependent

B. there is more then one possible composite key

C. there are two or more possible composite overlapping keys and one attributeof a composite key is dependent on an attribute of another composite key

D. there are two possible keys and they are dependent on one another

Correct : C. there are two or more possible composite overlapping keys and one attributeof a composite key is dependent on an attribute of another composite key

81. A relation is said to be in BCNF when

A. it has overlapping composite keys

B. it has no composite keys

C. it has no multivalued dependencies

D. it has no overlapping composite keys which have related attributes

Correct : D. it has no overlapping composite keys which have related attributes

82. A 3 NF relation is converted to BCNF by

A. removing composite keys

B. removing multivalued dependencies

C. dependent attributes of overlapping composite keys are put in a separateRelation

D. dependent non-key attributes are put in a separate table

Correct : C. dependent attributes of overlapping composite keys are put in a separateRelation

83. BCNF is needed because

A. otherwise tuples may be duplicated

B. when a data is deleted tuples may be lost

C. updating is otherwise difficult

D. when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples

Correct : D. when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples

84. Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation

A. i and ii

B. ii and iii

C. i and iv

D. i and iii

Correct : D. i and iii

85. A relation project guidance Project Guidance(professor, project, student no. st-name, dept) A professor can give many projects to many students A project will have many students A project may be guided by many professors The 4 NF relation corresponding to this are

A. Prof_Project (professor, st_name, dept) Proj_stud (project, student no.)

B. Prof_stud (professor, student no) Proj_stud (project, student no)

C. Student (student no, st_name, dept) Student (student no, st_name, dept)

D. Professor(professor, project) Professor( professor, project, dept) Student (student no, st_name, dept)

Correct : B. Prof_stud (professor, student no) Proj_stud (project, student no)

86. A 3 NF relation is split into 4 NF

A. by removing overlapping composite keys

B. by splitting into relations which do not have more than one independent multi valued dependency

C. removing multivalued dependency

D. by putting dependent non-key attribute in a separate table

Correct : B. by splitting into relations which do not have more than one independent multi valued dependency

87. Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

A. The multivalue, multicolumn problem

B. The inconsistent values problem

C. The missing values problem

D. The general-purpose remarks column problem

Correct : B. The inconsistent values problem

88. What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

A. ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);

B. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);

C. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);

D. None of the above is correct.

Correct : C. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);

89. The NOT EXISTS keyword will be true if:

A. any row in the subquery meets the condition.

B. all rows in the subquery fail the condition.

C. both of these two conditions are met.

D. neither of these two conditions is met.

Correct : B. all rows in the subquery fail the condition.

90. Changing cardinalities in a database is:

A. a common database design task.

B. a rare database design task, but does occur.

C. a database design task that never occurs.

D. is impossible to do, so a new database must be constructed and the data moved into it.

Correct : A. a common database design task.

91. Which one of the following sorts rows in SQL?

A. SORT BY

B. ALIGN BY

C. ORDER BY

D. GROUP BY

Correct : C. ORDER BY

92. The SQL keyword(s) ________ is used with wildcards.

A. LIKE only

B. IN only

C. NOT IN only

D. IN and NOT IN

Correct : A. LIKE only

93. If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

A. the primary key

B. any alternate key

C. a surrogate key

D. a foreign key

Correct : A. the primary key

94. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

A. Two

B. Three

C. Four

D. Six

Correct : D. Six

95. In creating a procedure, you may get a message if you have compile errors. Which of the following is true?

A. The line numbers reported match the line numbers you see in your text editor.

B. SQL*Plus will automatically show the errors to you.

C. To see the errors, enter SHOW ERRORS in SQL*Plus.

D. If there are no syntax errors, you will receive the message "NO ERRORS."

Correct : C. To see the errors, enter SHOW ERRORS in SQL*Plus.

96. Which of the following is not true about indexes?

A. Indexes are created to enforce uniqueness on columns.

B. Indexes are created to enable fast retrieval by column values.

C. Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.

D. Indexes are created with the ALTER TABLE command.

Correct : D. Indexes are created with the ALTER TABLE command.

97. In ……….. normal forms, any multivalued attributes have been removed.

A. First

B. Second

C. Third

D. Fourth

Correct : A. First

98. A (n) …………….. is an attribute in a relation that serves as a primary key of another relation in the same.

A. Composite key

B. Foreign key

C. Identifier key

D. Primary key

Correct : C. Identifier key

99. In the process of decomposition is called as

A. Normalization

B. Generalization

C. Aggregation

D. Specalization

Correct : A. Normalization

100. A relation Schema R is in ……….. if it is in 3NF and satisfies an additional constant thatfor every FD X->A. X must be a candidate key.

A. 1 NF

B. 2 NF

C. 3 NF

D. BCNF

Correct : D. BCNF

Quiznetik

DataBase Management System (DBMS) | Set 14

1. Which of the following is the default trigger that is created using the CREATE TRIGGER command?

2. Which of the following command is used to delete a trigger?

3. What is the name of a trigger that initiates another trigger?

4. Which of the following specifies a boolean expression that must be true for the trigger to fire?

5. Which of the following trigger will be executed before modifying each row affected by the triggering statement?

6. Which of the following is not true in case of triggers?

7. A database is divided into logical storage units called as

8. A file used to govern the initialization of the instance is known as

9. SGA stands for

10. Under which two circumstances do you design database triggers? (Choose two)

11. This statement fails when executed: CREATE OR REPLACE TRI GGER CALC_TEAM_AVG AFTER I NSERT ON PLAYER BEGIN INSERT INTO PLAYER_BATSTAT ( PLAYER_I D, SEASON_YEAR, AT_BATS, HI TS) VALUES ( : NEW. I D, 1 997, 0, 0) ; END; To which type must you convert the trigger to correct the error?

12. The OLD and NEW qualifiers can be used in which type of trigger?

13. Trigger are not supported in

14. The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTERINSERT trigger.

15. What are the after triggers ?

16. The variables in the triggers are declared using

17. Which of the following is NOT an Oracle-supported trigger?

18. Which of the following is true concerning triggers?

19. Which prefixes are available to Oracle triggers?

20. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

21. Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

22. Concurrency control is important for which of the following reasons?

23. The transaction log includes which of the following?

24. Which of the following is not true of SQL views?

25. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

26. Which of the following is true concerning a procedure?

27. A CASE SQL statement is which of the following?

28. Which of the following statements is true concerning routines and triggers?

29. How many bytes does each character in the UTF8 encoding take up?

30. PL/SQL has two types of subprograms, procedures and functions. Which subprogram isused to compute a value?

31. Which datatype is not allowed in the definition of PL/SQL record?

32. In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?

33. For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?

34. In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;

35. Which collection types is also known as index-by tables, lets you look up elements Using arbitrary numbers and strings for subscript values?

36. Assigning a value to a collection element can cause exceptions, such as

37. Which is a procedural extension of Oracle- SQL that offers language constructs similar tothose in imperative programming languages?

38. Which of the following retains duplicate rows in the result of a query or in an Aggregate expression?

39. Which of the following is an aggregate function in SQL?

40. Which command is used to add a column to an existing table?

41. A deadlock exists in the system if and only if the wait for graph:

42. Rollback of transactions is normally used to:

43. The DBMS language component which can be embedded in a program is

44. The statement in SQL which allows to change the definition of a table is

45. A DBMS query language is designed to

46. Which of the following is correct

47. Which of the following is a valid SQL type?

48. Which of the following is a legal expression in SQL?

49. If every non-key attribute is functionally dependent on the primary key, then the relation will be in:

50. Given the functional dependencies X →W; X→Y; Y→Z and Z→PQ Which of the following doesn’t hold well?

51. Relations produced from an E-R model will always be in

52. Third normal form is inadequate in situation where the relation

53. If a relation scheme is in BCNF, then it is also in

54. A primary key when combined with a foreign key create

55. The set of permitted value for each attribute is called its

56. The airline reservation system, the enables are date, flight number, place of departure, destination, type of plane & seats available. The primary key is

57. A functional dependency of the form X→Y is trivial if

58. The concept of locking can be used to solve the problem of

59. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.

60. A schedule S of n transactions is serializable if it is equivalent to some

61. In two-phase locking protocol.

62. Transaction timestamp is:

63. The granularity of a database item can be chosen to be

64. If the complete execution of the transaction(s) takes the database from one consistent state to the other then that property of transaction is called:

65. Which of the following is not the state that the transaction undergoes?

66. Timestamp can be generated by:

67. Which of the following is the formal process for deciding which attributes should be grouped together in a relation?

68. Who developed normalization process?

69. Who developed the BCNF?

70. What is the expansion of BCNF?

71. Which of the following is the result of a transitive dependency?

72. Which of the following is true?

73. How many inference rules are there for functional dependencies?

74. Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?

75. Every relation in BCNF is also in

76. A table that contains one or more repeating groups is in which normal form?

77. A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency

78. Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address)

14. The CREATE TRIGGER statement is used to create the trigger. THE _ clause specifies the table name on which the trigger is to be attached. The __ specifies that this is an AFTERINSERT trigger.