Sql For Database Construction MCQs with Explanations

Standard SQL-92 views are constructed using SQL SELECT statements , and they can include the GROUP BY clause . The SQL-92 standard allows views to be created with complex SELECT statements , including those that use GROUP BY, JOINs, subqueries, and aggregate functions . Therefore, the claim that views cannot contain the GROUP BY clause is incorrect according to the SQL-92 standard.

The correct answer is Option A: True Let's break down why: What is a trigger? Imagine a trigger like a tiny program that's automatically activated when something specific happens in your database. Stored Program: Triggers are essentially pre-written sets of SQL code. These SQL codes are stored within the database itself, waiting to be activated. Attached to a Database: These stored program (Triggers) are linked to a particular table or the database and waits for the event to be happening. Example: Think of it like this: You might set up a trigger to automatically update an "order history" table every time a new order is placed in the "orders" table. The "new order" event *triggers* the update. So, because triggers are stored programs connected to a database that automatically execute in response to certain events, the statement is true.

CREATE TABLE is the correct answer to “The SQL command to create a table is:”. This question is standard in competitive examination syllabi for Sql For Database Construction.

trigger is the correct answer to “A ________ is a stored program that is attached to a table or a view.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

deletes the table structure along with the table data. is the correct answer to “The DROP TABLE statement:”. This question is standard in competitive examination syllabi for Sql For Database Construction.

both of the above can be hidden by an SQL view. is the correct answer to “SQL views can be used to hide:”. This question is standard in competitive examination syllabi for Sql For Database Construction.

CREATE VIEW is the correct answer to “The SQL statement to create a view is:”. This question is standard in competitive examination syllabi for Sql For Database Construction.

a particular row in a particular underlying table. is the correct answer to “To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:”. This question is standard in competitive examination syllabi for Sql For Database Construction.

ALTERNATE KEY is the correct answer to “Which of the following is NOT a type of SQL constraint”. This question is standard in competitive examination syllabi for Sql For Database Construction.

stored procedure is the correct answer to “A ________ is a program that performs some common action on database data and that is stored in the database.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

All of the above are uses for SQL views. is the correct answer to “For what purposes are views used”. This question is standard in competitive examination syllabi for Sql For Database Construction.

A view is the correct answer to “What is an SQL virtual table that is constructed from other tables”. This question is standard in competitive examination syllabi for Sql For Database Construction.

rows can either be inserted into a table one at a time or in groups. is the correct answer to “When using the SQL INSERT statement:”. This question is standard in competitive examination syllabi for Sql For Database Construction.

Increased network traffic is the correct answer to “What is not an advantage of stored procedures”. This question is standard in competitive examination syllabi for Sql For Database Construction.

to accomplish both of the above. is the correct answer to “A reason for using an SQL view to hide columns is:”. This question is standard in competitive examination syllabi for Sql For Database Construction.

All of the above. is the correct answer to “Which of the following is an SQL trigger supported by Oracle”. This question is standard in competitive examination syllabi for Sql For Database Construction.

change the table structure. is the correct answer to “The SQL ALTER statement can be used to:”. This question is standard in competitive examination syllabi for Sql For Database Construction.

The CHECK constraint is the correct answer to “What SQL structure is used to limit column values of a table”. This question is standard in competitive examination syllabi for Sql For Database Construction.

System date is the correct answer to “Which is NOT one of the most common types of SQL CHECK constraints”. This question is standard in competitive examination syllabi for Sql For Database Construction.

To accomplish both of the above. is the correct answer to “What is an advantage of placing computations in SQL views”. This question is standard in competitive examination syllabi for Sql For Database Construction.

ORDER BY is the correct answer to “Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:”. This question is standard in competitive examination syllabi for Sql For Database Construction.

True is the correct answer to “The SQL statement used to create a view is CREATE VIEW.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

False is the correct answer to “The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

True is the correct answer to “SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

False is the correct answer to “The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

True is the correct answer to “SQL Server does not support the BEFORE trigger.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

False is the correct answer to “A updatable view has its own data.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

False is the correct answer to “The SQL DELETE statement is used to delete both the table structure and table data.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

True is the correct answer to “Common types of SQL CHECK constraints include range checks and limiting columns values.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

True is the correct answer to “If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

True is the correct answer to “When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

True is the correct answer to “Views can be used to show the results of computed columns.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

False is the correct answer to “A benefit of using a stored procedure is that it can be distributed to client computers.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

True is the correct answer to “A stored procedure is a program that performs some common action on database data and is stored in the database.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

True is the correct answer to “A SQL view is a virtual table that is constructed from other tables or views.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

True is the correct answer to “There are three SQL data modification operations: insert, modify and delete.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

True is the correct answer to “SQL statements can be embedded in triggers, stored procedures, and program code.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

False is the correct answer to “A view that contains a computed column can be easily updated.”. This question is standard in competitive examination syllabi for Sql For Database Construction.

False is the correct answer to “Three types of triggers are: BEFORE, AFTER and EXCEPTION.”. This question is standard in competitive examination syllabi for Sql For Database Construction.