QUIZ ON : angular - ANGULARJS INTRODUCTION

ANGULARJS INTRODUCTION

00:00:00

Question No# : 01 out of 50

What is the purpose of the SQL FORMAT() function?

A. Rounds a numeric value to the nearest integer

B. Formats a date or numeric value according to a specified format

C. Converts a string to lowercase

D. Retrieves the length of a string

Question No# : 02 out of 50

What is the purpose of the SQL DATE_FORMAT() function?

A. Converts a date to a string with a specified format

B. Adds a specified number of days to a date

C. Retrieves the current date and time

D. Returns the difference between two dates

Question No# : 03 out of 50

In MySQL, what is the purpose of the SQL HANDLER statement?

A. Deletes all records from a table

B. Retrieves data from a table

C. Performs a specific action when an event occurs

D. Adds a new column to a table

Question No# : 04 out of 50

Which SQL statement is used to grant SELECT privileges on all tables in a database to a user?

A. GRANT SELECT ON database.* TO user;

B. GRANT ALL PRIVILEGES ON database.* TO user;

C. GRANT DATABASE SELECT TO user;

D. GRANT USER SELECT ON database.*;

Question No# : 05 out of 50

Which SQL command is used to revoke all privileges from a user?

A. DENY ALL PRIVILEGES

B. REVOKE ALL

C. REVOKE ALL PRIVILEGES

D. DELETE PRIVILEGES

Question No# : 06 out of 50

What is the purpose of the SQL NULLIF() function?

A. Returns the first non-null expression among its arguments

B. Compares two expressions and returns null if they are equal

C. Converts a value to uppercase

D. Concatenates two or more strings

Question No# : 07 out of 50

Which SQL statement is used to change the data type of a column in a table?

A. ALTER TABLE

B. MODIFY COLUMN

C. CHANGE COLUMN

D. UPDATE TABLE

Question No# : 08 out of 50

What is the purpose of the SQL EXTRACT() function?

A. Removes a specific column from a table

B. Extracts a substring from a string

C. Extracts a part (year, month, day, etc.) from a date or time

D. Extracts a numeric value from a column

Question No# : 09 out of 50

What is the purpose of the SQL LAST_INSERT_ID() function?

A. Retrieves the last record in a table

B. Returns the last ID generated by an AUTO_INCREMENT column

C. Retrieves the last value in a column

D. Returns the last date and time a record was modified

Question No# : 10 out of 50

In MySQL, what is the purpose of the SQL EXPLAIN statement?

A. Provides information about the execution plan of a query

B. Exports data from a table

C. Adds explanatory comments to a query

D. Lists all foreign keys in a database

Question No# : 11 out of 50

In MySQL, what is the purpose of the SQL BIN() function?

A. Converts a value to binary

B. Returns the binary representation of a string

C. Retrieves the last inserted binary data

D. Checks if a value is binary

Question No# : 12 out of 50

What is the purpose of the SQL ROW_NUMBER() window function?

A. Returns the row number of a result set

B. Counts the total number of rows in a table

C. Retrieves the last row in a result set

D. Assigns a unique identifier to each row in a table

Question No# : 13 out of 50

What does the SQL statement GRANT ALL PRIVILEGES ON *.* TO user@localhost; do?

A. Grants the user all privileges on all databases from any host

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

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

D. Grants the user permission to create a new database

Question No# : 14 out of 50

Which SQL function is used to find the position of a substring in a string?

A. POSITION()

B. LOCATE()

C. FIND()

D. SEARCH()

Question No# : 15 out of 50

What is the purpose of the SQL IFNULL() function?

A. Checks if a value is NULL

B. Converts a value to uppercase

C. Returns the first non-null expression among its arguments

D. Calculates the average value for a column

Question No# : 16 out of 50

Which SQL function is used to find the position of a substring in a string?

A. LOCATE()

B. FIND()

C. SEARCH()

D. POSITION()

Question No# : 17 out of 50

AngularJS is perfect for?

A. SPAs

B. MPAs

C. DPAs

D. CPAs

Question No# : 18 out of 50

Which SQL function is used to find the position of a substring in a string?

A. POSITION()

B. LOCATE()

C. SUBSTRING_INDEX()

D. STRPOS()

Question No# : 19 out of 50

In MySQL, what is the purpose of the SQL SHOW WARNINGS statement?

A. Displays warnings generated during the execution of the last statement

B. Shows all warnings in the database

C. Lists all columns with warning messages

D. Clears all warning messages

Question No# : 20 out of 50

Which SQL function is used to return the current users host name and user name?

A. USER()

B. CURRENT_USER()

C. HOST_USER()

D. SESSION_USER()

Question No# : 21 out of 50

What is the purpose of the SQL SHOW COLUMNS FROM table_name statement?

A. Displays the structure of a table

B. Shows the relationships between tables

C. Lists all columns in a table

D. Retrieves the values in a specific column

Question No# : 22 out of 50

What is the purpose of the SQL TRIM() function?

A. Removes leading and trailing spaces from a string

B. Concatenates two or more strings

C. Converts a string to uppercase

D. Rounds a numeric value to the nearest integer

Question No# : 23 out of 50

What is the purpose of the SQL HAVING clause when used with GROUP BY?

A. Filters rows based on a condition before grouping

B. Groups rows based on a condition

C. Applies a condition to individual records after grouping

D. Sorts the result set in descending order

Question No# : 24 out of 50

In MySQL, what is the purpose of the SQL FLUSH TABLES statement?

A. To discard all changes made in a transaction

B. To refresh the table cache

C. To delete all records from a table

D. To optimize and flush the changes to disk for all tables

Question No# : 25 out of 50

What is the purpose of the SQL GROUP_CONCAT() function?

A. Concatenates rows into a single string based on a specified condition

B. Groups rows based on a columns values

C. Counts the number of rows in a result set

D. Retrieves the minimum value in a column

Question No# : 26 out of 50

Which directive initializes an AngularJS application?

A. ng-app

B. ng-init

C. ng-model

D. ng-application

Question No# : 27 out of 50

In MySQL, what is the purpose of the SQL LOCK TABLES statement?

A. To lock a specific row in a table

B. To prevent other sessions from accessing a table for a specific purpose

C. To modify the structure of a table

D. To unlock a table for other sessions

Question No# : 28 out of 50

Which SQL statement is used to add a unique constraint to a column?

A. ADD UNIQUE

B. UNIQUE COLUMN

C. SET UNIQUE

D. CREATE UNIQUE

Question No# : 29 out of 50

What is the purpose of the SQL POSITION() function?

A. Returns the position of a substring in a string

B. Retrieves the minimum value in a column

C. Counts the number of rows in a result set

D. Concatenates rows into a single string based on a specified condition

Question No# : 30 out of 50

What is the purpose of the SQL COALESCE() function when used with multiple arguments?

A. Returns the average value of the arguments

B. Returns the first non-null argument

C. Concatenates the arguments into a single string

D. Adds up all the arguments

Question No# : 31 out of 50

In MySQL, what is the purpose of the SQL EXISTS operator?

A. Checks if a table exists in the database

B. Tests for the existence of rows in a subquery

C. Checks if a column exists in a table

D. Tests for the existence of a database

Question No# : 32 out of 50

Which SQL clause is used to filter the result set based on a pattern?

A. PATTERN BY

B. MATCHING

C. LIKE

D. PATTERN MATCH

Question No# : 33 out of 50

Which SQL clause is used to sort the result set in descending order?

A. ORDER BY DESC

B. SORT DESC

C. DESCENDING

D. REVERSE ORDER

Question No# : 34 out of 50

Which SQL command is used to revoke all privileges from a user?

A. REVOKE ALL

B. DENY ALL PRIVILEGES

C. REVOKE PRIVILEGES

D. REMOVE ALL PRIVILEGES

Question No# : 35 out of 50

Which SQL clause is used to combine rows from two or more tables based on a related column?

A. WHERE

B. GROUP BY

C. JOIN

D. HAVING

Question No# : 36 out of 50

Which SQL function is used to concatenate two or more columns into a single string?

A. CONCAT()

B. COMBINE()

C. MERGE()

D. JOIN()

Question No# : 37 out of 50

In MySQL, what does the term "Auto Increment" refer to?

A. A function that increments a numeric value by a specified step

B. A constraint used for sorting the table

C. A unique identifier for a record in a table that increments automatically

D. A command to increment the value of a column

Question No# : 38 out of 50

Which SQL function is used to return the current users login name?

A. USER()

B. CURRENT_USER()

C. LOGIN_NAME()

D. SESSION_USER()

Question No# : 39 out of 50

Which SQL function is used to return the square root of a numeric value?

A. SQR()

B. SQRT()

C. ROOT()

D. POWER()

Question No# : 40 out of 50

What is the purpose of the SQL BINARY operator?

A. Converts a string to uppercase

B. Performs a case-sensitive comparison

C. Adds two binary numbers

D. Converts a string to lowercase

Question No# : 41 out of 50

In MySQL, what is the purpose of the SQL CURDATE() function?

A. Returns the current date and time

B. Returns the current date

C. Converts a string to lowercase

D. Retrieves the highest value in a column

Question No# : 42 out of 50

Which SQL command is used to change the data type of a column in a table?

A. MODIFY COLUMN

B. CHANGE COLUMN

C. ALTER COLUMN

D. CONVERT COLUMN

Question No# : 43 out of 50

In MySQL, what is the purpose of the SQL FLUSH PRIVILEGES statement?

A. Resets the database engine

B. Clears the query cache

C. Reloads the privilege tables

D. Drops all indexes from a table

Question No# : 44 out of 50

In MySQL, what is the purpose of the SQL FLUSH PRIVILEGES statement?

A. Flushes the contents of a table

B. Refreshes the privileges held by the server

C. Deletes all privileges from a user

D. Flushes the query cache

Question No# : 45 out of 50

What does the SQL statement SHOW INDEX FROM table_name; do?

A. Shows the structure of an index

B. Displays a list of all indexes in a database

C. Shows the indexes associated with a specific table

D. Deletes an index from a table

Question No# : 46 out of 50

What is the purpose of the SQL TRIM() function?

A. Removes all records from a table

B. Trims leading and trailing spaces from a string

C. Truncates a table structure

D. Performs mathematical operations on numeric values

Question No# : 47 out of 50

What is the purpose of the SQL COALESCE() function when used with multiple arguments?

A. Returns the first non-null expression among its arguments

B. Concatenates rows into a single string based on a specified condition

C. Calculates the average value of numeric column values

D. Retrieves the maximum value among the specified expressions

Question No# : 48 out of 50

What is the purpose of the SQL TRIM() function?

A. Removes all records from a table

B. Trims leading and trailing spaces from a string

C. Deletes a specific column from a table

D. Rounds a numeric value to the nearest integer

Question No# : 49 out of 50

In MySQL, what is the purpose of the SQL FLUSH PRIVILEGES statement?

A. Refreshes the database indexes

B. Removes all privileges from a user

C. Reloads the privileges from the grant tables in the mysql system database

D. Deletes all records from a table

Question No# : 50 out of 50

On which of the Architectural pattern AngularJS is based?

A. Observer Pattern

B. Decorator pattern

C. MVC Architecture pattern

D. MVVM Architectural pattern