<< Prev Question Next Question >>

Question 22/133

Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (133q)
Question 1: The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data t...
Question 2: Which two statements are true regarding Oracle database spac...
Question 3: Which two statements are true about interval data types?...
Question 4: You want to apply the principle of Least Privilege in all yo...
Question 5: You execute this command: (Exhibit) During the export operat...
Question 6: Which statement is true about aggregate functions?...
Question 7: Which compression method is recommended for Direct-Path Inse...
Question 8: Which two are true about complete recovery? (Choose two.)...
Question 9: Which three statements are true about advanced connection op...
Question 10: Examine this command: (Exhibit) Which two statements are tru...
Question 11: In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Ex...
Question 12: Evaluate these commands which execute successfully: (Exhibit...
Question 13: Which three statements are true about single-row functions? ...
Question 14: Which three statements are true regarding single row subquer...
Question 15: Which three statements are true concerning logical and physi...
Question 16: Which two statements are true about Enterprise Manager Datab...
Question 17: Examine this SQL statement: SELECT cust_id, cust_last_name "...
Question 18: Which two statements are true about Enterprise Manager Datab...
1 commentQuestion 19: Examine the description of the EMPLOYEES table: (Exhibit) Wh...
Question 20: Which two statements are true about trace files produced by ...
Question 21: A database is configured to use automatic undo management wi...
Question 22: Examine the description of the CUSTOMERS table: (Exhibit) Fo...
Question 23: Which three object types support deferred segment creation? ...
Question 24: Which three statements are true about Oracle synonyms? (Choo...
Question 25: You have been tasked to create a table for a banking applica...
Question 26: Which two functions are performed by a listener?...
Question 27: Which two are true about a SQL statement using SET operators...
Question 28: Which three statements are true about table data storage in ...
1 commentQuestion 29: Which three statements are true about inner and outer joins?...
2 commentQuestion 30: Which three statements are true about single-row functions? ...
Question 31: Which two statements are true about the DUAL table? (Choose ...
Question 32: You want to write a query that prompts for two column names ...
Question 33: Which is the default column or columns for sorting output fr...
Question 34: Which three functions are performed by dispatchers in a shar...
Question 35: Which two statements are true about the DUAL table? (Choose ...
Question 36: Which four account management capabilities can be configured...
Question 37: In one of your databases, you create a user, HR, and then ex...
Question 38: Evaluate these commands which execute successfully: (Exhibit...
Question 39: Which two statements are true regarding a SAVEPOINT? (Choose...
Question 40: You have been tasked to create a table for a banking applica...
Question 41: View the Exhibit and examine the structure of the PRODUCTS t...
Question 42: The SCOTT/TIGER user exists in two databases, BOSTON_DB and ...
Question 43: View the Exhibits and examine the structure of the COSTS and...
Question 44: In one of your databases, user KING is: 1. Not a DBA user 2....
Question 45: Which two statements are true about trace files produced by ...
Question 46: What is true about non-equijoin statement performance? (Choo...
Question 47: Which two statements are true about the PMON background proc...
Question 48: The SALES_Q1 and USERS tablespaces exist in one of your data...
Question 49: Examine these commands: (Exhibit) Which two statements are t...
Question 50: A script abc.sql must be executed to perform a job. A databa...
Question 51: The EMPLOYEES table contains columns EMP_ID of data type NUM...
Question 52: Which three statements are true about sequences in a single ...
Question 53: Which statement is true about smallfile tablespaces?...
Question 54: The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data t...
Question 55: You execute this query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYS...
Question 56: Which three statements are true about Deferred Segment Creat...
Question 57: In one of your databases, the user HR has the password HRMGR...
Question 58: The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data t...
Question 59: Examine the description of the product_details table: (Exhib...
Question 60: Which two tasks can be performed in the NOMOUNT state? (Choo...
Question 61: Which two statements are true about the configuration and us...
Question 62: In one of your databases, you create a user, HR, and then ex...
Question 63: Examine this command and some partial output: (Exhibit) Why ...
Question 64: View the Exhibits and examine the structure of the COSTS and...
Question 65: The EMPLOYEES table contains columns EMP_ID of data type NUM...
Question 66: View the Exhibits and examine the structure of the COSTS and...
Question 67: Your database instance is started with a PFILE. Examine thes...
Question 68: Which two statements are true about the Automatic Diagnostic...
Question 69: You must create a tablespace of non-standard block size in a...
Question 70: Which two statements are true about the rules of precedence ...
Question 71: Which two statements are true about the results of using the...
Question 72: In the ORCL database, UNDOTBS1 is the active undo tablespace...
Question 73: Which two statements are true about User Authentication in a...
Question 74: Which three statements are true about the naming methods and...
Question 75: Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QU...
Question 76: You have been tasked to create a table for a banking applica...
Question 77: Which three statements are true about dropping and unused co...
Question 78: You want to write a query that prompts for two column names ...
Question 79: Which three statements are true about the Automatic Diagnost...
Question 80: Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_...
Question 81: You execute this command: (Exhibit) Sufficient storage is av...
Question 82: You want to use table compression suitable for OLTP that wil...
Question 83: Which three statements are true about advanced connection op...
Question 84: Examine the description of the PRODUCT_STATUS table: (Exhibi...
Question 85: Your database instance is started with a PFILE. Examine thes...
Question 86: Which two are true about Oracle recovery and data protection...
Question 87: Which two are true about the roles? (Choose two.)...
Question 88: In the spfile of a single instance database, LOCAL_LISTENER ...
Question 89: A user complains about poor database performance. You suspec...
Question 90: The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED...
Question 91: Which three statements are true about dropping and unused co...
Question 92: You execute this command: (Exhibit) During the export operat...
Question 93: You execute this command: (Exhibit) During the export operat...
Question 94: What two are benefits of Data Pump? (Choose two.)...
Question 95: Which four account management capabilities can be configured...
Question 96: Which two statements are true about the SET VERIFY ON comman...
Question 97: The INVOICE table has a QTY_SOLD column of data type NUMBER ...
Question 98: Which three statements are true concerning logical and physi...
Question 99: Which two statements are true about the Automatic Diagnostic...
Question 100: Examine the description of the BOOKS table: (Exhibit) The ta...
Question 101: Examine the description of the BOOKS table: (Exhibit) The ta...
Question 102: You execute this query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYS...
Question 103: Which three functions are performed by dispatchers in a shar...
Question 104: Examine this description of the TRANSACTIONS table: (Exhibit...
Question 105: Examine this command and some partial output: (Exhibit) Why ...
Question 106: Examine the description of the employees table: (Exhibit) Wh...
Question 107: Which two statements are true about date/time functions in a...
Question 108: View the Exhibit and examine the structure of the PRODUCTS t...
Question 109: Which three statements are true about external tables in Ora...
Question 110: The SCOTT/TIGER user exists in two databases, BOSTON_DB and ...
Question 111: Which two statements are true about trace files produced by ...
Question 112: Which three instance situations are possible with the Oracle...
Question 113: You need to calculate the number of days from 1st January 20...
Question 114: In the ORCL database, UNDOTBS1 is the active undo tablespace...
Question 115: The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED...
Question 116: Which is true about roles?
Question 117: Which statement is true about the INTERSECT operator used in...
Question 118: Which three statements are true about Oracle synonyms? (Choo...
Question 119: Which three statements are true about Oracle synonyms? (Choo...
Question 120: Examine the description of the CUSTOMERS table: (Exhibit) Yo...
Question 121: Which two statements are true about the ORDER BY clause when...
Question 122: In one of your databases, you create a user, HR, and then ex...
Question 123: Which two types of files are opened by a database instance i...
Question 124: Evaluate these commands which execute successfully: (Exhibit...
Question 125: Which two statements are true about segment types in an Orac...
Question 126: Which three Oracle database space management features will w...
Question 127: Which three statements are true about GLOBAL TEMPORARY TABLE...
Question 128: You execute this command: (Exhibit) During the export operat...
Question 129: Which two statements are true about the rules of precedence ...
Question 130: Examine this command: (Exhibit) Which two statements are tru...
Question 131: Which two statements are true about Oracle synonyms?...
Question 132: Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_...
Question 133: Examine the description of the members table: (Exhibit) Exam...