SQL Set 2
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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