Definition true term the provides an easy to use

  • No School
  • NONE 0
  • Notes
  • JordanH91
  • 99
  • 100% (4) 4 out of 4 people found this document helpful

This preview shows page 73 - 79 out of 99 pages.

Definition: TRUE
Image of page 73
Term: The ____ provides an easy-to-use interface into performance data stored in an Oracle database. Definition: Database Control Term: The ____ command is used to examine potential query plans that the optimizer may utilize, when executing a particular query of DML statement. Definition: EXPLAIN PLAN Term: The ____ Connection Mode can help when there are more than 1000 concurrent users. Definition: Shared Server Term: If you execute STARTUP with no PFILE parameter, then you will get an error. Definition: FALSE Term: When the ____ initialization parameter is set, Oracle 10g knows where to locate all the datafiles. Definition: DB_FILE_DEST
Image of page 74
Term: ____ allow(s) construction of properly scripted intra-dependant SQL command structures. Definition: PL/SQL Term: A ____ baseline moves with the current date setting for your database server, from today backwards in time, for whatever period is specified. Definition: moving window Term: SQL*Loader is not limited to individual table loads. Definition: TRUE Term: The shared pool is the most highly concurrent section of memory for an Oracle database. Definition: TRUE Term: The ____ engine allows you to store, parse, and execute Java applets, servlets, and stored procedures within the database. Definition: JVM
Image of page 75
Term: The ____ tool allows you to create and run queries, add rows, modify data, and write reports using SQL. Definition: SQL*Plus Term: The default block size is ____ bytes, determined on database creation. Definition: 8192 Term: The default value for INITRANS is 1 for tables and ____ for indexes. Definition: 2 Term: The CREATE TABLE and ALTER TABLE commands can both be used to encrypt table data at the column level. Definition: TRUE Term: Internal LOBs use ____ semantics. Definition: copy
Image of page 76
Term: The BFILE data is stored inside the database. Definition: FALSE Term: Because of their potentially huge size, Oracle 10g has special storage methods for LOBs. Definition: TRUE Term: You can manually gather statistics for snapshot comparison use, using both STATSPACK and the Database Control. Definition: TRUE Term: Database types are generally application driven, or determined by the kinds of applications that users are utilizing against a database. Definition: TRUE Term: To invoke OMF, you simply indicate all of the filenames and locations in the CREATE DATABASE command. Definition: FALSE
Image of page 77
Term: When the ____ initialization parameter is set, Oracle 10g knows where to locate all the datafiles. Definition: DB_FILE_DEST Term: When choosing the DBA authentication method, you can choose between ____ and password file authentication. Definition: operating system Term: A ____ backup is the same as a snapshot. The only difference is that the export utility performs a logical backup, not a physical backup. Definition: consistent Term: In Oracle Database, restarting the database will always recover from a SHUTDOWN ABORT or a power failure.
Image of page 78
Image of page 79

You've reached the end of your free preview.

Want to read all 99 pages?

  • Oracle Database

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture