Loading questions...
Updated
You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table.
Which query will generate the required result?
In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'.
Evaluate the following query:
View the Exhibit and evaluate the structure and data in the CUST_STATUS table.
You execute the following commands:
View the Exhibit and examine the data in the employees table:
View the Exhibit and examine the structure of the product, component, and PDT_COMP tables.
In product table, PDTNO is the primary key.
In component table, COMPNO is the primary key.
In PDT_COMP table, <PDTNO, COMPNO) is the primary key, PDTNO is the foreign key referencing PDTNO in product table and COMPNO is the foreign key referencing the COMPNO in component table.
You want to generate a report listing the product names and their corresponding component names, if the component names and product names exist.
Evaluate the following query:
SQL>SELECT pdtno, pdtname, compno, compname
FROM product _____________ pdt_comp
USING (pdtno) ____________ component USING (compno)
WHERE compname IS NOT NULL;
Which combination of joins used in the blanks in the above query gives the correct output?
Evaluate the following SQL commands:
View the Exhibit and examine the structure of the promotions table.
Examine the data in the ORD_ITEMS table:
Examine the structure of the sales table:
Examine the structure of the products table:
View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the promotions table, and the required output format.
View the Exhibit and examine the structures of the employees and departments tables.
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 each word in uppercase.
Which statement would accomplish this requirement?
Examine the create table statements for the stores and sales tables.
SQL> CREATE TABLE stores(store_id NUMBER(4) CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2(12), store_address
VARCHAR2(20), start_date DATE);
SQL> CREATE TABLE sales(sales_id NUMBER(4) CONSTRAINT sales_id_pk PRIMARY KEY, item_id NUMBER(4), quantity NUMBER(10), sales_date
DATE, store_id NUMBER(4), CONSTRAINT store_id_fk FOREIGN KEY(store_id) REFERENCES stores(store_id));
You executed the following statement:
SQL> DELETE from stores -
WHERE store_id=900;
The statement fails due to the integrity constraint error:
ORA-02292: integrity constraint (HR.STORE_ID_FK) violated
Which three options ensure that the statement will execute successfully?
Create a free account to unlock all questions for this exam.
Log In / Sign UpEvaluate the following SQL statement:
Which statement is true regarding the outcome of the above query?
Which three SQL statements would display the value 1890.55 as $1, 890.55?
What would be the outcome?
You issue the following SQL statement:
Which statement is true regarding the execution of the above query?
For which substitution variables are you prompted for the input?
You want to display all the employee names and their corresponding manager names.
Evaluate the following query:
Which join option can be used in the blank in the above query to get the required output?
The command to create a table fails. Identify the two reasons for the SQL statement failure?
Evaluate the following SQL statement:
Which statement is true regarding the outcome of the above query?
Evaluate the following query:
Which statement is true regarding the outcome of the above query?
Evaluate the following create table statement:
Which two statements are true about the creation of the SALES1 table?
You want to display the names of the products that have the highest total value for UNIT_PRICE * QTY_IN_HAND.
Which SQL statement gives the required output?
Which two queries give the correct result?
You want to update the employees table as follows:
-Update only those employees who work in Boston or Seattle (locations 2900 and 2700).
-Set department_id for these employees to the department_id corresponding to London (location_id 2100).
-Set the employees' salary in iocation_id 2100 to 1.1 times the average salary of their department.
-Set the employees' commission in iocation_id 2100 to 1.5 times the average commission of their department.
You issue the following command:
What is the outcome?