35. A DISTINCT must always be used in the top-most SELECT statement of a set operation. False
36.It is possible to combine data from two tables that do not have a primary key/foreign key relationship into one result using a set operationTRUE
37.You cannot order the results of a set operation.FALSE
38.The UNION and UNION ALL set operators have the opposite effect of each other.FALSE
39.To obtain a list of last names that students and instructors share, you use the MINUS set operator.FALSE
40.A table can be created with or without data.TRUE
41.A table cannot be dropped if it has data in it. FALSE
42.Constraints always have a name TRUE
43.Constraints must be explicitly enabled before they can be used by the database. FALSE
44.You can add to and drop columns from a table using the ALTER TABLE command TRUE
45.You can rename a table with the RENAME or the ALTER TABLE command. TRUE
46.A parent table referenced by a child table may not be dropped. TRUE
47.The data of a temporary table is visible to all sessions. FALSE
48.The NUMBER data type is usually the best choice for a primary key. TRUE
49.By default, the foreign key restricts deletes of any parent row that has a corresponding child row(s). TRUE
50.You cannot selectively delete rows from a table.False
51.When inserting data into a table from another table, the table names and columns must be the same.False
52.Transaction control determines when data manipulation becomes permanent in a database.TRUE
53.You can update only a single column at a time in a table.False
54.The TRUNCATE command removes all data permanently from a table. TRUE
55.The TRUNCATE command and the TRUNC function can be used interchangeably TRUE
56.The conditional INSERT FIRST command evaluates the WHEN condition in order. For all conditions that are true a row is inserted into the appropriate table. FALSE
57.A session is an individual connection to the Oracle database server. true
58.DML statements such as INSERT, UPDATE, DELETE, and MERGE obtain a lock on the row(s), so other users cannot manipulate it. TRUE
60.Which SQL keyword specifies that an alias will be substituted for a column name in the output of a SQL query? AS
61.Which clause would you include in a SELECT statement to sort the rows returned by the LAST_NAME column? ORDER BY
62.Which statement about the ORDER BY clause is true? You can use a column alias in the ORDER BY clause.
63.You need to change the default sort order of the ORDER BY clause so that the data is displayed in reverse alphabetical order. Which keyword should you include in the ORDER BY clause?DESC (1)
41.which symbol do you use if you need to choose all the columns from the table to the result query ?( *)
42.The___ operator compares a value to every value to returned by a subquery (ALL)
43.Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those last name and first name starts with the letter ‘K’
Where last_name LIKE ‘K%’ and first_name LIKE ‘K%’
44.Write SQL statement for display the department numbers with more than three employees in each dept. select deptno, count(deptno) from emp group by deptno having count(*)>3;
45.Considerthe EMPLOYEES table. Which of the following SQL statements return the number of jobs that exist in the organization ?Select count(distinct job_id) From employees
46 You can add to drop columns from a table using the ALTER TABLE command (VERNO)
47.Which of the following functions is not multiple-row function? TRUNC
48.The TRUNCATE command removes all data permanently from table verno
49.The HR department needs a list of department ids for departments that do not contain the job ID ST_CLERC SELECT department_id FROM departments MINUS SELECT department_id FROM employeesWHEREjob_id = 'ST_CLERK';
50.Which of the following statements about aliases is not true?Aliases always require double quotation marks
51.Which of the following statements will not generate an error?Select e.last_name, d.department_nameFrom employees e, departments d WHERE e.departments_id=departments_id;
52.The following SQL statement can be expressed differently. Choose the correct equivalent statement
Select course_no, prerequisite from course
Where course_no IN (select course_no from section where NVL(section)>30)
