Exam Prep Questions


1:

Which data dictionary view would you use to get a list of all tablespaces and their associated data files?

  • A. DBA_TABLESPACES

  • B. DBA_DATA_FILES

  • C. DBA_SEGMENTS

  • D. DBA_EXTENTS

A1:

Answer B is correct. DBA_DATA_FILES gives you the TABLESPACE_NAME and its associated FILE_NAME as well as the numbers of bytes and blocks in the file and other useful information.

Answer A is incorrect because DBA_TABLESPACES gives you the TABLESPACE_NAME but not the filenames associated with it. Answer C is incorrect because it gives you segment information, and answer D is incorrect because it gives you extent information but not tablespace or data file information.

2:

Extents are collections of __________________.

  • A. Database blocks

  • B. Tablespaces

  • C. Table segments

  • D. Data files

A2:

Answer A is correct. Extents are composed of database blocks. Answer B is incorrect; tablespaces are the highest level of physical storage in the database. Answer C is incorrect; a table segment is made up of extents. Answer D is incorrect; a data file contains extents, not the other way around.

3:

What is the default number of transactions that MAXTRANS is set to if not specified?

  • A. 255

  • B. 10

  • C. 40

  • D. 1

A3:

Answer A is correct; the default MAXTRANS setting is 255. Answer B is incorrect; that is the percent that PCTFREE is set to by default. Answer C is incorrect; that is the PCTUSED default value. Answer D is incorrect; it is the default number for INITRANS.

4:

In a tablespace that has automatic segment space management, where is the free space managed?

  • A. In the data file

  • B. In the extent

  • C. In the data dictionary

  • D. In the bitmap segment

A4:

Answer D is correct. Bitmap segments inside the data and index segments control how free space is controlled in the segments. Answer A is incorrect because the data file is a repository for other structures and doesn't really contribute to space management. Answer B is incorrect because the extent doesn't manage space at the segment level, it only makes up a segment. Answer C is incorrect; one reason to use automatic segment space management is to limit the bottlenecks on the data dictionary.

5:

What does the parameter INITRANS specify?

  • A. The initial number of transactions created when a user logs in to SQL Plus

  • B. The maximum number of transaction slots that can be created for index and database blocks

  • C. The initial number of transaction slots created for index and database blocks

  • D. The initial number of transactions that can be run in the instance

A5:

Answer C is correct. INITRANS is the minimum number of transactions slots created for index blocks (default 2) and database blocks (default 1). Answer A is incorrect; there is a one-to-one correlation between transactions and SQL Plus sessions. Answer B is incorrect; MAXTRANS is the parameter that specifies the maximum number of transaction slots created in the database block. D is incorrect; no initial transactions are started when the instance is running.

6:

Which is not part of the database block header? [Choose all that apply]

  • A. Address of the database block

  • B. Address of the database

  • C. Address of the senior DBA

  • D. Row directory

  • E. Table directory

  • F. Transaction slots

  • G. Free space

  • H. Data space

A6:

The correct answers are B, C, G, and H. The address of the database (B) is not housed anywhere. The address of the senior DBA (C) is not likely to be kept in most databases and isn't stored at the database level. Free space (G) is a part of the block, but not of the block header. Data space is a part of the block, but not of the block header. Address of the database block (A) is in the header, as are the row directory (D), table directory (E), and transaction slots (F).

7:

When is an extent allocated to a segment? [Select all that apply]

  • A. When the segment is created

  • B. When the segment is opened

  • C. When the segment is truncated

  • D. When the segment is deleted

A7:

Answer A is correct. Extents are allocated when a segment is created, extended, or altered. Answer B is incorrect because segments are not opened; databases are opened. Answer C is incorrect because only tables and clusters can be truncated. Answer D is incorrect; when a segment is deleted, the extents are freed, not added.

8:

What information can be gained from querying the bootstrap segment?

  • A. When the database cache was created.

  • B. When the last maintenance data was for the bootstrap segment.

  • C. What segment types are found in the given database.

  • D. None, the bootstrap segment can't be queried.

A8:

Answer D is correct. The bootstrap segment can't be queried. Answer A is incorrect because, although the bootstrap segment helps create the database cache when the database is opened by the instance, it cannot be queried. Answer B is incorrect; you can neither query nor maintain the bootstrap segment. Answer C is incorrect; DBA_SEGMENTS can be queried to determine the kinds of segments located in the database.

9:

Which is not a part of the database block?

  • A. Header

  • B. Row directory

  • C. Data

  • D. Freelists

A9:

Answer D is correct. FREELISTS is a parameter that can be specified to help with space management but are not themselves located in the block. Answer A is incorrect because each database block contains a header. Answer B is incorrect because the row directory is a part of the header. Answer C is incorrect because the data is a part of every block regardless of the type of segment to which it belongs.

10:

Which is more appropriate to use to store a small list of values in a single column in each row in your address table?

  • A. VARRAY

  • B. Nested table

  • C. Index organized table

  • D. Index

A10:

Answer A is correct. You would store a limited list of values as a single column in each row of a table as a VARRAY. Answer B is incorrect; nested tables are useful for storing an entire row from another pseudo-table as a column in a row in your address table. Answer C is incorrect; you cannot store an index organized table within another table. Answer D is incorrect; indexes assist with retrieving information for a table but are not stored within the table.



    Oracle 9i Fundamentals I Exam Cram 2
    Oracle 9i Fundamentals I Exam Cram 2
    ISBN: 0789732653
    EAN: 2147483647
    Year: 2004
    Pages: 244
    Authors: April Wells

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net