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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
A. A table can have only one primary key but multiple foreign keys
B. A table can have only one primary key and foreign key
C. The foreign key columns and parent table primary key columns must have the same names
D. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
E. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
F. Only the primary key can be defined at the column and table level G
عرض الإجابة
اجابة صحيحة: BCF
السؤال #2
Examine this command and some partial output: Why does the DB01.abc.com service show unknown status?
A. The service DB01
B. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
C. The service DB01
D. The listener is not listening on the default port 1521
E. The SID_LIST_LISTENER section is not contained in the LISTENER
عرض الإجابة
اجابة صحيحة: BCD
السؤال #3
What is true about non-equijoin statement performance? (Choose two.)
A. Table aliases can improve performance
B. The BETWEEN condition always performs better than using the >= and <= conditions
C. The join syntax used makes no difference to performance
D. The BETWEEN condition always performs less well than using the >= and <= conditions
E. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
عرض الإجابة
اجابة صحيحة: BE
السؤال #4
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
A. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
C. It supports diagnostics for Automatic Storage Management (ASM)
D. It supports diagnostics for Oracle Clusterware
E. It is held inside an Oracle database schema
عرض الإجابة
اجابة صحيحة: AE
السؤال #5
Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)
A. Tablespace free space can be viewed in VSTABLESPACE
B. VSTABLESPACE displays information that is contained in the controlfile about tablespaces
C. VSTABLESPACE displays information about tablespaces contained in the data dictionary
D. Tablespace free space can be viewed in DBA_TABLESPACES
E. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
عرض الإجابة
اجابة صحيحة: BCF
السؤال #6
Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE ‘undotbs_01.dbf’ SIZE 100M AUTOEXTEND ON; Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)
A. Add the SEGMENT SPACE MANAGEMENT AUTO clause
B. Set UNDO_TABLESPACE to UNDOTBS01
C. Add the NOLOGGING clause
D. Make certain that the database operates in automatic undo management mode
E. Add the ONLINE clause
عرض الإجابة
اجابة صحيحة: BD
السؤال #7
Which three statements are true about table data storage in an Oracle Database? (Choose three.)
A. Data block headers contain their own Data Block Address (DBA)
B. A table row piece can be chained across several database blocks
C. Multiple row pieces from the same row may be stored in different database blocks
D. Multiple row pieces from the same row may be stored in the same block
E. Data block free space is always contiguous in the middle of the block
F. Index block free space is always contiguous in the middle of the block
عرض الإجابة
اجابة صحيحة: CDF
السؤال #8
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
A. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted
B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table
C. GLOBAL TEMPORARY TABLE space allocation occurs at session start
D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted
E. A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions
F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back
عرض الإجابة
اجابة صحيحة: BC
السؤال #9
Which three statements are true about Oracle synonyms? (Choose three.)
A. A synonym cannot be created for a PL/SQL package
B. A synonym can be available to all users
C. A SEQUENCE can have a synonym
D. A synonym created by one user can refer to an object belonging to another user
E. Any user can drop a PUBLIC synonym
عرض الإجابة
اجابة صحيحة: DE

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

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

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

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


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