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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which two are true about shrinking a segment online? (Choose two.)
A. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
B. It always eliminates all migrated rows if any exist in the table
C. To shrink a table it must have a PRIMARY KEY constraint
D. To shrink a table it must have a UNIQUE KEY constraint
E. To shrink a table it must have row movement enabled
F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
عرض الإجابة
اجابة صحيحة: CE
السؤال #2
Which three statements are true about single-row functions? (Choose three.)
A. They can be used only in the WHERE clause of a SELECT statement
B. The argument can be a column name, variable, literal or an expression
C. The data type returned can be different from the data type of the argument
D. They can be nested to any level
E. They can accept only one argument
F. They return a single result row per table
عرض الإجابة
اجابة صحيحة: AD
السؤال #3
Which two tasks can you perform using DBCA for databases? (Choose two.)
A. Configure a nonstandard block size for a new database
B. Register a new database with an available Enterprise Manager Management server
C. Change the standard block size of an existing database
D. Configure incremental backups for a new database
E. Enable flashback database for an existing database
عرض الإجابة
اجابة صحيحة: BCE
السؤال #4
In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl No name server is used. Which statement is true about ORCL?
A. It must be the value of the SERVICE_NAMES parameter on the client side
B. It must resolve to a valid connect descriptor in the server’s tnsnames
C. It must resolve to a valid connect descriptor in the client’s tnsnames
D. It must be the name of the database to whose instance HR wishes to connect
E. It must be the name of the server running the database to whose instance HR wishes to connect
عرض الإجابة
اجابة صحيحة: B
السؤال #5
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
B. Source Routing requires the use of a name server
C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
E. Load Balancing requires the use of a name server
F. Connect Time Failover requires the connect string to have two or more listener addresses configured
عرض الإجابة
اجابة صحيحة: BCF
السؤال #6
Which two statements are true about the DUAL table? (Choose two.)
A. It can be accessed only by the SYS user
B. It consists of a single row and single column of VARCHAR2 data type
C. It can display multiple rows but only a single column
D. It can be used to display only constants or pseudo columns
E. It can be accessed by any user who has the SELECT privilege in any schema
F. It can display multiple rows and columns
عرض الإجابة
اجابة صحيحة: BC
السؤال #7
Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)
A. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option
B. An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried
C. An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried
D. Partition key columns cannot be dropped
E. A DROP COLUMN command can be rolled back
F. A column that is set to UNUSED still counts towards the limit of 1000 columns per table
عرض الإجابة
اجابة صحيحة: AB
السؤال #8
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command: ALTER DATABASE MOUNT; Which two actions are performed? (Choose two.)
A. The online redo logs are opened
B. The online data files are opened
C. The alert log records the execution details
D. The Oracle background processes are started
E. The initialization parameter file is read
F. The control file is read
عرض الإجابة
اجابة صحيحة: B
السؤال #9
Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)
A. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
B. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
C. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
D. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
E. A block will always be eligible for inserts if the row is short enough to fit into the block
عرض الإجابة
اجابة صحيحة: ABF
السؤال #10
You execute this command: Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace? (Choose two.)
A. AUTOEXTEND is possible for the datafile
B. It must be bigger than the largest SMALLFILE tablespace
C. Additional data files may not be added
D. It will be a dictionary-managed tablespace by default
E. It will always have a 32K blocksize
عرض الإجابة
اجابة صحيحة: BC
السؤال #11
In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform? (Choose three.)
A. Revoke the CREATE SESSION privilege from other users
B. Revoke the CREATE SESSION privilege from user HR
C. Log in to the database instance
D. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
E. Execute DDL statements in the HR schema
F. Execute DML statements in the HR schema
عرض الإجابة
اجابة صحيحة: BCF
السؤال #12
You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE ‘/u01/app/oracle/sales01.dbf SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)
A. It must be smaller than the smallest BIGFILE tablespace
B. Free space is managed using freelists
C. Any data files added to the tablespace must have a size of 5 gigabytes
D. It uses the database default blocksize
E. It is a locally managed tablespace
عرض الإجابة
اجابة صحيحة: AB
السؤال #13
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE. NLS_DATE_FORMAT is set to DD-MON-RR. Which two are true about data type conversions involving these columns in query expressions? (Choose two.)
A. CONCAT (qty_sold, invoice_date) : requires explicit conversion
B. invoice_date = ’15-march-2019’ : uses implicit conversion
C. invoie_date > ’01-02-2019’ : uses implicit conversion
D. qty_sold BETWEEN ‘101’ AND ’110’ : uses implicit conversion
E. qty_sold = ‘0554982’ uses implicit conversion
عرض الإجابة
اجابة صحيحة: CE

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

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

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

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


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