Tuesday, April 23, 2019

Node js interview questions


This blog is just for revision .


  • Explain the version of a package in node js 
  1. major
  2. minor
  3. patch
  4. pre major
  5. pre minor
  6. pre patch
  7. pre release
  • What is the use of ~ and ^
  1. ~ matches the most recent patch version for the minor version
  2.  ^ matches the most recent minor version of the major version     

  • What are modules

Modules are way of organising reusable components


  1. Core
  2. Local
  3. Third party



  • What is the use of require()


It is used to import core modules.It is a function that can be used to import symbols from another module to the current scope



  • What is commonjs

Commonjs defines standards for modules, packages and unit testing.



  • What is AMD ?

Asynchronous


  • Explain the parts of package.json
  1. name
  2. version
  3. license
  4. description

  • Explain async functions
  • Explain await

Friday, April 19, 2019

mat-form-field must contain a MatFormFieldControl.


Hi Guys ,



Today I have faced this error :

ERROR Error: mat-form-field must contain a MatFormFieldControl.

Later I have found out that I have missed to add the attribute matInput .

<mat-form-field>
<input type="text" name="name" ngModel #refName="ngModel" name="name" required >
</mat-form-field>

Once I added the attribute to the input field matInput , the error was resolved .

<mat-form-field>
<input matInput type="text" name="name" ngModel #refName="ngModel" name="name" required >
</mat-form-field>


Video Link :

Full stack trace is as below .

CustDetailComponent.html:4 ERROR Error: mat-form-field must contain a MatFormFieldControl.
    at getMatFormFieldMissingControlError (form-field.es5.js:119)
    at MatFormField.push../node_modules/@angular/material/esm5/form-field.es5.js.MatFormField._validateControlChild (form-field.es5.js:771)
    at MatFormField.push../node_modules/@angular/material/esm5/form-field.es5.js.MatFormField.ngAfterContentInit (form-field.es5.js:453)
    at callProviderLifecycles (core.js:9553)
    at callElementProvidersLifecycles (core.js:9534)
    at callLifecycleHooksChildrenFirst (core.js:9524)
    at checkAndUpdateView (core.js:10455)
    at callViewAction (core.js:10692)
    at execComponentViewsAction (core.js:10634)
    at checkAndUpdateView (core.js:10457)

oracle plsql interview questions

Important Oracle PL SQL interview Questions .

  •  What is oracle database ?
 A database is a set of physical files on disk created by the CREATE DATABASE statement .

  • What is a database instance ?
A database instance is a set of memory structures that manage database files

What is a record type.
Group of related data items stored in fields.

What is a collection type
Ordered group of elements all of same type


What is type ref cursor
Data type whose value is in memory address of query work area of the database
  • What is an index ?
By creating an index on one or more columns of a table, you gain the ability in some cases to retrieve a small set of randomly distributed rows from the table .
  • What are triggers ?
triggers are procedures stored in PL/SQL or Java that run (fire) implicitly whenever a table or view is modified or when some user actions or database system actions occur.

  1. DML
  2. DDL


  • Implicit attributes of Cursor
  1. %FOUND
  2. %ISOPEN
  3. %NOTFOUND
  4. %ROWCOUNT
        • What is a DB Link ?
        it is a schema object in one database that enables you to access objects on another database .


        •  What is a cluster ?

         A cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common
        • What is a tablespace? 
        it is an allocation of space in the database that can contain schema objects.
        Types of tablespace .
        1. permanent tablespace contains persistent schema objects. Objects in permanent tablespaces are stored in datafiles.
        2. An undo tablespace is a type of permanent tablespace used by Oracle Database to manage undo data if you are running your database in automatic undo management mode. Oracle strongly recommends that you use automatic undo management mode rather than using rollback segments for undo.
        3. temporary tablespace contains schema objects only for the duration of a session. Objects in temporary tablespaces are stored in tempfiles.
        • What is SQL*Plus ?
        SQL*Plus has a command-line user interface that acts as the client when connecting to the database.
        • What is sql loader ?
        SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.


        • Explain normalization.

        Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly.
        Terminology :
        1. attribute : column
        2. candidate key : primary key ( simple or composite )
        3. prime attribute : column which is part of primary key
        4. non prime attribute : column not part of primary key .
        5. super key : any set of attributes which identifies a unique record .
        6. functional dependency : B depends on A 
        7. transitive dependency : B is dependent of A . C is dependent of B . So C has a transitive dependency on A .

        1NF : attribute should be atomic.
        2NF : non prime attribute should not depend on a subset of primary key
        3NF : non prime attribute should not have transitive dependency with the super key .
        BCNF : any functional dependency should be a super key .

        Saturday, April 13, 2019

        Angular Quiz



        Score :
        0
        Test your understanding
        angular-cli.json was deprecated in which version ?
        v5
        v4
        v6
        v7
        Info

        ec2-user@ec2 Permission denied