On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on SQL Set 2

Q1 | Which of the following statements is true concerning subqueries?
  • Involves the use of an inner and outer query
  • Cannot return the same result as a query that is not a subquery
  • Does not start with the word SELECT
  • All of the mentioned
Q2 | Which of the following is a correlated subquery?
  • Uses the result of an inner query to determine the processing of an outer query
  • Uses the result of an outer query to determine the processing of an inner query
  • Uses the result of an inner query to determine the processing of an inner query
  • Uses the result of an outer query to determine the processing of an outer query
Q3 | The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID,ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T?
  • Equi-join
  • Natural join
  • Outer join
  • Cartesian join
Q4 | Which is not a type of join in T-SQL?
  • Equi-join
  • Natural join
  • Outer join
  • Cartesian join
Q5 | What is a view?
  • A view is a special stored procedure executed when certain event occurs
  • A view is a virtual table which results of executing a pre-compiled query
  • A view is a database diagram
  • None of the Mentioned
Q6 | Which of the following is not a limitation of view?
  • ORDER BY Does Not Work
  • Index Created on View Used Often
  • Cross Database Queries Not Allowed in Indexed View
  • Adding Column is Expensive by Joining Table Outside View
Q7 | Which of the following statement is true?
  • Views could be looked as an additional layer on the table which enables us to protect intricate or sensitive data based upon our needs
  • Views are virtual tables that are compiled at run time
  • Creating views can improve query response time
  • All of the Mentioned
Q8 | SQL Server has mainly how many types of views?
  • one
  • two
  • three
  • four
Q9 | Dynamic Management View is a type of ___________
  • System Defined Views
  • User Defined View
  • Simple View
  • Complex View
Q10 | Syntax for creating views is __________
  • CREATE VIEW AS SELECT
  • CREATE VIEW AS UPDATE
  • DROP VIEW AS SELECT
  • CREATE VIEW AS UPDATE
Q11 | You can delete a view with ___________ command.
  • DROP VIEW
  • DELETE VIEW
  • REMOVE VIEW
  • TRUNCATE VIEW
Q12 | What is SCHEMABINDING a VIEW?
  • Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view
  • These are stored only in the Master database
  • These types of view are defined by users on a specified schema
  • These are used to show database self describing information
Q13 | Which of the following is not a SQL Server INFORMATION_SCHEMA view?
  • INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
  • INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
  • INFORMATION_SCHEMA.KEY_COLUMN_USAGE
  • sys.dm_exec_connections
Q14 | ___________ is stored only in the Master database.
  • Database-scoped Dynamic Management View
  • Complex View
  • Catalog View
  • None of the mentioned
Q15 | In the __________ normal form, a composite attribute is converted to individual attributes.
  • First
  • Second
  • Third
  • Fourth
Q16 | Tables in second normal form (2NF):
  • Eliminate all hidden dependencies
  • Eliminate the possibility of a insertion anomalies
  • Have a composite key
  • Have all non key fields depend on the whole primary key
Q17 | Which-one ofthe following statements about normal forms is FALSE?
  • BCNF is stricter than 3 NF
  • Lossless, dependency -preserving decomposition into 3 NF is always possible
  • Loss less, dependency – preserving decomposition into BCNF is always possible
  • Any relation with two attributes is BCNF
Q18 | Functional Dependencies are the types of constraints that are based on______
  • Key
  • Key revisited
  • Superset key
  • None of the mentioned
Q19 | Which is a bottom-up approach to database design that design by examining the relationshipbetween attributes:
  • Functional dependency
  • Database modeling
  • Normalization
  • Decomposition
Q20 | Which forms simplifies and ensures that there are minimal data aggregates and repetitivegroups:
  • 1NF
  • 2NF
  • 3NF
  • All of the mentioned
Q21 | Which forms has a relation that possesses data about an individual entity:
  • 2NF
  • 3NF
  • 4NF
  • 5NF
Q22 | Which forms are based on the concept of functional dependency:
  • 1NF
  • 2NF
  • 3NF
  • 4NF
Q23 | Empdt1(empcode, name, street, city, state, pincode).For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in
  • 1 NF only
  • 2 NF and hence also in 1 NF
  • 3NF and hence also in 2NF and 1NF
  • BCNF and hence also in 3NF, 2NF and 1NF
Q24 | We can use the following three rules to find logically implied functional dependencies.This collection of rules is called
  • Axioms
  • Armstrong’s axioms
  • Armstrong
  • Closure
Q25 | Which of the following is not Armstrong’s Axiom?
  • Reflexivity rule
  • Transitivity rule
  • Pseudotransitivity rule
  • Augmentation rule