ITPub博客

（76）You need to display the first names of all customers from the CUSTOMERS table that contain the character 'e' and have the character 'a' in the second last position.Which query would give the required output?A.SELECT cust_first_name FROM customers...

（79）View the Exhibit and examine the structure of the CUSTOMERS table.In the CUSTOMERS table, the CUST_LAST_NAME column contains the values 'Anderson' and 'Ausson'. You issue the following query:SELECT LOWER(REPLACE(TRIM('son' FROM cust_last_name),'An','O'))...

（73）Which tasks can be performed using SQL functions that are built into Oracle database ? (Choose three .)A. finding the remainder of a divisionB. adding a number to a date for a resultant date valueC. comparing two expressions to check whether they are equalD. checking whether a s...

（80）Which two statements are true regarding working with dates? (Choose two.)A. The default internal storage of dates is in the numeric format.B. The default internal storage of dates is in the character format.C. The RR date format automatically calculates the century from the SYSDATE ...

（71）Which arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database ? (Choose three .)A. additionB. subtractionC. raising to a powerD. finding the quotientE. finding the lowest value答案：（A、C、E）解析：...

（77）In the CUSTOMERS table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'ABIGAIL'.Evaluate the following query:SELECT INITCAP(cust_first_name || ‘ ‘ ||            &nbs...

（78）Evaluate the following query:SELECT TRUNC(ROUND(156.00,-1),-1) FROM DUAL;What would be the outcome?A. 16B. 100C. 160D. 200E. 150答案:（C）

（72）Which tasks can be performed using SQL functions built into Oracle Database ? (Choose three.)A. displaying a date in a nondefault formatB. finding the number of characters in an expressionC. substituting a character string in a text expression with a specified stringD. combining...

1. 先到网上下载#使用rlwrap-0.37.tar.gz以/tmp目录# 解压rootRH54.cuug.nettmp$ tar-[@:/] rlwrap-0.37rootRH54.cuug.nettmprlwrap-0.37$ configurerootRH54.cuug.nettmprlwrap-0.37$ make[@://] installoracleRH54.cuug.nethomeoracle$...

（67）Which two statements are true regarding the ORDER BY clause? (Choose two.)A. It is executed first in the query execution.B. It must be the last clause in the SELECT statement.C. It cannot be used in a SELECT statement containin g a HAVING clause.D. You cannot specify a column na...

（68）Which statement is true regarding the default behavior of the ORDER BY clause?A. In a character sort, the values are case-sensitive.B. NULL values are not considered at all by the sort operation.C. Only those columns that are specified in the SELECT list can be used in the ORDER BY ...

（70）View the Exhibit and examine the structure of the PRODUCTS table. （与63题重复）You want to display only those product names with their list prices where the list price is at least double the minimum price. The report should start with the product name having the maximum list price satisfyi...

（62）View the Exhibit and examine the structure of the CUSTOMERS table.You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B,or C, and credit limit is below 10, 000.Evaluate the following two queries:SEL...

（65）View the Exhibit and examine the structure of the CUSTOMERS table.You have been asked to produce a report on the CUSTOMERS table showing the customers details sorted in descending order of the city and in the descending order of their income level in each city. Which query would accomplish ...

（66）View the Exhibit and examine the data in the COSTS table.You need to generate a report that displays the IDs of all products in the COSTS table whose unit price is at least 25% more than the unit cost.The details should be displayed in the descending order of 25% of the unit cost.Yo...

（64）View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table.Evaluate the following two queries:SELECT DISTINCT promo_category, to_char(promo_cost) "code"FROM promotions ORDER BY code;SELECT ...

（69）You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table.Those customers who do not have a credit limit should appear last in the list.Which two queries would achieve the required result? (Choose two.)A....

（51）Which statement is true regarding synonyms?A. Synonyms can be created only for a table.B. Synonyms are used to reference only those tables that are owned by another user.C. A public synonym and a private synonym can exist with the same name for the same table.D. The DROP SYNONYM...

（60）View the Exhibit and examine the structure of CUSTOMERS table. Evaluate the following query:SELECT cust_id, cust_city FROM customersWHERE cust_first_name NOT LIKE 'A_%g_%'AND cust_credit_limit BETWEEN 5000 AND 15000AND cust_c...

（58）The PART_CODE column in the SPARES table contains the following list of values:PART_CODEA%_WQ123A%BWQ123AB_WQ123Evaluate the following query:SELECT part_codeFROM spares...