DATABASE IITU QUIZ

1. A table can be created with or without data

True

False

2. With SQL, how do you select all the columns from a table named "Persons"?

SELECT [all] FROM Persons

SELECT Persons

SELECT * FROM Persons

SELECT *.Persons

3. You can add and drop columns from a table using the ALTER TABLE command.

True

False

4. A table can be created with or without data.

True

False

5. Which keyword is used to provide an alias to a column?

COLUMN

AS

ALIAS

IS

6. What does SQL stand for?

Structured Query Language

Strong Question Language

Structured Question Language

Slow Query Language

7. You can add and drop columns from a table using the ALTER TABLE command.

True

False

8. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

SELECT * FROM Persons WHERE FirstName'Peter'

SELECT [all] FROM Persons WHERE FirstName='Peter'

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

SELECT * FROM Persons WHERE FirstName='Peter'

9. Which of the following is a concatenation operator?

&

+

||

*

10. Which SQL keyword is used to sort the result-set?

ORDER

SORT BY

SORT OR

ORDER BY

11. Which keyword is used to provide an alias to a column?

COLUMN

AS

ALIAS

IS

12. Queries containing set operators are called ______ .

Compound queries

Subqueries

Inner queries

Outer queries

13. With SQL, how can you return the number of records in the "Persons" table?

SELECT LEN(*) FROM Persons

SELECT NO(*) FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT(*) FROM Persons

14. Transaction control determines when data manipulation becomes permanent in a database.

True

False

15. What will be the result of the following SQL statement? (SYSDATE is a date of your exam)SELECT TO_CHAR(SYSDATE, 'Day') FROM Dual;

31.05.2013

Friday

31

31-05.2013

16. With SQL, how do you select a column named "FirstName" from a table named "Persons"?

SELECT Persons.FirstName

SELECT FirstName FROM Persons

EXTRACT FirstName FROM Persons

EXTRACT FROM Persons

17. Which of the following is a concatenation operator?

&

||

*

18. Transaction control determines when data manipulation becomes permanent in a database.

True

False

19. What is the most common type of join?

JOINED

JOINED TABLE

INSIDE JOIN

INNER JOIN

20. By default, the foreign key restricts deletes of any parent row has a corresponding child row(s).

True

False

21. Privileges, roles, and synonyms are all used to implement security in an Oracle Database.

True

False

22. Which symbol do you use if you need to choose all the columns from the table to the result query?

*

+

All

%

23. Which SQL statement is used to update data in a database?

MODIFY

SAVE

UPDATE

SAVE AS

24. Which SQL statement is used to insert new data in a database?

INSERT INTO

INSERT NEW

ADD RECORD

ADD NEW

25. Queries containing set operators are called __________ .

Outer queries

Subqueries

Inner queries

Compound querires

26. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

True

False

27. Queries containing set operators are called __________ .

Outer queries

Subqueries

Inner queries

Compound queriresCompound queriresCompound querires

28. You can add to and drop columns from a table using the ALTER TABLE command.

True

False

29. The NUMBER data types is usually the best choice for a primary key.

True

False

30. Which of the following is the correct order of keywords for SQL SELECT statements?

SELECT, FROM, WHERE

FROM, WHERE, SELECT

WHERE, FROM,SELECT

SELECT,WHERE,FROM

31. A table can be created with or without data

True

False

32. Privileges, roles, and synonyms are all used to implement security in an Oracle database.

True

False

33. Which operator is used to select values within a range?

RANGE

WITHIN

BETWEEN

AND

34. Queries containing set operators are called __________ .

Outer queries

Subqueries

Inner queries

Compound querires

35. Which keyword is used to eliminate duplicate rows in the result?

DISTINCT

DESCRIBE

HAVING

GROUP BY

36. The result of a SQL SELECT statement is a(n) ________ .

Report

Form

File

Table

37. Which SQL statement is used to extract data from a database?

GET

OPEN

SELECT

EXTRACT

38. With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT * FROM Persons WHERE FirstName'Peter' AND LastName'Jackson'

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

SELECT * FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'

39. The TRUNCATE command removes all data permanently from a table.

True

False

40. By default, the foreign key restricts deletes of any parent row has a corresponding child row(s).

True

False

41. Which command is used to view the structure of the table LOCATIONS?

DESCRIBE LOCATIONS

SHOW STRUCTURE LOCATIONS

SELECT * FROM LOCATIONS

PRINT LOCATIONS

42. What will be the result of the following query?SELECT ROUND (63.548, -1) FROM DUAL;

64

60

63

70

43. Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who do not work in the departments 90 and 60?

WHERE department_id = 90 AND department_id = 60

WHERE department_id IN (90,60)

WHERE department_id NOT IN (90,60)

WHERE department_id =90 PR department_id = 60

44. Queries containing set operators are called ______ .

Compound queries

Subqueries

Inner queries

Outer queries

45. The TRUNCATE command removes all data permanently from a table.

True

False

46. What will be the result of the following query?SELECT ROUND (63.548, -1) FROM DUAL;

64

60

63

70

47. Which of the following are the five built-in functions provided by SQL?

COUNT, SUM, AVG, MAX, MIN

SUM, AVG, MIN, MAX, MULT

SUM, AVG, MULT, DIV, MIN

SUM, AVG, MIN, MAX, NAME

48. 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?

WHERE salary > 5000 OR salary < 18000

WHERE salary < 5000 AND salary > 18000

WHERE salary > 5000 AND salary < 18000

WHERE salary >5000 AND salary > 18000

49. Which command is used to view the structure of the table LOCATIONS?

DESCRIBE LOCATIONS

SHOW STRUCTURE LOCATIONS

SELECT * FROM LOCATIONS

PRINT LOCATIONS

50. The data dictionary view USER_TAB_PRIVS_MADE lists details of table privilege grants performed by the current user.

True

False

51. Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who do not work in the departments 90 and 60?

WHERE department_id = 90 AND department_id = 60

WHERE department_id IN (90,60)

WHERE department_id NOT IN (90,60)

WHERE department_id =90 PR department_id = 60

52. With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT OR 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

53. What will be the result of the following SQL statement? (SYSDATE is a date of your exam)SELECT TO_CHAR(SYSDATE, 'Day') FROM Dual;

31.05.2013

Friday

31

31-05.2013

54. By default, the foreign key restricts deletes of any parent row that has a corresponding child row(s).

True

False

55. Which command is used to view the structure of the table LOCATIONS?

DESCRIBE LOCATIONS

SHOW STRUCTURE LOCATIONS

SELECT * FROM LOCATIONS

PRINT LOCATIONS

56. The ______ constraint defines a condition that each row must satisfy.

PRIMARY KEY

CHECK

UNIQUE

FOREIGN KEY

57. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

ONLY

UNIQUE

DISTINCT

SINGLE

58. With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

SELECT LastName>'Hansen' AND LastName

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

SELECT LastName='Hansen' AND LastName='Pettersen' FROM Persons

59. Which SQL statement is used to return only different values?

SELECT DISTINCT

SELECT UNIQUE

SELECT DIFFERENT

EXTRACT DESC

60. With SQL, how can you insert a new record into the "Persons" table?

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

INSERT VALUES ('Jimmy') IN Persons

61. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

INSERT INTO Persons ('Olsen') INTO LastName

INSERT ('Olsen') INTO Persons (LastName)

INSERT INTO Persons (LastName) VALUES ('Olsen')

INSERT ('Olsen') INTO Persons

62. Which operator is used to search for a specified pattern in a column?\

LIKE

FROM

GET

SET

63. A SELECT statement that is embedded in a clause of another SELECT statement is called

Main query

Subquery

Inner query

Outer query

64. DML statement such as INSERT, UPDATE, DELETE, and MERGE obtain a lock on the row(s), so other users cannot manipulate it.

True

False

65. Use the _____ operator to return all rows from multiple tables and eliminate any duplicate rows.

UNION

MINUS

UNION ALL

INTERSECT

66. Consider the following SQL statement. What will be the result? SELECT e.last_name, e.salary, d.department_name FROM employees e, departments d WHERE e.department_id = d.department_id

An error will occur since none of the JOIN operations is used

The Cartesian product of the two tables based on the department_id column will be displayed

An error will occur since in the SELECT clause a column thet is used to join the tables is missing

67. The NOT NULL constraint enforces a column to not accept null values

True

False

68. Use the _______ operator to return all rows from multiple tables and eliminate any duplicate rows.

UNION ALL

MINUS

INTERSECT

UNION

69. Both object and system privileges can be granted through a single role to a user.

True

False

70. Which of the following is the original purpose of SQL?

To specify the syntax and semantics of SQL data definition language

To specify the syntax and semantics of SQL manipulation language

To define the data structures

All of the above.

71. Transaction control determines when data manipulates becomes permanent in a database.

True

False

72. The ______ constraint defines a condition that each row must satisfy.

PRIMARY KEY

CHECK

UNIQUE

FOREIGN KEY

73. You can rename a table with the RENAME or the ALTER TABLE command.

True

False

74. When using LIKE condition which symbol is used to denote one character?

-

+

%

*

75. You can update only a single column at time in a table.

True

False

76. You can place the subquery in a number of SQL clauses, including the following:I. WHERE clauseII. HAVING clauseIII. FROM clause

I and II

I,II and III

I only

I and III

77. Queries that return only one row from the inner SELECT statement are called

Multiple-column subqueries

Single-row subqueries

Single-column subqueries

Multiple-row subqueries

78. Which symbol is used to create a substitution variable

&

-

%

*

79. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName='%a%'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

80. What will be the result of the following SQL statement?SELECT INITCAP(SUBSTR(CONCAT('Hello',world),4,3)) FROM DUAL;

LLO

Llo

Low

LOW

81. You can update only a single column at a time in a table.

True

False

82. Constraints always have a name.

True

False

83. Write SQL statement for display the names of the employees who are working in the company for the past 5 years:

Select ename from emp where hiredate < add_month(sysdate,-60);

Select ename from emp where hiredate < add_month(sysdate,+5);

Select ename from emp where hiredate < add_month(sysdate,+60);

Select ename from emp where hiredate < add_month(sysdate,-5);

84. Use the _____ operator to return all rows from multiple tables and eliminate any duplicate rows.

UNION

MINUS

UNION ALL

INTERSECT

85. When executed, this statement cannot be rolled back

ALTER TABLE

DROP TABLE

REMOVE TABLE

DELETE TABLE

86. What will be the result of the following SQL statement? (SYSDATE is a date of your exam)SELECT TO_CHAR(SYSDATE, 'DD.MM.YY') FROM Dual;

31.May.2013

An error will occur

31.05.2013

31.05.13

87. Which of the following statements is NOT true?

SQL statements are no case sensitive

Keywords cannot be abbreviated

SQL statement can be only one line

Keywords cannot be split across lines

88. When using LIKE conditions which symbol is used to denote zero or many characters?

+

*

%

_

89. When using LIKE condition which symbol is used to denote one character?

-

+

%

*

90. Consider the EMPLOYEES table. Which of the following conditions in the WHERE clause will generate an error?

SELECT * FROM employees WHERE last_name =’&Name’

SELECT job_id, SUM(salary) FROM employees GROUP BY ‘&Column’

SELECT * FROM &Table

SELECT &Column FROM employees

91. A parent table referenced by a child table may not be dropped.

True

False

92. It is possible to combine from two tables that do not have a primary key/foreign key relationship into one result using a set operation.

True

False

93. What will be the result of the following SQL statement?SELECT SUBSTR ('Hello,World!!!',13) FROM DUAL

An error will occur, since SUBSTR function need to take 3 parameters

Hello,World!!!13

!!!

Hello, World!

94. You can add a row using SQL in database with which of the following?

ADD

CREATE

INSERT

MAKE

95. A subquery must be enclosed in _________ .

Double quotes

Single quotes

Parantheses

Braces

96. The command to eliminate a table from a database is:

REMOVE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

97. Any user can grant or revoke ant type of system privileges to or from another user.

True

False

98. Consider the EMPLOYEES table. Which of the following SQL statements is correct to provide the sentence in the format "King has been working since 01.01.1987" with "Employee Information" alias?

SELECT last_name ||’has been working since’ || hire_date “Employee Information” FROM employees;

SELECT last_name || ‘has been working since’ || hire_date Employee Information FROM employees

SELECT last_name || ‘has been working since’ || hire_date ‘Employee Information’ FROM employees;

SELECT last_name || ”has been working since” || hire_date “Employee Information” FROM employees;

99. Consider the EMPLOYEES table. When condition in the WHERE clause limit the employees to IT Programmers with salary greater than 5000?

WHERE salary>5000 AND job_id = ‘IT_PROG’

WHERE salary>5000 AND job_id = “IT_PROG”

WHERE salary>5000 AND job_id = IT_PROG

WHERE salary>5000 OR job_id = ‘IT_PROG’

100. Delete the zip codes 02199 and 43011 from the ZIPCODE table. Make the change permanent.

DELETE FROM zipcode WHERE zip ANY (‘02199’,’43011’) COMMIT

DELETE FROM zipcode WHERE zip ALL (‘02199’,’43011’) COMMIT

DELETE FROM zipcode WHERE zip IN (‘02199’,’43011’) COMMIT

DELETE FROM zipcode WHERE zip ANY (‘02199’,’43011’)

101. You cannot drop a user if objects exist in the user's schema.

True

False

102. You cannot drop a user if objects exist in the user's schema.

True

False

103. Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those whose last name and first name starts with the letter 'K'?

WHERE last_name = ‘K%’ and first_name = ‘K%’

WHERE last_name LIKE ‘K_’ and first_name LIKE ‘K_’

WHERE last_name LIKE ‘K%’ and first_name LIKE ‘K%’

WHERE last_name and first_name = ‘K%’

104. The UNION and UNION ALL set operator have the opposite effect other.

True

False

105. You can nor selectively delete rows a table.

True

False

106. Consider the EMPLOYEES table. Which of the following SQL statements is correct to provide the sentence in the format "King has been working since 01.01.1987" with "Employee Information" alias?

SELECT last_name ||’has been working since’ || hire_date “Employee Information” FROM employees;

SELECT last_name || ‘has been working since’ || hire_date Employee Information FROM employees

SELECT last_name || ‘has been working since’ || hire_date ‘Employee Information’ FROM employees;

SELECT last_name || ”has been working since” || hire_date “Employee Information” FROM employees;

107. 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 userb.employees;

SELECT * FROM employees;

SELECT * FROM usera.employees;

SELECT * FROM employees.userb;

108. Which SQL statement is used to create a table in a database?

CREATE DATABASE TAB

CREATE DB

CREATE DATABASE TABLE

CREATE TABLE

109. Consider the EMPLOYEES table. Which of the following conditions in the WHERE clause will generate an error?

SELECT * FROM employees WHERE last_name=’&Name’

SELECT job_id, SUM(salary) FROM employees GROUP BY ‘&Column’

SELECT * FROM &Table

SELECT &Column FROM employees

110. You can nor selectively delete rows a table.

True

False

111. Which is right of the following clauses?

SELECT… WHERE … ORDER BY … GROUP BY

SELECT … FROM … GROUP BY … ORDER BY … WHERE

SELECT…FROM…WHERE…GROUP BY…ORDER BY

SELECT … FROM … WHERE … ORDER BY … GROUP BY

112. The subquery generally executes __ , and its output is used to complete the query condition for the main (or ) query.

First, outer

Last, outer

Last, inner

First, inner

113. Any user can grant or revoke any type of system privilege to or from another user

True

False

114. Comparison conditions fall into two classes:

Single-column operators (>, =, >=,

Multiple-row operators (>, =, >=,

Single-row operators (>, =, >=,

115. Consider the SQL statement. Which of the following clauses does not sort the result rows by the salary values in the ascending order? SELECT last_name "Employee", salary "Salary" FROM employees

ORDER BY salary;

ORDER BY 2

ORDER BY “Salary” ASC;

ORDER BY “Salary” DESC;

116. Which of the following functions is not single-row function?

CONCAT

SUM

UPPER

ROUND

117. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

UPDATE Persons SET LastName='Hansen' IN LastName='Nilsen'

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

118. Queries that return more than one row from the inner SELECT statement are called

Multiple-row subqueries

Multiple-column subqueries

Sing-column subqueries

Single-row subqueries

119. Write SQL statement for increase salary of all managers by 10%

Update emp set sal=sal*1.1 where empno in (select mgr from emo);

Update emp set sal=sal*1.1 where empno in (select emp from emo);

Update emp set sal=sal*0.1 where empno in (select emp from emo);

Update emp set sal=sal*0.1 where empno in (select mgr from emo);

120. The data of a temporary table is visible to all session.

True

False

121. To obtain a last names thet student and instructors share, you use the mINUS set operator.

True

False

122. Which of the following functions joins two strings together?

CONCAT

TRIM

INSTR

SUBSTR

123. The command to remove rows from a table 'CUSTOMER' is:

REMOVE FROM CUSTOMER ...

DROP FROM CUSTOMER ...

DELETE FROM CUSTOMER WHERE ...

UPDATE FROM CUSTOMER ...

124. The data of a temporary table is visible to all session.

True

False

125. What will be the result of the following SQL statement?SELECT count(d.department_name), l.cityFROM departments d NATURAL JOIN locations lGROUP BY l.city

The number of department in all cities is shown

The number if departments in one particular city is shown

An error will occur since the GROUP BY clause cannot be used with NATURAL JOIN

The number of departments in EACH city is shown.

126. Which SQL statement is used to create a database?

CREATE TABLE

CREATE DB

CREATE DATABASE TEST

NEW DATABASE

127. Consider the EMPLOYEES table. Which of the following statements displays the date in the 'January, 19 1998'?

SELECT TO_DATE(hire_date,’fmMONTH, DD YYYY’) FROM employees

SELECT TO_DATE(hire_date,’fmMonth, DD YYYY’) FROM employees

SELECT TO_CHAR(hire_date,’fmMonth, DD YYYY’) FROM employees

SELECT TO_DATE(hire_date,’fmMON, DD YEAR’) FROM employees

128. When inserting data into a table form another table, the table names and columns must be the same.

True

False

129. The ____ operator compares a value to EACH value returned by a subquery

NOT

ANY

SOME

ALL

130. ______ clause can be used and is required in the subquery to perform Top-N analysis.

HAVING

ORDER BY

GROUP BY

WHERE

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

CONCAT

INSTR

TRIM

SUBSTR

132. Consider the SQL statement. Which of the following clauses does not sort the result rows by salary value in the ascending order?SELECT last_name "Employee", salary "Salary"FROM employees

ORDER BY salary;

ORDER BY 2;

ORDER BY “Salary” ASC;

ORDER BY Salary DESC;

133. Consider the EMPLOYEES table. Which of the following statements count the number of employees within each department?

SELECT department_id, COUNT(last_name) FROM employees GROUP BY department_id

SELECT department_name, COUNT(last_name) FROM employees GROUP BY department_id

SELECT department_id, department_name, COUNT(last_name) FROM employees GROUP BY department_id

SELECT department_id, COUNT(last_name) FROM departments GROUP_BY last_name

134. The ____ operator returns all rows that are selected by either query

UNION ALL

INTERSECT

UNION

MINUS

135. Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who work in the department prompted by the user?

WHERE department_id = ‘%Department’

WHERE department_id LIKE ‘%Department’

WHERE department_id = ‘&Department’

WHERE department_id like ‘_Department’

136. The ______ operator compares a value to every value returned by a subquery.

NOT

ALL

SOME

ANY

137. You cannot order the results of a set operation.

True

False

138. The SQL WHERE clause:

Limits the column data that are returned.

Limits the row data are returned.

Both A and B are correct.

Neither A nor B are correct.

139. The wildcard in a WHERE clause is useful when?

An exact match is necessary in a SELECT statement.

An exact match is not possible in a SELECT statement.

An exact match is necessary in a CREATE statement.

An exact match is not possible in a CREATE statement.

140. Which of the following clauses is used to limit the rows that are retrieved by the query?

WHERE

ORDER BY

FROM

GROUP BY

141. You can not order the results of a set operation

True

False

142. A DISTINCT must always be user in the top-most SELECT statement of a set operation

True

False

143. Write SQL statement for display the department numbers with more than employees in each dept.

Select deptno, count(deptno) from emp group by deptno having count(*)>3;

Select deptno, count (deptno) from emp group by deptno having count(*)>2;

Select deptno, count (emp) from deptno group by emp having count(*)>2;

Select deptno, count(deptno) from deptno group by emp having count(*)>3;

144. Which of the following SQL statements will generate an error?

SELECT last_name Name FROM employees WHERE Name like ‘K%’

SELECT department_id Dep, COUNT(last_name) FROM employees GROUP BY dep

SELECT department_id Dep, COUNT(last_name) Num FROM employees GROUP BY department_id HAVING Num>5

SELECT last_name Name FROM employees ORDER BY Name

145. The TRANCATE command and the TRUNC function can be used interchangeably.

True

False

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

The keyboard AS between an alias and a column name is optional

Aliases always require double quotation marks

Aliases immediately follows the column name

Aliases rename column heading

147. Consider the EMPLOYEES table. Which of the following displays the maximum average salary for each department?

SELECT MAX(AVG(salary)) FROM employees

SELECT department_id, MAX(AVG(salary)) FROM employees GROUP BY department_id

SELECT AVG(MAX(salary)) FROM employees GROUP BY department_id

SELECT MAX(AVG(salary)) FROM employees GROUP BY department_id

148. Which statement discards all pending data changes

SAVEPOINT

ROLLBACK

COMMIT

DISCARD

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

The keyboard AS between an alias and a column name is optional

Aliases always require double quotation marks

Aliases immediately follows the column name

Aliases rename column heading

150. The condition INSERT FIRST command evaluates the WHEN condition in order. For all conditions that are true a row is inserted into the appropriate table.

True

False

Database Iitu Quiz

1. A table can be created with or without data

2.

What first name or nickname would you like us to use?

2. With SQL, how do you select all the columns from a table named "Persons"?

3. You can add and drop columns from a table using the ALTER TABLE command.

4. A table can be created with or without data.

5. Which keyword is used to provide an alias to a column?

6. What does SQL stand for?

7. You can add and drop columns from a table using the ALTER TABLE command.

8. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

9. Which of the following is a concatenation operator?

10. Which SQL keyword is used to sort the result-set?

11. Which keyword is used to provide an alias to a column?

12. Queries containing set operators are called ______ .

13. With SQL, how can you return the number of records in the "Persons" table?

14. Transaction control determines when data manipulation becomes permanent in a database.

15. What will be the result of the following SQL statement? (SYSDATE is a date of your exam)SELECT TO_CHAR(SYSDATE, 'Day') FROM Dual;

16. With SQL, how do you select a column named "FirstName" from a table named "Persons"?

17. Which of the following is a concatenation operator?

18. Transaction control determines when data manipulation becomes permanent in a database.

19. What is the most common type of join?

20. By default, the foreign key restricts deletes of any parent row has a corresponding child row(s).

21. Privileges, roles, and synonyms are all used to implement security in an Oracle Database.

22. Which symbol do you use if you need to choose all the columns from the table to the result query?

23. Which SQL statement is used to update data in a database?

24. Which SQL statement is used to insert new data in a database?

25. Queries containing set operators are called __________ .

26. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

27. Queries containing set operators are called __________ .

28. You can add to and drop columns from a table using the ALTER TABLE command.

29. The NUMBER data types is usually the best choice for a primary key.

30. Which of the following is the correct order of keywords for SQL SELECT statements?

31. A table can be created with or without data

32. Privileges, roles, and synonyms are all used to implement security in an Oracle database.

33. Which operator is used to select values within a range?

34. Queries containing set operators are called __________ .

35. Which keyword is used to eliminate duplicate rows in the result?

36. The result of a SQL SELECT statement is a(n) ________ .

37. Which SQL statement is used to extract data from a database?

38. With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

39. The TRUNCATE command removes all data permanently from a table.

40. By default, the foreign key restricts deletes of any parent row has a corresponding child row(s).

41. Which command is used to view the structure of the table LOCATIONS?

42. What will be the result of the following query?SELECT ROUND (63.548, -1) FROM DUAL;

43. Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who do not work in the departments 90 and 60?

44. Queries containing set operators are called ______ .

45. The TRUNCATE command removes all data permanently from a table.

46. What will be the result of the following query?SELECT ROUND (63.548, -1) FROM DUAL;

47. Which of the following are the five built-in functions provided by SQL?

48. 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?

49. Which command is used to view the structure of the table LOCATIONS?

50. The data dictionary view USER_TAB_PRIVS_MADE lists details of table privilege grants performed by the current user.

51. Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who do not work in the departments 90 and 60?

52. With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

53. What will be the result of the following SQL statement? (SYSDATE is a date of your exam)SELECT TO_CHAR(SYSDATE, 'Day') FROM Dual;

54. By default, the foreign key restricts deletes of any parent row that has a corresponding child row(s).

55. Which command is used to view the structure of the table LOCATIONS?

56. The ______ constraint defines a condition that each row must satisfy.

57. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

58. With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

59. Which SQL statement is used to return only different values?

60. With SQL, how can you insert a new record into the "Persons" table?

61. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

62. Which operator is used to search for a specified pattern in a column?\

63. A SELECT statement that is embedded in a clause of another SELECT statement is called

64. DML statement such as INSERT, UPDATE, DELETE, and MERGE obtain a lock on the row(s), so other users cannot manipulate it.

65. Use the _____ operator to return all rows from multiple tables and eliminate any duplicate rows.

66. Consider the following SQL statement. What will be the result? SELECT e.last_name, e.salary, d.department_name FROM employees e, departments d WHERE e.department_id = d.department_id

67. The NOT NULL constraint enforces a column to not accept null values

68. Use the _______ operator to return all rows from multiple tables and eliminate any duplicate rows.

69. Both object and system privileges can be granted through a single role to a user.

70. Which of the following is the original purpose of SQL?

71. Transaction control determines when data manipulates becomes permanent in a database.

72. The ______ constraint defines a condition that each row must satisfy.

73. You can rename a table with the RENAME or the ALTER TABLE command.

74. When using LIKE condition which symbol is used to denote one character?

75. You can update only a single column at time in a table.

76. You can place the subquery in a number of SQL clauses, including the following:I. WHERE clauseII. HAVING clauseIII. FROM clause

77. Queries that return only one row from the inner SELECT statement are called

112. The subquery generally executes __ , and its output is used to complete the query condition for the main (or ) query.