Archived Questions & Answers

New Topic

845539 topics

Page 4 of 1692
- Jump to page:
Previous
1
2
3
4
5
6
…
1692
Next

Topics

Replies

Views

Last post

Which two statements are true concerning ASM diskgroups using disks with a 4k sector size?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

388 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
You administer a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs: PDB_1 and PDB_2.Examine th

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

390 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which three statements are true about Quality of Service Management (QoS)?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

424 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
A directory +DATA/ORCL/DATAFILE/USERS exists in ASM.USERS is a user created directory; ORCL and DATAFILE are system gene

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

429 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which three statements are true concerning policy-based cluster management in Oracle12c Clusterware?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

423 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which three statements are true about the cluster file system archiving scheme?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

415 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which three statements are true about Oracle Clusterware 12c Flex Cluster architecture?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

390 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which statement is true concerning the installation of an Oracle Grid Infrastructure 12c patchset and its status during

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

432 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which three statements are true about ASM Cloud File System (ACFS) replication?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

404 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which two components must always be defined or specified by an administrator to make an application highly available usi

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

421 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which three components are integral parts of High Availability NFS (HANFS)?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

489 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Oracle Clusterware manages an administrator-managed database service defined with theMANUAL management policy.Which two

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

470 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which three types of patches and upgrades are supported for Oracle Grid Infrastructure12c?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

546 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
You issue the command:SQL>ALTER DATABASE BACKUP CONTROLFILE TO TRACE;Which statement is true about the command?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

498 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Identify three benefits of unified auditing.

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

474 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which two statements are true about the Automatic Diagnostic Repository (ADR)?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

494 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

470 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which two statements are true regarding SecureFile lobs?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

492 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which two statements describe the relationship between a window, a resource plan, and a job class?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

445 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issu

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

468 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RM

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

462 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Examine the RMAN commands executed in your database:RMAN>CONFIGUREDEFAULT DEVICE TYPE TO disk;RMAN>CONFIGURE DEVICETYPE

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

450 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.After a few days,

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

505 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

489 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

530 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
You create two Resource Manager plans, one for night time workloads, the other for day time.How would you make the plans

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

440 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
While performing database backupto tape via the media manager interface, you notice that tape streaming is not happening

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

487 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user.The CATDB11 database contai

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

539 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. Yo

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

469 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which four actions are possible during an Online Datafile Move operation?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

472 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
A user issues a query on thesales table and receives the following error:ERROR at line 1:ORA-01565: error in identifying

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

533 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which three statements are true about unplugging a pluggable database (PDB)?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

499 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which two statements are true about unified auditing?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

455 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which three types of failures are detected by the Data Recovery Advisor (DRA)?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

437 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
user_data is a nonencryptedtablespace containing tables with data.You must encrypt ail data in this tablespace.Which thr

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

524 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which two statements are true about a common user?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

489 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
You created a tablespace with this statement:CREATE BIGFILE TABLESPACE adtbs -DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

443 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

486 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

491 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over thre

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

436 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
A complete database backup to media is taken for your database every day. Which three actions would you take to improve

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

498 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Examine the RMAN command:RMAN> BACKUP VALIDATE DATABASE;Which statement is true about the execution of the command?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

438 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

468 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which three RMAN persistent settings can be set for a database?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

448 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

484 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
In which three scenarios is media recovery required?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

493 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
LDAP_DIRECTORY_SYSAUTH is set to YES.Users requiring DBAs access have been granted the sysdba enterpriserole in OracleIn

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

494 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Examine the partial AWR report taken for a time period of 60 minutes:Which two inferences can you draw from this report?

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

468 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
For which three problem categories does Automatic Database Diagnostic Monitor (ADDM) provide analysis and recommendation

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

464 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
You are administering a database that supports multiple applications, which make dedicated connections to the database i

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

477 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
To investigate the slow response time of queries on the TRANS table, you gathered the table statistics and executed the

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

442 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Examine the parameters set for your database instance:You are administering a database that supports an OLTP workload. U

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

466 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Examine the parameters set for a database instance supporting a mixed workload:The database instance supports shared ser

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

518 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which two statements are true about server-generated alerts? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

438 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which three statements are true about using Real-Time Database Operations? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:54 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:54 pm

1 Replies

469 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:54 pm
Which four objectives are achieved by using Resource Manager to manage multiple concurrent user sessions that are compet

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

519 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your database supports an OLTP system.Examine the parameter values configured in your database:sga_max_size = 480Msga_ta

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

476 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two are prerequisites for running the I/O calibration tool? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

471 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Identify two effects of the DB_FILE_MULTIBLOCK_READ_COUNT parameter on the optimizer. (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

488 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You are administering a database that supports an OLTP workload. An application regularly creates global temporary table

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

464 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the partial PLAN_TABLE output:Which is the correct sequence of execution? (Choose the best answer.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

430 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your database supports a DSS workload. In an application, a few complex queries that contain multiple functions and expr

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

479 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You are administering a database that supports a mixed workload. Many applications are running on the middle tier that u

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

449 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the Load Profile section of an AWR report:Which two inferences can you derive from the details in this section?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

475 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
and alsoto introduce new objects to the database. You also want to upgrade the hardware. You have already created a test

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

456 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three statements are true about the interpretation of an execution plan? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

471 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You are administering a database that supports a DSS workload. Automatic SharedMemory Management is enabled for the data

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

465 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true about Compare Period ADDM? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

446 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
In which three situations can dynamic statistics be used? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

542 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
In your database, the measured 99th percentile value is used as the maximum value. You set a warning threshold level of

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

435 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your database supports a mixed workload. In an application, multiple complex queries with functions and expressions are

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

423 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the parameters set for your database instance:. The database supports a mixedworkload and works with different w

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

456 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Users report this error message when inserting rows into the orders table:ERROR at line1:ORA-01654f:unable to extend ind

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

449 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You must unload data from the orders, order_items, and products database tables to four files using the External Tables.

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

423 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the followin

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

419 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both h

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

522 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currentl

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

481 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three conditions must be true for unused block compression to be used automatically while performing backups by us

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

546 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
In which situation can you use Flashback Database?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

481 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You are administering a multitenant container database (CDB).Identify two ways to access a pluggable database (PDB) that

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

459 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:SQL> ALTER SYSTEM

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

441 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statem

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

480 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

410 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):1. Start the

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

467 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

432 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Man

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

448 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true about a multitenant architecture? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

440 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine these Data Pump commands to export and import objects from and to the same database.The dba has not yet created

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

442 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a g

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

447 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The b

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

452 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Identify two scenarios in which the RMAN crosscheck command can be used. (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

453 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

448 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three RMAN persistent settings can be set for a database? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

455 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

453 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true about dropping a pluggable database (PDB)? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

430 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.You rename the undotbs undo tablespace:ALTER TABLESPACE undotbs RENAME

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

453 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
In which three scenarios is media recovery required? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

448 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable dat

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

436 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.Examine the commands ex

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

429 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:SQL> SEL

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

473 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the contro

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

426 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choo

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

438 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Identify three scenarios in which RMAN will use backup sets to perform active database duplication. (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

503 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your database is running in archivelog mode. Examine the parameters for your database instance:LOG_ARCHIVE_DEST_l ='LOCA

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

431 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You created a database with DBCA by using one of the Oracle supplied templates.Which is the default permanent tablespace

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

452 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
The following parameters are set for your Oracle 12c database instance:OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMI

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

499 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the RMAN command:RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLU

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

475 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:1. Create media families for data files and

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

464 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the initialization parameter that is set in the PFILE:DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'You execute

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

473 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

433 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three types of failures are detected by the Data Recovery Advisor (DRA)? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

514 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant contai

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

440 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true when row-archival management is enabled? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

440 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

470 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You want RMAN to make duplicate copies of data files when using the backup command.What must you set using the RMAN conf

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

427 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases runni

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

457 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.Which two

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

446 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
A database is running in archivelog mode. The database contains locally managed tablespaces. Examine the RMAN command:RM

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

570 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequi

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

490 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple plugg

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

492 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB HR_PDB, th

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

419 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You wish to create jobs to satisfy these requirements:1. Automatically bulk load data from a flat file.2. Rebuild indexe

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

446 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You want to export the pluggable database (PDB) HR_PDB1 from the multitenant container database (CDB) CDB1 and import it

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

468 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

492 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two are prerequisites for setting up Flashback Data Archive? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

429 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the command:SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;In which two scenarios is this command r

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

436 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

485 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

543 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
For which three pieces of information can you use the RMAN list command? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

496 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
A complete database backup to media is taken for your database every day. Which three actions would you take to improve

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

450 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true about scheduling operations in a pluggable database (PDB)? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

425 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the perfo

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

460 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

422 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which four actions are possible during an Online Data file Move operation? (Choose four.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

432 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

503 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA ar

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

432 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

455 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Man

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

487 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
A senior DBA asked you to execute the following command to improve performance:SQL> ALTER TABLE subscribe log STORAGE (B

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

436 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You are administering a database and you receive a requirement to apply the following restrictions:1. A connection must

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

454 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

485 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Identify three valid methods of opening, pluggable databases (PDBs). (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

475 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You executed this command to create a password file:$ orapwd file = orapworcl entries = 10 ignorecase = NWhich two state

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

447 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
To enable the Database Smart Flash Cache, you configure the following parameters:DB_FLASH_CACHE_FILE = "˜/dev/flash_devi

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

468 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.All databases of all ver

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

477 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You execute the following commands to audit database activities:SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SP

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

460 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You execute the following PL/SQL:Which two statements are true? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

504 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three statements are true about using flashback database in a multitenant container database (CDB)? (Choose three.

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

478 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the followin

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

433 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You execute the following piece of code with appropriate privileges:User SCOTT has been granted the CREATE SESSION privi

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

441 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You run a script that completes successfully using SQL*Plus that performs these actions:1. Creates a multitenant contain

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

444 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.Which two met

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

447 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You notice that the elapsed time for an important database scheduler Job is unacceptably long.The job belongs to a sched

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

421 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three statements are true concerning the multitenant architecture? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

466 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALO

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

507 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

446 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privileg

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

527 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the contents of SQL loader control file:Which three statements are true regarding the SQL* Loader operation perf

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

517 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the following parameters for a database instance:MEMORY_MAX_TARGET=0 -MEMORY_TARGET=0 -SGA_TARGET=0 -PGA_AGGREGA

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

564 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

455 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

456 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause.What a

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

442 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following co

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

441 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy th

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

505 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true about variable extent size support for large ASM files? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

471 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in H

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

482 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three statements are true about adaptive SQL plan management? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

460 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the parameter for your database instance:You generated the execution plan for the following query in the plan ta

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

487 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You notice a performance change in your production Oracle database and you want to know which change has made this perfo

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

470 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the following query output:You issue the following command to import tables into the hr schema:$ > impdp hr/hr d

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

454 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.A multitenant container datab

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

450 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major sch

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

469 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).The characteristics

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

449 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED containe

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

458 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.The CDB

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

489 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out o

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

464 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

450 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

489 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on d

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

511 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automa

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

581 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

475 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:SQL

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

498 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Identify two correct statements about multitenant architectures. (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

475 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
To implement Automatic Management (AMM), you set the following parameters:When you try to start the database instance wi

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

516 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo m

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

455 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:After ch

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

429 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing t

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

446 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the following command:CREATE TABLE (prod_id number(4),Prod_name varchar2 (20),Category_id number(30),Quantity_on

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

446 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

470 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the current value for the following parameters in your database instance:SGA_MAX_SIZE = 1024M -SGA_TARGET = 700M

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

437 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two are true concerning a multitenant container database with three pluggable database? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

446 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS ("˜SH"™, "˜CUSTOMERS"™, "˜PUBLISH"™, "˜false"™);Which three s

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

489 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
The following parameter are set for your Oracle 12c database instance:OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSEOPTIMIZE

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

532 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

423 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

442 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the query and its output:What might have caused three of the alerts to disappear?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

475 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You execute the commands:Which two statements are true? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

443 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true about extents? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

535 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the memory-related parameters set in the SPFILE of an Oracle database:Which statement is true?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

428 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which statement is true regarding the startup of a database instance?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

440 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Your database is open and the listener LISTENER is up. You issue the command:LSNRCTL> RELOAD -What is the effect of relo

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

387 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

472 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the structure of the sales table, which is stored in a locally managed tablespace with Automatic Segment Space M

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

436 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which action takes place when a file checkpoint occurs?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

474 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.Which two stateme

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

540 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three factors influence the optimizer's choice of an execution plan? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

464 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
The HR user receives the following error while inserting data into the sales table:On investigation, you find that the u

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

527 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three statements are true about a job chain? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

494 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two tasks can be performed on an external table? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

443 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

450 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which statement is true about the Log Writer process?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

506 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements correctly describe the relationship between data files and logical database structures? (Choose two

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

491 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

478 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications: "

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

461 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
What happens if a maintenance window closes before a job that collects optimizer statistics completes?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

551 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

438 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the followi

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

482 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the parameters for your database instance:You execute the following command:SQL> ALTER TABLESPACE undotbs1 RETEN

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

484 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true regarding constraints?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

610 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the structure of the employees table.You want to display the maximum and minimum salaries of employees hired 1 y

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

433 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which create table statement is valid?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

474 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
View the Exhibit and examine the data in the employees table:You want to display all the employee names and their corres

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

460 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
View the Exhibits and examine the structures of the products and sales tables.Which two SQL statements would give the sa

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

447 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

420 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You want to create a sales table with the following column specifications and data types:SALESID: Number -STOREID: Numbe

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

483 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
View the Exhibit and examine the structure of the products table.All products have a list price.You issue the following

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

426 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
View the Exhibit for the structure of the student and faculty tables.You need to display the faculty name followed by th

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

448 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You issue the following command to drop the products table:SQL> DROP TABLE products;Which three statements are true abou

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

478 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three SQL statements would display the value 1890.55 as $1, 890.55?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

455 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You want to create a table employees in which the values of columns EMPLOYEES_ID and LOGIN_ID must be unique and not nul

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

484 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which two statements are true regarding single row functions?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

444 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
View the Exhibit and examine the data in the products table.You need to display product names from the products table th

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

444 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
View the Exhibit and examine the structure of the promotions table.You need to generate a report of all promos from the

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

444 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Using the customers table, you need to generate a report that shows 50% of each credit amount in each income level. The

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

488 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Evaluate the following SQL commands:The command to create a table fails. Identify the two reasons for the SQL statement

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

459 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the data in the CUST_NAME column of the customers table.You need to display customers' second names where the se

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

474 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the structure of the orders table:You want to find the total value of all the orders for each year and issue the

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

473 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
In the customers table, the CUST_CITY column contains the value 'Paris' for theCUST_FIRST_NAME 'Abigail'.Evaluate the fo

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

448 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Examine the structure of the employees table:There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.You

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

452 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You need to generate a list of all customer last names with their credit limits from the customers table.Those customers

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

442 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Evaluate the following SQL statement:Which statement is true regarding the above query if one of the values generated by

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

426 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
View the Exhibit and examine the data in the promotions table.PROMO_BEGIN_DATE is stored in the default date format, dd-

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

466 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
View the Exhibit and examine the structure of the products table.Using the products table, you issue the following query

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

446 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

450 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three statements are true about Automatic Workload Repository (AWR)?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

423 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

445 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You notice a performance change in your production Oracle 12c database. You want to know which change caused this perfor

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

415 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on d

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

411 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automa

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

424 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Which statement is true concerning dropping a pluggable database (PDB)?

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

442 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You upgrade your Oracle database in a multiprocessor environment. As a recommended best practice, you execute the follow

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

420 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
Identify two correct statements about multitenant architecture. (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

417 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

439 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
To implement Automatic Management (AMM), you set the following parameters:When you try to start the database instance wi

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

425 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARC

Last post by answerhappygod « Sun Jun 11, 2023 3:51 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:51 pm

1 Replies

414 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:51 pm
You must track all transactions that modify certain tables in the SALES schema for at least three years.Automatic undo m

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

413 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:After ch

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

459 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
On your Oracle 12c database, you invoked SQL*Loader to load data into the EMPLOYEES table in the HR schema by issuing th

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

397 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following stateme

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

402 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Examine this command:Which three statements are true about using an invisible column in the PRODUCTS table?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

407 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which three statements are true concerning unplugging a pluggable database (PDB)?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

422 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Examine the current values for the following parameters in your database instance:SGA_MAX_SIZE = 1024M -SGA_TARGET = 700

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

403 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which two are true concerning a multitenant container database with three pluggable database?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

430 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):Which

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

408 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false');Which three statement

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

383 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits.

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

398 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
The following parameters are set for your Oracle 12c database instance:You want to manage the SQL plan evolution task ma

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

429 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache conta

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

417 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB). (C

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

412 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
A new report process containing a complex query is written, with high impact on the database. You want to collect basic

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

404 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is da

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

406 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

468 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which three functions are performed by the SQL Tuning Advisor?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

432 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk gro

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

461 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the followi

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

443 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Your database is running an ARCHIVELOG mode.The following parameters are set in your database instance:Which statement i

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

429 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to user

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

409 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNSPING command executes successfully when

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

400 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degr

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

401 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over thre

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

451 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You notice that the performance of your production 24/7 Oracle 12c database significantly degraded. Sometimes you are no

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

430 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
What are three purposes of the RMAN "FROM SERVICE" clause? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

443 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which three are true about the large pool for an Oracle database instance that supports shared server connections?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

456 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a la

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

435 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enable

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

442 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find tha

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

464 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which Oracle Database component is audited by default if the unified Auditing option is enabled?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

440 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACC

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

423 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inad

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

427 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which statement is true about Oracle Net Listener?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

441 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? (C

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

386 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Examine these commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

430 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

433 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You want to install a database patch on your eight-node cluster by using Opatch with, the minimum amount of down time to

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

477 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You are managing a three-Instance RAC database. In the AWR report, you notice a gc current block busy wait event on one

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

410 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
orcl1, orcl2, and orcl3 are tnsnames that connect to predefined instances of a three- instance RAC database which uses A

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

459 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Assuming a RAC database called ORCL, select three statements that correctly demonstrate management actions for the AP se

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

514 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
I he ASM instance in your environment can support databases from version 10.2.0.4 through 11.2.0.1 You want to use all A

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

408 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
The high availability services provided by Oracle Clusterware are used to protect Oracle resources, such as RAC database

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

479 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which four statements are true about services and connection load balancing?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

411 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Your cluster Is subject to a service-level agreement that allows for little scheduled down time You want to use patching

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

455 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You are allocating space from the ASM disk group for an ADVM volume. What will be the volume extent and Volume Allocatio

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

409 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You want to reorganize the DATA diskgroup while continuing database operations. TheDATA diskgroup was created using norm

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

432 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
When creating an Oracle Cluster database using DBCA the "Memory size (SGA and PGA) field is supplied on value of 2000 MB

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

387 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
As part of your data center's high availability strategy, you are creating resource definitions to control the managemen

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

467 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which command will set full debugging for the communications and resource management components; of the CRS module on no

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

451 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
The Oracle Grid Infrastructure administrator runs ocrconfig -backupioc <new_location> after completing the installation

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

394 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You use the following command to create a disk group:CREATE DISRGROUP DATA NORMAL REDUNDANCYFAILGROUP fg_f ra_l DISK -'/

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

400 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
The Global Cache Block Access Latency chart shows high elapsed times. What are two possible causes for this?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

408 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
: 4You are in the planning stages for upgrading your Oracle RAC database from OracleDatabase 10g Release 2 to Oracle Dat

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

415 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
The original cluster on RACNODE1, RACNODE 2, RACNODE 3, and RACNODE4 had theOracle Grid Infrastructure installed to supp

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

387 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Under which account(s) can the Oracle Clusterware processes run for the Linux platform?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

408 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You want to check an ACFS for consistency on the Linux platform. Which command-line tool would you use to do this?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

461 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You plan to use Enterprise Manager to locate and stage patches to your Oracle Home.The software library has been configu

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

384 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
The disk groups on the current ASM instance at version 11.2 were configured to support a version 10.2 database instance.

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

448 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Examine the following output:[oracIe@gr5153 ~]$ sudo crsctl config crsCRS-4622: Oracle High Availability Services autost

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

471 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
The database administrator is tasked with creating an ASM disk group. Exadata is not being used.If failure groups are no

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

417 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which two conditions are required by the ASM fast mirror resynchronization to track block changes for a set period of ti

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

440 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which three describe how often OCR backups are taken and how many are retained, according to the default backup schedule

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

402 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
: 5The Instance Initialization parameters are set to:DB_CREATE_FILE_DEST = +DATA -DB_CREATE_ONLlNE_LOG_DEST_l = +LOGSDB_

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

444 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Examine the Exhibit.*** Exhibit is Missing ***Which three statements are correct?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

412 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You plan to remove a node called RACNODE4 from a four-node cluster.The cluster is running Oracle Grid Infrastructure 11g

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

441 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which two Cluster ware stack administration actions must be performed as the root user?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

456 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

426 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Examine the following values of the initialization parameters in the database having the SIDORCL:The environment variabl

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

407 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

388 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facin

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

539 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Your company wants to upgrade the current production database to the RAC environment,To perform testing before migrating

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

430 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You are working on a CATDB database that contains an Oracle Database Version 11.1 catalog schema owned by the user RCO11

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

598 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Which three are the validstatements in relation to SQL plan baselines? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

426 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Evaluate the following code:SQL>VARIABLE task_name VARCHAR2(255)SQL>VARIABLE sql_stmt VARCHAR2(4000);SQL>BEGIN -: sql_st

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

444 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
See the Exhibit:As shown in exhibit examine the Data Pump architecture:Identify the numbered components:

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

459 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You plan to have a larger movingwindow size for the default system-defined moving window baseline because you want to us

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

405 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You perform the followingactivities during the database upgrade from Oracle Database 10g to Oracle Database 11g;-> Captu

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

419 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
Identify the three predefined server-generated alerts. (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

411 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
See the following PL/SQL block:DECLARE -my_plans pls_integer,BEGIN -My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sq

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

433 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You plan to set up the automaticWorkload Repository (AWR) baseline metric threshold for moving window baseline. Which ac

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

419 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
See the Exhibit:In the CUSTOMERS_OBE table, when the value of COST_STATE_PROVINCE is CA, the value of COUNTRY_ID is US.

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

424 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You want to convert you existing non-ASM files to ASM files for the database PROD.Which method or command would you use

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

481 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three loca

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

402 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
See the exhibit:To examine the error while executing the REPARI FAILURe command in an RMAN session.What is the reason fo

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

451 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
See the Exhibit:To examine the error obtained during the I/O calibration process.There are no data files on raw devices.

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

419 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of qu

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

394 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You have the following requirements in relation to the detection of block corruption for your database instance:-> Check

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

453 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You have three temporary tablespace groups named G1, G3 and G3 in you database.You are creating a new temporary tablespa

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

389 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

446 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You have three production databases, HRDB, FINDB and ORGDB that use the same ASM instance. At the end of the day, while

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

401 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You want to convert your existing non-ASM files to ASM files for the database PROD.Which method or command would you use

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

405 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:ALTER TA

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

420 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above comma

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

398 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
View the Exhibit and examine a portion of the output obtained from the following query:SQL> SELECT * FROM v$sys_time_mod

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

410 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
View Exhibit1 and examine a portion of Active Session History(ASH) report.View Exhibit2 to examine the tablespaces.Which

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

437 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
A batch workload that historically completed in the maintenance window between 10:00 PM and midnight is currently showin

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

433 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
View the Exhibit and examine the query based on the DBA_THRESHOLDS view and its partial output :Which observation about

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

390 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You observed in your database that the queries formerly executed in 5 seconds now take longer time.View the Exhibit and

Last post by answerhappygod « Sun Jun 11, 2023 3:50 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:50 pm

1 Replies

461 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:50 pm
You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to check the following wait events:E

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

413 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You identified poorly performing SQL statements that use bind variables. You want to examine the execution plans for the

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

418 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Examine the output of the following query:SQL> SELECT c.name,a.addr,a.gets,a.misses,a.sleeps,2 a.immediate_gets,a.immedi

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

426 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You observed very low cache-hit ratio in your database as shown below:SQL> SELECT (1-((phy.value-phyd.value) / (cur.valu

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

459 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You identified poorly performing SQL by analyzing the V$SQL and V$SQLSTATS views.You want to investigate the plans for t

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

431 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You work as a consultant DBA for various clients. A performance issue in one of the online transaction processing (OLTP)

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

420 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
View the Exhibit and examine the content of the V$SGA_RESIZE_OPS view.The Shared Pool was shrunk when the Default Buffer

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

477 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
A user in a session executed the following SQL statement to set the optimizer mode:ALTER SESSION SET OPTIMIZER_MODE = AL

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

428 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Identify the type of recommendation that can automatically be implemented by theAutomatic Tuning Advisor as part of auto

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

415 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to TRUE for a24x7 database instance. The space consumption has

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

441 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You are working as a DBA for a DSS system, on which applications primarily perform large sequential I/Os. The company wa

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

426 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
View the Exhibit that shows your investigation on degraded performance.What would you do? (Choose all that apply.)

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

447 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Your database supports many applications running on the middle tier. Many applications users create jobs for which you w

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

439 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which two symptoms related to the database buffer cache together indicate that there are many full table scans happening

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

430 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
View the Exhibit and analyze a portion of the Active Session History (ASH) report marked with a red rectangle.Which two

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

451 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
The database application developers are planning to make some major schema changes such as creating new indexes and mate

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

394 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You are asked to implement Automatic Memory Management (AMM) and you added two initialization parameters to do this. The

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

428 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
During a proactive database performance monitoring routine, on examining the AWR report you find that log file sync appe

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

431 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which three statements are true about performance analysis by SQL PerformanceAnalyzer? (Choose three.)

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

445 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Identify the reason why chained or migrated rows in a table cause performance degradation when you access them.

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

441 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You work as a DBA for a company and as a performance improvement measure, you implemented the result cache in your datab

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

416 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
View the Exhibit and examine the content of the V$MEMORY_RESIZE_OPS view.Which two conclusions can you draw? (Choose two

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

455 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You are working on an online transaction processing (OLTP) system. The middle-tier applications use connection pooling t

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

478 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You work as a consultant DBA for various clients. A performance issue in one of the online transaction processing (OLTP)

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

429 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
View the Exhibit and analyze the output of a query executed on theV$MEMORY_RESIZE_OPS view. Why do INITIAL_SIZE, TARGET_

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

422 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
As part of a proactive tuning activity, you have the Automatic Workload Repository (AWR) and ADDM enabled for your datab

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

413 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
View the Exhibit exhibit1 to examine the series of SQL commands and parameter settings.View the Exhibit exhibit2 to exam

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

444 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
In which two scenarios would you recommend using RAID level 5 as an option for database storage?(Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

392 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Examine the SQL statement given below:SQL> EXPLAIN PLAN for -SELECT department_name,count(*)FROM hr.employees e, hr.depa

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

431 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
View the Exhibit and examine the content. ALLOCATED_SPACE and FREE_SPACE are not matching with the TABLESPACE_SIZE value

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

423 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You are working on an online transaction processing (OLTP) system. You are investigating the reasons for performance deg

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

388 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
View Exhibit1 and examine the indexes on the CUSTOMERS table.The statistics for the CUSTOMERS table have been updated re

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

398 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You are a DBA in ABC Corp. You are working on a DSS system.. The applications directly connect to the database to perfor

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

409 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You are working on an online transaction processing (OLTP) system. By day most of theapplication users perform queries a

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

452 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You notice that two wait events, Latch:cache buffer chains and Latch:cache buffer LRU chains, appear consistently in the

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

417 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?A. a cumulativ

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

396 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

401 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What command would you issue to enable automated backups of control files?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

422 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Given below are RMAN commands to enable backup optimization and set the retention policy:RMAN> CONFIGURE DEFAULT DEVICE

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

453 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

507 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which view provides information on the backup status of the datafiles in the database?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

486 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which command is used to configure RMAN to perform a compressed backup for every backup executed?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

423 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

427 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You want the ability to recovery any time within the last seven days and therefore you configured the recovery window re

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

390 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which of the following best describes a full backup?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

440 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You issue the following command:RMAN>CONFIGURE BACKUP OPTIMIZATION ON;What is the result of this command on your backups

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

430 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

428 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Cho

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

425 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which type of backup must be performed first with an incremental backup?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

441 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You configured the default backup device type as disk for RMAN backups. In your database, because of business requiremen

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

421 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which of the following most closely represents an image copy?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

413 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

438 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Whic

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

428 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You issued the following commands to configure setting in RMAN;RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN> CONFI

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

463 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You issue the following RMAN command to set a retention policy on a database:RMAN>CONFIGURE RETENTION POLICY TO REDUNDAN

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

455 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three loca

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

435 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Identify the channel settings that can be performed using the CONFIGURE CHANNEL orALLOCATE CHANNEL commands in RMAN. (ch

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

406 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
The following databases are registered in the base recovery catalog: PROD1, PROD2, andPROD3.The database user CATOWNER o

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

391 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which statement about using RMAN stored scripts is true?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

396 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

414 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

421 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Given the script -create script db_backup_datafile_script{backup datafile and 1, and2 plus archivelog delete input;}What

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

392 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery cata

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

428 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You can back up the RMAN recovery catalog with RMAN.

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

456 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

413 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
In what order would you execute the following steps to create a recovery catalog? a. Issue the create catalog command. b

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

442 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What privileges must be granted to allow an account to create the recovery catalog?(Choose all that apply.)

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

433 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

404 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog t

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

401 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the followin

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

411 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
How would you grant the RVPC user access to specific RMAN database records in theRMAN virtual private catalog?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

377 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilitie

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

434 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
The following databases are registered in the base recovery catalog: PROD1, PROD2, andPROD3.The database user CATOWNER o

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

451 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What is the purpose of the RMAN recovery catalog? (Choose all that apply.)

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

427 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line? Ass

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

493 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

441 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which option is best practice for creating a recovery catalog owner in the catalog database?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

422 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which command do you use to create a recovery-catalog schema?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

410 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
RMAN provides more granular catalog security through which feature?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

419 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which statement is true regarding virtual private catalogs?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

374 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
While performing a regular check on your recovery catalog you realized that the catalog database is running out of space

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

429 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check sc

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

416 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
In your production database, you:-> Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup oper

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

389 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

446 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You are using the control file to maintain information about the database backups that are being performed by Recovery M

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

461 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You have created a script in the recovery catalog called backup_database.Which of the following commands would successfu

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

413 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What RMAN command must you use before you can back up a database using the recovery catalog?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

419 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What command would you use to ensure that backup records in the control file are pointing to actual physical files on th

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

435 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command.Which statement is true about the

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

382 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
When you create a backup control file, where is the resulting file written to?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

449 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area d

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

419 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Observe the following warning in an RMAN session of your database instance:WARNING: new failures were found since last L

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

435 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What are the different logging modes available in Oracle Database 11g? (Choose two.)

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

404 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What will be the end result of this set of RMAN commands?shutdown abortstartup mountrestore datafile 4 until time '09/30

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

404 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You have configured flash recovery area in your database and you set the followingInitialization parameters for your dat

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

422 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What does the SCN represent?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

410 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
How long will this backup be allowed to run?Backup as compressed backupset duration 2:00 minimize load database;

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

395 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been c

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

396 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

417 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You enable block change tracking. You issue the following command:BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day, you

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

413 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What command is used to reset a database to a previous incarnation?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

399 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which statement is true regarding the VALIDATE DATABASE command?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

390 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names o

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

419 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which is the correct command to put the database in ARCHIVELOG mode?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

431 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

433 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What will be the result of the following configuration?Log_archive_dest_1 = 'location=c:\oracle\arch\mydb'Log_archive_de

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

437 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Your developers have asked you to restore the development database, which is inNOARCHIVELOG mode, back to last Tuesday t

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

428 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
How many individual archive-log destination directories are supported by OracleDatabase11g?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

408 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which of the following methods can be used to detect block corruption?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

400 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You have the following requirements in relation to the detection of block corruption for your database instance:-> Check

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

415 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which command do you use to generate a report of database incarnations?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

401 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
If a backup is expired, which of the following is true?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

641 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Archived redo logs can be copied to more than one destination by Oracle.

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

417 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You run the following commands:RMAN> list expired backup;RMAN> delete expired backup;What will happen to the backup set

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

386 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
How is block-change tracking enabled?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

456 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

409 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What is the purpose of the recover command? (Choose all that apply.)

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

454 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You want to make sure that your database backup does not exceed 10 hours in length.What command would you issue that wou

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

390 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true a

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

480 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
View the Exhibit and examine the Data Pump architecture.Identify the numbered components.Exhibit:

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

419 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You execute the following Recovery Manager (RMAN) commands in the following order:BACKUP VALIDATE DATABASE;RECOVER CORRU

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

411 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which command would you use to determine what database backups are currently available for restore?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

400 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
If you issue the command shutdown abort prior to trying to put the database inARCHIVELOG mode, what will be the result w

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

435 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
View the Exhibit for the object interdependency diagram.-> The PRODUCTS table is used to create the PRODCAT_VW view.-> P

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

412 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
What does it mean if a backup is expired?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

401 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

407 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every t

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

427 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
If a log file becomes corrupted, it may cause the database to stale. How would you correct such a situation?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

388 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
You want to use the automatic management of backup and recovery operations features for your database.Which configuratio

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

460 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

596 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Your archive-log destination directory runs out of space. What is the impact of this on the database?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

402 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which RMAN backup command is used to create the block-change tracking file?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

493 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

418 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the productio

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

385 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm
Which of the following parameters defines the location where Oracle should create archived redo logs?

Last post by answerhappygod « Sun Jun 11, 2023 3:49 pm
Replies: 1
by answerhappygod » Sun Jun 11, 2023 3:49 pm

1 Replies

409 Views

Last post by answerhappygod
Sun Jun 11, 2023 3:49 pm