30. DDL operations, once performed are automatically committed & do not require any commit statement for
confirmation (True)
31. No column of a Non-key preserved table can be modified through a view (True)
32. No trigger other than the INSTEAD OF trigger can be applied to a view (True)
33. PL/SQL programs residing at the client side are called named PL/SQL blocks (False)
34. The difference between a procedure and a function is that a procedure needs to be executed explicitly using
EXECUTE whereas a function can be executed within an SQL statement as well (True)
35. The datatypes of parameters passed to stored procedures cannot have any width (True)
36. DDL statements cannot be executed within a Pl/SQL code (False)
37. Oracle stored procedures can only be written in Pl/SQL (False)
38. BOOLEAN is a valid datatype in PL/SQL & not in Oracle database (True)
39. The updates made to a view are not reflected to the underlying base tables (False)
40. A single query cannot have WHERE, GROUP BY, HAVING and ORDER BY clauses simultaneously (False)
41. DECODE is a standard function specified by SQL 92 standards (False)
42. The two SELECT statements joined using UNION, INTERSECT and MINUS must have same no, of
columns & datatypes, the size of these columns does not matter (True)
43. The UNION clause does not eliminate duplicates (False)
44. A view is non-updateable if it has a reference to ROWNUM (True)
45. An ORDER BY clause cannot be used in a CREATE VIEW statement (True)
46. Oracle, by default creates an index on every UNIQUE column of a table (True)
47. ROWID is a datatype (True)
48. 2NF applies only to the tables with composite primary keys (True)
49. The inner join (or equi join) is same as the natural join (True)
50. The anonymous Pl/SQL blocks stored at the client side are a part of the Oracle database (False)
51. The “i” in Oracle 8i stands for “improved” (False)
52. The implicit variables :new and :old cannot be used in context of table level triggers (True)
53. A function and a table cannot have a same name but a function and a trigger can (True)
54. Oracle completely follows all of the 12 Codd’s rules (False)
55. NLS_DATE_FORMAT can be used to change the default date format (DD-MON-YY) in Oracle (True)
56. Indexing a table increases the speed of execution of queries based on it (True)
57. The HAVING clause can only contain aggregate functions (True)
58. Oracle stores dates and time as two separate values (False)
59. The ROWNUM column can be modified through update statement (False)
60. SELECT NLOG(7) FROM dual returns the natural log of 7 (False)
|