Menu mobile
Home
Programming
Python Tutorial
Java Tutorial
C Tutorial
C++ Tutorial
Web Technology
HTML
CSS
Java Script
PHP
React JS
Node JS
Assignment
MS Office
HTML
CSS
Bootstrap
Java Script
JQuery
AngularJs
Project
Blog
QUIZ ON : angular - ANGULARJS INTRODUCTION
ANGULARJS INTRODUCTION
00:00:00
English
Hindi
Question No# :
01
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# :
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
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# :
04
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# :
05
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# :
06
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# :
07
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# :
08
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# :
09
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# :
10
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# :
11
out of 50
Which SQL clause is used to define a condition for a group of rows when using the HAVING clause?
A.
WHERE
B.
GROUP
C.
FILTER
D.
CONDITION
Question No# :
12
out of 50
What is the purpose of the SQL ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW in a window function?
A.
Specifies the range of rows to include in the window function from the start to the current row
B.
Specifies the range of rows to include in the window function from the current row to the end
C.
Excludes the current row from the window function
D.
Specifies the range of rows to include in the window function from the start to the end
Question No# :
13
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# :
14
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# :
15
out of 50
Who is inventor of Angular js?
एंगुलर जेएस के आविष्कारक कौन हैं?
A.
Tim Berners Lee
Tim Berners Lee
B.
Misko Hevery
Misko Hevery
C.
Bill Gates
Bill Gates
D.
None of these
None of these
Question No# :
16
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# :
17
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# :
18
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# :
19
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# :
20
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# :
21
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# :
22
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# :
23
out of 50
Which SQL statement is used to change the data type of a column in a table?
A.
ALTER COLUMN
B.
MODIFY COLUMN
C.
CHANGE COLUMN
D.
CONVERT COLUMN
Question No# :
24
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# :
25
out of 50
Angular js is launched
एंगुलर जेएस कब लॉन्च किया गया है
A.
2010
2010
B.
2008
2008
C.
2001
2001
D.
2005
2005
Question No# :
26
out of 50
Which SQL statement is used to remove a unique constraint from a column?
A.
DROP CONSTRAINT
B.
REMOVE CONSTRAINT
C.
ALTER TABLE
D.
DELETE CONSTRAINT
Question No# :
27
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# :
28
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# :
29
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# :
30
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# :
31
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# :
32
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# :
33
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# :
34
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# :
35
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# :
36
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# :
37
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# :
38
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# :
39
out of 50
In MySQL, what is the purpose of the SQL LOAD DATA INFILE statement?
A.
Loads data into a table from an external file
B.
Deletes data from a table
C.
Loads data into a temporary table
D.
Inserts a new record into a table
Question No# :
40
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# :
41
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# :
42
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# :
43
out of 50
In MySQL, what is the purpose of the SQL HANDLER statement?
A.
Manages user-defined functions
B.
Controls error handling in stored procedures
C.
Handles exceptions in transactions
D.
Manages event scheduling
Question No# :
44
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# :
45
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# :
46
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# :
47
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# :
48
out of 50
On which of the Architectural pattern AngularJS is based?
AngularJS किस आर्किटेक्चर पैटर्न पर आधारित है?
A.
Observer Pattern
Observer Pattern
B.
Decorator pattern
Decorator pattern
C.
MVC Architecture pattern
MVC Architecture pattern
D.
MVVM Architectural pattern
MVVM Architectural pattern
Question No# :
49
out of 50
What is the purpose of the SQL TRIM() function?
A.
Removes all rows from a table
B.
Trims leading and trailing spaces from a string
C.
Deletes a specific record from a table
D.
Rounds a numeric value to the nearest integer
Question No# :
50
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
CCC Online Test 2021
CCC Practice Test Hindi
Python Programming Tutorials
Best Computer Training Institute in Prayagraj (Allahabad)
Best Java Training Institute in Prayagraj (Allahabad)
Best Python Training Institute in Prayagraj (Allahabad)
O Level Online Test in Hindi
Bank SSC Railway TET UPTET Question Bank
career counselling in allahabad
Sarkari Naukari Notification
Best Website and Software Company in Allahabad
Sarkari Exam Quiz