[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-497 Dumps with VCE and PDF Download 61-70

Ensurepass.com : Ensure you pass the IT Exams 2018 Jan Oracle Official New Released 1z0-497
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-497.html

Oracle Database 12c Essentials

Question No: 61

Examine the table:

Table name: PRODUCTS Schema: SCOTT Tablespace: USERS

Organization: Standard (Heap Organized)

This table contains 20 rows. In the data that has been entered, the PROD_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and PROD_RATE has four-digit values for all rows.

Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?

  1. PROD_NAME size can be increased from five to 10 characters.

  2. PROD_ID can be changed from CHAR to NUMBER data type.

  3. PROD_RATE size can be changed from NUMBER(4) to NUMBER(6, 2).

  4. New columns can be added only if they have a NOT NULL constraint.

  5. None of the existing columns can be dropped because they contain data.

Answer: A,C

Question No: 62

Why does performance degrade when many UPDATE, INSERT, or DELETEstatements are issued on a table that has an associated bitmap index?

  1. The DML operations re-create the bitmap index blocks.

  2. The bitmap index is rebuilt automatically after a DML operation.

  3. The smallest amount of a bitmap that can be locked is a bitmap segment.

  4. Additional time is taken to remove NULL values from the bitmap index alter a DML operation.

Answer: C

Explanation: Bitmap indexes in currently “supported” versions of Oracle are maintained in a much more efficient manner than they were previously, to the point where the need for frequently rebuilds has been much reduced, even in tables in which such indexes are not dropped during heavy loads.

That said, Bitmap indexes are still unsuitable in OLTP type environments (even in 11g or later) due to the locking implications associated with them.

Note: bitmap indexes are only suitable for static tables and materialized views which are updated at nigh and rebuilt after batch row loading.

Not B: Like b-tree indexes, bitmap indexes should be rebuilt (ALTER INDEX . . . REBUILD) if there is a lot of DML (UPDATE, INSERT, DELETE) activity.

Not A: Since 10g, Oracle is significantly more efficient and where possible will simply adjust the current rowid range of the Bitmap index entry and modify the bitmap string accordingly to accommodate a new row value (resulting in an overall increase of just 2 bytes overall in this example) rather than create a totally new index entry (which required an additional 21 bytes in the 9i example).

Question No: 63

Which two statements are true regarding SQL*Plus?

  1. It has commands for performing database administration operations.

  2. It can be used in interactive but not batch mode for SQL commands.

  3. It has to be installed separately after the Oracle Database 12c installation.

  4. Operating system commands can be executed from the SQL*Plus command prompt.

Answer: A,D

Reference: http://docs.oracle.com/cd/B14117_01/server.101/b12170/qstart.htm

Question No: 64

When executing shutdown abort in a pluggable database (PDB), you .

  1. shut down abort the CDB

  2. shut down abort the PDB

  3. shut down immediate the PDB

  4. shut down immediate the CDB

Answer: C

Question No: 65

Which statement is true about loading data by using the conventional path of SQL*Loader?

  1. Redo is not generated while performing conventional path loads.

  2. Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,

  3. No exclusive locks are acquired when the conventional path loads are performed.

  4. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.

  5. INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.

Answer: C

Reference: http://www.orafaq.com/wiki/SQL*Loader

Question No: 66

As part of your Oracle Database 12c post-installation tasks, you run these commands:

Cd $ORACLE_HOME/bin srvctl stop database -d myDb chopt enable dm

srvctl start database -d myDb What does this do?

  1. It enables the Oracle Data Mining option in your Oracle binary files.

  2. It creates the Fast Recovery Area disk group.

  3. It generates Client Static Library.

  4. It configures one of the Oracle user accounts.

  5. It configures Oracle Net Services.

  6. It configures Oracle Messaging Gateway.

Answer: A

Reference: http://docs.oracle.com/cd/E16655_01/install.121/e17889/postinst.htm#RILIN1049 (see 4.4)

Question No: 67

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:

ERROR at line 1:

ORA-00060: deadlock detected while waiting for resource

You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two statements are true about SCOTT#39;s session in this scenario?

  1. The session is terminated after receiving the error and JIM can continue with his transaction.

  2. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

  3. The session is rolled back after receiving the error and JIM can continue with his transaction.

  4. SCOTT has to re-execute the last command in the transaction after he commits the transaction.

Answer: B,D

Explanation: https://www.youtube.com/watch?v=JitJRb5x9vI

Question No: 68

Which three statements are true about database storage structures?

  1. A data file can span across tablespaces.

  2. An extent contains one or more segments.

  3. Tablespaces contain one or more data files.

  4. Data objects are stored as segments in tablespaces.

  5. Segments can span across data files within a tablespace.

Answer: C,D,E Explanation:

https://docs.oracle.com/cd/E11882_01/server.112/e40540/physical.htm#CNCPT1109

Question No: 69

Which three are initialization parameters for backup and recovery?

  1. CLONEDB

  2. FILESYSTEMIO_OPTIONS

  3. DB_CREATE_FILE_DEST

  4. RECYCLEBIN

  5. TAPE_ASYNCH_IO

Answer: A,D,E

Explanation:

http://docs.oracle.com/database/121/REFRN/refrn00102.htm#REFRN00102

Question No: 70

You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?

  1. You should not install the Oracle Database software into an existing Oracle home from a different release.

  2. A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.

  3. Oracle recommends that you back up the root. sh script after you complete the installation.

  4. Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.

  5. You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.

Answer: C

Explanation: https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG1035 https://docs.oracle.com/database/121/LADBI/post_inst_task.htm#LADBI7749

100% Ensurepass Free Download!
Download Free Demo:1z0-497 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-497 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.