____ function extract characters from the text field.
LEN()
NOW()
MID()
FORMAT()
Correct Answer :
C. MID()
MID() function extract characters from the text field.
Related Questions
Number of operands used by Unary Operator is?
1
2
3
4
Which of the following constraints are TRUE to be put in Password system?
One uppercase character must be included in the password.
An eight-character minimum password is required.
At least one symbol must appear in the password.
All of the above
What is TRUE about NOT IN clause?
The result is purged of duplicates
Duplicate records are not removed
Performs column-by-column comparisons
None of the above
In order to start the transaction, the command used is
Mysql > START COMMIT;
Mysql > START TRANSACTION;
Mysql > START ROLLBACK;
None of the above
Using the SQL last() function, one can return the ______ value of the selected column.
First
Second
Third
Last
SQL EXCEPT returns the record from -
First SELECT Query
Second SELECT Query
Third SELECT Query
None of the above
Which of the following is not MySQL Numeric Data Type?
BIT(Size)
CHAR(Size)
INTEGER(Size)
INT(Size)
All other columns other than the column which is termed as Primary Key, are known as
Unique Keys
Alternate Keys
Composite Keys
None of the above
What does the CREATE INDEX Statement do?
An index is created in a SQL database table with this SQL statement.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
The SQL database table's index is deleted using this SQL statement.
Whenever a sub query appears in SQL, it is enclosed within ____ and placed to the ____ of the SQL operators.
Brackets, Left
Brackets, Right
Parenthesis, Left
Parenthesis, Right
Savepoint command is used with _____ command.
Commit
Transaction
Rollback
None of the above
Foreign key is a field in a table that is _______ key in another table?
Primary
Unique
Composite
None of the above
Which one is not the OPTIONAL Clause in SELECT statement?
WHERE
ORDER BY
HAVE
HAVING
Which of the following clause is optional in SQL SELECT Statement?
SELECT
FROM
HAVING
None of the above
Which of the following statement is false?
There is no difference between a lower case and upper case keyword in SQL.
It is easier to read SQL queries when the keywords are in lowercase.
An SQL statement's syntax is determined by its text line.
One or more SQL statements can be placed on a single line of text.
Which statement is TRUE about the HAVING Clause?
In order to group the rows, HAVING Clause is used.
In order to return the rows, HAVING Clause is used.
In order to select the defined groups by the GROUP BY Clause, HAVING Clause is used.
None of the above
Which of the following is among the 12 Codd's Rules?
View Updating Rule
Relational Level Operation Rule
Distribution Independence Rule
None of the above
What is meant by Partial Database Control?
Business rules are hidden.
Users or professionals can't have the full control over the database.
Both A and B
None of the above
A SELECT statement is intersected to use it as a join, but it only returns the records that are ________ between both statements.
Distinct
Common
Shared
Both B and C
Select the correct statement about SQL Scripts?
At the run time, the SQL*Plus commands are ignored.
SQL Scripts and SQL Commands in the SQL Scripts have no interaction.
Through the SQL Script editor, SQL Commands are cut and pasted.
All of the above
Which of the following statement is TRUE about DISTINCT Clause?
Returns only Distinct values.
Only on the single column, it operates.
It can be used with the aggregates such as COUNT, AVG, etc.
All of the above
Which of the following statement is TRUE?
At run time, temporary tables can be created.
Temporary table can do similar operations to normal table.
Both A) and B)
None of the above
In order to assign a random name to a column or table, which SQL SELECT Clause is used?
FROM
WHERE
HAVING
AS
Which statement is correct to remove an Index from MySQL Database?
DROP INDEX Index_Name;
ALTER TABLE Table_Name DROP INDEX Index_Name;
DROP INDEX Index_Name ON Table_Name;
DROP INDEX Table_Name.Index_Name;
Which statement is TRUE about the GROUP BY Clause?
In order to retrieve rows, GROUP BY Clause is used.
In order to group the rows that share the same property, GROUP BY Clause is used.
In order to select the defined groups, GROUP BY Clause is used.
In order to return the rows, GROUP BY Clause is used.
The SELECT TOP statement shows the limited number of:
Rows
Columns
Tables
None of the above
Which statement is TRUE about the ORDER BY Clause?
In order to return the rows in a specific order, ORDER BY Clause is used.
In order to group the rows, ORDER BY Clause is used.
In order to select the defined groups, ORDER BY Clause is used.
None of the above
Which of the following is/are Scalar function(s)?
UCASE()
MID()
ROUND()
All of the above
What does the CREATE TABLE Statement do?
The stored data in the SQL database is changed or modified by this SQL statement.
By deleting the stored data, this SQL statement deletes the database.
A new table in SQL is created using this SQL statement.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
Which statement is used to select the database in SQL?
SELECT
USE
ALTER
CREATE