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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which statement is true about aggregate functions?
A. Aggregate functions can be nested to any number of levels
B. The AVG function implicitly converts NULLS to zero
C. Aggregate functions can be used in any clause of a SELECT statement
D. The MAX and MIN functions can be used on columns with character data types
عرض الإجابة
اجابة صحيحة: B
السؤال #2
You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)
A. analysis of all privileges used by all users including administrative users in the database
B. analysis of all privileges used by all users but excluding administrative users in the database
C. analysis of privileges that a user has on their own schema objects that they did not use
D. analysis of privileges that a user has on their own schema objects that they did use
E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
F. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role
عرض الإجابة
اجابة صحيحة: A
السؤال #3
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)
A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
B. SYSDATE can be queried only from the DUAL table
C. CURRENT_DATE returns the current date and time as per the session time zone
D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
عرض الإجابة
اجابة صحيحة: BC
السؤال #4
In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: Which statement is true?
A. Dynamic service registration cannot be used for this database instance
B. The LREG process registers services dynamically with the LISTENER_1 listener
C. LISTENER_1 must also be defined in the LISTENER
D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
عرض الإجابة
اجابة صحيحة: DE
السؤال #5
Which three statements are true about the DESCRIBE command? (Choose three.)
A. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
B. It can be used from SQL Developer
C. It displays the NOT NULL constraint for any columns that have that constraint
D. It can be used to display the structure of an existing view
E. It displays all constraints that are defined for each column
F. It can be used only from SQL *Plus
عرض الإجابة
اجابة صحيحة: ADF
السؤال #6
Examine this command: Which two statements are true? (Choose two.)
A. DML may be performed on tables with one or more extents in this data file during the execution of this command
B. The tablespace containing SALES1
C. The tablespace containing SALES1
D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST
E. The file is renamed and stored in the same location
عرض الإجابة
اجابة صحيحة: AB
السؤال #7
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)
A. writing inbound request to the common request queue from all shared server connections
B. checking for outbound shared server responses on the common outbound response queue
C. receiving inbound requests from processes using shared server connections
D. sending each connection input request to the appropriate shared server input queue
E. broadcasting shared server session responses back to requesters on all connections
F. sending shared server session responses back to requesters on the appropriate connection
عرض الإجابة
اجابة صحيحة: BCF

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

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

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

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


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