MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 38 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Three types of triggers are: BEFORE, AFTER and EXCEPTION.~! |
| A. | True |
| B. | False |
| Answer» C. | |
| 2. |
A view that contains a computed column can be easily updated.~! |
| A. | True |
| B. | False |
| Answer» C. | |
| 3. |
SQL statements can be embedded in triggers, stored procedures, and program code.~! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
There are three SQL data modification operations: insert, modify and delete.~! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 5. |
SQL Server does not support the BEFORE trigger.~! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
A SQL view is a virtual table that is constructed from other tables or views.~! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 7. |
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.~! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 9. |
A stored procedure is a program that performs some common action on database data and is stored in the database.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 11. |
Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 12. |
A trigger is a stored program that is attached to a database.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 13. |
Common types of SQL CHECK constraints include range checks and limiting columns values.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 14. |
SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 15. |
A benefit of using a stored procedure is that it can be distributed to client computers.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 16. |
The SQL DELETE statement is used to delete both the table structure and table data.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 17. |
The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 18. |
Views can be used to show the results of computed columns.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 19. |
A updatable view has its own data.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 20. |
The SQL statement used to create a view is CREATE VIEW.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 21. |
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:%! |
| A. | GROUP BY |
| B. | WHERE |
| C. | ORDER BY |
| D. | FROM |
| Answer» D. FROM | |
| 22. |
What is an advantage of placing computations in SQL views?%! |
| A. | To save users from having to write an expression. |
| B. | To ensure that the results are consistent. |
| C. | To accomplish both of the above. |
| D. | None of the above is correct - computations cannot be placed in a view. |
| Answer» D. None of the above is correct - computations cannot be placed in a view. | |
| 23. |
Which is NOT one of the most common types of SQL CHECK constraints?%! |
| A. | System date |
| B. | Range checks |
| C. | Lists of values |
| D. | Comparing one column value to another within the same table |
| Answer» B. Range checks | |
| 24. |
What SQL structure is used to limit column values of a table?%! |
| A. | The LIMIT constraint |
| B. | The CHECK constraint |
| C. | The VALUE constraint |
| D. | None of the above is correct. |
| Answer» C. The VALUE constraint | |
| 25. |
The SQL statement to create a view is:%! |
| A. | CREATE VIEW |
| B. | MAKE VIEW |
| C. | SELECT VIEW |
| D. | INSERT VIEW |
| Answer» B. MAKE VIEW | |
| 26. |
*$_The SQL statement to create a view is:? |
| A. | CREATE VIEW |
| B. | MAKE VIEW |
| C. | SELECT VIEW |
| D. | INSERT VIEW |
| Answer» B. MAKE VIEW | |
| 27. |
*$_The SQL ALTER statement can be used to:? |
| A. | change the table structure. |
| B. | change the table data. |
| C. | add rows to the table. |
| D. | delete rows from the table. |
| Answer» B. change the table data. | |
| 28. |
*$_What is an SQL virtual table that is constructed from other tables?? |
| A. | Just another table |
| B. | A view |
| C. | A relation |
| D. | Query results |
| Answer» C. A relation | |
| 29. |
%_SQL views can be used to hide:_% |
| A. | columns and rows only. |
| B. | complicated SQL syntax only. |
| C. | both of the above can be hidden by an SQL view. |
| D. | None of the above is correct. |
| Answer» D. None of the above is correct. | |
| 30. |
%_Which of the following is an SQL trigger supported by Oracle?_% |
| A. | BEFORE |
| B. | INSTEAD OF |
| C. | AFTER |
| D. | All of the above. |
| Answer» E. | |
| 31. |
%_For what purposes are views used?_% |
| A. | To hide columns only |
| B. | To hide rows only |
| C. | To hide complicated SQL statements only |
| D. | All of the above are uses for SQL views. |
| Answer» E. | |
| 32. |
__The DROP TABLE statement:__ |
| A. | deletes the table structure only. |
| B. | deletes the table structure along with the table data. |
| C. | works whether or not referential integrity constraints would be violated. |
| D. | is not an SQL statement. |
| Answer» C. works whether or not referential integrity constraints would be violated. | |
| 33. |
__A reason for using an SQL view to hide columns is:__ |
| A. | to simplify a result only. |
| B. | to prevent the display of sensitive data only. |
| C. | to accomplish both of the above. |
| D. | None of the above are reasons for using an SQL view. |
| Answer» D. None of the above are reasons for using an SQL view. | |
| 34. |
__A ________ is a program that performs some common action on database data and that is stored in the database.__ |
| A. | trigger |
| B. | stored procedure |
| C. | pseudofile |
| D. | None of the above is correct. |
| Answer» C. pseudofile | |
| 35. |
A ________ is a stored program that is attached to a table or a view.$? |
| A. | pseudofile |
| B. | embedded SELECT statement |
| C. | trigger |
| D. | None of the above is correct. |
| Answer» D. None of the above is correct. | |
| 36. |
What is not an advantage of stored procedures?$? |
| A. | Greater security |
| B. | SQL can be optimized |
| C. | Code sharing |
| D. | Increased network traffic |
| Answer» E. | |
| 37. |
What is not an advantage of stored procedures?? |
| A. | Greater security |
| B. | SQL can be optimized |
| C. | Code sharing |
| D. | Increased network traffic |
| Answer» E. | |
| 38. |
Which of the following is NOT a type of SQL constraint?? |
| A. | PRIMARY KEY |
| B. | FOREIGN KEY |
| C. | ALTERNATE KEY |
| D. | UNIQUE |
| Answer» D. UNIQUE | |