DBMS_CSN_WEEK5_QUIZ

Which best describes the TO_CHAR function?

• The TO_CHAR function can be used to specify meaningful column names in an SQL statement's result set.

• The TO_CHAR function can only be used on Date columns.

• The TO_CHAR function can be used to display dates and numbers according to formatting conventions that are supported by Oracle.

• The TO_CHAR function can be used to remove text from column data that will be returned by the database.

• OPTION A AND B

Which group function would you use to display the highest salary value in the EMPLOYEES table?

• COUNT

• MIN

• AVG

• MAX

Evaluate this SELECT statement:

SELECT MIN(hire_date), department_id

FROM employees

GROUP BY department_id;

Which values are displayed?

• The hire dates in the EMPLOYEES table that contain NULL values

• The latest hire date in the EMPLOYEES table

• The earliest hire date in the EMPLOYEES table

• The earliest hire date in each department

• None of the above

Which of the following entities most likely contains valid attributes? (Choose two)

• Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed

• Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built

• Entity: Pet. Attributes: Name, Birthdate, Owner

• Entity: Mother. Attributes: Name, Birthdate, Occupation, Start Date

• NONE OF THE ABOVE

Which SELECT statement will display both unique and non-unique combinations of the MANAGER_ID and DEPARTMENT_ID values from the EMPLOYEES table.

• SELECT DISTINCT manager_id, department_id FROM employees;

• SELECT manager_id, department_id DISTINCT FROM employees;

• SELECT manager_id, DISTINCT department_id FROM employees;

• SELECT manager_id, department_id FROM employees;

• OPTION B AND C

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

• Candidate key

• SURROGATE key

• Super key

• Foreign key

• NONE OF THE ABOVE

List out the department wise maximum

salary, minimum salary, average salary of the employees

• Select job_id, count(*), max(salary), min(salary), avg(salary) from employee group by job_id

• Select DEPT_ID, count(*), max(salary), min(salary), avg(salary) from employee group by DEPT_ID

• Select DEPT_ID, count(*), from employee group by DEPT_ID

• Select job_id, count(*), SUM(salary), min(salary), avg(salary) from employee group by job_id

• OPTION A AND C

(items_ordered)--->RELATION

(customerid, order_date, item,quantity,Price)--ATTRIBUTES

(ustomers)---->RELATION

(Cstomerid,firstname,lastname,city,state)--ATTRIBUTES. How many people are in each unique state in the customers table? Select the state and display the number of people in each.

CHOOSE THE CORRECT ANSWER

• SELECT DISTINCT item FROM items_ordered;

• SELECT state, count(state) FROM customers GROUP BY state;

• SELECT state, count(CITY)customers GROUP BY state;

• SELECT state, count(ID) FROM customers group by state;

Select the item and price for all of the items in the items_ordered table that the price is greater than 10.00. Display the results in ascending order based on the price.

choose the correct answer

• SELECT item, price FROM items_ordered WHERE price > 10.00 ORDER BY price;

• SELECT item, price FROM items_ordered WHERE price =10.00 ORDER BY price ASC;

• SELECT item, price FROM items_ordered WHERE price > 10.00 ORDER BY price ASC;

• SELECT price FROM items_ordered WHERE price > 10.00 ORDER BY price ASC;

It is the one in which at least one sub class participates as a sub class in more than one class/sub class relationship is known as

• Specialization Overlapping

• Specialization Hierarchy

• Specialization Lattice

• Disjoint total