1.7. Review Questions

  1. Which of the following SQL commands is an example of a DML command?

    1. SELECT

    2. CREATE

    3. INSERT

    4. GRANT

  2. You have just started a database transaction by inserting a row into a table. Which of the following actions will end this transaction?

    1. Inserting another row

    2. Issuing a COMMIT command

    3. Issuing an END TRANSACTION command

    4. Deleting the row you just inserted

  3. You are designing an application that will enforce business rules through table design. One of the tables in the application contains information about parts that are used to manufacture your product. When creating the PARTS table, what could you do to make certain that each part receives a part number and that each part number will be unique?

    1. Place a Unique constraint on the part number column of the PARTS table.

    2. Place a Not Null constraint on the part number column of the PARTS table.

    3. Place a Primary Key constraint on the part number column of the PARTS table.

    4. Place a Foreign Key constraint on the part number field of the PARTS table.

  4. Which of the following is not an advantage of SQL over traditional programming languages?

    1. SQL statements use English-like commands.

    2. A user can choose from several interfaces when interacting with SQL.

    3. SQL has sophisticated condition testing and looping capabilities.

    4. Users do not have to know how or where their data is physically stored in order to access it.

  5. How much free disk space is required to install Oracle Database 10g?

    1. 1.5MB

    2. 15GB

    3. 1.5KB

    4. 1.5GB

  6. You've just been hired as a DBA for a large company. During the interview process, you were shown the job description for the position. Which of the following tasks might have been included on this job description?

    1. Install and configure Oracle 10g software.

    2. Implement database installations according to OFA guidelines.

    3. Use OFA-compliant naming conventions for database files and directories.

    4. Any of the above may have been included on the DBA job description.

  7. Which of the following is not one of the differences between SQL*Plus and iSQL*Plus?

    1. iSQL*Plus is accessed via a web browser, but SQL*Plus must be run from a client or on the server.

    2. iSQL*Plus output is displayed in a separate window from the commands, but SQL*Plus displays everything in one window.

    3. iSQL*Plus can use SQL and PL/SQL to access the database, as can SQL*Plus.

    4. iSQL*Plus can only be used to access databases on Windows servers, but SQL*Plus can be used to access databases on Unix or Windows servers.

  8. Which of the following is an example of an environment variable that might be defined on a Unix system prior to starting the OUI?

    1. ORACLE_DIR

    2. $ORACLE_HOME

    3. $ORA_HOME

    4. $ORACLE_HM

  9. The DBA_TABLES data dictionary view contains a column called OWNER that shows the user name of the account who owns each table. What SQL clause would you add to a query on DBA_TABLES to view only those tables owned by a user called APPS?

    1. WHERE

    2. GROUP BY

    3. HAVING

    4. ALTER

  10. You have just logged on to the database as the user APPS and need to know which tables you own or have been granted access to. Which of the following data dictionary views would you query to see a listing of these tables?

    1. DBA_TABLES

    2. USER_TABLES

    3. ALL_TABLES

    4. MY_TABLES

  11. You want to configure the instance so that the sizes of the Shared Pool, Buffer Cache, Large Pool, and Java Pool are automatically managed by Oracle. Which initialization parameter do you need to set to allow this to happen?

    1. SGA_TARGET

    2. SHARED_POOL_SIZE

    3. LARGE_POOL_SIZE

    4. DB_CACHE_SIZE

  12. Which of the following is not considered part of an Oracle database?

    1. Datafiles

    2. Redo logs

    3. PFILE and SPFILE

    4. Control files

  13. Which of the following statements is not always true?

    1. Every database has at least three tablespaces.

    2. Every database has at least three datafiles.

    3. Every database has at least three multiplexed redo logs.

    4. At least three types of segments can exist in a database.

  14. The LRU algorithm is used to manage what part of the Oracle architecture?

    1. Users who log on to the database infrequently and may be candidates for being dropped.

    2. The datafile that stores the least amount of information and will need the least frequent backup.

    3. The tables that users rarely access so that they can be moved to a less active tablespace.

    4. The Shared Pool and Database Buffer Cache portions of the SGA.

  15. Two structures make up an Oracle server: an instance and a database. Which of the following best describes the difference between an Oracle instance and a database?

    1. An instance is made up of memory structures and processes, whereas a database is composed of physical files.

    2. An instance is only used during database creation; after that, the database is all that is needed.

    3. An instance is started whenever the demands on the database are high, but the database is used all the time.

    4. An instance is configured using a PFILE, whereas a database is configured using an SPFILE.

  16. Which of the following is the proper order of Oracle's storage hierarchy, from smallest to largest?

    1. Operating system block, database block, segment, extent

    2. Operating system block, database block, extent, segment

    3. Segment, extent, database block, operating system block

    4. Segment, database block, extent, operating system block

  17. You've been asked to install Oracle 10g on a new Unix server. You're likely to ask the Unix system administrator to do all but which of the following for you in order to get the new server ready for Oracle?

    1. Modify the server's kernel parameters.

    2. Create a new Unix user to own the Oracle software.

    3. Create the mount points and directory structure using the OFA model.

    4. Determine which directory will be used for $ORACLE_HOME.

  18. Oracle's OFA model specifies a naming convention for all but which of the following?

    1. User names

    2. Mount points

    3. Directory paths

    4. Database filenames

  19. The Oracle Universal Installer is started by executing which program?

    1. emctl

    2. runInstaller

    3. ouistart

    4. isqlplusctl

  20. On Unix systems, the script root.sh must be executed during the installation process. What is the purpose of this script?

    1. It creates the root user in the database.

    2. It creates the root directory for the server.

    3. It grants root superuser privileges to the Oracle Unix account.

    4. It copies files and sets permissions on files outside $ORACLE_HOME.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset