ICS122 (Prelims)

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

Tablespaces

A database is divided into logical storage units called ________ which group related structures or data files together.

A text file that can be edited with a text editor

A response file is:

Segments

A tablespace contains a collection of:

1 MB

ASM disks are divided into Allocation Units (AU). The default AU size is:

The minimum memory size for the database buffer cache is set to 100 MB

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command: SQL>ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

ORACLE_BASE

Base of the Oracle directory structure.

FALSE

Bigfile Tablespace must have one (1) file of at least 100 MB.

TRUE

Data segment compression is disables by default.

Create only one DISKGROUP

During Grid infrastructure setup it is possible to:

Control files, Online redo logs

Fine-grain striping, by default, is used for _____________.

11.2, 10.1

For 11g ASM instance, the default compatibility is __________ and __________ for database compatibility.

SGA

Group of shared memory structures that contain and control information for one Oracle database instance is called _________.

Mounted exclusively in RESTRICT mode

In order to drop a database, using a DROP DATABASE command, the database must be:

When DBAS need to connect remotely to startup the database instance

In which situation would you use static database registration for a listener?

Oracle Net Listener

On the database server, Oracle Net includes an active process called __________, which is responsible for coordinating connections between the database and external applications.

NLS_LANG

Operational environment variable that controls language, territory and client character set settings.

Recovery Manager (RMAN)

Oracle tools that provide a complete solution for the backup, restoration and recovery needs of the entire database or of specific database files.

SQL*Plus

Standard command-line for managing your database.

Performs process recovery when a user profile fails

The Process Monitor (PMON) ___________.

TRUE

The Service Control utility (srvctl) can be used to start/stop the instance.

Chained row

The _______ row happen when an inserted row is too large to fit into a single block.

Block header

The _________ contains the segment type (such as table or index), data block address, table directory, row directory and transaction slots approximately 23 bytes each, which are used when modifications are made to rows in the block.

Row data

The _________ space grows upward from bottom.

Intra-block chaining

The __________ row usually happen when a table has 255 columns and the row pieces are placed across multiple blocks.

PGA

The ___________ contains data and control information for a server or background processes.

Free Space

The ___________ is the middle of the block, enabling the header and the row data space to grow when necessary.

Migrated row

The ___________ row happen when an update causes the existing row to outgrow the available free space of the current block.

Server parameter file

The acronym SPFILE stands for __________________.

FALSE

The database cannot have a mixture of Oracle-managed and unmanaged files.

3.6H

The default for DISK_REPAIR_TIME is:

Shutdown Immediate

The default shutdown mode when using Enterprise Manager is:

8192

The default value for DB_BLOCK_SIZE parameter is:

200

The default value for DB_FILES parameter is:

0

The default value for the DB_CACHE_SIZE parameter if SGA_TARGET is set:

Shutdown Normal

The default when issuing the SHUTDOWN command from SQL*Plus is:

TRUE

The entire row may not be stored in one place.

ORACLE_HOME

The environment which the Oracle products run.

ABORT

The following are forms of shutdown that do not apply when there are connected RDBMS instances except:

These are the functions of Process Monitor: Performs process recovery when a use process fails, Monitors sessions for idle session timeout, Dynamically registers database services with listeners

The following are the functions of Process Monitor except:

256 MB

The minimum recommended amount of memory for an ASM instance is:

TRUE

The parameter DB_BLOCK_SIZE is set for the lifetime of a database and cannot be changed.

ORACLE_SID

The system identifier for an Oracle instance, such as orcl for the database and +ASM for an ASM instance.

C

The tnsnames.ora file has an entry for the service alias ORCL as follows: ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.156.24.216) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.oracle.com) ) ) The TNSPING command executes successfully when tested with ORCL, but you are not able to connect to the database instance with the following command: SQL > CONNECT scott/tiger@orcl What could be the reason for this? A. The listener is not running on the database node. B. The TNS_ADMIN environmental variable is set to a wrong value. C. The orcl.oracle.com database service is not registered with the listener. D. The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.

FALSE

The universal installer performs all required configuration for installing Oracle software.

SQL*Plus and SQL Developer

These tools enable you to perform many of the database management operations as well as to select, insert, update or delete data in the database.

System Global Area (SGA), Program Global Area (PGA)

Two basic memory structures associated with an instance.

External redundancy

Type of redundancy where ASM does not provide any mirroring and the disks are assumed to be highly reliable.

Normal redundancy

Type of redundancy where ASM supports 2-way mirroring by default to assure data integrity for less reliable storage.

High redundancy

Type of redundancy where ASM supports 3-way mirroring by default for even greater assurance of data integrity.

Viewing alert summaries and performance graphs, creating and modifying objects, performing backup and recovery

What are the things that you can do with Enterprise Manager?

FALSE

When the NLS_LANG is not set properly, the data entering the database is converted properly.

TRUE

When the NLS_LANG parameter is set properly, the database can automatically convert incoming data from the client operating system.

TRUE

When using the shared server process architecture, the PGA is relocated into the SGA.

SYSOPER

Which ASM privilege has limited privilege to start and stop the ASM instance along with the set of nondestructive ALTER DISKGROUP command.

SYSASM

Which ASM privilege has the full administrative privilege?

FORCE

Which STARTUP command parameters relevant to ASM issue a SHUTDOWN ABORT to the ASM instance before restarting?

Listener.ora, sqlnet.ora

Which configuration files are used to configure the listener? listener.ora listener.conf tnsnames.ora tnsnames.conf sqlnet.ora sqlnet.conf

DBA_TABLES

Which data dictionary view can be used to find the names of all tables in the database?

Process parameter

Which initialization parameter specifies the maximum number of OS user processes that can simultaneously connect?

-The database instance that is being managed, -A Listener that allows connections to the database, -The management interface. This may be either a management agent running on the node where the database server runs or the stand-alone Oracle Enterprise Manager Database control. This is also referred to as the Database Console.

Which of the following component must be started before you can use the services of the component and must be shut down when shutting down the server hosting the Oracle database?

INSTANCE_TYPE

Which parameter is required for an ASM instance?

Shutdown Abort

Which shutdown option choose for instantaneous shutdown by aborting the database instance?

Shutdown Transactional

Which shutdown option to choose in order to disconnect all connected users after transaction have completed?

Shutdown Immediate

Which shutdown option to choose in order to rollback active transactions and disconnect all connected users?

Shutdown Normal

Which shutdown option to choose in order to wait for all currently connected users to disconnect from the database?

II and III

Which two statements are true regarding listeners? (Choose two.) I. Listeners use only the TCP/IP protocol. II. Multiple listener processes can run simultaneously on a host. III. Multiple database instances can be registered with a single listener. IV. The listener-related errors can be traced only at the administrative level. V. Only one database instance can be registered with a single listener at any time.

A and C

Which two statements correctly describe the relation between a data file and the logical database structures? A. An extent cannot spread across data files. B. A segment cannot spread across data files. C. A data file can belong to only one tablespace. D. A data file can have only one segment created in it. E. A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.

7,1,5,2,3,6. No need for step 4

You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read.

The sessions are not affected and continue to function normally

Your database is open, and the LISTENER is running. The new DBA of the system stops the listener by using the command: LSNRCTL>STOP. What happen to the sessions that are presently connected to the database instance?

Database Configuration Assistant (DBCA)

_______ creates a database from Oracle-supplied templates, enabling you to copy a pre-configured seed database.

Password file

_________ allows users using sysdba, sysoper, and sysasm roles to connect remotely to the instance and perform administrative tasks.

Data files

_________ contain the user or application data of the database as well as metadata and data dictionary.

Parameter file

_________ is used to define how the instance is configured when it starts up.

ASM files

_________ is/are collection of ASM extents composed of AUs.

Online redo log files

__________ allow for instance recovery of the database.

Oracle Enterprise Manager (EM)

__________ combines a graphical console, agents, common services and tool to provide an integrated and comprehensive system management platform for managing Oracle products.

Server process

__________ connects to the Oracle instance and is started when the user establishes a session.

Archived redo log file

__________ contain an on-going history of the data change that are generated by the instance.

SQL Developer

__________ is a graphical user interface for accessing your instance of Oracle Database. It supports the development in both SQL and PL/SQL.

Segment

__________ is a set of extent allocated for a certain logical structure.

Server Control Utility (srvctl)

__________ is a standard command-line interface that can be used to start and stop the database and instances, manage ASM instances, manage configuration information, and move or remove instances and services.

Extent

__________ is specific number of contiguous oracle blocks that are used to store specific type of information.

User process

__________ is the application or tool that connects to the Oracle database.

Process Monitor Process (PMON)

__________ performs process recovery when the user process fails.

System Monitor Process (SMON)

__________ performs recovery at instance startup and cleans up unused temporary segment.

Enterprise Manager

__________ provides a graphical interface for doing almost task that you need to do as database administrator.

Background processes

__________ started when an Oracle instance started

Control files

___________ contain data about the database itself.

Oracle Universal Installer (OUI)

___________ is a Java application that performs component-based installations and enables different levels of integration bundle, suite and Web-based installations as well as complex logic in a single package.


Ensembles d'études connexes

BIO 142 Lymphatic & Immune System

View Set

好词好句 (4) good sentences for emotion

View Set

Chapter 8: Environmental Health and Toxicology

View Set

CHAPTER 63 - Management of Patients with Neurologic Trauma

View Set

Research in Health Science set I

View Set

Biology Exam 2 Practice Questions

View Set

Chapter 15: Mental and Behavioral Health

View Set