Download Oracle Database Administration I.1z0-082.TestKing.2019-12-22.44q.vcex

Vendor: Oracle
Exam Code: 1z0-082
Exam Name: Oracle Database Administration I
Date: Dec 22, 2019
File Size: 89 KB
Downloads: 3

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Demo Questions

Question 1
Which three statements are true concerning logical and physical database structures? (Choose three.)
  1. All tablespaces may have one or more data files
  2. The extents of a segment must always reside in the same datafile
  3. A smallfile tablespace might be bigger than a bigfile tablespace 
  4. A segment can span multiple data files in some tablespaces
  5. A segment’s blocks can be of different sizes
  6. A segment might have only one extent
  7. Segments can span multiple tablespsaces
Correct answer: CFG
Question 2
Which two statements are true regarding a SAVEPOINT? (Choose two.)
  1. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
  2. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
  3. Only one SAVEPOINT may be issued in a transaction
  4. A SAVEPOINT does not issue a COMMIT
  5. Rolling back to a SAVEPOINT can undo a DELETE statement
Correct answer: DE
Question 3
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)
  1. writing inbound request to the common request queue from all shared server connections
  2. checking for outbound shared server responses on the common outbound response queue
  3. receiving inbound requests from processes using shared server connections
  4. sending each connection input request to the appropriate shared server input queue
  5. broadcasting shared server session responses back to requesters on all connections
  6. sending shared server session responses back to requesters on the appropriate connection
Correct answer: ACD
Question 4
You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed. 
The variables used in your query are never undefined in your session. 
Which query can be used? 
  1. SELECT &&col1, &&col2
    FROM &table
    WHERE &&condition = &&cond;
  2. SELECT &col1, &col2
    FROM &&table
    WHERE &condition;
  3. SELECT &col1, &col2
    FROM “&table”
    WHERE &condition;
  4. SELECT ‘&&col1’, ‘&&col2’
    FROM &table
    WHERE ‘&&condition’ = ‘&cond’;
  5. SELECT &&col1, &&col2
    FROM &table
    WHERE &&condition;
Correct answer: B
Question 5
Examine the description of the CUSTOMERS table:
  
You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters. 
Which query can be used?
  1. SELECT * FROM customers WHERE city LIKE ‘D_%’;
  2. SELECT * FROM customers WHERE city = ‘%D_’;
  3. SELECT * FROM customers WHERE city LIKE ‘D_’;
  4. SELECT * FROM customers WHERE city = ‘D_%’;
Correct answer: A
Question 6
Examine this command:
  
Which two statements are true? (Choose two.)
  1. DML may be performed on tables with one or more extents in this data file during the execution of this command.
  2. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
  3. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
  4. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
  5. The file is renamed and stored in the same location
Correct answer: AB
Question 7
Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)
  1. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
  2. An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried.
  3. An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried.
  4. Partition key columns cannot be dropped. 
  5. A DROP COLUMN command can be rolled back
  6. A column that is set to UNUSED still counts towards the limit of 1000 columns per table
Correct answer: ABF
Question 8
Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? 
(Choose two.)
  1. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
  2. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
  3. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
  4. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
  5. A block will always be eligible for inserts if the row is short enough to fit into the block
Correct answer: CE
Question 9
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?
  1. COLUMN STORE COMPRESS FOR QUERY LOW
  2. ROW STORE COMPRESS BASIC
  3. COLUMN STORE COMPRESS FOR ARCHIVE LOW
  4. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
  5. ROW STORE COMPRESS ADVANCED 
Correct answer: E
Explanation:
Reference: https://www.oracle.com/technetwork/database/options/compression/advanced-compression-wp-12c-1896128.pdf
Reference: https://www.oracle.com/technetwork/database/options/compression/advanced-compression-wp-12c-1896128.pdf
Question 10
Which two statements are true about space-saving features in an Oracle Database? (Choose two.)
  1. Private Temporary Tables (PTTS) store metadata in memory only
  2. An index created with the UNUSABLE attribute has no segment
  3. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement
  4. An index that is altered to be UNUSABLE will retain its segment
  5. A table that is truncated will always have its segment removed
Correct answer: BC
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!