SQL statement can be only on one line.

130.What is a database?A database is a shared collection of logically related data, and a description of this data, designed to meet the information needs of an organization

132.What is a Database Management System?

A DBMS is a set of software tools that control access, organize, store, manage, retrieve and maintain data in a database

133.Which of the following statements about normalization is NOT true?

Normalization is a process that cannot be undone

134.Which of the following statements about normalization is NOT true?

Normalization is performed within conceptual database design

135.Which of the following statements about normalization is NOT true?

Normalization is performed as a series of steps from 3NF to 1NF

136.Which of the following statements is not true?

An attribute that cannon be further subdivided into smaller components is called single-valued attribute

137.Which of the following statements is not true?

Degree of a relation is a number of keys in the relation

1.Which of the following statements is not true?

The Second Normal Form implies the absence of transitive dependencies in the relation

2.Which of the following statements is NOT true?

SQL statement can be only on one line

8.Which of the following statements about aliases is NOT true?

Aliases always require double quotation marks

9.Which of the following statements is NOT true?

Character string and date values are need to be enclosed in double quotation marks0

10.Which of the following statements is NOT true?

CONCAT function can accept any number of parameters

11.Which of the following statements is NOT true?

Only two tables can be joined using the JOIN operations

12.Which of the following statements is NOT true?

ROLLBACK command discard all the previous data changes even if they were confirmed by the COMMIT command

13.Which of the following statements about an INSERT command is NOT true?

The order of the columns listed in the INSERT table must be the same as in the table

14.Which of the following statements about ALTER command is NOT true?

ALTER TABLE command is used for deleting a row from a table

15.Which of the following statements about constraints is NOT true?

Only one constraint can be applied to one column

16.Consider the EMPLOYEES table. Which of the following statements calculate the average value for the commission_pct column ( taking into consideration only those employees who have a commission )SеLECT COUNT (commission_pct) From EMPLOYEESWHERE commission_pct IS NOT NULL

17.Which of the following functions extracts a string determinate length?SUBSTR

1.Remove rows and a tables structure DROP TABLE

2.______ clause can be used and is required in the sub query to perform Top-N analysisORDER BY

3.Write the question for the following query

List the courses number and description of courses with either the courses number 20 as a prerequisite or location of L111

4.What will be result of the following SQL statement Low

5.Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who work in department prompted by userWHERE department_id=’&DEPARTMENT’

6.Use the ______ operator to return all rows from multiple table and eliminate any duplicate rows UNION

8.Remove rows and table structure:Drop Table

9.Write the question for the following query:SELECT course_no, descriptionFROM courseWHERE course_no IN(SELECT course_noFROM sectionWGERE location = ‘L111’)OR prerequisite = 20List the course number and description of course with either the course number 20 as a prerequisite or a location of L111

10.Delete the student 900 from the STUDENT table. Make the change permanent.

-

11.Constraints always have a name:Verno

The _______ operator returns all rows that are selected by either query.UNION

12.If there are schemas named USERA and USERB, and both have an EMPLOYEES table, then if USERA wants to access the EMPLOYEES table that belongs to USERB, USERA must write select statement as follows: SELECT * FROM usera.emplyees;

13.Which of the following queries determines which enrolled students have no grades at all:

14.Consider the EMPLOYEES table. Which of the following statements displays the hire date in the format ‘Nineteenth of January, 1998’?

-

15.Consider the EMPLOYEES table. Which of the following statements calculate the maximum salary for each job, displaying only those rows where maximum salary is less than 12000?

16.Which of the following functions finds the numeric position of a named character?INSTR

17.Consider the following SQL statement. What will be the result

18.Oracle’s multi-versioning feature achieves read-consistent query results.Verno

19.A table cannot be dropped if it has data in it.Neverno

20.Consider the EMPLOYEES table. Which of the following statement count the number of employees with the same job?

21.Consider the SQL statement. Which of the following clauses does not sort the result rows by the salary value in the ascending order?

22.Produce a list of jobs for departments 10, 50, 20, in that order. Display job ID an department ID.

23.Consider the EMPLOYEES table. Which of the following SQL statements is correct to display the last name of the employee with its hire date providing the Employee and Hire aliases (case is important)?

25.Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those whose salary is greater than 5000 but less than 18000?

26..what will be result of the following SQL statement -Select last_name, department_nameFrom employees, departments The Cartesian product of the two tables will be displayed

27.What will be the result of the following SQL statementSelect count(d.department_name), l.city From departments d Natural JOIN locations l

Group By l.city

The number of departments in each city is shown

28.Queries that return only one row from the inner SELECT statement are called single-row subqueries

***Which of the following elements cannot be included in a WHERE clause? A column alias (*)***Which operator is used to combine columns of character strings toother columns?||***Which comparison condition would you use to select rows that matcha character pattern? LIKE

***Evaluate this SELECT statement:
SELECT last_name, first_name, salary
FROM employees;
How will the results of this query be sorted? (The database will display the rows in whatever order it finds it indatabase, so no particular order. (*))***Evaluate this SELECT statement:
SELECT first_name, last_name, email
FROM employees
ORDER BY last_name;
Which statement is true? (The rows will be sorted alphabetically by the LAST_NAME values.)

86. Which is right order of the following clauses?

121.Consider the following SQL statement. How can you describe the condition in the WHERE clause?

ANY - Compare value to each value returned by the subquery ANY is equivalent to IN.