Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-053

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
Get Contributor Access
Question #11
What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?
  1. A
    The number of DBWR processes increases
  2. B
    The number of ASMB processes increases
  3. C
    The number of DBWR_TO_SLAVES increases
  4. D
    The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead

Correct Answer:
D

Question #12
ASM supports all but which of the following file types? (Choose all that apply.)
  1. A
    Database files
  2. B
    SPFILEs
  3. C
    Redo-log files
  4. D
    Archived log files
  5. E
    RMAN backup sets
  6. F
    Password files
  7. G
    init.ora files

Correct Answer:
FG
What Types of Files Does Oracle ASM Support?

Question #13
After executing the command -
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?
  1. A
    The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
  2. B
    The drop disk operation is complete and you can run the undrop disks command if needed.
  3. C
    The drop disk operation is complete and you cannot run the undrop disks command.
  4. D
    The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.
  5. E
    None of the above is true.

Correct Answer:
C
Once the DROP DISK operation is completed, you CANNOT run the UNDROP DISKS command any more.

Question #14
What is the net effect of the following command?
alter diskgroup dgroup1 drop disk abc;
  1. A
    The 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.
  2. B
    The 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.
  3. C
    The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete, the disk will be dropped.
  4. D
    This command will fail because you cannot drop a specific disk in an ASM disk group.
  5. E
    The 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

Correct Answer:
C

Question #15
Which of the following is not a configurable attribute for an individual disk group?
  1. A
    AU_SIZE
  2. B
    COMPATIBLE.RDBMS
  3. C
    COMPATIBLE.ASM
  4. D
    DISK_REPAIR_TIME
  5. E
    DG_DROP_TIME

Correct Answer:
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.

Question #16
Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment.
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?
  1. A
    It performs parallel recompilation of only the stored PL/SQL code.
  2. B
    It performs sequential recompilation of only the stored PL/SQL code.
  3. C
    It performs parallel recompilation of any stored PL/SQL as well as Java code.
  4. D
    It performs sequential recompilation of any stored PL/SQL as well as Java code.

Correct Answer:
C
Recompile invalid objects with utlrp.sql

Question #17
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.
Which parameter should you specify to control the speed of the rebalancing activity?
  1. A
    ASM_POWER_LIMIT
  2. B
    ASM_DISKSTRING
  3. C
    ASM_DISKGROUPS
  4. D
    INSTANCE_TYPE

Correct Answer:
A

Question #18
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)
  1. A
    ORACLE_BASE should be set explicitly.
  2. B
    An Oracle base should have only one Oracle home created in it.
  3. C
    Flash recovery area and data file location should be on separate disks.
  4. D
    Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.

Correct Answer:
ACD

Question #19
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:
$ SQLPLUS scott/tiger@DB01 AS SYSDBA
Which DB01 is the net service name.
Which authentication method would be used first?
  1. A
    authentication by password file
  2. B
    authentication by using certificates over SSL
  3. C
    authentication by using the Oracle Internet Directory
  4. D
    authentication by using the local OS of the database server

Correct Answer:
A

Question #20
You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.
What configuration would you effect to achieve your objective? (Choose all that apply.)
  1. A
    Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
  2. B
    Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
  3. C
    Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
  4. D
    Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

Correct Answer:
AD

Previous Questions Next Questions

All Pages