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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Examine the description of the BOOKS table: The table has 100 rows. Examine this sequence of statements issued in a new session: INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)
A. The second ROLLBACK command does nothing
B. The second ROLLBACK command replays the delete
C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
D. The second ROLLBACK command undoes the insert
E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
عرض الإجابة
اجابة صحيحة: ACEG
السؤال #2
Which three statements are true about the Oracle Data Dictionary? (Choose three.)
A. Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
B. The data dictionary is created and maintained by the database administrator
C. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
D. Base tables can be queried directly
E. It is owned by the SYSTEM user
F. Usernames of all users including database administrators are stored in the data dictionary
عرض الإجابة
اجابة صحيحة: DE
السؤال #3
In one of your databases, user KING is: \1. Not a DBA user \2. An operating system (OS) user Examine this command and its output: What must you do so that KING is authenticated by the OS when connecting to the database instance?
A. Set OS_AUTHEN_PREFIX to OPS$
B. Have the OS administrator add KING to the OSDBA group
C. Grant DBA to KING
D. Unset REMOTE_LOGIN_PASSWORDFILE
E. Alter user KING to be IDENTIFIED EXTERNALLY
عرض الإجابة
اجابة صحيحة: CDF
السؤال #4
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.)
A. SELECT NVL(cust_credit_linit *
B. SELECT NVL2(cust_credit_linit *
C. SELECT NVL(TO_CHAR(cust_credit_limit *
D. SELECT TO_CHAR(NVL(cust_credit_limit *
E. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit *
عرض الإجابة
اجابة صحيحة: B
السؤال #5
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)
A. The Oracle join syntax supports creation of a Cartesian product of two tables
B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
C. The SQL:1999 compliant ANSI join syntax supports natural joins
D. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
E. The Oracle join syntax only supports right outer joins
F. The Oracle join syntax supports natural joins G
عرض الإجابة
اجابة صحيحة: ACD
السؤال #6
You want to use table compression suitable for OLTP that will: Compress rows for all DML statements on that table Minimize the overheads associated with compression Which compression option is best suited for this?
A. COLUMN STORE COMPRESS FOR QUERY LOW
B. ROW STORE COMPRESS BASIC
C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
E. ROW STORE COMPRESS ADVANCED
عرض الإجابة
اجابة صحيحة: B
السؤال #7
Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)
A. The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query
B. The number, but not names, of columns must be identical for all SELECT statements in the query
C. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query
D. The names and number of columns must be identical for all SELECT statements in the query
E. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query
عرض الإجابة
اجابة صحيحة: E

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

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

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

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


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