MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 16 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
____________IS_STORED_ONLY_IN_THE_MASTER_DATABASE.?$ |
| A. | Database-scoped Dynamic Management View |
| B. | Complex View |
| C. | Catalog View |
| D. | None of the mentioned |
| Answer» E. | |
| 2. |
Which of the following is not a SQL Server INFORMATION_SCHEMA view? |
| A. | INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE |
| B. | INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS |
| C. | INFORMATION_SCHEMA.KEY_COLUMN_USAGE |
| D. | sys.dm_exec_connections |
| Answer» E. | |
| 3. |
Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause? |
| A. | With |
| B. | Check |
| C. | With check |
| D. | All of the mentioned |
| Answer» B. Check | |
| 4. |
What is SCHEMABINDING a VIEW? |
| A. | Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view |
| B. | These are stored only in the Master database |
| C. | These types of view are defined by users on specified schema |
| D. | These are used to show database self describing information |
| Answer» C. These types of view are defined by users on specified schema | |
| 5. |
SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view? |
| A. | The from clause has only one database relation |
| B. | The query does not have a group by or having clause |
| C. | The select clause contains only attribute names of the relation and does not have any expressions, aggregates, or distinct specification |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 6. |
You can delete a view with ___________ command. |
| A. | DROP VIEW |
| B. | DELETE VIEW |
| C. | REMOVE VIEW |
| D. | TRUNCATE VIEW |
| Answer» B. DELETE VIEW | |
| 7. |
Updating the value of the view |
| A. | Will affect the relation from which it is defined |
| B. | Will not change the view definition |
| C. | Will not affect the relation from which it is defined |
| D. | Cannot determine |
| Answer» E. | |
| 8. |
Syntax for creating views is |
| A. | CREATE VIEW AS SELECT |
| B. | CREATE VIEW AS UPDATE |
| C. | DROP VIEW AS SELECT |
| D. | CREATE VIEW AS UPDATE |
| Answer» B. CREATE VIEW AS UPDATE | |
| 9. |
Materialised views make sure that |
| A. | View definition is kept stable |
| B. | View definition is kept up-to-date |
| C. | View definition is verified for error |
| D. | View is deleted after specified time |
| Answer» B. View definition is kept up-to-date | |
| 10. |
Dynamic Management View is a type of |
| A. | System Defined Views |
| B. | User Defined View |
| C. | Simple View |
| D. | Complex View |
| Answer» B. User Defined View | |
| 11. |
Which one denotes the view. |
| A. | Course_id |
| B. | Watson |
| C. | Building |
| D. | physics_fall_2009 |
| Answer» C. Building | |
| 12. |
SQL Server has mainly how many types of views? |
| A. | one |
| B. | two |
| C. | three |
| D. | four |
| Answer» C. three | |
| 13. |
Which of the following following statement is true? |
| A. | Views could be looked as an additional layer on the table which enables us to protect intricate or sensitive data based upon our needs |
| B. | Views are virtual tables that are compiled at run time |
| C. | Creating views can improve query response time |
| D. | All of the Mentioned |
| Answer» E. | |
| 14. |
Which of the following is not a limitation of view? |
| A. | ORDER BY Does Not Work |
| B. | Index Created on View Used Often |
| C. | Cross Database Queries Not Allowed in Indexed View |
| D. | Adding Column is Expensive by Joining Table Outside View |
| Answer» C. Cross Database Queries Not Allowed in Indexed View | |
| 15. |
Which of the following is the syntax for views where v is view name? |
| A. | Create view v as “query name”; |
| B. | Create “query expression” as view; |
| C. | Create view v as “query expression”; |
| D. | Create view “query expression”; |
| Answer» D. Create view ‚Äö√Ñ√∂‚àö√ë‚àö‚à´query expression‚Äö√Ñ√∂‚àö√ë‚àöœÄ; | |
| 16. |
Which of the following creates a virtual relation for storing the query? |
| A. | Function |
| B. | View |
| C. | Procedure |
| D. | None of the mentioned |
| Answer» C. Procedure | |