Oracle Database 12c: Installation and Administration - 1z0-062 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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

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;
Which is the outcome?

A. Change is applied to the current instance, but does not persist after instance restart. B. The value is changed for the current instance and in the PFILE. C. It fails because the SCOPE clause is missing. D. The value is changed only in the PFILE and takes effect at the next instance startup.

Discussion 0

Correct Answer: A Vote an answer

Question 2

Which three statements are true about Oracle Data Pump? (Choose three.)

A. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege. B. A directory object must exist and a user performing an EXPDP or IMPDP operation must have read and write permission on that directory object. C. Oracle Data Pump export operations invoked from the clients that are connected remotely by using a connection string, create Data Pump files on the client file system. D. Oracle Data Pump export and import operations can be performed to move data across different database releases. E. DBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients.

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 3

You install Oracle Grid Infrastructure standalone server and issue the following command:
crsctl start has
Which two existing components get automatically added to the Oracle Restart configuration? (Choose two.)

A. Oracle CSSD services B. Oracle Net Listener C. Oracle Healthcheck services D. the database whose instance is running E. Oracle Notification services

Discussion 0

Correct Answer: A,E Vote an answer

Question 4

You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file? (Choose two.)

A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role. B. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role. C. It contains usernames and passwords of database users who are members of the OSDBA operating system group. D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role. E. It contains username and passwords of database users who are members of the OSOPER operating system group.

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

On your Oracle Database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true? (Choose two.)

A. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true. B. Only the ORD_CUSTOMER_IX1 index created. C. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table. D. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table. E. Both the indexes are created and used by the optimizer for queries on the ORDERS table. F. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

Discussion 0

Correct Answer: D,F Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.
The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade.
What must you do first in this situation to attempt to fix this problem?

A. Run utluiobj.sql to filter out objects that were invalidated by the upgrade process. B. Run catuppst.sql to perform revalidation actions C. Run preupgrd.sql and then execute the generated "fix-up" scripts to resolve status issues. D. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.

Discussion 0

Correct Answer: D Vote an answer

Question 7

Your database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
You execute the following command:

And then grant OPS$GUEST_USER the CREATE SESSION privilege.
Which two statements are true? (Choose two.)

A. GUEST_USER is forced to change the password at the first login. B. GUEST_USER can query the tables created in the USERS tablespace by default. C. A local GUEST_USER OS account should exist before GUEST_USER can log on to the database. D. GUEST_USER can log on to the database without specifying a username and password. E. The authentication details for GUEST_USER are stored in the database password file.

Discussion 0

Correct Answer: C,D Vote an answer

Question 8

Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file?
(Choose three.)

A. The SQL* Loader operation fails because no record terminators are specified. B. Field names should be the first line in the both the SQL* Loader data files. C. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data. D. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator. E. The SQL* Loader data file myfile1.dat has the column names for the EMP table.

Discussion 0

Correct Answer: C,D,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 9

Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).

A. Configure at least one dispatcher for the TCP/IP protocol. B. Install Oracle HTTP Server. C. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server. D. Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Express. E. Grant the APEX_PUBLIC_USER role to the SYSMAN user.

Discussion 0

Correct Answer: A,C Vote an answer

Question 10

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M; B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M; C. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M; D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M; E. BACKUP ARCHIVELOG ALL SECTION SIZE 25M; F. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M; G. BACKUP SPFILE SECTION SIZE 1M;

Discussion 0

Correct Answer: A,B,C,F Vote an answer

Question 11

One of your databases has archive logging enabled and RMAN backups are taken at regular intervals.
The data file for the USERS tablespace is corrupt.
Which command must you execute before starting the recovery of this tablespace?

A. ALTER TABLESPACE users OFFLINE NORMAL; B. ALTER TABLESPACE users OFFLINE IMMEDIATE; C. ALTER TABLESPACE users OFFLINE TEMPORARY; D. STARTUP FORCE E. SWITCH DATAFILE ALL;

Discussion 0

Correct Answer: C Vote an answer

Question 12

You create a locally managed tablespace ORDERS_TBS with automatic segment management.
You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.
CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?

A. It minimizes row chaining during row insertion. B. It automatically coalesces free space of a data block when it reaches 20% of available space. C. It minimizes row migration during existing row data updation. D. It allows only 80% of space to be occupied in all data blocks of this table.

Discussion 0

Correct Answer: D Vote an answer

Question 13

In your database, archive logging and control file autobackup are enabled.
The data files and redo log files are intact but control files are impacted due to media failure.
In which two recovery scenarios must you use the RESETLOGS option? (Choose two.)

A. One control file copy is intact so the spfile is changed to refer to only one copy. B. One control file copy is intact and damaged control file copies have to be restored to the default location. C. All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually. D. All copies of the control file are damaged and the auto backed up control file is used for recovery. E. One control file copy is intact and damaged control file copies have to be restored to a non-default location.

Discussion 0

Correct Answer: C,D Vote an answer