Make your own quiz Manage my Quizzes Plans / Features Guides and Help Contact Privacy & Security

SUBP-2kol

Create a professional and engaging illustration depicting a database with gears and graphs, symbolizing data management, performance tuning, and SQL operations in an Oracle Database context.

Oracle Database Mastery Quiz

Test your knowledge and expertise in Oracle Database management with our comprehensive quiz! Dive into various topics, including backup strategies, performance tuning, data recovery, and SQL operations.

36 questions covering key database concepts
Evaluate your skills and knowledge
Great for DBAs, developers, and students

36 Questions9 MinutesCreated by OptimizingData321

Which two statements are true regarding consistent backups? (Choose two)

Database can be opened immediately after the restore operation.

Database can be opened only after the restore and recovery operations.

Consistent backups can be taken only when the instance is running and the database is closed.

Consistent backups can be taken only when the instance is shut clown and the database is closed.

Consistent backup are taken before the changes in the online redo log files haw been applied to the data files.

You are a performance-sensitive DBA, and you are nervous about gathering new statistics, since they may alter optimization plans in an unexpected way. To avoid this potential outcome, your best course of action would be to:

Refrains from collecting statistics

Use Real Application Testing to capture the workload and the worked and then run the

Use hints to create fixed plans for SQL statements

Use deferred publishing of statistics to allow you to test execution plans before making the statistics public

Use invisible indexes to dominate execution plans

Evaluate the following command:

$sqlplus / nolog

In which scenario would the above command execute successfully?

Only from the server if the database instance is not up.

Either from the server or client even if the database instance is not up.

Either from a client or server only if the database instance is up and the command connects the session to the instance.

Either from a client or server only if the database instance is up but the command does not connect the session to the instance.

View the exhibit.

You plan to load the customer information that has been brought from a non Oracle database in the CUSTOMERS table in your database using the "Enterprise Manager –Load Data From User File" option. Which files should you create before using this option?

Only data file

Data file and log file

Data file and dump file

Data file and control file

In your database, the SQL Tuning Advisors running automatically during the system maintenance window as a maintenance task. Which of its recommendations would be implemented automatically?

Creation of new indexes

Refreshing optimizer statistic

Restructuring SQL statements

Creation or modification of a SQL Profile

Which two statements we true regarding the index creation recommendations given by SQL Tuning Advisor and SQL Access Advisor?(Choose two.)

SQL Tuning Advisor considers the impact of the indexes only queries

SQL Tuning Advisor considers the impact of the indexes on both queries and DML operations

SQL Tuning Advisor considers the impact of the new indexes on both queries and DML operations. D

SQL Tuning Advisor considers the impact of the indexes on only data manipulation language (DML) operations

Which three statements about the Automatic Database Diagnostic Monitor (ADDM) are true? (Choose three)

requires the database to be open

Analyses the performance of specified objects

Implements all recommendations automatically

recommends solutions and quantifies expected benefits

Retains snapshots in the SYSAUX tablespace until the database is restarted

Analyzes the snapshots stored in the Automatic Workload Repository (AWR)

User HR has made some modifications to the data in the HR.EMPLOYEES table. You need to now restore the data in the table to a previous version and use the Enterprise Manager. From which source dose the operation flash back the table data to the specified time?

Redo logs

Undo tablespace

Flash recovery area

Temporary tablespace

Which two statements are true regarding point-in-time recovery? (Choose two.)

It requires the SPFILE

It requires the control file

It uses only online redo logs

It uses both archivelog and online redo logs

Examine the structure of the PRODUCTS table.

The PRODUCTS table contains 20 rows.

In the data that has been entered, the PROD_ID column contains only single digit values, PROD_NAMK has a maximum of 5 characters, and RATE has 4 digit values for all rows.

Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table? (Choose two.)

PROD_NAME size can be reduced from 10 to 5 characters

PROD_IP can be changed from CHAR to NUMBER data type

Now columns can be added only if they have NOT NULL constraint

PROD_RATE size can be changed from NUMBER (4) to NUMBER (6, 2)

None of the existing columns can be dropped because they contain data

Which three statements are true regarding inconsistent backup? (Choose three)

It can be used only for incomplete recovery

It can be taken only when the database is open

It can be taken only when the database is closed

It can be used for complete and incomplete recovery

The archived redo logs changes must be applied to the data files before the backup

Both online and archived redo logs can have changes that have not been applied before the backup.

Which three statements are true regarding database recovery operations? (Choose three.)

Complete recovery involves only rolling forward operations

Database recovery is not required after an instance recovery.

Incomplete recovery applies changed only from archived redo logs

Complete database recovery must be performed after an instance recovery

Complete recovery involves both rolling forward and rolling backward operations

Incomplete recovery can apply changes from both online and archived redo logs

Which statement describes the function of the Segment Advisor?

It advises on the usage frequency of the database objects

It advises on the currently validity status of the database

It identifies database objects that have unused space that can be reclaimed

It identifies the space requirements for the database objects based on their usage and growth statistics.

You create an index, EMP_IDX, on the ENAME column in the EMP table. Identify the three operations in which FMP_IDX would be used? (Choose three.)

Addition of new data to the EMP table

Deletion of existing row from the EMP table

Modification of data in any column in the EMP table

All queries that display data from the ENAME column

Queries that search for data based on a condition on the ENAME column

Which two statements are true regarding the segment shrink operation? (Choose two.)

It compacts data within the segment.

It decreases I he size of the tablespace.

It can be performed only on an offline tablespace.

It reclaims unused space and retains it within the tablespace.

Which two statements are true regarding the Undo Retention Settings? (Choose two.)

Enabling Retenting Guarantee ensures that only long-running Queries do not fail.

Undo Retention Indicates the time period for which committed transaction data is retained

Enabling Retention Guarantee ensures that long running queries and transactions do not fail

Undo Retention indicates the time period or which uncommitted transaction data is retained

Which two statements are true regarding views? (Choose two)

Views contain no data

Views provide an additional level of security by restricting access to a predetermined set of rows and columns of a table

Views can be created only on tables in the same schema

Views on one or more tables can be used to update the columns specified in the views

Listed below are the database resident program units and their descriptions in random order.

1. Package

2. Procedure

3. Function

4. Trigger

a. Stored subprogram that is associated with a database table, view or event

b. Standalone program that must return a value

c. Structure that contains program definitions and PL/SQL code

d. stand-alone program that may or may not return a value which option specifies the correct definition for each program unit?

1-c, 2-d, 3-b, 4-a

L-c, 2 b, 3-d, 4-a

l-a, 2-b, 3-d, 4-c

L-a, 2-d, 3-b, 4-c

You want to use the automatic management of backup and recovery operations feature for your database. Which configuration must you set?

Enable the flash recovery area and specify it as the archived redo log destination

Disable the flash recovery area and start the database instance in ARCHIVELOG mode

Enable the flash recovery area but do not specify it as the archived redo log destination

Disable the flash recovery area and start the database instance in NOARCHIVELOG mode

Which statement is true regarding the Oracle Universal Installer (OUI)?

OUI supports the installation of several of several active Oracle homes on the same host

Operating system environment variables need to be set before running the OUI.

OUI can be used to uninstall only the complete Oracle software and not specific products.

OUI enables configuring of listener as part of the installation process but not the creation of Net.

Which three statements are true about database storage structures? (Choose three.)

A data file can span across tablespaces

An extent contains one or more segments

Table spaces contain one or more data files

Data objects are stored as segments in tablespaces

Segments can span across data files within a tablespace

A customer recently had a security audit, when they were told that their test and development environment contained test data, which was the copy of production data, yet was not properly protected. What technology should be used to quickly bring these environments into compliance?

Advanced Security Option

Audit Vault

Database Vault

Data Masking Pack or Enterprise Manager

Label Security

Which two options describe the features of simple views?(Choose two.)

Hide data complexity

Improve data storage

provide additional level of security

Speed up query and data manipulation language (DML) operations

Which two statements ore true regarding the-Database Configuration Assistant (DBCA)? (Choose two.)

It can be used to delete only the logical structure of a database

It can be used to delete Uu1 logical structure and physical files of a database.

It can be used to change the configuration of a database only if it has been created using DBCA.

It can be used to change the configurations of o database that has been created either manually or using DBCA.

Choose three areas for which Oracle Database 11g Release 2 and Enterprise Manager offer tools that can recommended solutions on optimal implementation.

Indexes

Compression

Data recovery

Data block size

CPU usage

Availability

You started up your database In the NOARCHIVELOG mode. Which are the two implications of this setting? (Choose two.)

The database can be backed up only while it is closed.

The database can be completely recovered from Instance failure.

The database can be backed up when the database instance is running.

The database can be completely recovered from disk failure even after a log switch has happened and online redo logs are overwritten.

You have to create a table, STUDENTS, with the columns: STUENT_ID, STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID. The following constraints have to be enforced on this table:

Each student must be uniquely identifiable by the STUDENT_ID.

The STUDENT_ID columns should not be left blank.

The student should not be less than 15 years of age.

The student can only take a course that is specified in the COURSE table in the database.

Which three constraints must be explicitly enforced on the table?(Choose three)

Check constraint on the COURSE_ID column

Foreign key constraint on the COURSE_ID column

Check constraint on the DATE_OF_BIRTH column

Unique key constraint on the STUDENT_ID column

Primary key constraint on the STUDENT_ID columns

Which method can you use to receive a notification when the free disk space in the recovery area falls below 10%?

Submit a job that queries the Automatic Workload Repository (AWK).

Create an alert that sends a notification when the threshold value is reached.

Invoke the Database Configuration Assistant (DBCA. To configure notifications and set threshold values.

Specify the users who should receive notifications in the Preferred Credential of the Enterprise Manager.

Run the Automatic Database Diagnostic Monitor (ADDM) to analyze disk space and display a warning message.

Which two statements ore true regarding the status of data file backups after 31 days?

In flash recovery area, they are deleted immediately

In non flash recovery area, they are marked as obsolete and have to be deleted manually

In flash recovery area, they are marked as obsolete but retained and deleted automatically when space is required

In non flash recovery area, they are marked as obsolete but retained and deleted automatically when space is required

Which three statements are true regarding the Database Configuration Assistant (DBCA) templates? (Choose three)

Templates are stored as XML files

Templates are stored as HTML files

A new template can be created using only an existing database

Seed templates contain both the logical structure and physical files of an existing database

A new template can be created using either an existing database or template.

Seed templates contain both the logical structure and physical files of an existing database.

Which two of the following tasks must you perform in order to benefit from the SQL Query Result Cache?

Use a SQL_QUERY_RESULT_CACHE hint in your SQL statement

Set RESULT_CACHE_MODE to FORCE

Make sure the RESULT_CACHE_MAX_SIZE is greater than 0.

Have SQL statements that are executed repeatedly.

Use temporary tables.

Not use bind variables in your query

Which two statements are true regarding indexes? (Choose two.)

Column can have multiple indexes created on it

An index can be created on one or more columns.

Index must be created in the same tablespace as the table.

Indexes are implicitly created by the PRIMARY KEY and UNIQUE constrains.

Which statement is true regarding Automatic Memory Management?

You need to specify only the SGA memory size.

You need to specify the SGA and PGA memory sizes separately.

You need to specify the total memory size, which is dynamically sized for SGA and PGA components and can be exchanged between the SGA and PGA

You need to specify the total memory size, which is dynamically sized for SGA and PGA components but cannot be exchanged between the SGA and PGA

Your test database is currently running in the ARCHIVELOG mode and you plan to switch to the NOARCHIVELOG mode temporarily. Which type of backup should you perform before switching the mode to ensure database recovery is possible?

Whole backup

Level 0 incremental backup of data files

Full backup of data files using only backup sets

Full backup of data files using only image copies

The RECYCLEBIN parameter is set to on for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? (Choose two.)

All the related indexes and views are automatically dropped

The Flashback Drop feature can recover only the table structure.

Only the related indexes are dropped whereas views are invalidated.

The Flashback Drop feature can recover both the table structure and its data.

Which two statements are true regarding the usage of integrity constraints? (Choose two.)

IEM h column can have only one constraint

Primary key constrain can consist of multiple columns from the same table

Foreign key column can reference e a primary key column in the same of or different tables.

More than one row in a table cannot contain null value In a column with unique constraint.

A check constraint can enforce conditions that refer to the values in other columns in the table

{"name":"SUBP-2kol", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge and expertise in Oracle Database management with our comprehensive quiz! Dive into various topics, including backup strategies, performance tuning, data recovery, and SQL operations.36 questions covering key database conceptsEvaluate your skills and knowledgeGreat for DBAs, developers, and students","img":"https:/images/course6.png"}