Assessment Modules:
Module 1
An Introduction to Database Development
1-A
How many types of SQL Server Components are there?
1-B
How many types of SQL Server Tools are available in 2018?
2
This component is used to orchestrate the movement of data between SQL Server components and other external systems. Traditionally used for extract, transform and load (ETL) operations. Choose the option below which best describes the description above
3
How many number of instances of SQL Server Database Engine can you install on a Single server?
Back To Top
Module 2
Designing and implementing Tables
1-A
How many types of Normalization Forms are there?
1-B
This Normalization form eliminates repeating groups in individual tables. In Addition to this, it creates a separate table for each set of related data. Furthermore, It identifies each set of related data by using a primary key
Which Normalization Form is this?
2
Which of the following statements are true about Unique Identifiers?
3-A
Following are the steps when you are creating a schema except one:
3-B
Which of the following objects cannot be stored in a schema?
4-A
A primary key uniquely identifies each row within a table and candidate key could be used to identify a row. Which of the following is false about Candidate Key?
- D. A and C
4-B
Keys which are references between tables and can also be self-referenced. Also, multiple type of this keys can exist in one table. Because of these keys rows cannot be deleted or updated without cascading options.
Among the options given below, what type of key is it?
- A. Primary Keys
- B. Foreign Keys
- C. Natural Keys
Back To Top
Module 3
Advanced Table Designs
1
You are partitioning data and using Partition function. Which of the following data types are not allowed in a partition function?
Back To Top
Module 4
Ensuring Data Integrity Through Constraints:
1
How many types of Data Integrity are there?
1-A
This integrity defines the allowed values in columns:
1-B
This integrity defines relationships between tables
1-C
Integrity in which primary key uniquely identifies each row within a table
2
While implementing Domain Integrity, Default Constraints plays an important role. Which of the following aspects of Default Constraints are Essential?
3
Sequences are another way of creating values for insertion into a column as sequential numbers. Select from the options below which best describes about Sequences when implementing Referential and Entity Integrity.
Back To Top
