34. A table whose primary key retains its uniqueness in the view created over it is called a key preserved table
35. Instead of trigger is used to take care of operations on columns of a Non Key-preserved table through the
join view
36. The main data dictionary in Oracle that keeps the information of all the other data dictionary tables along
with their description is DICTIONARY
37. The 2 main parts of an Oracle package are package specification & package body
38. A tablespace is a collection of datafiles
39. The 2 modes in which an Oracle database runs are ARCHIVELOG & NOARCHIVELOG
40. The 2 list functions available in Oracle are GREATEST, & LEAST
41. The SQL query for calculating the cube of 4 is SELECT POWER(4, 3) FROM dual
42. WITH READ ONLY clause when used with CREATE VIEW statement prevents the users from modifying the
underlying base tables through the view
43. The 3 standard roles provided by Oracle are Connect, resource and DBA
44. The With admin option clause of the GRANT command makes the recipient the owner of the granted
object
45. The With grant option clause of the GRANT command allows the recipient to pass the privilege to others
46. The 5 important components of a Database Management system (DBMS) are Database engine, data
dictionary, query processor, report writer & form generator
47. The world’s first relational database was Oracle V.2
48. Specialization is a IS-A relationship and Composition is a HAS-A relationship
49. 1NF specifies that there should be no repeating groups
50. The join that combines every row (no matter matching or non-matching) of both the tables is a FULL join
51. By default, the 3 users created in every Oracle database are System, sys and Internal
52. All uncommitted data during the course of a transaction is stored in REDO LOG buffer
53. The source code of an Oracle stored procedure can be retrieved using USER_SOURCE data dictionary.
54. The 3 different flavours of Oracle 8i are Oracle 8i Workgroup Server, Personal Oracle and Oracle 8i
Enterprise Edition
55. The precompiler used for SQL statements embedded in a C program is Pro*C
56. DBMS_OUTPUT is a package and PUT_LINE is a function
57. A User defined type(UDT) can be created in Oracle using create type statement
58. The 2 implicit variables available to a trigger that contain the row values before and after updates are :new
and :old
59. The error codes for user defined error messages must lie between -20000, and -20999
60. RAISE_APPLICATION_ERROR statement terminates the PL/SQL block abruptly and displays the specified
error message
61. PRAGMA EXCEPTION_INIT statement is used to substitute a user-defined exception in place of a
predefined Oracle exception
62. A NULL value in the column indicates that the value is not applicable or currently not available
63. init.ora file contains the no. of failed login attempts after which the SQL*PLUS application shuts down
64. A Sequence can be used to provide a surrogate key in a table that does not have a primary key of its own
65. A synonym is a logical alias of any database object in Oracle
66. create global temporary table clause is used to create temporary tables in Oracle.
67. Snapshots are the means of creating local copies of remote tables.
68. Materialized views are also known as Snapshots
|