ICS122 (Prelims)
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.