SQL For Database Construction MCQ

Test your knowledge with important SQL For Database Construction MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more SQL For Database Construction MCQs at Bissoy

• Three types of triggers are: BEFORE, AFTER and EXCEPTION.
  ক

  True

  খ

  False
• A view that contains a computed column can be easily updated.
  ক

  True

  খ

  False
• SQL statements can be embedded in triggers, stored procedures, and program code.
  ক

  True

  খ

  False
• There are three SQL data modification operations: insert, modify and delete.
  ক

  True

  খ

  False
• A SQL view is a virtual table that is constructed from other tables or views.
  ক

  True

  খ

  False
• A stored procedure is a program that performs some common action on database data and is stored in the database.
  ক

  True

  খ

  False
• A trigger is a stored program that is attached to a database.
  ক

  True

  খ

  False
• A benefit of using a stored procedure is that it can be distributed to client computers.
  ক

  True

  খ

  False
• Views can be used to show the results of computed columns.
  ক

  True

  খ

  False
• When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
  ক

  True

  খ

  False
• If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.
  ক

  True

  খ

  False
• Common types of SQL CHECK constraints include range checks and limiting columns values.
  ক

  True

  খ

  False
• The SQL DELETE statement is used to delete both the table structure and table data.
  ক

  True

  খ

  False
• A updatable view has its own data.
  ক

  True

  খ

  False
• SQL Server does not support the BEFORE trigger.
  ক

  True

  খ

  False
• The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
  ক

  True

  খ

  False
• Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.
  ক

  True

  খ

  False
• SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
  ক

  True

  খ

  False
• The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
  ক

  True

  খ

  False
• The SQL statement used to create a view is CREATE VIEW.
  ক

  True

  খ

  False
• Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
  ক

  GROUP BY

  খ

  WHERE

  গ

  ORDER BY

  ঘ

  FROM
• What is an advantage of placing computations in SQL views?
  ক

  To save users from having to write an expression.

  খ

  To ensure that the results are consistent.

  গ

  To accomplish both of the above.

  ঘ

  None of the above is correct - computations cannot be placed in a view.
• Which is NOT one of the most common types of SQL CHECK constraints?
  ক

  System date

  খ

  Range checks

  গ

  Lists of values

  ঘ

  Comparing one column value to another within the same table
• What SQL structure is used to limit column values of a table?
  ক

  The LIMIT constraint

  খ

  The CHECK constraint

  গ

  The VALUE constraint

  ঘ

  None of the above is correct.
• What is not an advantage of stored procedures?
  ক

  Greater security

  খ

  SQL can be optimized

  গ

  Code sharing

  ঘ

  Increased network traffic
• A ________ is a program that performs some common action on database data and that is stored in the database.
  ক

  trigger

  খ

  stored procedure

  গ

  pseudofile

  ঘ

  None of the above is correct.
• To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
  ক

  a particular column in a particular underlying table.

  খ

  a particular column in a particular row.

  গ

  a particular row in a particular underlying table.

  ঘ

  None of the above is correct.
• The SQL statement to create a view is:
  ক

  CREATE VIEW

  খ

  MAKE VIEW

  গ

  SELECT VIEW

  ঘ

  INSERT VIEW
• SQL views can be used to hide:
  ক

  columns and rows only.

  খ

  complicated SQL syntax only.

  গ

  both of the above can be hidden by an SQL view.

  ঘ

  None of the above is correct.
• The DROP TABLE statement:
  ক

  deletes the table structure only.

  খ

  deletes the table structure along with the table data.

  গ

  works whether or not referential integrity constraints would be violated.

  ঘ

  is not an SQL statement.