SQL Set 2

Learning Mode Previous Next

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

Previous Next