25. ________ keeps track of who is changing Oracle's Registry entries. (P.106) A. Registry Auditing.
26. What should be done for saving the current values? (P.108) A. The following has to be done for saving the current values:
a. Start the Registry Editor (Start|Run|REGEDT32). The Registry Editor should appear.
b. Click on the HKEY_LOCAL_MACHINE window, then navigate to the SOFTWARE|
ORACLE subkey.
c. With the ORACLE subkey highlighted, select Registry|Save Key from the menu. The Save Key dialog box should appear.
d. Enter a name for the file to contain the subkey values, then click on Save .
27. Name some of the features included in Windows NT to manage security in the network environment. (P.113)
A. Domains and Workgroups, user accounts, groups, profiles, system policies logon scripts, shared folders, and file permissions.
28. A _______ consists of Windows NT workstations in a peer-to-peer ship.
A. Workgroup
29. A ______ domain consists of a group of Windows NT servers and workstations.
A. Domain.
30. ______ is a central NT server, where a single profile can be stored. (P.117) A. Roaming profile.
31. _____ is the extension for mandatory profile and ______ is an extension for roaming and personal files.
A. .MAN , .USR
32. What are the steps to assign a logon script to a user account? (P.118) A. To assign a logon script to a user account:
a. Start the User Manager For Domains (Start|Programs|Adminstrative Tools|
User Manager For Domains)
b. Double-click on the username to display the User Properties dialog box.
c. Click on the Profile button to display the User Environment dialog box Enter the name of the logon script in the Logon Script Name field, then click on OK.
d. Click on OK again to close the User Properties dialog box and return to the User Manager for Domains.
33. In a Windows NT network, folders are made available to network users
through creation of a _______. (P.118) A. Folder share.
34. Explain the types of file and folder permissions on NTFS drives. (P.119)
A. Permission Description
No Access Prohibit all access to the folder. This is the default permission.
List Allow a user to display the contents of the folder, but not read files or execute prog-rams in the folder.
Read Allow a user to view the contents of the folder or file, and execute programs.
Add Allow a user to create new files or sub-folders in the folder.
Add&Read Allow all of the actions granted by the Add and Read permissions.
Change Allow all of the actions granted by the Read permission, plus the ability to add, change or delete files or folders.
Full Control Allow all of the actions granted by the Change permission, plus the ability of the user to change permissions or take ownership of the file or folder.
Special Directory Customize permissions for a specified folder.
Access
Special File Access Customize permissions for a specified file.
35. Permissions are also available for FAT drives. True/false (P.120) A. False. Permissions are not available for FAT drives.
36. ______ and _______ are the categories of data dictionary views. (P.149) A. static and dynamic.
37. _______ and ______ are the two areas of the shared pool. (P.157) A. Library cache and data dictionary cache.
38. _______ indicates the number of misses in the library cache during cution.
A. RELOADS.
39. Explain the page faults. (P.163)
A. If a process needs to access a page that is not currently in its working set, then a page fault occurs. This can either be soft fault, where the required page is found elsewhere in memory, or a hard fault where the
required page is on disk and has to be read into memory.
Soft faults don't cause any noticeable delays in the processing, but hard faults do, if there is a large number of them.
40. What are the benefits of Net8? (P.223) A. Here is a partial listing of Net8 benefits:
-- Net8 can support thousands of simulaneous database connections, with a minimum of overhead. This ability is not exactly new, but it has not previously been available under Windows NT.
-- Net8 is a protocol-independent. Your applications and the database are entirely insulated from the details of the network. The database and the applications that run against it don't have to worry about such things as packets, ports, or sockets. Net8 will support whatever mix of protocols you currently have in place. And if you decide to run your application and database using different network protocols, nothing has to be rewritten.
-- Net8 is a topology- and media-independent. Token Ring? Ethernet? Sure.
Thin-wire? Thick-wire? FDDI? No problem. Once again, you can mix and match as needed.
-- Net8 and ODBC work together seamlessly. If you write an application that uses ODBC, the ODBC driver makes Net8 calls as needed. Your application will never know the difference.
41. What are the guidelines to be followed when placing archived redo logs?
(P.280)
A. When placing archived redo logs, follow these guidelines:
-- Place archived redo logs on a device separate from the online redo logs to reduce contention between LGWR and ARCH.
-- Ensure that there is adequate free space and that the drive is fast enough to allow ARCH to finish archiving an online redo log before LGWR wraps around to it.
42. ________ contain objects that are more frequently accessed than other objects in the database. (P.281)
A. Hot tablespaces.
43. _______ is an area of storage in which an Oracle disk sort occurs.
A. Temporary segment.
44. If the redo log member is incorrect or incomplete then it is a ______
status. (P.316) A. STALE
45. What are the LOB datatypes that can be stored in an Oracle Database?
(P.344)
A. There are three different LOB datatypes that can be stored in an Oracle database, each of which is suited for different applications:
--CLOB--Character large object. Used for storage of character data.
--BCLOB--Intended for multibyte character data, such as Japanese.
--BLOB--Binary large object. BLOBs are useful for storing multimedia data, such as sound, pictures and video.
46. _________ attribute is used to speed up long-running DML statements.
(P.389) A. NOLOGGING
47. Explain the extended ROWID components. (P.437)
A. The extended ROWID is broken into the following four distinct components:
Data object number--six characters Relative file number--three characters Block number--Six characters
Row number--three characters
48. Explain the restricted ROWID components. (P.442)
A. A restricted ROWID is represented by the following three distinct onents:
Block number--Eight characters. This represents the block number in the data file that contains a particular row. Oracle8 uses this, combined with the row number and file number, to quickly locate a row in the base.
Row number--Four characters. As with the extended ROWID, Oracle8 can cate a specific row once it has the block number and the row number.
File number--Four characters. This is the absolute file number where the row is located. Absolute file numbers can be determined by querying the FILE_ID column of the DBA_DATA_FILES data dictionary view.
49. Explain what are storage parameters. (P.444)
A. There are two storage parameters PCTFREE and PCTUSED used by Oracle8 to control how individual rows are stored in a block. It's helpful to think of PCTFREE and PCTUSED as a high water mark and a low water mark, ectively, for block storage utilization. PCTFREE controls how much space Oracle8 should reserve for updates to rows in a block, while PCTUSED trols how full a block should be, at a minimum.
50. How do we know which blocks in a table are available for INSERT activity?
A. Oracle8 employs free lists to keep track of which blocks in a table are available for INSERT activity.
51. What are the symbols in the Map window? (P.498) A. The symbols in the Map window are as follows:
Green Flag -- No worries, mate.
Yellow Flag -- A condition exists that should be checked.
Red Flag -- A severe condition exists and requires immediate attention Circle With Slash -- A group or object is down or unavailable. This symbol appears only if the UpDown event is registered for the group or object in the map.
52. Objects have status symbols only with registered events. True/False.
A. True.
53. How does the Create A New Map dialog appear? (P.512)
A. From the OEM Console Menu, select Map|Create Map, or use the Create Map icon on the OEM Console toolbar.
54. What is the default location for bitmap files? (P.513) A. %ORACLE_HOME%\sysman\bmp
55. When is a database is said to be running and when down? (P. 523)
A. When an instance exists the database is said to be running. When an ance does not exist, it is said to be down or unavailable to users.
56. ALTER DATABASE ARCHIVELOG command is available with the help of ______
Startup Mode.
A. MOUNT
57. Explain what is SHUTDOWN ABORT. (P.524)
A. The SHUTDOWN ABORT is a shutdown mode which stops the instance without rolling back uncommitted transactions or performing a checkpoint. itted transactions are lost. Instance recovery is required at startup.
This mode is used when a NORMAL or IMMEDIATE shutdown fails.
A SHUTDOWN ABORT stops the database but does not release the memory ocated to each thread--as much as 40-200K each. To release this memory, stop and restart the Oracle service.
58. What is the command to create a tablespace named APP_DATA? (P.552) A. CREATE TABLESPACE APP_DATA
DATAFILE 'G:\ORADATA\SID\APP1SID.DBF'
DEFAULT STORAGE (INITIAL 20K NEXT 10K MINEXTENTS 5 PCTINCREASE 1);
59. What are extents?
A. Extents are chunks of data blocks where storage is allocated to segments.
60. Describe the types of Rollback Segments. (P.556)
A. Rollback segments can be either online or offline. An online rollback segment is available to transactions. An offline rollback segment is available to transactions but still consumes space in its tablespace.
Rollback segments can be either private or public. The difference is important only in the Oracle Parallel Server, where a private rollback segment is owned by one instance but a public one can be acquired by any instance.
61. How does Oracle periodically write message files to the directories?
(P.558)
A. Oracle periodically writes message files to the directories specified by the following initialization parameters:
BACKGROUND_DUMP_DEST USER_DUMP_DEST
CORE_DUMP_DEST
62. What is the database's alert log?
A. It is a plain text file named SIDALRT.LOG contained in the BACKGROUND_DUMP_DE ST
directory.
63. What is the OEM Storage Manager and explain its areas. (P.559)
A. The OEM Storage Manager is a graphical tool used to create, alter and drop tablespaces, data files, and rollback segments. The Storage Manager has three major areas:
-- A menu bar at the top of the screen.
-- A tree-structured list of tablespaces, data files, and rollback ments on the left side of the screen.
-- A window on the right that provides additional detail about the object currently selected in the tree list.
64. What is a schema? (P.588)
A. A schema is the set of objects belonging to a single Oracle user account, including the user's tables, indexes, synonyms, views, sequences, and stored PL/SQL programs.
65. When you create a table, you allocate at least one chunk of storage to it, called the ______ extent.
A. INITIAL.
66. How is a not null constraint declared? (P.590) A. A not null constraint is declared as follows:
CHECK(UPDATED_BY IS NOT NULL)
67. What is a synonym and what are its purposes? (P.594)
A. In Oracle, a synonym is a permanent alias for a table or view. There are two primary purposes for synonyms:
Hide object ownership--For example, the following synonym eliminates the need to include the owner of the CUSTOMER table when a user other than CUSTMGT references the table:
CREATE PUBLIC SYNONYM CUSTOMER FOR CUSTMGT.CUSTOMER;
Simplify command entry--For example, the synonym CUST requires less typing than the full name of the CUSTOMER table.
CREATE SYNONYM CUST FOR CUSTOMER;
68. What is the command for private synonyms?