Angular & Sql

Question 1

Variables defined with let are?

Answer 1

Block-scoped

Question 2

Which command is used to perform unit tests in Angular?

Answer 2

ng test

Question 3

What’s the role of a controller in MVC?

Answer 3

It controls interactions between Model and View

Question 4

What do we call Angular pipes that return the same output for same input?

Answer 4

Pure pipes

Question 5

Directive used instead of href in Angular 2 routing?

Answer 5

routerLink

Question 6

Directive that displays views for a route?

Answer 6

routerOutlet

Question 7

What contains route info for a component in an outlet?

Answer 7

ActivatedRoute

Question 8

What allows values to be passed in URLs to components?

Answer 8

Route parameters

Question 9

Default tooltip position?

Answer 9

Bottom

Question 10

Azure SQL is best for apps that need…?

Answer 10

Elastic scale

Question 11

Clause to rename a column in output?

Answer 11

AS

Question 12

What does [] wildcard do?

Answer 12

Matches single character in specified range

Question 13

Aggregate functions ignore NULLs except with…?

Answer 13

COUNT(*)

Question 14

Keyword to create view using multiple tables?

Answer 14

JOIN

Question 15

What’s it called when one procedure calls another?

Answer 15

Nested Procedure

Question 16

Smallest unit of data storage?

Answer 16

Data Page

Question 17

What is each page in a B-tree index called?

Answer 17

Leaf Node

Question 18

Trigger type that runs on CREATE, ALTER, DROP?

Answer 18

DDL Trigger

Question 19

Which trigger uses Inserted and Deleted tables on update?

Answer 19

UPDATE Trigger

Question 20

What is used for conditional logic in Transact-SQL?

Answer 20

Control-of-flow statements

Question 21

Which data types can’t be used in SELECT list subqueries?

Answer 21

ntext, text, image

Question 22

Function to convert JSON to rows and columns?

Answer 22

OPENJSON rowset

Question 23

Advantages of Stretch Database?

Answer 23

Historical data migration, cost-effective storage

Question 24

What is Polybase used for?

Answer 24

Combining relational and non-relational data

Question 25

Control node tasks in Polybase?

Answer 25

Parse, manage parallel queries, bring data temporarily

Question 26

Keyword to bind view to a schema?

Answer 26

`SCHEMABINDING`

Question 27

Why use Columnstore indexes?

Answer 27

Better performance

Question 28

Azure SQL family includes?

Answer 28

SQL Server on VMs, Managed Instance, Azure SQL DB, SQL Edge

Question 29

Component that defines how types are used in runtime?

Answer 29

Common Type System (CTS)

Question 30

`valueOne = valueOne / 5` when valueOne is int and value is <5?

Answer 30

0

Question 31

What does bitwise `|` operator do?

Answer 31

Puts ON a bit

Question 32

NOT a valid assignment operator?

Answer 32

`\=`

Question 33

VS 2019 feature with code suggestions & tips?

Answer 33

IntelliSense

Question 34

WCF matches with?

Answer 34

Service-oriented messaging framework

Question 35

LINQ matches with?

Answer 35

Data querying for .NET

Question 36

WPF matches with?

Answer 36

UI based on XML & vector graphics

Question 37

Which should be used for every line to have a new line character in the program.

Answer 37

/n

Question 38

Which function is used to see the existence of an entry in a map.

Answer 38

map.has()

Question 39

Which keyword is used to access class's member variables and functions inside class member function

Answer 39

this

Question 40

To use [(ng-Model)] one has to import which module?

Answer 40

@FormsModule