Oracle 1z0-053 Exam Practice Questions (P. 2)
- Full Access (706 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #11
- AThe number of DBWR processes increases
- BThe number of ASMB processes increases
- CThe number of DBWR_TO_SLAVES increases
- DThe rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead
D

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #12
- ADatabase files
- BSPFILEs
- CRedo-log files
- DArchived log files
- ERMAN backup sets
- FPassword files
- Ginit.ora files
FG
What Types of Files Does Oracle ASM Support?


Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #13
ALTER DISKGROUP diskgroup2 DROP DISK dg2a;
You issue the following command from the ASM instance:
SELECT group_number, COUNT(*) FROM v$asm_operation;
What is the implication if the query against V$ASM_OPERATION returns zero rows?
- AThe drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
- BThe drop disk operation is complete and you can run the undrop disks command if needed.
- CThe drop disk operation is complete and you cannot run the undrop disks command.
- DThe query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.
- ENone of the above is true.
C
Once the DROP DISK operation is completed, you CANNOT run the UNDROP DISKS command any more.

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #14
alter diskgroup dgroup1 drop disk abc;
- AThe disk ABC will be dropped from the disk group. Since you did not issue a rebalance command, the data on that disk will be lost.
- BThe command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.
- CThe disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete, the disk will be dropped.
- DThis command will fail because you cannot drop a specific disk in an ASM disk group.
- EThe disk drop command will be suspended for a predetermined amount of time, waiting for you to also issue an alter diskgroup rebalance command. Once you
C

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #15
- AAU_SIZE
- BCOMPATIBLE.RDBMS
- CCOMPATIBLE.ASM
- DDISK_REPAIR_TIME
- EDG_DROP_TIME
E
DG_DROP_TIME is an invalid DG attribute.
Disk Group Attributes -
The DISK_REPAIR_TIME disk group attribute specifies how long a disk remains offline before ASM drops the disk.
The COMPATIBLE.ASM attribute determines the minimum software version for an ASM instance that uses the disk group.
The COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that uses the disk group.
The AU_SIZE attribute determines the allocation unit size of the disk group. The values can be 1, 2, 4, 8, 16, 32, and 64 MB.

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #16
At the end of the upgrade, you observe that the DBA executes the following script:
SQL> @utlrp.sql -
What is the significance of executing this script?
- AIt performs parallel recompilation of only the stored PL/SQL code.
- BIt performs sequential recompilation of only the stored PL/SQL code.
- CIt performs parallel recompilation of any stored PL/SQL as well as Java code.
- DIt performs sequential recompilation of any stored PL/SQL as well as Java code.
C
Recompile invalid objects with utlrp.sql

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #17
Which parameter should you specify to control the speed of the rebalancing activity?

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #18
- AORACLE_BASE should be set explicitly.
- BAn Oracle base should have only one Oracle home created in it.
- CFlash recovery area and data file location should be on separate disks.
- DFlash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.
ACD

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #19
$ SQLPLUS scott/tiger@DB01 AS SYSDBA
Which DB01 is the net service name.
Which authentication method would be used first?
- Aauthentication by password file
- Bauthentication by using certificates over SSL
- Cauthentication by using the Oracle Internet Directory
- Dauthentication by using the local OS of the database server
A

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #20
What configuration would you effect to achieve your objective? (Choose all that apply.)
- ASet the ASM compatibility attribute for the ASM disk group to 11.1.0.
- BSet the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
- CSet the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
- DSet the COMPATIBLE initialization parameter for the database instance to 11.1.0.
AD

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
All Pages