ITPub博客

（25）You need to create a table with the following column specifications:1. Employee ID (numeric data type) for each employee2. Employee Name (character data type) that stores the employee name3. Hire date, which stores the date of joining the organization for each employee4. Status ...

（30）Evaluate the following CREATE TABLE commands:The above command fails when executed. What could be the reason?A. SYSDATE cannot be used with the CHECK constraint.B. The BETWEEN clause cannot be used for the CHECK constraint.C. The CHECK constraint cannot be placed on columns havin...

（23）Examine the structure proposed for the TRANSACTIONS table:Which statements are true regarding the creation and storage of data in the above table structure? (Choose all that apply.)A. The CUST_STATUS column would give an error.B. The TRANS_VALIDITY column would give an error.C. T...

（22）You need to create a table for a banking application. One of the columns in the table has the following requirements:1) You want a column in the table to store the duration of the credit period.2) The data in the column should be stored in a format such that it can be easily added and s...

（26）Which is the valid CREATE TABLE statement?A. CREATE TABLE emp9$#(emp_no NUMBER (4));B. CREATE TABLE 9emp$#(emp_no NUMBER(4));C. CREATE TABLE emp*123(emp_no NUMBER(4));D. CREATE TABLE emp9$#(emp_no NUMBER(4), date DATE);...

（11）View the Exhibit and examine the structure of the PRODUCTS table. All products have a list price. You issue the following command to display the total price of each product after a discount of 25% and a tax of 15% are applied on it. Freight charges of $100 have to be applied to all the product...

（17）View the Exhibit and examine the data in the EMPLOYEES table.You want to generate a report showing the total compensation paid to each employee to date. You issue the following query:SELECT ename || ' joined on ' || hiredate || ', the total compensation paid is ' ||...

（18）Examine the structure of the PROMOTIONS table:The management wants to see a report of unique promotion costs in each promotion category. Which query would achieve the required result?A. SELECT DISTINCT promo_cost, promo_category FROM promotions;B. SELECT ...

（20）Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.)A. Only one LONG column can be used per table.B. A TIMESTAMP data type column stores only time values with fractional seconds.C. The BLOB data type column is used to store binary data...

（16）Evaluate the following query:SELECT promo_name || q'{'s start date was }' || promo_begin_date AS "Promotion Launches" FROM promotions;What would be the outcome of the above query?A. It produces an error because flower braces have been used.B. It p...

（14）Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount in each income level.The report should NOT show any repeated credit amounts in each income level. Which query would give the required result?A.SELECT cust_income_level, DISTIN...

（19）Evaluate the following query:SELECT INTERVAL '300' MONTH, INTERVAL '54-2' YEAR TO MONTH,INTERVAL '11:12:10.1234567' HOUR TO SECONDFROM dual;What is the correct output of the above query?A. +25-00 , +54-02, +00 11:12:10....

（12）You need to produce a report where each customer's credit limit has been incremented by $1000.In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit.The column headings should have only the first letter of...

（13）View the Exhibit and examine the structure of the PRODUCTS table. You need to generate a report in the following format:CATEGORIES5MP Digital Photo Camera's category is Photo Y Box's category is ElectronicsEnvoy Ambassador's category is HardwareWhich two queries would give the r...

（15）View the Exhibit and examine the data in the CUSTOMERS table.Evaluate the following query:SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDPOINT, MIDPOINT + 100 AS "MAX LOWER LIMIT" FROM customers;The above query produces an error on execution. W...

（10）View the Exhibit; examine the structure of the PROMOTIONS table.Each promotion has a duration of at least seven days .Your manager has asked you to generate a report, which provides the weekly cost for each promotion done to l date.Which query would achieve the required result?...

（8）View the Exhibit and examine the structure of the CUSTOMERS table.Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)A. listing of customers who do not have a credit limit and were born before 1980B. finding the number of customers, in...

（3）You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'.Which WHERE clause could be used in the SELECT statement to get the required output?A. WHERE prod_id LIKE '%_D123%' ESCAPE '_'B.WHERE prod_i...

（1）View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables.The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the...

（4）Which two statements are true regarding single row functions? (Choose two.)A. They accept only a single argument.B. They can be nested only to two levels.C. Arguments can only be column values or constants.D. They always return a single result row for every row of a queried table...