QUIZ ON : angular - ANGULARJS INTRODUCTION

ANGULARJS INTRODUCTION

00:00:00

Question No# : 01 out of 50

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

A. ALTER TYPE

B. MODIFY COLUMN

C. CHANGE COLUMN

D. ALTER TABLE

Question No# : 02 out of 50

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

A. Returns the next value in a result set based on a specified order

B. Calculates the average value for each group of rows

C. Retrieves the previous value in a result set based on a specified order

D. Performs a left outer join between tables

Question No# : 03 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# : 04 out of 50

Who is inventor of Angular js?

A. Tim Berners Lee

B. Misko Hevery

C. Bill Gates

D. None of these

Question No# : 05 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# : 06 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# : 07 out of 50

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

A. Repeats a string a specified number of times

B. Returns the position of a substring in a string

C. Concatenates two or more strings

D. Rounds a numeric value to the nearest integer

Question No# : 08 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# : 09 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# : 10 out of 50

In MySQL, what does the term "Foreign Key" refer to?

A. A key used for sorting the table

B. A unique identifier for a record in a table

C. A key used for encryption

D. A column or set of columns that refers to the primary key of another table

Question No# : 11 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# : 12 out of 50

Which SQL statement is used to add a new column to an existing table?

A. ADD COLUMN

B. INSERT COLUMN

C. CREATE COLUMN

D. ALTER COLUMN

Question No# : 13 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# : 14 out of 50

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

A. Retrieves the previous value in a result set based on a specified order

B. Returns the next value in a result set based on a specified order

C. Calculates the average value for each group of rows

D. Counts the number of rows in a result set

Question No# : 15 out of 50

Which SQL statement is used to create a primary key constraint on an existing table?

A. ADD PRIMARY KEY

B. CREATE PRIMARY KEY

C. SET PRIMARY KEY

D. PRIMARY KEY TABLE

Question No# : 16 out of 50

Which SQL statement is used to perform a self-join?

A. SELF JOIN

B. INNER JOIN

C. CROSS JOIN

D. LEFT JOIN

Question No# : 17 out of 50

Which SQL statement is used to remove a non-unique index from a table?

A. DROP INDEX

B. REMOVE INDEX

C. DELETE INDEX

D. ERASE INDEX

Question No# : 18 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# : 19 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# : 20 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# : 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 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# : 23 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# : 24 out of 50

Which SQL function is used to convert a string to lowercase?

A. LCASE()

B. LOWER()

C. CONVERT()

D. TOLOWER()

Question No# : 25 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# : 26 out of 50

AngularJS is primarily a:

A. Server-side Framework

B. JavaScript Framework

C. Database System

D. CSS Framework

Question No# : 27 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# : 28 out of 50

Which SQL clause is used to exclude rows that meet a specific condition in a query?

A. EXCLUDE

B. IGNORE

C. WHERE NOT

D. NOT

Question No# : 29 out of 50

What is the purpose of the SQL RAND() function when used with a seed value?

A. Generates a random number without any seed value

B. Generates a random number based on a specified seed value

C. Generates a random string

D. Retrieves a random record from a table

Question No# : 30 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# : 31 out of 50

Which SQL statement is used to count the number of rows in a table?

A. TOTAL ROWS

B. COUNT ROWS

C. NUMROWS

D. SELECT COUNT(*)

Question No# : 32 out of 50

What does the SQL statement SET foreign_key_checks = 0; do?

A. Disables foreign key checks for the current session

B. Enables foreign key checks for the entire database

C. Deletes all foreign keys from a table

D. Modifies the structure of a foreign key

Question No# : 33 out of 50

Which SQL statement is used to rename a column in a table?

A. RENAME COLUMN

B. ALTER COLUMN

C. CHANGE COLUMN

D. MODIFY COLUMN

Question No# : 34 out of 50

Which SQL command is used to create a unique index on a table?

A. CREATE INDEX

B. MAKE INDEX

C. UNIQUE INDEX

D. ADD INDEX

Question No# : 35 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# : 36 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# : 37 out of 50

What is the purpose of the SQL CROSS JOIN?

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

B. Retrieves all rows from both tables, regardless of a match

C. Performs a join operation with a condition

D. Creates a Cartesian product of two tables

Question No# : 38 out of 50

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

A. Truncates a string to a specified length

B. Removes leading and trailing spaces from a string

C. Extracts a substring from a string

D. Replaces a specified substring with another substring

Question No# : 39 out of 50

Which SQL function is used to retrieve the current users hostname and user name concatenated?

A. CURRENT_USER()

B. USER_NAME()

C. SESSION_USER()

D. SYSTEM_USER()

Question No# : 40 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# : 41 out of 50

Angular js is launched

A. 2010

B. 2008

C. 2001

D. 2005

Question No# : 42 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# : 43 out of 50

Which architecture pattern is commonly used in AngularJS?

A. MVC

B. FTP

C. TCP/IP

D. Client-Server Only

Question No# : 44 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# : 45 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# : 46 out of 50

What is the purpose of the SQL SESSION variable @@autocommit?

A. Sets the isolation level of the current transaction

B. Controls whether each SQL statement is treated as a transaction and is automatically committed

C. Retrieves the current users login name

D. Changes the collation of the current session

Question No# : 47 out of 50

Which of the following statement is correct for AngularJS?

A. AngularJS is an HTML framework

B. AngularJS is a Java framework

C. AngularJS is a JavaScript framework

D. AngularJS is a SQL framework

Question No# : 48 out of 50

AngularJS is perfect for?

A. SPAs

B. MPAs

C. DPAs

D. CPAs

Question No# : 49 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# : 50 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