DATA SYSTEMS ADMINISTRATION - D330 (All Questions from Chapter 8-10, 12-15, and 17)

Which parameter can an administrator enable without restarting a database?

A. COMPATIBLE

B. DB_DOMAIN

C. SGA_TARGET

D. UNDO_MANAGEMENT

C. SGA_TARGET

Which view displays database parameters and values modified using the SCOPE=SPFILE clause?

A. V$SPPARAMETER

B. V$NLS_PARAMETER

C. V$HS_PARAMETER

D. V$PARAMETER

A. V$SPPARAMETER

Which command performs a clean shutdown without waiting for clients to disconnect?

A. SHUTDOWN ABORT

B. SHUTDOWN NORMAL

C. SHUTDOWN TRANSACTIONAL

D. SHUTDOWN IMMEDIATE

D. SHUTDOWN IMMEDIATE

Which area is a member of the System Global Area (SGA)?

A. Java pool

B. Log writer

C. Database writer

D. Process monitor

A. Java Pool

Which types of events are recorded in an alert log?

A. Package creation

B. User creation

C. Role creation

D. Tablespace creation

D. Tablespace creation

Which initialization parameter sets the location of the alert log?

A. AUDIT_FILE_DEST

B. LOG_ARCHIVE_DEST

C. DIAGNOSTIC_DEST

D. CORE_DUMP_DEST

C. DIAGNOSTIC_DEST

Where is the listener.ora file located by default?

A. $ORACLE_HOME/RDBMS

B. $ORACLE_HOME/NETWORK/ADMIN

C. $ORACLE_HOME/DATABASE/ADMIN

D. $ORACLE_HOME/DBS/ADMIN

B. $ORACLE_HOME/NETWORK/ADMIN

Which type of connection uses the Oracle Listener to communicate?

A. Client with database server

B. Browser with application server

C. Two application servers

D. Client with backup tool

A. Client with database server

What does the SERVER=DEDICATED element in a tnsnames.ora file associate with each client connection?

A. A committed server process

B. A shared server process

C. A pooled server process

D. A dispatched server process

A. A committed server process

Which net service naming method requires the client to use a fixed port number?

A. Local

B. External

C. Host

D. Directory

C. Host

A database link named wgu2021 has been created to link to a remote object in the test database. The object is named employee and is owned by Scott.

Which reference resolves to the remote object?

A. scott.employee@wgu2021

B. scott.employee

C. employee

D. scott.employee@test

A. scott.employee@wgu2021

Which information from a remote database is included in the configuration of a database link?

A. User name

B. Data files

C. Tables

D. Views

A. User name

Which object can be added to an existing bigfile tablespace?

A. datafiletemp table

B. table data

C. tablespacedictionary table

D. undo data

B. table data

What is the purpose of the undo tablespace?

A. To manage space for sort operations

B. To facilitate the rollback of transactions

C. To allocate space for SQL cursors

D. To maintain the Automatic Workload Repository

B. To facilitate the rollback of transactions

Which dictionary view is available in the database to view segment advisor results?

A. DBA_ADVISOR_TASKS

B. DBA_ADVISOR_TEMPLATES

C. DBA_ADVISOR_OBJECTS

D. DBA_ADVISOR_USAGE

C. DBA_ADVISOR_OBJECTS

A database administrator needs to recover unused space from a tablespace while preventing data loss.

What should the administrator use?

A. The SHRINK option

B. The DROP command

C. The FLASHBACK command

D. The OFFLINE clause

A. the SHRINK option

Which package should an administrator use to configure local extent management for tablespaces?

A. DBMS_SPACE_ADMIN

B. DBMS_AUDIT_MGMT

C. DBMS_TRANSFORM

D. DBMS_METADATA

A. DBMS_SPACE_ADMIN

What should an administrator use to identify tables that are fragmented?

A. Segment Advisor

B. Automatic Database Diagnostic Monitor

C. DBMS_SPACE

D. DBMS_REPAIR

A. segment advisor

Which parameter determines how long information should be kept before it is overwritten in an undo tablespace?

A. UNDO_RETENTION

B. DBA_FLASHBACK_RETENTION_TARGET

C. SORT_AREA_RETAINED_SIZE

D. UNDO_MANAGEMENT

A. UNDO_RETENTION

How is undo tablespace storage allocated?

A. Segments are assigned dynamically each time a change is made.

B. Segments are static and are configured by the database administrator.

C. Each transaction specifies how many segments are required for the transaction.

D. Each transaction uses segments that are released from prior transactions.

A. Segments are assigned dynamically each time a change is made.

Given the following transactions and sessions named Session1 and Session2:

At 8:00, Session1 issues the statement: UPDATE POLICY SET LOB= '16' WHERE status='bound' AND LOB_CAT='cancel';

At 8:05, Session1 commits the update transaction.

At 8:05, Session2 issues the statement: UPDATE POLICY SET LOB= '16' WHERE status='submitted' And LOB_CAT='cancel';

At 8:15, Session1 issues the statement: UPDATE POLICY SET LOB= '81' WHERE status='bound' AND LOB_CAT='cancel';

At 8:30, Session2 issues the statement: UPDATE POLICY SET LOB= '16' WHERE status='bound' AND LOB_CAT='cancel';

What happens after Session2 issues the statement at 8:30?

A. A deadlock occurs, and the database cancels Session2.

B. The database is updated by the second transaction from Session2.

C. A deadlock occurs, and the database cancels Session1.

D. The database is not updated, and both sessions are terminated.

A. A deadlock occurs, and the database cancels Session2.

Which condition is automatically resolved by Oracle without human intervention?

A. Deadlocks

B. "Snapshot too old" error

C. Resumable space allocation

D. Flash recovery area

A. Deadlocks

Which feature allows a failed transaction to be suspended until the problem that caused the failure is resolved?

A. Resumable space allocation

B. Segment shrinking

C. Instance recovery

D. Oracle managed files

A. Resumable space allocation

Which view has space information?

A. DBA_OBJECTS

B. V$TABLESPACE

C. V$SQLTEXT

D. DBA_DATA_FILES

D. DBA_DATA_FILES

An administrator attempts to roll back a transaction from the previous day. The rollback attempt fails.

Which action will prevent the failure from recurring?

A. Enabling the retention guarantee

B. Setting the session to be resumable

C. Flushing the log buffer

D. Restarting the database

A. Enabling the retention guarantee

What is the impact of setting the value of the undo retention initialization parameter to 900 in an undo tablespace that uses a fixed size?

A. Data for committed transactions will be kept for the specified period of time.

B. Data for committed transactions will be overwritten if an active transaction needs the space.

C. Up to 900 MB of data will be protected from being overwritten.

D. Up to 900 transactions will be protected from being overwritten.

B. Data for committed transactions will be overwritten if an active transaction needs the space.

Which parameter disables conventional path loading when using SQL*Loader?

A. PARALLEL

B. SILENT

C. DIRECT

D. RESUMABLE

C. DIRECT

What allows users to capture data from non-Oracle sources into an Oracle database?

A. SQL*Loader

B. Recovery Manager

C. Transportable Tablespaces

D. Import Transformation

A. SQL*Loader

Which SQL statement is allowed with external tables?

A. UPDATE

B. DELETE

C. SELECT

D. INSERT

C. SELECT

An administrator plans to use SQL*Loader to import a data file using a fixed-width format.

Which file must be configured before importing the file?

A. Control

B. Data

C. Bad

D. Discard

A. Control

Which tool identifies potential performance bottlenecks?

A. Cluster Verification Utility

B. Automatic Database Diagnostic Monitor

C. Oracle Data Guard Broker

D. Privilege Analysis

B. Automatic Database Diagnostic Monitor

Which tool contains procedures to collect performance information on database objects?

A. DBMS_STATS

B. Automated Maintenance Tasks

C. DBMS_WORKLOAD_REPOSITORY

D. Cost-based optimizer

A. DBMS_STATS

Which tool is started by the system and automatically improves the performance of queries?

A. SQL Tuning Advisor

B. SQL*Loader

C. SQL Access Advisor

D. SQL*Plus

A. SQL Tuning Advisor

When does a DBA run an Automatic Workload Repository (AWR) report to find the root cause of an issue?

A. When a job is running slow in the database

B. When the database fails to recover

C. When the database fails to start up

D. When a space issue occurs in the database

A. When a job is running slow in the database

Which additional information can administrators collect by configuring the Automatic Workload Repository (AWR) to use the ALL statistics collection level?

A. Row count

B. Execution plan

C. Table histogram

D. Column density

B. Execution plan

An administrator runs the following SQL statements:

CREATE USER HR_User IDENTIFIED BY 'Password' DEFAULT TABLESPACE DATA;

GRANT CREATE SESSION, CREATE TABLE to HR_User;

HR_User creates a new table in their own schema.

What happens when HR_User inserts a row into the new table?

A. The insert fails with an error for missing privileges on the DATA tablespace.

B. The insert succeeds and its segment is added in the DATA tablespace.

C. The insert fails with an error for missing privileges on the TEMPORARY tablespace.

D. The insert succeeds and its segment is added to the SYSTEM tablespace.

A. The insert fails with an error for missing privileges on the DATA tablespace.

Which parameter is used when creating a user account that will be authenticated by the operating system?

A. GLOBALLY

B. VALUES

C. USING

D. EXTERNALLY

D. EXTERNALLY

Which dictionary table stores the credentials for a password-authenticated account?

A. USER$

B. UET$

C. FET$

D. AUD$

A. USER$

Given the following SQL statement:

DROP USER User1 CASCADE;

What happens to tables that User1 owns when an administrator runs the SQL statement?

A. Tables are moved to a default account.

B. Tables and the data are deleted from the database.

C. Tables are archived by the system.

D. Tables and data are moved to the undo tablespace.

B. Tables and the data are deleted from the database.

Which privilege is required to add a foreign key constraint to a table owned by another user?

A. REFERENCES

B. UPDATE

C. ALTER

D. INSERT

A. REFERENCES

Which privilege provides grantees permission to remove accounts from a database?

A. Drop user

B. Alter user

C. Drop profile

D. Alter profile

A. Drop user

What is the result of the CASCADE option when used with the DROP USER command?

A. All the user's objects are removed from the database.

B. Any privileges granted by the user are revoked.

C. All objects that depended on the users' objects are removed.

D. Any user accounts that accessed the users' data are disabled.

A. All the user's objects are removed from the database.

Which privilege must be granted to allow a user to modify existing rows in a table?

A. UPDATE

B. ALTER

C. DEBUG

D. INSERT

A. UPDATE

A user creates a role granting select and update access to table1, and assigns the role to a coworker. The next day the user revokes select access from the role.

Which actions will the coworker still be able to perform on table1?

A. Modify

B. Display

C. Add

D. Delete

A. Modify

A user needs to view the table privileges of other users.

Which role should be granted to the user?

A. SELECT_CATALOG_ROLE

B. CONNECT

C. EXECUTE_CATALOG_ROLE

D. RESOURCE

A. SELECT_CATALOG_ROLE

After an administrator granted some privileges to a user, all database users automatically had those same privileges.

Which user was assigned the privileges?

A. PUBLIC

B. SCOTT

C. SYSTEM

D. DBSNMP

A. PUBLIC

An administrator wants to limit CPU time for accounts.

Which object should the administrator alter?

A. Profile

B. Role

C. Tablespace

D. Schema

A. Profile

In response to users' complaints that the system is slow, a database administrator detects that a user is consuming too many resources.

Which parameter controls the use of service units?

A. CPU_PER_CALL

B. CPU_PER_SESSION

C. COMPOSITE_LIMIT

D. ASM_POWER_LIMIT

C. COMPOSITE_LIMIT

An administrator creates a user profile that forces a change to the user's password at the first login.

Which clause did the administrator include in the create user statement?

A. BY PASSWORD

B. ACCOUNT LOCK

C. PASSWORD EXPIRE

D. ACCOUNT UNLOCK

C. PASSWORD EXPIRE

Which type of database backup can be performed while a database is online?

A. Partial

B. Full

C. Consistent

D. Inconsistent

D. Inconsistent

Which file must be present to start an instance of a database?

A. Control

B. Redo

C. Archive

D. Alert

A. Control

Which format minimizes the space required for a full database backup?

A. Compressed

B. Image

C. Backup set

D. Binary file

A. Compressed

What can be queried from a database while it is in the NOMOUNT state?

A. Instance parameters

B. Control file records

C. Checkpoint information

D. Incarnation information

A. Instance parameters

An administrator starts a database and initiates instance recovery.

Which type of files can be recovered?

A. Control

B. Redo log

C. Data

D. Trace

C. Data

Which parameter affects the mean time to recovery target for a database instance?

A. LOG_CHECKPOINTS_TO_ALERT

B. LOG_CHECKPOINT_INTERVAL

C. LOG_ARCHIVE_TRACE

D. LOG_FILE_NAME_CONVERT

B. LOG_CHECKPOINT_INTERVAL

Which process duplicates modified blocks from a buffer cache to files on disk?

A. Apply Server (ASnn)

B. Checkpoint (CKPT)

C. Database Writer (DBWn)

D. Log Writer (LGWR)

C. Database Writer (DBWn)

Which file does the Database Upgrade Assistant (DBUA) obtain its list of databases from?

A. tnsnames.ora

B. glogin.sql

C. host_name.olr

D. sqlnet.ora

C. host_name.olr

Which action updates a database from an earlier version to a newer version while the database remains online?

A. Using Oracle Golden Gate

B. Using Oracle Universal Installer

C. Performing a manual upgrade

D. Performing a parallel upgrade

A. Using Oracle Golden Gate

Which data pump parameter can an administrator use to perform a metadata-only export?

A. CONTENT

B. SCHEMAS

C. INCLUDE

D. ATTACH

A. CONTENT

Which method allows any Oracle release to be migrated to Oracle 12c?

A. Export and Import

B. Manual Upgrades

C. Transportable Tablespaces

D. Database Upgrade Assistant

A. Export and Import

A database will be migrated to a platform that has a different endianness.

Which action must be performed on the data files before the migration?

A. Compress by using a compression tool

B. Convert by using Recovery Manager

C. Include in a transportable tablespace

D. Verify free space allocation of 20%

B. Convert by using Recovery Manager

Which method is used to perform an in-place upgrade?

A. Database Upgrade Assistant

B. Export/import

C. Transportable tablespace

D. Oracle GoldenGate

A. Database Upgrade Assistant

Which type of auditing rule records table insert operations?

A. Action

B. Privilege

C. Role

D. Object

A. Action

How should an administrator enable mixed-mode auditing for a database?

A. By configuring the ORA_ACCOUNT_MGMT predefined policy

B. By recompiling the Oracle executable using the uniaud_on parameter

C. By setting the parameter COMPATIBLE to 12.1

D. By setting the parameter STATISTICS_LEVEL to ALL

A. By configuring the ORA_ACCOUNT_MGMT predefined policy

Which interactive tool presents a view of an alert log?

A. adrci

B. imp

C. lsnrctl

D. tkprof

A. adrci

Which information is included in the output of the utlu121s.sql post-upgrade status script?

A. Information about the current version of database components

B. The before and after upgrade size of the SYSTEM tablespace

C. Newly created default accounts that should be locked

D. A list of patches recommended for the new version

A. Information about the current version of database components

A company plans to use Data Guard SQL Apply to migrate a database to Oracle 12c.

Which type of upgrade does this tool perform?

A. Rolling

B. Export/import

C. Transportable tablespace

D. Direct

A. Rolling

Which upgrade option automates the upgrade process without user intervention?

A. Database Upgrade Assistant GUI interface

B. Manual database upgrade

C. Database Upgrade Assistant in silent mode

D. Export/import upgrade

C. Database Upgrade Assistant in silent mode

Which parameter must be set after an upgrade to enable the new version's features?

A. processes

B. cluster_database

C. compatible

D. hs_autoregister

C. compatible

Which tool provides status upgrade result information after an upgrade?

A. utluiobj.sql

B. emremove.sql

C. catuppst.sql

D. utlu121s.sql

D. utlu121s.sql

Choose two SGA structures that are required in every Oracle instance.

A. Large pool

B. Shared pool

C. Buffer cache

D. Java pool

B. Shared pool

C. Buffer cache

Database buffer cache, shared pool, and log buffer are required; they are configured automatically in every instance. It is better to use Automatic Memory Management

or Automatic Shared Memory Management, so that the DBA does not need to tune individual components.

Which statement is true?

A. A database can have only one control file.

B. A database must have at least two control files.

C. A database may have zero or more control files.

D. A database must have at least one control file.

D. A database must have at least one control file.

The control file is the most key file in an Oracle database. Due to its importance, it is a good practice to have two more copies of the file. A database must have at least one control file to start the database.

Which component is configured at database startup and cannot be dynamically managed?

A. Redo log buffer

B. Streams pool

C. Java pool

D. Shared pool

E. None of the above

A. Redo log buffer

An Oracle database allows you to manage all memory components dynamically, except the redo log buffer. Redo log buffer is set at instance startup and is not dynamically alterable without restarting the instance.

Which component is not part of an Oracle instance?

A. System global area

B. Process monitor

C. Control file

D. Shared pool

E. None

C. Control file

Control file, data file, and redo log files are part of the Oracle database. The Oracle instance constitutes the memory structures and background processes.

Which background process guarantees that committed data is saved even when the changes have not been recorded in data files?

A. DBWn

B. PMON

C. LGWR

D. CKPT

E. ARCn

C. LGWR

The log writer (LGWR) process writes the redo log buffer information to the online redo log files. A commit operation is completed only after the redo buffer is written to online redo log files.

User John has updated several rows in a table and issued a commit. What does the DBWn (database writer) process do at this time in response to the commit event?

A. Writes the changed blocks to data files.

B. Writes the changed blocks to redo log files.

C. Triggers checkpoint and thus LGWR writes the changes to redo log files.

D. Does nothing.

D. Does nothing.

When a user issues a commit, the LGWR process makes sure the redo log buffer is written to the online redo log files. Database writer takes no action against the commit event.

Which of the following best describes a RAC configuration?

A. One database, multiple instances

B. One instance, multiple databases

C. Multiple databases plugged in from multiple servers

D. Multiple databases, multiple instances

A. One database, multiple instances

With Real Application Clusters, multiple instances (known as nodes) can mount one database. One instance can be associated with only one database.

Which component of the SGA contains the parsed SQL code?

A. Database buffer cache

B. Dictionary cache

C. Library cache

D. Parse cache

C. Library cache

The shared SQL area is stored in the library cache in a shared pool and is shared between users. If a query is executed again before it is aged out of the library cache, Oracle will use the parsed code and execution plan from the library cache. The database buffer cache has the data blocks cached. The dictionary cache caches data dictionary information. There is no SGA component called the parse cache.

Which tasks are accomplished by the SMON process? (Choose all that apply.)

A. Performs recovery at instance startup

B. Performs cleanup after a user session is terminated

C. Starts any server process that stopped running

D. Coalesces contiguous free space in dictionary-managed tablespaces

A. Performs recovery at instance startup

D. Coalesces contiguous free space in dictionary-managed tablespaces

SMON is responsible for performing instance recovery using the online redo log files and for coalescing contiguous free space in tablespaces. The PMON is responsible for session cleanup and for freeing up all resources after a user session is terminated.

Choose the best statement from the options related to segments.

A. A contiguous set of blocks constitutes a segment.

B. A nonpartitioned table can have only one segment.

C. A segment can belong to more than one tablespace.

D. All of the above are true.

B. A nonpartitioned table can have only one segment.

A table or index has a segment. A segment consists of one or more extents. A segment can belong to only one tablespace, but it can span across multiple data files.

From the following list, choose two processes that are optional in an Oracle Database 12c database.

A. MMON

B. MMNL

C. ARCn

D. MMAN

C. ARCn

D. MMAN

MMON (Manageability Monitor) captures the AWR database and performs ADDM analysis. MMNL (Manageability Monitor Lite) performs tasks related to active session-history sampling and metrics computation. The ARCn (Archiver) process is responsible for writing redo log copies to the archive log location. This process is

enabled only when the database is running in ARCHIVELOG mode. MMAN (Memory Manager) is responsible for resizing the memory components when required. This process is active only when Automatic Memory operations are configured.

Which SGA component will you increase or configure so that RMAN tape backups do not use memory from the shared pool?

A. Java pool

B. Streams pool

C. Recovery pool

D. Large pool

D. Large pool

The large pool is configured so that RMAN does not use the shared pool; therefore, the shared pool is totally dedicated to application space.

When a user session is terminated, which processes are responsible for cleaning up and releasing locks?

A. DBWn

B. LGWR

C. MMON

D. PMON

E. SMON

D. PMON

PMON is responsible for cleaning up failed user processes. It reclaims all the resources held by the user and releases all locks on tables and rows held by the user. No other process is involved in the session cleanup.

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

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

B. The data file that stores the least amount of information and will need the least frequent backup

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

D. The shared pool and database buffer cache portions of the SGA

D. The shared pool and database buffer cache portions of the SGA.

The LRU mechanism ensures that each user's server process can find free space in the shared pool and database buffer cache whenever they need it, but it also keeps frequently used objects cached in those memory areas.

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?

A. An instance consists of memory structures and processes, whereas a database is composed of physical files.

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

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

D. An instance is configured using a pfile, whereas a database is configured using a spfile.

A. An instance consists of memory structures and processes, whereas a database is composed of physical files.

The instance consists of the SGA and all the Oracle background processes. The database is composed of the control files, data files, and redo logs.

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

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

Multiple operating-system blocks make up database blocks, contiguous chunks of which make up extents. A segment consists of one or more extents.

The DBA unknowingly terminated the process ID belonging to the PMON process of Oracle Database 12c database using the kill -9 command on Unix. Choose the best answer:

A. Oracle spawns another PMON process automatically.

B. The database hangs, and the DBA must manually start a PMON process.

C. If the database is in ARCHIVELOG mode, Oracle automatically starts another PMON process and recovers from the database hang.

D. The instance crashes and needs to be restarted.

D. The instance crashes and needs to be restarted.

PMON is one of the critical processes of Oracle Database 12c, and terminating that process will crash the database. During instance startup, Oracle will require the redo log files with status CURRENT as well as ACTIVE in order to perform instance recovery.

When an incremental checkpoint happens in a database, which file(s) are updated with the checkpoint position?

A. Data files

B. Control files

C. Initialization Parameter Files

D. Redo log files

E. Archive log files

B. Control files

During an incremental database checkpoint, the control file is updated with the checkpoint position; data files are not updated. Data file headers are updated with checkpoint information by the DBWn process when dirty buffers are written to the files. During threaded checkpoint or full database checkpoint, all file headers are updated. This happens during a normal shutdown as well as during online log switch.

User Isabella updates a table and commits the change after a few seconds. Which of the following actions are happening in the database? Order them in the correct sequence and ignore the actions that are not relevant.

1. A. Oracle reads the blocks from data file to buffer cache and updates the blocks.

2. E. The server process writes the change vectors to the redo log buffer.

3. C. The user commits the change.

4. F. LGWR flushes the redo log buffer to redo log files.

5. G. A checkpoint occurs.

6. B. Changed blocks from the buffer cache are written to data files.

7. D. LGWR writes the changed blocks to the redo log buffer. (Not Relevant)

A, E, C, F, G, B.

Data blocks are always changed in the memory, and the change vec tors are written to redo the log buffer. LGWR writes the redo log buffers to redo the log files on disk as soon as the commit occurs. This guarantees recoverability. During a checkpoint, data files are updated with the changed blocks by the DBWn process.

Querying the V$LOG file shows the following information. Which redo group files are required for instance crash recovery?

SQL> select GROUP#, ARCHIVED, STATUS from V$LOG;

GROUP# ARC STATUS

---------- --- ----------------

1 NO CURRENT

2 NO INACTIVE

3 NO INACTIVE

4 NO ACTIVE

A. Group 1 and 4

B. Group 2 and 3

C. Groups 1 through 4

D. Group 1

E. Group 4

A. Group 1 and 4

Redo log groups with status CURRENT and ACTIVE are required during instance crash recovery.

You noticed that the current value of the UNDO_RETENTION parameter is 900 and is too low for some of your transactions. The database was created using DBCA. You issue the following statement:

ALTER SYSTEM SET UNDO_RETENTION=4800;

Which option is true?

A. UNDO_RETENTION is a static parameter and, therefore, cannot be changed using ALTER SYSTEM.

B. The change will be available to the instance only after a database cycle.

C. The value is changed in memory, and when the database restarts the next time, the new value will be preserved when using the spfile.

D. The value is changed only in memory, and the server parameter file needs to be updated for the change to persist across database shutdowns.

C.

When using ALTER SYSTEM to change parameter values, the change is made to the server parameter file (spfile) too, because the default for the SCOPE clause is BOTH. Option D would have been correct, if the pfile were used to start up the database. When a database is created using DBCA, the parameter file created is always spfile.

You need to find the directory where the Oracle alert log is being written. Which initialization parameter can be best used to list the full directory path of the alert log location?

A. ALERT_LOG_DEST

B. BACKGROUND_DUMP_DEST

C. DIAGNOSTIC_DEST

D. INIT_LOG_DUMP_DEST

B. BACKGROUND_DUMP_DEST.

DIAGNOSTIC_DEST is the initialization parameter that determines where the Automatic Diagnostic Repository home is located. The alert log file would be in the /diag/rdbms///alert directory. A text version of the alert log is in the /diag/ rdbms///trace directory. But BACKGROUND_DUMP_DEST shows the full path of the trace directory location.

Which data dictionary view is used to view the current values of parameters?

A. V$DATABASE

B. V$SPPARAMETER

C. V$PARAMETER

D. V$SYSPARAMETER

C. V$PARAMETER

V$PARAMETER shows information about the parameters and their current values in the database. V$SPPARAMTER shows the information as read from the spfile.

Which startup options must be used to start the instance when you create a new database?

A. STARTUP FORCE

B. STARTUP MOUNT

C. STARTUP RESTRICT

D. STARTUP NOMOUNT

D. STARTUP NOMOUNT

When creating a new database or creating a control file, the database should be in the NOMOUNT state.

The DIAGNOSTIC_DEST parameter is not set up in the initialization parameter file. The value of the ORACLE_HOME environment variable is /u01/app/oracle/product/12.1.0, and the value of ORACLE_BASE is /u01/app/oracle. The database and instance name is xyz.

What is the location of the text-alert log file for the xyz database?

A.)/u01/app/oracle/product/12.1.0/log/rdbms/xyz/xyz/trace

B.)/u01/app/oracle/diag/rdbms/xyz/xyz/trace

C.)/u01/app/oracle/diag/rdbms/xyz/xyz/alert

D.)/u01/app/oracle/product/12.1.0/diag/rdbms/xyz/xyz/trace

E.)/u01/app/oracle/log/rdbms/xyz/xyz/trace

B. /u01/app/oracle/diag/rdbms/xyz/xyz/trace

The alert log file in Oracle Database 12c is saved in the $ORACLE_BASE/diag/ rdbms///trace directory. The XML version of the alert log file is in the $ORACLE_BASE/diag/rdbms///alert directory.

You want to create a database using the DBCA with DB_BLOCK_SIZE as 32KB. Which statement is true?

A. A block size of 32KB is not allowed in Oracle Database 12c.

B. You must choose the Data Warehouse template in the DBCA.

C. You must choose the Custom template in the DBCA.

D. You must set the environment variable DB_BLOCK_SIZE to 32,768.

C. You must choose the Custom template in the DBCA.

The Custom template lets you choose the database block size in the DBCA. If the template includes data files, the block size of the template cannot be changed. The predefined templates that come with data files have the block size at 8K

All of the following are database-management options within the Database Configuration Assistant except which one?

A. Change Database Initialization Parameters

B. Create a Database

C. Manage Templates

D. Delete a Database

A. Change Database Initialization Parameters

The Database Configuration Assistant lets you create databases, manage templates, add database options, and delete databases. Although you can change initialization parameters when you are defining a database, this is not one of the management options available.

The Oracle Universal Installer is started by executing which program?

A. emctl

B. runInstaller

C. ouistart

D. isqlplusctl

B. runInstaller

The runInstaller executable performs a preinstall check of the operating system and hardware resources before starting the OUI graphical tool.

You've been asked to install Oracle Database 12c on a new Linux server. You're likely to ask the Unix system administrator to do all but which one 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. Determine which directory will be used for $ORACLE_HOME.

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 derived from $ORACLE_BASE or designated by the $ORACLE_HOME environment variable.

Your database name is OCA12C. The options show the files that are available in the $ORACLE_HOME/dbs directory. Which file is used to start up the database instance when you issue the STARTUP command?

A. initOCA12C.ora

B. OCA12Cspfile.ora

C. spfile.ora

D. init.ora

C. spfile.ora

When starting the instance, Oracle looks for spfileOCA12C.ora file. If it cannot find that file, it looks for spfile.ora. If that file is not found, Oracle looks for the initOCA12C.ora file.