Database Iitu Quiz

150 Questions | Attempts: 611
Share
Please wait...
Question 1 / 150
0 %
0/100
Score 0/100
1. A table can be created with or without data
Submit
Please wait...
About This Quiz
Database Iitu Quiz - Quiz

.

We’ll put your name on your report, certificate, and leaderboard.
2. With SQL, how do you select all the columns from a table named "Persons"?
Submit
3. You can add and drop columns from a table using the ALTER TABLE command.
Submit
4. A table can be created with or without data.
Submit
5. Which keyword is used to provide an alias to a column?
Submit
6. What does SQL stand for?
Submit
7. You can add and drop columns from a table using the ALTER TABLE command.
Submit
8. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
Submit
9. Which of the following is a concatenation operator?
Submit
10. Which SQL keyword is used to sort the result-set?
Submit
11. Which keyword is used to provide an alias to a column?
Submit
12. Queries containing set operators are called ______ .
Submit
13. With SQL, how can you return the number of records in the "Persons" table?
Submit
14. Transaction control determines when data manipulation becomes permanent in a database. 
Submit
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;
Submit
16. With SQL, how do you select a column named "FirstName" from a table named "Persons"?
Submit
17. Which of the following is a concatenation operator?
Submit
18. Transaction control determines when data manipulation becomes permanent in a database. 
Submit
19. What is the most common type of join?
Submit
20. By default, the foreign key restricts deletes of any parent row has a corresponding child row(s).
Submit
21. Privileges, roles, and synonyms are all used to implement security in an Oracle Database.
Submit
22. Which symbol do you use if you need to choose all the columns from the table to the result query?
Submit
23. Which SQL statement is used to update data in a database?
Submit
24. Which SQL statement is used to insert new data in a database?
Submit
25. Queries containing set operators are called __________ .
Submit
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
Submit
27. Queries containing set operators are called __________ .
Submit
28. You can add to and drop columns from a table using the ALTER TABLE command.
Submit
29. The NUMBER data types is usually the best choice for a primary key.
Submit
30. Which of the following is the correct order of keywords for SQL SELECT statements?
Submit
31. A table can be created with or without data
Submit
32. Privileges, roles, and synonyms are all used to implement security in an Oracle database.
Submit
33. Which operator is used to select values within a range?
Submit
34. Queries containing set operators are called __________ .
Submit
35. Which keyword is used to eliminate duplicate rows in the result?
Submit
36. The result of a SQL SELECT statement is a(n) ________ .
Submit
37. Which SQL statement is used to extract data from a database?
Submit
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"?
Submit
39. The TRUNCATE command removes all data permanently from a table.
Submit
40. By default, the foreign key restricts deletes of any parent row has a corresponding child row(s).
Submit
41. Which command is used to view the structure of the table LOCATIONS?
Submit
42. What will be the result of the following query?SELECT ROUND (63.548, -1) FROM DUAL;
Submit
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?
Submit
44. Queries containing set operators are called ______ . 
Submit
45. The TRUNCATE command removes all data permanently from a table.
Submit
46. What will be the result of the following query?SELECT ROUND (63.548, -1) FROM DUAL;
Submit
47. Which of the following are the five built-in functions provided by SQL?
Submit
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?
Submit
49. Which command is used to view the structure of the table LOCATIONS?
Submit
50. The data dictionary view USER_TAB_PRIVS_MADE lists details of table privilege grants performed by the current user.
Submit
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?
Submit
52. With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
Submit
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;
Submit
54. By default, the foreign key restricts deletes of any parent row that has a corresponding child row(s).
Submit
55. Which command is used to view the structure of the table LOCATIONS?
Submit
56. The ______ constraint defines a condition that each row must satisfy.
Submit
57. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
Submit
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"?
Submit
59. Which SQL statement is used to return only different values?
Submit
60. With SQL, how can you insert a new record into the "Persons" table?
Submit
61. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
Submit
62. Which operator is used to search for a specified pattern in a column?\
Submit
63. A SELECT statement that is embedded in a clause of another SELECT statement  is called 
Submit
64. DML statement such as INSERT, UPDATE, DELETE, and MERGE obtain a lock on the row(s), so other users cannot manipulate it.
Submit
65. Use the _____ operator to return all rows from multiple tables and eliminate any duplicate rows.
Submit
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
Submit
67. The NOT NULL constraint enforces a column to not accept null values
Submit
68. Use the _______ operator to return all rows from multiple tables and eliminate any duplicate rows.
Submit
69. Both object and system privileges can be granted through a single role to a user.
Submit
70. Which of the following is the original purpose of SQL?
Submit
71. Transaction control determines when data manipulates becomes permanent in a database.
Submit
72. The ______ constraint defines a condition that each row must satisfy.
Submit
73. You can rename a table with the RENAME or the ALTER TABLE command.
Submit
74. When using LIKE condition which symbol is used to denote one character?
Submit
75. You can update only a single column at time in a table.
Submit
76. You can place the subquery in a number of SQL clauses, including the following:I. WHERE clauseII. HAVING clauseIII. FROM clause
Submit
77. Queries that return only one row from the inner SELECT statement are called
Submit
78. Which symbol is used to create a substitution variable
Submit
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"?
Submit
80. What will be the result of the following SQL statement?SELECT INITCAP(SUBSTR(CONCAT('Hello',world),4,3)) FROM DUAL;
Submit
81. You can update only a single column at a time in a table.
Submit
82. Constraints always have a name.
Submit
83. Write SQL statement for display the names of the employees who are working in the company for the past 5 years:
Submit
84. Use the _____ operator to return all rows from multiple tables and eliminate any duplicate rows.
Submit
85. When executed, this statement cannot be rolled back
Submit
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;
Submit
87. Which of the following statements is NOT true?
Submit
88. When using LIKE conditions which symbol is used to denote zero or many characters?
Submit
89. When using LIKE condition which symbol is used to denote one character?
Submit
90. Consider the EMPLOYEES table. Which of the following conditions in the WHERE clause will generate an error?
Submit
91. A parent table referenced by a child table may not be dropped.
Submit
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.
Submit
93. What will be the result of the following SQL statement?SELECT SUBSTR ('Hello,World!!!',13) FROM DUAL
Submit
94. You can add a row using SQL in database with which of the following?
Submit
95. A subquery must be enclosed in _________ .
Submit
96. The command to eliminate a table from a database is:
Submit
97. Any user can grant or revoke ant type of system privileges to or from another user.
Submit
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?
Submit
99. Consider the EMPLOYEES table. When condition in the WHERE clause limit the employees to IT Programmers with salary greater than 5000?
Submit
100. Delete the zip codes 02199 and 43011 from the ZIPCODE table. Make the change permanent.
Submit
101. You cannot drop a user if objects exist in the user's schema. 
Submit
102. You cannot drop a user if objects exist in the user's schema.
Submit
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'?
Submit
104. The UNION and UNION ALL set operator have the opposite effect other. 
Submit
105. You can nor selectively delete rows a table.
Submit
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?
Submit
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:
Submit
108. Which SQL statement is used to create a table in a database?
Submit
109. Consider the EMPLOYEES table. Which of the following conditions in the WHERE clause will generate an error?
Submit
110. You can nor selectively delete rows a table.
Submit
111. Which is right of the following clauses?
Submit
112. The subquery generally executes ______ , and its output is used to complete the query condition for the main (or ____ ) query.
Submit
113. Any user can grant or revoke any type of system privilege to or from another user
Submit
114. Comparison conditions fall into two classes:
Submit
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
Submit
116. Which of the following functions is not single-row function?
Submit
117. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
Submit
118. Queries that return more than one row from the inner SELECT statement are called
Submit
119. Write SQL statement for increase salary of all managers by 10%
Submit
120. The data of a temporary table is visible to all session.
Submit
121. To obtain a last names thet student and instructors share, you use the mINUS set operator.
Submit
122. Which of the following functions joins two strings together?
Submit
123. The command to remove rows from a table 'CUSTOMER' is:
Submit
124. The data of a temporary table is visible to all session.
Submit
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
Submit
126. Which SQL statement is used to create a database?
Submit
127. Consider the EMPLOYEES table. Which of the following  statements displays the date in the 'January, 19 1998'?
Submit
128. When inserting data into a table form another table, the table names and columns must be the same.
Submit
129. The ____ operator compares a value to EACH value returned by a subquery
Submit
130. ______ clause can be used and is required in the subquery to perform Top-N analysis.
Submit
131. Which of the following functions finds the numeric position of a named character?
Submit
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
Submit
133. Consider the EMPLOYEES table. Which of the following statements count the number of employees within each department? 
Submit
134. The ____ operator returns all rows that are selected by either query
Submit
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?
Submit
136. The  ______ operator compares a value to every value returned by a subquery.
Submit
137. You cannot order the results of a set operation.
Submit
138. The SQL WHERE clause:
Submit
139. The wildcard in a WHERE clause is useful when?
Submit
140. Which of the following clauses is used to limit the rows that are retrieved by the query?
Submit
141. You can not order the results of a set operation
Submit
142. A DISTINCT must always be user in the top-most SELECT statement of a set operation
Submit
143. Write SQL statement for display the department numbers with more than employees in each dept. 
Submit
144. Which of the following SQL statements will generate an error?
Submit
145. The TRANCATE command and the TRUNC function can be used interchangeably.
Submit
146. Which of the following statements about aliases is NOT true?
Submit
147. Consider the EMPLOYEES table. Which of the following displays the maximum average salary for each department?
Submit
148. Which statement discards all pending data changes
Submit
149. Which of the following statements about aliases is NOT true?
Submit
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.
Submit
View My Results

Quiz Review Timeline (Updated): Dec 14, 2017 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Dec 14, 2017
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 14, 2017
    Quiz Created by
    Daniyar
Cancel
  • All
    All (150)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
A table can be created with or without data
With SQL, how do you select all the columns from a table named...
You can add and drop columns from a table using the ALTER TABLE...
A table can be created with or without data.
Which keyword is used to provide an alias to a column?
What does SQL stand for?
You can add and drop columns from a table using the ALTER TABLE...
With SQL, how do you select all the records from a table named...
Which of the following is a concatenation operator?
Which SQL keyword is used to sort the result-set?
Which keyword is used to provide an alias to a column?
Queries containing set operators are called ______ .
With SQL, how can you return the number of records in the...
Transaction control determines when data manipulation becomes...
What will be the result of the following SQL statement? (SYSDATE is a...
With SQL, how do you select a column named "FirstName" from...
Which of the following is a concatenation operator?
Transaction control determines when data manipulation becomes...
What is the most common type of join?
By default, the foreign key restricts deletes of any parent row has a...
Privileges, roles, and synonyms are all used to implement security in...
Which symbol do you use if you need to choose all the columns from the...
Which SQL statement is used to update data in a database?
Which SQL statement is used to insert new data in a database?
Queries containing set operators are called __________ .
The OR operator displays a record if ANY conditions listed are true....
Queries containing set operators are called __________ .
You can add to and drop columns from a table using the ALTER TABLE...
The NUMBER data types is usually the best choice for a primary key.
Which of the following is the correct order of keywords for SQL SELECT...
A table can be created with or without data
Privileges, roles, and synonyms are all used to implement security in...
Which operator is used to select values within a range?
Queries containing set operators are called __________ .
Which keyword is used to eliminate duplicate rows in the result?
The result of a SQL SELECT statement is a(n) ________ .
Which SQL statement is used to extract data from a database?
With SQL, how do you select all the records from a table named...
The TRUNCATE command removes all data permanently from a table.
By default, the foreign key restricts deletes of any parent row has a...
Which command is used to view the structure of the table LOCATIONS?
What will be the result of the following query?SELECT ROUND (63.548,...
Consider the EMPLOYEES table. Which condition in the WHERE clause...
Queries containing set operators are called ______ . 
The TRUNCATE command removes all data permanently from a table.
What will be the result of the following query?SELECT ROUND (63.548,...
Which of the following are the five built-in functions provided by...
Consider the EMPLOYEES table. Which condition in the WHERE clause...
Which command is used to view the structure of the table LOCATIONS?
The data dictionary view USER_TAB_PRIVS_MADE lists details of table...
Consider the EMPLOYEES table. Which condition in the WHERE clause...
With SQL, how can you return all the records from a table named...
What will be the result of the following SQL statement? (SYSDATE is a...
By default, the foreign key restricts deletes of any parent row that...
Which command is used to view the structure of the table LOCATIONS?
The ______ constraint defines a condition that each row must satisfy.
To remove duplicate rows from the results of an SQL SELECT statement,...
With SQL, how do you select all the records from a table named...
Which SQL statement is used to return only different values?
With SQL, how can you insert a new record into the "Persons"...
With SQL, how can you insert "Olsen" as the...
Which operator is used to search for a specified pattern in a column?\
A SELECT statement that is embedded in a clause of another SELECT...
DML statement such as INSERT, UPDATE, DELETE, and MERGE obtain a lock...
Use the _____ operator to return all rows from multiple tables and...
Consider the following SQL statement. What will be the result? SELECT...
The NOT NULL constraint enforces a column to not accept null values
Use the _______ operator to return all rows from multiple tables and...
Both object and system privileges can be granted through a single role...
Which of the following is the original purpose of SQL?
Transaction control determines when data manipulates becomes permanent...
The ______ constraint defines a condition that each row must satisfy.
You can rename a table with the RENAME or the ALTER TABLE command.
When using LIKE condition which symbol is used to denote one...
You can update only a single column at time in a table.
You can place the subquery in a number of SQL clauses, including the...
Queries that return only one row from the inner SELECT statement are...
Which symbol is used to create a substitution variable
With SQL, how do you select all the records from a table named...
What will be the result of the following SQL statement?SELECT...
You can update only a single column at a time in a table.
Constraints always have a name.
Write SQL statement for display the names of the employees who are...
Use the _____ operator to return all rows from multiple tables and...
When executed, this statement cannot be rolled back
What will be the result of the following SQL statement? (SYSDATE is a...
Which of the following statements is NOT true?
When using LIKE conditions which symbol is used to denote zero or many...
When using LIKE condition which symbol is used to denote one...
Consider the EMPLOYEES table. Which of the following conditions in the...
A parent table referenced by a child table may not be dropped.
It is possible to combine from two tables that do not have a primary...
What will be the result of the following SQL statement?SELECT SUBSTR...
You can add a row using SQL in database with which of the following?
A subquery must be enclosed in _________ .
The command to eliminate a table from a database is:
Any user can grant or revoke ant type of system privileges to or from...
Consider the EMPLOYEES table. Which of the following SQL statements is...
Consider the EMPLOYEES table. When condition in the WHERE clause limit...
Delete the zip codes 02199 and 43011 from the ZIPCODE table. Make the...
You cannot drop a user if objects exist in the user's schema. 
You cannot drop a user if objects exist in the user's schema.
Consider the EMPLOYEES table. Which condition in the WHERE clause...
The UNION and UNION ALL set operator have the opposite effect...
You can nor selectively delete rows a table.
Consider the EMPLOYEES table. Which of the following SQL statements is...
If there are schemas named USERA and USERB, and both have an EMPLOYEES...
Which SQL statement is used to create a table in a database?
Consider the EMPLOYEES table. Which of the following conditions in the...
You can nor selectively delete rows a table.
Which is right of the following clauses?
The subquery generally executes ______ , and its output is used to...
Any user can grant or revoke any type of system privilege to or from...
Comparison conditions fall into two classes:
Consider the SQL statement. Which of the following clauses does not...
Which of the following functions is not single-row function?
How can you change "Hansen" into "Nilsen" in the...
Queries that return more than one row from the inner SELECT statement...
Write SQL statement for increase salary of all managers by 10%
The data of a temporary table is visible to all session.
To obtain a last names thet student and instructors share, you use the...
Which of the following functions joins two strings together?
The command to remove rows from a table 'CUSTOMER' is:
The data of a temporary table is visible to all session.
What will be the result of the following SQL statement?SELECT...
Which SQL statement is used to create a database?
Consider the EMPLOYEES table. Which of the following  statements...
When inserting data into a table form another table, the table names...
The ____ operator compares a value to EACH value returned by a...
______ clause can be used and is required in the subquery to perform...
Which of the following functions finds the numeric position of a named...
Consider the SQL statement. Which of the following clauses does not...
Consider the EMPLOYEES table. Which of the following statements count...
The ____ operator returns all rows that are selected by either query
Consider the EMPLOYEES table. Which condition in the WHERE clause...
The  ______ operator compares a value to every value returned by...
You cannot order the results of a set operation.
The SQL WHERE clause:
The wildcard in a WHERE clause is useful when?
Which of the following clauses is used to limit the rows that are...
You can not order the results of a set operation
A DISTINCT must always be user in the top-most SELECT statement of a...
Write SQL statement for display the department numbers with more than...
Which of the following SQL statements will generate an error?
The TRANCATE command and the TRUNC function can be used...
Which of the following statements about aliases is NOT true?
Consider the EMPLOYEES table. Which of the following displays the...
Which statement discards all pending data changes
Which of the following statements about aliases is NOT true?
The condition INSERT FIRST command evaluates the WHEN condition in...
Alert!

Advertisement