خذ اختبارات أخرى عبر الإنترنت

السؤال #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. It is not possible to shrink either indexes or Index Organized Tables (IOTs)A

B. It always eliminates all migrated rows if any exist in the table

B. The second ROLLBACK command replays the delete

C. To shrink a table it must have a PRIMARY KEY constraint

C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

D. To shrink a table it must have a UNIQUE KEY constraint

D. The second ROLLBACK command undoes the insert

E. To shrink a table it must have row movement enabled

E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

عرض الإجابة

اجابة صحيحة: CD

السؤال #2

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

A. The CURRENT_TIMESTAMP function returns data without time zone information

B. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

C. A TIMESTAMP data type column contains information about year, month, and day

D. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

E. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

عرض الإجابة

اجابة صحيحة: BCE

السؤال #3

The ORCL database has RESUMABLE TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA. U1 executes this command: SQL> CREATE TABLE t1 AS (SELECT object_name, sharing, created FROM dba_objects); U1 complains that the command is taking too long to execute. In the alert log, the database administrator (DBA) finds this: 2017-03-06T12:15:17.183438+05:30 statement in resumable session ‘User U1(136), Session 1, Instance 1’ was suspended due to ORA-01536: space quota excee

A. Add a data file to DATA

B. Drop other U1 objects in DATA

C. Increase U1’s quota sufficiently in DATA

D. Set DEFERRED_SEGMENT_CREATION to TRUE

E. Grant UNLIMITED TABLESPACE to U1

F. Set AUTOEXTEND ON for data files in DATA

عرض الإجابة

اجابة صحيحة: ACF

السؤال #4

Examine the description of the CUSTOMERS table: You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters. Which query can be used?

A. SELECT * FROM customers WHERE city LIKE ‘D_%’;

B. SELECT * FROM customers WHERE city = ‘%D_’;

C. SELECT * FROM customers WHERE city LIKE ‘D_’;

D. SELECT * FROM customers WHERE city = ‘D_%’;

عرض الإجابة

اجابة صحيحة: CE

السؤال #5

Which three statements are true concerning logical and physical database structures? (Choose three.)

A. All tablespaces may have one or more data files

B. The extents of a segment must always reside in the same datafile

C. A smallfile tablespace might be bigger than a bigfile tablespace

D. A segment can span multiple data files in some tablespaces

E. A segment’s blocks can be of different sizes

F. A segment might have only one extent G

عرض الإجابة

اجابة صحيحة: C

السؤال #6

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

A. the number of hours for which an account is locked after the configured number of login attempts has been reached

B. the number of days for which an account may be inactive before it is locked

C. the maximum amount of CPU time allowed for a user’s sessions before their account is locked

D. the ability to prevent a password from ever being reused

E. the number of password changes required within a period of time before a password can be reused

F. the number of days for which an account is locked after the configured number of login attempts has been reached G

عرض الإجابة

اجابة صحيحة: CDF

السؤال #7

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed. The variables used in your query are never undefined in your session. Which query can be used?

A. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;

B. SELECT &col1, &col2FROM &&tableWHERE &condition;

C. SELECT &col1, &col2FROM “&table”WHERE &condition;

D. SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;

E. SELECT &&col1, &&col2FROM &tableWHERE &&condition;

عرض الإجابة

اجابة صحيحة: ADE

السؤال #8

View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries? (Choose two.)

A. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE

B. Display suppliers whose PROD_LIST_PRICE is less than 1000

C. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable

D. Display the total number of products supplied by supplier 102 which have a product status of obsolete

E. Display the minimum PROD_LIST_PRICE for each product status

عرض الإجابة

اجابة صحيحة: B

السؤال #9

Which three statements are true about external tables in Oracle 18c and later releases? (Choosethree.)

A. A table can have only one primary key but multiple foreign keysA

B. A table can have only one primary key and one foreign key

B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table

C. The foreign key columns and parent table primary key columns must have the same names

C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table

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

D. They cannot be partitioned

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

E. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table

F. Only the primary key can be defined at the column and table level

F. They support UPDATEs but not INSERTs and DELETEs

G. Primary key and foreign key constraints can be defined at both the column and table level

عرض الإجابة

اجابة صحيحة: ABC

السؤال #10

You execute this query:SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), MON), dd Monday for fmMonth rrrr)What is the result?

A. Data block headers contain their own Data Block Address (DBA)A

B. A table row piece can be chained across several database blocks

B. It returns the date for the first Monday of the next month

C. Multiple row pieces from the same row may be stored in different database blocks

C. It generates an error

D. Multiple row pieces from the same row may be stored in the same block

D. It returns the date for the last Monday of the current month

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

عرض الإجابة

اجابة صحيحة: B

السؤال #11

Which two tasks can you perform using DBCA for databases? (Choose two.)

A. CONCAT (qty_sold, invoice_date) : requires explicit conversionA

B. invoice_date = ’15-march-2019’ : uses implicit conversion

B. Register a new database with an available Enterprise Manager Management server

C. invoie_date > ’01-02-2019’ : uses implicit conversion

C. Change the standard block size of an existing database

D. qty_sold BETWEEN ‘101’ AND ’110’ : uses implicit conversion

D. Configure incremental backups for a new database

E. qty_sold = ‘0554982’ uses implicit conversion

E. Enable flashback database for an existing database

عرض الإجابة

اجابة صحيحة: AB

السؤال #12

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

A. The sales user must have a quota on the TEMP tablespaceA

B. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

C. The sales user must have been granted the CREATE SESSION privilege

C. The SQL:1999 compliant ANSI join syntax supports natural joins

D. The sales user must have their quota on the users tablespace removed

D. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

E. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema

E. The Oracle join syntax only supports right outer joins

F. The sales user must have been granted the CREATE TABLE privilege

F. The Oracle join syntax supports natural joins

G. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

عرض الإجابة

اجابة صحيحة: ACD

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

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

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

بريد إلكتروني:

رقم الواتس اب/الهاتف:

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

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع!
احصل الان

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

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

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع! احصل الان

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

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع!
احصل الان