Online Access Free 1z1-072 Practice Test

Which three are true about Oracle Database backup taken with RMAN?

• A.RMAN always includes the control file in a backup.
• B.A whole backup contains all data blocks of all data files.
• C.RMAN cannot backup REDO logs.
• D.An RMAN image copy can be written only to disk.
• E.A full backup contains all data blocks from one or more data files.
• F.Only offline backup are consistent.

You execute this command to connect to an instance from a client on a different machine:
CONNECT username/password@net_service_name
No name servers are configured.
Which two are true about net_service_name? (Choose two.)

• A.It must be defined in the tnsnames.ora file on the server side.
• B.It must be defined in the tnsnames.ora file on the client side.
• C.It must contain only one address protocol for one listener.
• D.It must have the same name as the SERVICE_NAME defined in it.
• E.It must contain the address protocol for only one listener.

Which two are true about conventional path SQL load? (Choose two.)

• A.It locks objects being processed.
• B.It does not generate UNDO.
• C.It enforces referential integrity constraints.
• D.It always generates redo.
• E.It cannot load data into clustered tables.

Which is a machine image in Oracle Cloud?

• A.the number of OCPUs and amount of memory allocated to an instance
• B.the number of OCPUs, amount of memory, and persistent block storage space allocated to an instance
• C.the physical persistent block storage space allocated to an instance
• D.a template of a virtual hard disk of specific size without an operating system installed
• E.a template of a virtual hard disk of specific size with an installed operating system

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.ROW STORE COMPRESS ADVANCED
• B.COLUMN STORE COMPRESS FOR ARCHIVE LOW
• C.COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• D.COLUMN STORE COMPRESS FOR QUERY LOW
• E.ROW STORE COMPRESS BASIC