لا تريد أن تفوت شيئا؟

نصائح اجتياز امتحان الشهادة

آخر أخبار الامتحانات ومعلومات الخصم

برعاية وحديثة من قبل خبرائنا

نعم، أرسل لي النشرة الإخبارية

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements: What is the result of the last SET CONTAINER statement and why is it so?
A. It succeeds because the PDB_ADMIN user has the required privileges
B. It fails because common users are unable to use the SET CONTAINER statement
C. It fails because local users are unable to use the SET CONTAINER statement
D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB)
عرض الإجابة
اجابة صحيحة: AE

View The Updated 1z0-062 Exam Questions

SPOTO Provides 100% Real 1z0-062 Exam Questions for You to Pass Your 1z0-062 Exam!

Get 1z0-062 Practice Test
السؤال #2
You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor? (Choose three.)
A. It may advise the use of online table redefinition for tables in dictionary managed tablespace
B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows
C. It may advise the use of online table redefinition for tables in locally managed tablespaces
D. It will detect and advise about chained rows
E. It may advise the use of segment shrink for free list managed tables
عرض الإجابة
اجابة صحيحة: ACD
السؤال #3
Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
A. It calls SQL advisors automatically if required
B. It provides recommendations only for poorly performing SQL statements
C. Its results are stored in AWR
D. It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis
E. It requires at least one Automatic Workload Repository (AWR) snapshot for analysi
عرض الإجابة
اجابة صحيحة: ABF
السؤال #4
Which three statements are true about server-generated alerts? (Choose three.)
A. Server-generated alerts notify administrators of problems that cannot be resolved automatically
B. Alerts are not issued for locally managed read-only tablespaces
C. Response actions cannot be specified for server-generated alerts
D. Stateful alerts can be queried only from the DBA_ALERT_HISTORY view
E. When an alert is cleared, it is moved to the DBA_ALERT_HISTORY view
عرض الإجابة
اجابة صحيحة: CDF
السؤال #5
Which statement is true about profiles?
A. Resource limits specified in a profile assigned to a user are always enabled
B. A user can exist without any profile
C. A profile can be assigned only to one user
D. Password management using profiles is always enable
عرض الإجابة
اجابة صحيحة: AB
السؤال #6
Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database? (Choose two.)
A. The DEGREE_OF_PARALLELISM parameter is set to AUTO
B. You cannot have multiple SQL *Loader data files
C. If no data file is specified, it assumes the data file to be
D. You can have multiple bad files created when loading in parallel
E. You can selectively load rows into a table based on a filter
عرض الإجابة
اجابة صحيحة: CE
السؤال #7
What should you do to ensure that a job stores minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?
A. Create an event-based job
B. Create a lightweight job
C. Specify the job as a member of a job class
D. Use a job array
عرض الإجابة
اجابة صحيحة: B
السؤال #8
You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects. During this operation, you want to ensure the following:
A. Long-running queries are not affected
B. No extra space is used
C. Data manipulation language (DML) operations on the table succeed at all times throughout the process
D. Unused space is reclaimed both above and below the high water mar
E. Which ALTER TABLE option would you recommend?
F. DEALLOCATE UNUSED G
عرض الإجابة
اجابة صحيحة: B
السؤال #9
Examine the parameters for a database instance: Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?
A. Transactions write their undo in the SYSTEM undo segment
B. Transactions fail
C. Transactions wait until space becomes available in UNDOTBS1
D. Transactions write their undo in a temporary tablespace
عرض الإجابة
اجابة صحيحة: BC
السؤال #10
Which three statements are true about space usage alerts? (Choose three.)
A. Alerts are issued only when the critical threshold for space available in a tablespace is breached
B. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace
C. Database alerts can provide warnings about low space availability at both tablespace and segment levels
D. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode
E. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database
عرض الإجابة
اجابة صحيحة: C
السؤال #11
A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted? (Choose three.)
A. SYS sessions, regardless of the roles that are set in the session
B. SYSTEM sessions, regardless of the roles that are set in the session
C. SCOTT sessions, only if the MGR role is set in the session
D. SCOTT sessions, only if the MGR role is granted to SCOTT
E. SCOTT sessions, because he is the owner of the table
F. SYSTEM session, only if the MGR role is set in the session
عرض الإجابة
اجابة صحيحة: BD
السؤال #12
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)
A. ADBA can check specific tables with the DMU
B. The database to be migrated must be opened read-only
C. The release of the database to be converted can be any release since 9
D. The DMU can report columns that are too long in the converted characterset
E. The DMU can report columns that are not represented in the converted characterset
عرض الإجابة
اجابة صحيحة: BE
السؤال #13
What must you use to read data from a table in your database and write it to an external table?
A. Use SQL* LOADER conventional path load
B. Use SQL* LOADER direct path load
C. Use CREATE TABL
D.
E. Use CREATE TABL
F.
عرض الإجابة
اجابة صحيحة: AE
السؤال #14
An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations. What do you recommend to minimize this?
A. Configure the nonstandard buffer cache with a buffer size greater than the size of the default buffer cache
B. Increase the size of the shared pool
C. Configure the KEEP buffer cache and alter the tables to use the KEEP cache
D. Configure the RECYCLE buffer cache and alter the tables to use the RECYCLE cach
عرض الإجابة
اجابة صحيحة: ADE

View The Updated Oracle Exam Questions

SPOTO Provides 100% Real Oracle Exam Questions for You to Pass Your Oracle Exam!

Get Oracle Practice Test

عرض الإجابات بعد التقديم

يرجى إرسال البريد الإلكتروني الخاص بك والواتس اب للحصول على إجابات الأسئلة.

ملحوظة: يرجى التأكد من صلاحية معرف البريد الإلكتروني وWhatsApp حتى تتمكن من الحصول على نتائج الاختبار الصحيحة.

بريد إلكتروني:
رقم الواتس اب/الهاتف:


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.