ocp习题-Chapter 1 Oracle Database 10g Components and Architecture

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

A. i SQL*Plus is accessed via a web browser, but SQL*Plus must be run from a client or on

the server.

B. i SQL*Plus output is displayed in a separate window from the commands, but SQL*Plus displays

everything in one window.

C. i SQL*Plus can use SQL and PL/SQL to access the database, as can SQL*Plus.

D. i SQL*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.

 

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

A. Every database has at least three tablespaces.

B. Every database has at least three datafiles.

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

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

 

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

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

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

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

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

 

17. You’ve been asked to install Oracle 10 g 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?

A. Modify the server’s kernel parameters.

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

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

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

 

D. While the Unix system administrator is responsible for creating volume groups and mount points, the DBA generally decides where the Oracle binaries will be installed—the location des-ignated by the $ORACLE_HOME environment variable.

 

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

A. User names

B. Mount points

C. Directory paths

D. Database filenames

 

A. The OFA model does not include any reference to naming conventions for things inside the database, such as users, tables, or tablespaces.

 

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

the purpose of this script?

A. It creates the root user in the database.

B. It creates the root directory for the server.

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

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