Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.Only the EMPLOYEE_ID column is indexed.Rows exist for employees 100 and 200.Examine this statement:Which two statements are true? (Choose two.) A. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200 B. Employee 200 will have SALARY set to the same value as the… Read More »
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;… Read More »
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. invoice_date=”15-march-2019″ : uses implicit conversion B. qty_sold = ‘0554982’ uses implicit conversion C. CONCAT (qty_sold, invoice_date) : requires explicit… Read More »
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′, `&&col2′FROM &tableWHERE `&&condition’… Read More »
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. qty_sold BETWEEN ‘101’ AND ‘110’ : uses implicit conversion B. qty_sold = ‘0554982’ uses implicit conversion C. invoie_date >… Read More »
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.Which two queries execute successfully? (Choose two.) A. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available’)) FROM customers; B. SELECT NVL(cust_credit_limit * .15, `Not Available’) FROM customers; C. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available’) FROM customers; D. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available’) FROM customers; E. SELECT NVL2(cust_credit_limit *… Read More »
When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean? A. The SQL statement completed its execution. B. The SQL statement is executing. C. The SQL statement is queued. D. The SQL statement did not complete either due to an error. Correct Answer: C https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htm
True Or False? Once You Remove A Section, Row, Column, Or Module From Your Page You Cannot Undo It. True False
Anne Is Looking At The “Performance” Column In The Asset Report Of Her Google App Campaign. She Wants To See How Specific Assets Have Been Performing. She Notices The Terms “Low”, “Good”, And “Best” In The Column. Asset Ratings Are Distributed Based On Which Criteria? The number of impressions they receive in each ad group. The all conversion… Read More »
True Or False? The Matches Column In The Backlink Gap Report Table Shows How Many Of The Analyzed Domains Have Gotten Their Links From A Certain Referring Domain. True False