Flydumps Oracle 1Z0-020 exam material details are researched and created by the Most Professional Certified Authors who are regularly using current exams experience to create precise and logical dumps.You can get questions and answers from many other websites or books,but logic is the main key of success,and Flydumps will give you this key of success.
Question: 1
Which two statements are true? (Choose two)
A. With composite partitioning, table partitions can store data rows.
B. With composite partitioning, table partitions cannot store data rows.
C. With composite partitioning, table subpartitions can store data rows.
D. With composite partitioning, table subpartitions cannot store data rows.
Answer: B, C
Question: 2
Which two statements are true for an online index rebuild? (Choose two)
A. No table locking is required.
B. The operation can be done in parallel.
C. Queries on the base table will result in errors.
D. Changes to the base table are logged in a journal table.
Answer: A, D
Question: 3
Following an upgrade from Oracle8, release 8.0, to Oracle8i, release 1 or 2, you should run the script utlrp.sql to accomplish which goal?
A. Create a set of compatible data dictionary tables.
B. Recompile any PL/SQL modules made invalid by the upgrade.
C. To remove the release upgrade program modules from the SYSTEM tablespace.
D. Replace statistics tables created with the DBMS_STATS with current versions.
Answer: B
Question: 4
When you create a stored outline, in which schema is it stored?
A. SYS
B. OUTLN
C. SYSTEM
D. The Current User
Answer: B
Question: 5
What is the maximum number of parallel recover servers when the FAST_START_PARALLEL_ROLLBACK parameter is set to HIGH?
A. 2* CPU_COUNT
B. 4* CPU_COUNT
C. 6* CPU_COUNT
D. 2* number of rollback transactions
E. 4* number of rollback transactions
Answer: B
Question: 6
Given: LOG_ARCHIEVE_DEST_2??? ?.ìC ???LOCATION = /archive2 OPTIONAL??? What effect does OPTIONAL have in the location parameter?
A. There is an error on startup because there is no OPTIONAL clause available.
B. If the destination is unavailable, it puts the archive log in a default directory.
C. If the destination is unavailable, it allows the online redo log to be overwritten.
D. If the destination is unavailable, it allows the online redo log to be overwritten at the request of the DBA.
E. If the destination is unavailable, it allows the online redo log to be overwritten if the parameter LOG_ARCHIVE_DEST_2_OVERWRITE is set to ??True??
Answer: C
Question: 7
Which two can be obtained from the summary advisor? (Choose two)
A. Summary accounting.
B. Summary refresh plan.
C. Summary recommendations.
D. Summary space requirements.
Answer: C, D
Question: 8
What does fine-grained access enable you to do?
A. Associate policies with tables and view.
B. Choose the schema in which a stored PL/SQL block will execute in.
C. Select which user??s privilege map is used during execution.
D. Select how external object references are resolved in queries.
Answer: A
Question: 9
What are autonomous transactions?
A. PL/SQL blocks that have a transaction scope independent of the transaction scope of the calling PL/SQL block.
B. Nested transactions that share resources with the calling transaction.
C. The transaction that is created by the LOGON event trigger.
Answer: A
Question: 10
When the listener is NOT available during client load balancing and failover, which file does the client use to pick a listener/
A. TNSNAMES.ORA on the server
B. LISTENER.ORA on the client
C. TNSNAMES.ORA on the client
D. LISTENER.ORA on the server
Answer: C
Question: 11
Which four steps are required to transport a tablespace? (Choose four)
A. Make the tablespace read-only.
B. Import metadata into the target database.
C. Export metadata from the source database.
D. Copy the data files to the target system.
E. Make the tablespace in the target database read-write.
F. Rename the data files on the source system.
Answer: A, B, C, D
Question: 12
Examine this statement:
SELECT deptno, job, SUM(sal)
FROM emp
Which GROUP BY clause would you use to generate a subtotal of the sum of salaries in each
department, and a subtotal of the sum of salaries of all the different job types?
A. GROUP BY deptno, job;
B. GROUP BY CUBE (deptno, job);
C. GROUP BY ROLLUP (deptno, job);
D. GROUP BY SUM (deptno), SUM (job);
E. GROUP BY CUBE (deptno, job, sal);
Answer: C
Question: 13
Why would you drop a column instead of marking it unused?
A. You want to release the space.
B. You want it to process more quickly.
C. You want users to be able to modify the table during the operation.
D. You want to prevent users from creating a new column with the same name.
E. You want the column data to be available again on export or import of the table.
Answer: A
Question: 14
Which statement about transportable tablespaces is true?
A. They can be used reorganize table in a tablespace.
B. The name of the tablespace can be changed during transportation.
C. The data in the tablespace is copied using the SQL*Loader utility.
D. The name of the schema that owns the objects in the tablespace can be changed during transportation.
Answer: D
Question: 15
Which three steps should you complete before attempting a manual upgrade from Oracle8, version 8.0, to Oracle *I, release 1 or 2? (Choose three)
A. Ensure you do not have a role or user called OUTLN in your database.
B. Make a backup.
C. Drop all rollback segments with unlimited extents.
D. Ensure you have free space in your SYSTEM tablespace.
Answer: A, B, D
Question: 16
Which type of statement specifies whose schema should be used when resolving object names?
A. DEFINE
B. AUTHID
C. PRAGMA
D. EXECUTE
E. SET USER
Answer: B
Question: 17
Examine this statement:
SELECT *
FROM (SELECT class_id, crs_id
FROM classes
ORDER BY start_date DESC)
WHERE ROWNUM < 11;
What will happen when this executes?
A. The ten rows with the latest start date will be returned.
B. The ten rows with the earliest start date will be returned.
C. An error is returned citing an ORDER BY embedded within a subquery.
D. An error is returned citing an ORDER BY clause reference to a column that is not selected.
Answer: A
Question: 18
What happens during query rewrites of materialized views?
A. The user rewrites the SELECT statement without the GROUP BY clause.
B. The user rewrites the SELECT statement to use the table instead of the materialized view.
C. The optimizer the SELECT statement to use the table instead of the materialized view.
D. The optimizer rewrites the SELECT statement to use the materialized view instead of the table.
Answer: D
Question: 19
Which two initialization parameters are used to create the default value for the SERVICE_NAMES initialization parameter when it is not specified? (Choose two)
A. DB_NAMES
B. DB_FILE_NAME_CONVERT
C. DB_DOMAIN
D. MTS_SERVICE
E. INSTANCE_NAME
Answer: A, C
We provide thoroughly reviewed Oracle 1Z0-020 using the training resources which are the best for Oracle 1Z0-020,and to get certified by Microsoft Windows Store apps.It is a best choice to accelerate your career as a professional in the Information Technology industry. Now we add the latest Oracle 1Z0-020 content and to print and share content.