Oracle認(rèn)證考試章節(jié)練習(xí)(2020.02.16)

A.&p_where_clause 
B.:p_where_clause 
C.WHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone 
D.Where cust_ID=&p_custid cust_name=&p_cust_name or cust_phone=&p_cust_phone

A. Binary data up to 4 gigabytes.
B. Character data up to 4 gigabytes.
C. Raw binary data of variable length up to 2 gigabytes.
D. Binary data stored in an external file, up to 4 gigabytes.
E. A hexadecimal string representing the unique address of a row in its table.

A. SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
B. SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE HH:MI:SS AM') NEW _ DATE FROM dual;
C. SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY NEW _ DATE FROM dual;
D. SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth "of" Month YYYYfmtHH:HI:SS AM')NEW_DATE FROM dual;

A. It allows a grantee DBA privileges.
B. It is required syntax for object privileges.
C. It allows privileges on specified columns of tables.
D. It is used to grant an object privilege on a foreign key column.
E. It allows the grantee to grant object privileges to other users and roles.

A. Implement RMAN multiplexing
B. Set the DEBUG ON in the RMAN script
C. Specify the command ID in the RMAN script
D. Use a tag with the RMAN BACKUP command

A.int Long
B.Short Long
C.Compilation fails.
D.An exception is thrown at runtime.

A.menu
B.functions
C.data group
D.responsibility
E.functional group

A.人工處理
B.文件系統(tǒng)處理
C.字處理
D.數(shù)據(jù)庫(kù)系統(tǒng)處理

A.Temporary tables 
B.Index-organized tables 
C.Cluster tables 
D.Standard Oracle tables 

A. the Partitioned Cache
B. the Local Cache
C. the Map Listener running within a Partitioned Cache
D. the Map Listener running within an application