ANGULARJS INTRODUCTION

AngularJS is an HTML framework

AngularJS is a Java framework

AngularJS is a SQL framework

Observer Pattern

Decorator pattern

MVC Architecture pattern

MPAs

DPAs

CPAs

ng-init

ng-model

ng-application

2008

2001

2005

Tim Berners Lee

Bill Gates

None of these

Grants the user all privileges on a specific database from any host

Grants the user specific privileges on all databases from a specific host

Grants the user permission to create a new database

COMBINE()

MERGE()

JOIN()

Generates a random number without any seed value

Generates a random string

Retrieves a random record from a table

Groups rows based on a columns values

Counts the number of rows in a result set

Retrieves the minimum value in a column

UNIQUE COLUMN

SET UNIQUE

CREATE UNIQUE

Returns the current date and time

Counts the number of rows in a result set

Retrieves the maximum value in a column

Displays the structure of a database

Creates a new database

Shows the relationships between tables

LCASE()

CONVERT()

TOLOWER()

Combines rows from two or more tables based on a related column

Retrieves all rows from both tables, regardless of a match

Performs a join operation with a condition

RENAME COLUMN

ALTER COLUMN

MODIFY COLUMN

Shows the structure of an index

Displays a list of all indexes in a database

Deletes an index from a table

Exports data from a table

Adds explanatory comments to a query

Lists all foreign keys in a database

Retrieves the last record in a table

Retrieves the last value in a column

Returns the last date and time a record was modified

Filters rows based on a condition before grouping

Groups rows based on a condition

Sorts the result set in descending order