What is the Magic Table in Sql server ?

What is the Magic Table in Sql server ?

Ans :- Magic table are the temporary object created by server internally to hold recently  inserted value in case of inserted or hold the deleted value in case of deleted or to hold the updated value in case of updated.


Let suppose if we want to create trigger on the table on insert or delete. so on insertion of a record into that table the inserted table will be created automatically by the sql server database, on deletion of record from the table the deleted table will be created automatically by the database

so these 2 table inserted and deleted are called magic table.

these table are not a physical table these are only internal table.

Most commonly asked interview question on ,net and angular 2

Comman interview question for .net and angular 2



Hi friends here i am providing the list of the some question that are commonly asked for every .net and angular 2 developer for the 2-3 years of experience

1. FirstorDefault in Linq

2. Difference between design principle and design patterns

3. Viewchild in angular 2

4. Difference between promise and subscribe & observables

5. How to change layout page dynamically in view

Q1 . Difference between common.js and system.js in ES2015

Q2 . How can we replace the http service with custom service.

Q3 . Optional parameters in javascript

Q4 . Function overloading in typescript.

Q5 . Difference between observables and promise.

Q6 . Enable experimental metadata support in angular

Q7 . Generics in typescript.

Q8 . Oninit and OnDestroy.

Q9 . @Injectable in angular

Q10 . Default access specifier in typescript.

Q11 . Routing guard in angular.

Q12 . Pipe and async pipes in angular.

Q13 . Declaration files in typescript.

Q14 . Inheritance in typescript.

Q15 . Interface in typescript.

Q16 . How can we expose input & output properties for a component so that they consumed by other components

Q17 . RXJS map,switchingmap,mergemap,from,of,zip,empty,throw.

Q18 . Uniontype & tuple in javascript

Q19 . Interceptor.

Q20 . Routing resolver.

Q21 . Custom pipes

Q22 . optional and default parametres in javascript?

Q23 what is canActive and resolver in angular?

Q24 Benefit of using Angular route Resolver?

Q25 What is auth Guard ?

Q26 Why the company required MVC pattern with angular?

Q27 what is async pipe in angular?

Q28 what is template string?  -- template string is used which lets define the multiline string

     Eg:

    @Component({
  selector: 'joke',
  template: `
  <h1>What did the cheese say when it looked in the mirror?</h1>
 <p>Halloumi (hello me)</p>
  `
})

c#

Q29 How to make generic class that should have parameter less constructor?

Q30 What is the Extension method in C#?

Q31 How to invoke directives in angular?

Q32 What is service and factory in angular?

Q33 What is var keyword in c#?

Q34 What is the difference between string and StringBuilder?

Q35 what is the use of observable and the promise and why we use observable instead we have promise

Q36. why function is there is sql if we have stored procedure in that?

Can't bind to 'formGroup' since it isn't a known property of 'form'.

Can't bind to 'formGroup' since it isn't a known property of 'form'. 

this error is because both

formGroup and formControl  directive are belongs to reactive forms module and you have not import this ReactiveFormModule in your's Angular application so this type of error occurred.

Import this module in your's app.module like this.

import { BrowserModule } from '@angular/platform-browser';

import { NgModule } from '@angular/core';

import { ReactiveFormsModule } from '@angular/forms';

import { AppComponent } from './app.component';

import { CreateEmployeeComponent } from './employee/create-employee/create-employee.component';

import { ListEmployeeComponent } from './employee/list-employee/list-employee.component';

import { AppRoutingModule } from './/app-routing.module';

@NgModule({

declarations: [

AppComponent,

CreateEmployeeComponent,

ListEmployeeComponent

],

imports: [

BrowserModule,

AppRoutingModule,

ReactiveFormsModule

],

providers: [],

bootstrap: [AppComponent]

})

export class AppModule { }

'router-outlet' is not a known element

If you getting this type of error in your's angular project when you configure your router module file.

then just check the routing module file and check the import and export array.

you must be declare the RouterModule in your's export array.

In my case app.routing module file 

@NgModule({

imports: [

RouterModule.forRoot(appRoutes),

],

exports: [

RouterModule

]