2014 Latest Pass4sure&Lead2pass Oracle 1Z0-032 Exam Questions (71-80)

You receive the following error while connecting to an Oracle9i database instance:
ORA-12523 TNS:listener could not find instance appropriate for the client connection Which action would be appropriate in the context of investigating the cause of error?

A.    checking the listener.ora file to verify that the protocol specified in ADDRESS is supported by
the database server
B.    checking the sqlnet.ora file to verify that the NAMES.DIRECTORY_PATH = (TNSNAMES,HOSTNAME)
parameter is set
C.    executing the lsnrctl services command to verify that the instances are registered with the listener,
and have the READY status.
D.    checking the tnsnames.ora file to verify that the net service name specified in your connect string
is mapped to a connect descriptor

Answer: C

You work on a database that is used for application development and operates in ARCHIVELOG mode. As a DBA, you know that database downtime can be tolerated and have designed a backup strategy containing a weekly closed database backup. The local naming method is used by clients to connect to the database. Which files should you include in this weekly user-managed backup? (Choose all that apply.)

A.    control file
B.    sqlnet.ora file
C.    archived log files
D.    tnsnames.ora file
E.    listener configuration file

Answer: AC

In your Oracle9i database, INSTANCE_NAME and SERVICE_NAMES parameters are set. Which statement is correct regarding the service registration with the default local listener?

A.    You must manually configure the listener.ora file to enable PMON to register service information
with the listener automatically.
B.    By default, the PMON process automatically registers service information with its local listener on
the default local address of TCP/IP, port 1521.
C.    You must configure the LOCAL_LISTENER parameter in the initialization parameter file to enable
PMON to register service information with the listener automatically.
D.    You must set the NAMES.DIRECTORY_PATH = (TNSNAMES,HOSTNAME) parameter in the
sqlnet.ora file to enable PMON to register service information with the listener automatically.

Answer: B

You need to change your test database from NOARCHIVELOG mode to ARCHIVELOG mode. In the process you execute the ALTER DATABASE command to change the database to ARCHIVELOG mode. What will be the outcome of this command?

A.    It opens the database and sets the database in ARCHIVELOG mode.
B.    It sets the database in ARCHIVELOG mode and updates the control file.
C.    It updates the header of all the data files and sets the database in ARCHIVELOG mode.
D.    It enables the Archiver (ARCn) processes and sets the database in ARCHIVELOG mode.

Answer: B

There are three databases in your company: PDDB, QTDB, and SLDB. A single RMAN recovery catalog is used for all the three databases. In the recovery catalog you have a stored script, Level0Backup, created for performing a level 0 backup. For which database will the backup be performed when you execute this script?

A.    all the three databases
B.    depends on the channel allocation
C.    the target database to which RMAN is connected
D.    the database configured using the CONFIGURE command at the command line before calling the script

Answer: C

You have configured the Oracle Shared Server. Which initialization parameter would you configure so that the shared pool is not used for the shared server-related User Global Area (UGA)?


Answer: D

While using Oracle Import utility to import the ORDERS table, the CREATE TABLE command in the export dump file fails because the structure of the table already exists. What should you do to avoid this error and continue loading data into the ORDERS table?

A.    set IGNORE to Y
B.    set DESTROY to Y
C.    set COMPILE to Y
D.    set CONSTRAINTS to N

Answer: A

Which option must you specify in the sqlnet.ora file on the client machines to enable clients to use the host naming method?

A.    names.addresses
B.    names.default_domain
C.    names.directory_path
D.    names.preferred_servers
E.    sqlnet.authentication_services

Answer: C

SQL*Loader is a utility that can perform which two tasks? (Choose two.)

A.    load data from a disk, tape, or named pipes
B.    load data into an Oracle database using DML statements
C.    extract, reorganize, and insert data within an Oracle database
D.    load data from external files into tables in an Oracle database
E.    load data into an Oracle database using operating system commands
F.    load data directly from a non-Oracle database to an Oracle database

Answer: AD

Which two statements are true regarding Recovery Manager (RMAN) recovery? (Choose two.)

A.    RMAN always recovers all data files including the SYSTEM data file.
B.    RMAN can be used to recover a corrupted data block in any data file.
C.    RMAN always recovers the current control file and the SYSTEM data file.
D.    RMAN prompts for the required archived redo log files while recovering a corrupted file.
E.    RMAN uses the archived redo log files and online redo log files to recover a restored file without prompting
for the file names.

Answer: BE

If you want to pass Oracle 1Z0-032 successfully, donot missing to read latest lead2pass Oracle 1Z0-032 practice exams.
If you can master all lead2pass questions you will able to pass 100% guaranteed.



Comments are closed.