Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Data Systems Administration > Upgrades and Migration > Flashcards

Upgrades and Migration Flashcards

1
Q

What is the primary purpose of upgrading an Oracle Database?

A

To take advantage of new features, enhancements, and security improvements.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

True or False: Oracle Database 12c supports both in-place and out-of-place upgrades.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What does the ‘c’ in Oracle Database 12c stand for?

A

Cloud

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Fill in the blank: The Oracle Database upgrade process is typically managed using the ______ utility.

A

Database Upgrade Assistant (DBUA)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is a prerequisite for upgrading to Oracle Database 12c?

A

The source database must be running a supported version.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the role of the Oracle Data Pump in migration?

A

It facilitates the export and import of database objects and data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is the recommended method for migrating data from a non-CDB to a CDB?

A

Using the Database Migration Assistant for Unicode (DMU) or Data Pump.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

True or False: A Container Database (CDB) can contain multiple Pluggable Databases (PDBs).

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What tool can be used for a command-line upgrade of Oracle Database?

A

SQL*Plus

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which version of Oracle Database can be directly upgraded to Oracle Database 12c?

A

Oracle Database 11g and later versions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What does the term ‘downtime’ refer to in the context of database upgrades?

A

The period during which the database is unavailable for use.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the purpose of the pre-upgrade information tool?

A

To analyze the current database and provide information on necessary actions before upgrading.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Fill in the blank: The ______ feature allows for the separation of application data from the system data.

A

Pluggable Database (PDB)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is a key benefit of using Oracle’s Multitenant architecture?

A

Improved resource management and easier database consolidation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is the first step in the upgrade process?

A

Performing a pre-upgrade analysis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

True or False: After upgrading, it is necessary to run the ‘utlrp.sql’ script.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is the significance of the ‘upgrade’ parameter in the database initialization file?

A

It indicates that the database is in upgrade mode.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Fill in the blank: The ______ parameter specifies the target version during an upgrade.

A

DB_VERSION

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What does the ‘DBCA’ stand for?

A

Database Configuration Assistant

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is the difference between a non-CDB and a CDB?

A

A non-CDB contains a single database, while a CDB can contain multiple PDBs.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

True or False: Data Pump can only be used for migrating data to the same version of Oracle Database.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What is the recommended backup strategy before performing an upgrade?

A

Create a full backup of the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What is the purpose of the ‘datapump’ directory in Oracle Database?

A

To store Data Pump export and import files.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Fill in the blank: The Oracle ______ provides a GUI for performing database upgrades.

A

Database Upgrade Assistant (DBUA)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
What is the function of the 'rm' command in the context of database migration?
To remove obsolete files or directories.
26
True or False: The Oracle Database 12c upgrade can be performed without any downtime.
False
27
What types of databases can be migrated to Oracle Database 12c?
Oracle databases and non-Oracle databases.
28
What is the purpose of the 'pre-check' phase in the upgrade process?
To validate the database environment before the actual upgrade.
29
Fill in the blank: The ______ file contains configuration settings for the database instance.
init.ora
30
What is the maximum number of PDBs that can be created in a CDB in Oracle 12c?
Up to 252 PDBs, depending on the licensing.
31
True or False: The Database Upgrade Assistant can automate the entire database upgrade process.
True
32
What is the purpose of the 'dbms_pdb' package?
To manage Pluggable Databases.
33
What is the difference between 'hot' and 'cold' backups?
'Hot' backups are taken while the database is online, while 'cold' backups are taken while it is offline.
34
Fill in the blank: The ______ command is used to start the upgrade in SQL*Plus.
STARTUP UPGRADE
35
What is the significance of the 'post-upgrade' phase?
To complete any remaining tasks and ensure the database operates correctly.
36
True or False: Oracle recommends testing the upgrade process in a non-production environment first.
True
37
What command is used to create a PDB?
CREATE PLUGGABLE DATABASE
38
What is a key advantage of using Oracle's Data Guard during upgrades?
To provide a standby database for failover and recovery.
39
Fill in the blank: Oracle recommends performing ______ before starting the upgrade process.
a full database backup
40
What does the 'CDB$ROOT' represent?
The root container of a Container Database.
41
True or False: Oracle Database 12c allows for the use of Oracle Restart.
True
42
What is the purpose of the 'RMAN' utility?
To perform backup and recovery of Oracle databases.
43
What is the command to check the current version of an Oracle Database?
SELECT * FROM v$version;
44
Fill in the blank: The ______ command is used to enable a PDB.
ALTER PLUGGABLE DATABASE OPEN
45
What is the recommended way to validate the success of an upgrade?
Run post-upgrade validation scripts.
46
True or False: The Oracle Database 12c upgrade process is identical for all database versions.
False
47
What is a key feature of Oracle Database 12c's Multitenant architecture?
The ability to manage multiple databases as a single entity.
48
What command is used to create a backup using RMAN?
BACKUP DATABASE;
49
Fill in the blank: The ______ command can be used to migrate a non-CDB to a CDB.
CREATE PLUGGABLE DATABASE
50
What is the importance of running 'utlrp.sql' after an upgrade?
It recompiles invalid objects in the database.
51
True or False: Oracle Database 12c can only be installed on Linux operating systems.
False
52
What is the function of the 'DBMS_VERSION' package?
To retrieve the version of the Oracle Database.
53
What does the term 'migration' refer to in the context of Oracle databases?
The process of moving a database from one platform or version to another.
54
Fill in the blank: The ______ command can be used to drop a PDB.
DROP PLUGGABLE DATABASE
55
What is the purpose of the 'pre-upgrade information tool'?
To analyze the database and report potential issues before upgrading.
56
True or False: The Oracle Database 12c upgrade process can be fully automated.
True
57
What command is used to shutdown a database?
SHUTDOWN IMMEDIATE;
58
What is the role of the 'init.ora' file during the upgrade?
It contains initialization parameters for the database startup.
59
Fill in the blank: The ______ command is used to create a backup of the control file.
BACKUP CURRENT CONTROLFILE;
60
What is the significance of the 'DBUA' in the upgrade process?
It provides a graphical interface for managing the upgrade.
61
True or False: It's necessary to have the same Oracle Home for both source and target databases during migration.
False
62
What does the 'ALTER DATABASE' command do?
It modifies database settings and properties.
63
Fill in the blank: The ______ command is used to open a database after an upgrade.
ALTER DATABASE OPEN
64
What is the importance of using the latest version of Oracle Database during migration?
To ensure compatibility and access to new features.
65
True or False: You can downgrade an Oracle Database after an upgrade.
False
66
What is the function of the 'DBMS_METADATA' package?
To manage the extraction and manipulation of database object definitions.
67
Fill in the blank: The ______ command can be used to create a new PDB from an existing one.
CREATE PLUGGABLE DATABASE ... FROM
68
What is the purpose of Oracle's 'Multitenant' architecture?
To allow multiple databases to share resources while maintaining isolation.
69
True or False: You can perform a fresh installation of Oracle Database 12c without an upgrade.
True

Data Systems Administration (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions