（单选题）
The accounts receivable department requested an accounts status to allow users to enter either a customer name, customer number, customer phone number and then display the customer out standing balance. You want to restrict the data retrieved based on values entered by the users. Which where clause would you write in the query to select statement to accomplish this task?（）
A&p_where_clause
B:p_where_clause
CWHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone
DWhere cust_ID=&p_custid cust_name=&p_cust_name or cust_phone=&p_cust_phone
正确答案
答案解析
略
相似试题
（多选题）
What privileges must be granted to allow an account to create the recovery catalog？（）
（多选题）
Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
（多选题）
Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
（单选题）
At the end of the financial year， an accounts accumulation batch is run. This batch updates the company’s accounting records. During the batch run process， some incorrect entries were inserted into the ACCOUNT table. You identified the bug and immediately stopped the batch run process， but 3000 incorrect records were inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the state it was at 11：50 P.M. Which flashback feature will you use？（）
（单选题）
On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）
（单选题）
On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup.Which flashback feature would you use？（）
（单选题）
You create a financial report to be represented to board of directors. The accounting manager has asked you to change the number format to show a thousand separator. What is the best method to make this change to the report quickly?（）
（单选题）
What is the purpose of the catalog command？（）
（多选题）
What is the purpose of the recover command？（）
