ORANUX Consulting & Training 0% Test Evaluation- Oracle Database Administration II (1Z0-083) Put the Training Code to pass the Evaluation Test for the training 1Z0-083 quiz sent by ORANUX! Welcome to Evaluation Test for the training 1Z0-082 quiz! NameEmailPhone Number 1 / 20 1. Which three statements are true concerning logical and physical database structures? (Choose three.) A. All

Test Evaluation- Oracle Database Administration II (1Z0-083)

Put the Training Code to pass the Evaluation Test for the training 1Z0-083 quiz sent by ORANUX!

Welcome to Evaluation Test for the training 1Z0-082 quiz!

NameEmailPhone Number

1 / 20

1. In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

A. Dynamic service registration cannot be used for this database instance

B. The LREG process registers services dynamically with the LISTENER_1 listener

C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

2 / 20

2. Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

A. It overwrites data in EMP with data in EMP.DAT

B. It uses the database buffer cache to load data

C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations

D. It generates a sql script that it uses to load data from EMP.DAT to EMP

E. It appends data from EMP.DAT to EMP

3 / 20

3. Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

A. The service DB01.abc.com is dynamically registered

B. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1

C. The service DB01.abc.com is statically registered

D. The listener is not listening on the default port 1521

E. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

4 / 20

4.

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

A. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;

B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;

C. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;

D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

E. SELECT customer_id AS "˜CUSTOMER-ID', transaction_date AS DATE, amount + 100 "˜DUES AMOUNT' FROM transactions;

5 / 20

5. Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)

A. two or more instances on separate servers all associated with one database

B. one instance on one server associated with one database

C. one instance on one server associated with two or more databases on the same server

D. one instance on one server not associated with any database

E. one instance on one server associated with two or more databases on separate servers

6 / 20

6. You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression
Which compression option is best suited for this?

A. COLUMN STORE COMPRESS FOR QUERY LOW

B. ROW STORE COMPRESS BASIC

C. COLUMN STORE COMPRESS FOR ARCHIVE LOW

D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

E. ROW STORE COMPRESS ADVANCED

7 / 20

7. In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space

B. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space

C. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space

D. Add the AUTOEXTEND ON clause with NEXT set to 100M

E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space

8 / 20

8. Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

A. The value is changed only in the PFILE and takes effect at the next instance startup

B. The value is changed for the current instance and in the PFILE

C. It fails because the SCOPE clause is missing

D. Change is applied to the current instance, but does not persist after instance restart

9 / 20

9. Which two statements are true regarding a SAVEPOINT? (Choose two.)

A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement

B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement

C. Only one SAVEPOINT may be issued in a transaction

D. A SAVEPOINT does not issue a COMMIT

E. Rolling back to a SAVEPOINT can undo a DELETE statement

10 / 20

10. You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

A. AUTOEXTEND is possible for the datafile

B. It must be bigger than the largest SMALLFILE tablespace

C. Additional data files may not be added

D. It will be a dictionary-managed tablespace by default

E. It will always have a 32K blocksize

11 / 20

11. Which two tasks can you perform using DBCA for databases? (Choose two.)

A. Configure a nonstandard block size for a new database

B. Register a new database with an available Enterprise Manager Management server

C. Change the standard block size of an existing database

D. Configure incremental backups for a new database

E. Enable flashback database for an existing database

12 / 20

12. In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

A. T1, an index segment for the primary key, a LOB segment, and a lobindex segment

B. no segments are created

C. T1 only

D. T1 and an index segment created for the primary key only

E. T1, an index segment for the primary key, and a LOB segment only

13 / 20

13. You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

A. It must be smaller than the smallest BIGFILE tablespace

B. Free space is managed using freelists

C. Any data files added to the tablespace must have a size of 5 gigabytes

D. It uses the database default blocksize

E. It is a locally managed tablespace

14 / 20

14.

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

A. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

B. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

C. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

D. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

E. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

15 / 20

15. Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

A. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set

B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set

C. It supports diagnostics for Automatic Storage Management (ASM)

D. It supports diagnostics for Oracle Clusterware

E. It is held inside an Oracle database schema

16 / 20

16. Which three statements are true concerning logical and physical database structures? (Choose three.)

A. All tablespaces may have one or more data files

B. The extents of a segment must always reside in the same datafile

C. A smallfile tablespace might be bigger than a bigfile tablespace

D. A segment can span multiple data files in some tablespaces

E. A segment's blocks can be of different sizes

F. A segment might have only one extent

G. Segments can span multiple tablespaces

17 / 20

17. Which two are true about shrinking a segment online? (Choose two.)

A. It is not possible to shrink either indexes or Index Organized Tables (IOTs)

B. It always eliminates all migrated rows if any exist in the table

C. To shrink a table it must have a PRIMARY KEY constraint

D. To shrink a table it must have a UNIQUE KEY constraint

E. To shrink a table it must have row movement enabled

F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

18 / 20

18. Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

A. Oracle Managed Files (OMF)

B. Online table segment shrink

C. Online index segment shrink

D. Automatic data file extension (AUTOEXTEND)

E. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

19 / 20

19. Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

A. The online redo logs are opened

B. The online data files are opened

C. The alert log records the execution details

D. The Oracle background processes are started

E. The initialization parameter file is read

F. The control file is read

20 / 20

20. You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:

Export> STOP_JOB=immediate -
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

A. You can no longer monitor it

B. You can reattach to it and monitor it

C. It is paused and can be resumed

D. It continues to run in the background

E. It terminates

Your score is

0%