1. Redo Log Buffer SGA stores all the redo log entries.
2. Process is a ’thread of control’ or mechanism in Operating System that executes series of steps.
3. The data of a row in a table may not be able to fit the same data block. Data for row is stored in a chain of
data blocks which is called as Row chaining
4. A sub-query cannot have a _______ clause and a _____ of selects.
5. A __________ is a set of values that may appear in one or more columns.
6. PL/SQL provides ______ keyword, which is used to name an exception.
7. An _______ defined as the collection of blocks which must be continuous whenever allocation takes place.
8. A ________________ is a table that is currently being modified by a DML statement.
9. The ________ character is used to designate wild characters.
10. Indexes are created in conjunction with ________ and ________ constraints.
11. Types of views are ________ and ________ .
12. The date function that returns a numerical value is ________ .
13. To define access keys in the menu give the ________ symbol before the desired character.
14. An index may contain upto ________ columns.
15. To print the message along with the variable ew use the package ________ .
16. To select data from a range of values ________ operator is used.
17. A ________ expression returns either TRUE or FALSE.
18. ________ number of columns can be used in an ORDER BY clause.
19. Once the values are inserted in a table, the size of its columns can only be Increased & can never be
decreased
20. ROWID is a pseudo column
21. The 2 pseudo columns present in every Oracle table are ROWID & ROWNUM
22. In DBMS terms, the number of rows in a table is called its cardinality & the no. of columns it has defines its
degree
23. The most serious drawback in the ER model is that it cannot depict relationships
24. Dummy records is used to represent many to many relationship in the Network model
25. The data structure used in the Network model is graph & that used in the hierarchical model is tree
26. The 3 default tablespaces created in Oracle are System, User & Temp
27. The memory area allocated to each Oracle user is called Schema
28. An SQL query is interpreted & a PL/SQL block is compiled before execution
29. The 4 phases of processing a cursor are Declare, Open, Fetch & Close
30. The FOR UPDATE clause when used with a SELECT query locks a table
31. When a user executes SELECT ……. FOR UPDATE on a table, it tries to lock it, but if the table is already
locked, the user is placed in a no-operation mode. This situation can be prevented by using NOWAIT clause
32. The maximum no. of triggers(of different types) that can be created in Oracle 8 are13
33. The error code and the corresponding error message of every runtime error occurring in Oracle is stored in
SQLCODE & SQLERRM variables respectively
|