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. A table can be created with or without data.

True

False

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

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. Transaction control determines when data manipulation becomes permanent in a database.

True

False

11. Which of the following is a concatenation operator?

&

||

*

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

COLUMN

AS

ALIAS

IS

13. 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

14. 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

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

ORDER

SORT BY

SORT OR

ORDER BY

16. Queries containing set operators are called ______ .

Compound queries

Subqueries

Inner queries

Outer queries

17. 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

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

True

False

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

True

False

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

*

+

All

%

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

MODIFY

SAVE

UPDATE

SAVE AS

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

INSERT INTO

INSERT NEW

ADD RECORD

ADD NEW

23. Queries containing set operators are called __________ .

Outer queries

Subqueries

Inner queries

Compound querires

24. 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

25. What is the most common type of join?

JOINED

JOINED TABLE

INSIDE JOIN

INNER JOIN

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

True

False

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

True

False

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

True

False

29. Queries containing set operators are called __________ .

Outer queries

Subqueries

Inner queries

Compound queriresCompound queriresCompound querires

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. Privileges, roles, and synonyms are all used to implement security in an Oracle database.

True

False

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

DISTINCT

DESCRIBE

HAVING

GROUP BY

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

GET

OPEN

SELECT

EXTRACT

34. 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'

35. A table can be created with or without data

True

False

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

RANGE

WITHIN

BETWEEN

AND

37. Queries containing set operators are called __________ .

Outer queries

Subqueries

Inner queries

Compound querires

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

Report

Form

File

Table

39. Queries containing set operators are called ______ .

Compound queries

Subqueries

Inner queries

Outer queries

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

64

60

63

70

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

True

False

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

True

False

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

DESCRIBE LOCATIONS

SHOW STRUCTURE LOCATIONS

SELECT * FROM LOCATIONS

PRINT LOCATIONS

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

True

False

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

64

60

63

70

46. 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

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

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

True

False

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

PRIMARY KEY

CHECK

UNIQUE

FOREIGN KEY

55. 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

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

DESCRIBE LOCATIONS

SHOW STRUCTURE LOCATIONS

SELECT * FROM LOCATIONS

PRINT LOCATIONS

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

ONLY

UNIQUE

DISTINCT

SINGLE

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

Main query

Subquery

Inner query

Outer query

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

True

False

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

UNION

MINUS

UNION ALL

INTERSECT

61. 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

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

SELECT DISTINCT

SELECT UNIQUE

SELECT DIFFERENT

EXTRACT DESC

63. 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

64. 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

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

LIKE

FROM

GET

SET

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. Use the _______ operator to return all rows from multiple tables and eliminate any duplicate rows.

UNION ALL

MINUS

INTERSECT

UNION

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

True

False

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

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. You can rename a table with the RENAME or the ALTER TABLE command.

True

False

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

-

+

%

*

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

True

False

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

PRIMARY KEY

CHECK

UNIQUE

FOREIGN KEY

75. Which symbol is used to create a substitution variable

&

-

%

*

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

True

False

77. 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

78. 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

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. 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);

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

LLO

Llo

Low

LOW

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

True

False

83. Constraints always have a name.

True

False

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

UNION

MINUS

UNION ALL

INTERSECT

85. 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

86. 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

87. When executed, this statement cannot be rolled back

ALTER TABLE

DROP TABLE

REMOVE TABLE

DELETE TABLE

88. 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!

89. A subquery must be enclosed in _________ .

Double quotes

Single quotes

Parantheses

Braces

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

+

*

%

_

91. 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

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

True

False

93. 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

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

-

+

%

*

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

ADD

CREATE

INSERT

MAKE

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

REMOVE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

97. 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’)

98. 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’

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

True

False

100. 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;

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

True

False

102. 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%’

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

True

False

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

True

False

105. You can nor selectively delete rows a table.

True

False

106. 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

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 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

109. 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

110. 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;

111. You can nor selectively delete rows a table.

True

False

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

CREATE DATABASE TAB

CREATE DB

CREATE DATABASE TABLE

CREATE TABLE

113. 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;

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

CONCAT

SUM

UPPER

ROUND

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

True

False

116. Comparison conditions fall into two classes:

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

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

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

117. 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

118. 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);

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

True

False

120. 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'

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. ______ clause can be used and is required in the subquery to perform Top-N analysis.

HAVING

ORDER BY

GROUP BY

WHERE

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

NOT

ANY

SOME

ALL

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. Which statement discards all pending data changes

SAVEPOINT

ROLLBACK

COMMIT

DISCARD

148. 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

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. A table can be created with or without data.

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

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. Transaction control determines when data manipulation becomes permanent in a database.

11. Which of the following is a concatenation operator?

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

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

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

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

16. Queries containing set operators are called ______ .

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

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

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

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

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

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

23. Queries containing set operators are called __________ .

24. 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

25. What is the most common type of join?

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

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

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

29. Queries containing set operators are called __________ .

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

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

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

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

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

35. A table can be created with or without data

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

37. Queries containing set operators are called __________ .

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

39. Queries containing set operators are called ______ .

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

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

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

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

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

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

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

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. What will be the result of the following SQL statement? (SYSDATE is a date of your exam)SELECT TO_CHAR(SYSDATE, 'Day') FROM Dual;

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

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

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

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

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

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

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

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

61. 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"?

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

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

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

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

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. Use the _______ operator to return all rows from multiple tables and eliminate any duplicate rows.

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

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

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

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

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

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

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

75. Which symbol is used to create a substitution variable

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

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

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