Oracle Database 11g Essentials - 1Z0-514 Exam Practice Test

A. Dictionary-managed tablespaces can be converted to locally managed tablespaces.

B. Locally managed temporary tablespaces can be converted to permanent tablespaces.

C. AUTOEXTEND can be enabled only for new data files.

D. Space usage alert thresholds can be modified only if the tablespace contains no data.

A. A user automatically has all the object privileges on all the objects contained in his or her schema.

B. Object privileges can be granted by both owner of the object and the DBA

C. The DBA can revoke object privileges from the owner of the object.

D. Objectprivileges can begranted only by the owner of the object.

A. It can be accessed Irrespective of whether the database instance shut down or running.

B. It can beaccessed only it thedefault preset port number1158 is available.

C. It can be accessed only it the Net service names have been configured in the server tnsnames.ora file.

D. It can be accessed through a Web browser or command line.

A. undo tablespace

B. temporary tablespace

C. redo logs

D. flash recovery area

A. Complete recovery involves only rolling forward operations

B. Database recovery is not required after an instance recovery.

C. Complete recovery involves both rolling forward and rolling backward operations

D. Incomplete recovery applies changes only from archived redo logs.

E. Incomplete recovery can apply changes from both online and archived redo logs.

F. Complete database recovery must be performed after an instance recovery.

A. Each group must have the same number of members.

B. The redo log groups in a database are written to in a cyclic fashion.

C. The members within a redo log group are written to in a cyclic fashion.

D. Each group must have a minimum of two members.

E. A minimum of two redo log groups is required for a database to open.

A. adding 20% more memory to the new server to handle the increased requirements of Oracle Database 11g Release 2

B. running both systems in parallel during production usage

C. reproducing the current client environment on the new serverto ensure that the new environment can deliver the same results with the same workload.

D. using SQL Performance Analyzer to compare the performance of SQL statements in the new and old server environments

E. using Database Replay to capture the workload on the existing server, to be used in testing the new server environment