Output returned by the Scalar functions is/are -
Single Value
Multiple Value
Two Values
None of the above
Correct Answer :
A. Single Value
The output returned by the Scalar functions is Single Value.
Related Questions
Why index is important in SQL?
The large database can be searched quickly with SQL Indexes.
The concept below is a quick way to include different values in those columns.
A smaller table may not recognize the performance of an index when used with an index.
All of the above
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
What is the difference between VARCHAR and VARCHAR2?
VARCHAR can store upto 4000 bytes and VARCHAR2 can store upto 8000 bytes.
VARCHAR can store upto 2000 bytes and VARCHAR2 can store upto 4000 bytes.
Both VARCHAR and VARCHAR2 are similar but use of VARCHAR2 is mostly recommended.
There is no similarity between VARCHAR and VARCHAR2.
In the case of ____ Independence Rule, Physical independence of data to access the database is a requirement for a database or an application.
Physical Data
Logical Data
Integrity
Distribution
For integer value, which data type is supported in Oracle?
INT
Number
Digit
None of the above
The Web SQL API is supported by
Opera
Google Chrome
Android Browsers
All of the above
Using the SQL last() function, one can return the ______ value of the selected column.
First
Second
Third
Last
In SQL, Like is a ____ operator.
Relational
Logical
Additional
Unique
TINYTEXT can hold the maximum length of ___ characters?
254
255
256
257
Which of the following is the feature(s) of SQL Auto Increment?
In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key.
Explicitly initializing and modifying the auto-increment value is possible at any time.
Record identifiers can easily be created that are unique to each record.
All 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
What will be the output of the below SQL statement?
25
26
25.65
25.00
In order to remove an index, we need to use which command?
REMOVE
DELETE
DROP
DEL
Select the syntax of Single Line Comment.
.
!
--
#
Which syntax is correct for RENAME DATABASE in MySQL?
RENAME old_database_name TO new_database_name;
RENAME DATABASE old_database_name TO new_database_name;
ALTER old_database_name MODIFY NAME = new_database_name;
ALTER DATABASE old_database_name MODIFY NAME = new_database_name;
Select the correct order of precedence among the following?
OR > NOT > + > **
NOT > OR > ** > +
** > + > OR > NOT
** > + > NOT > OR
To delete table definition and all data from the table, which statement is used?
DELETE
DROP
ALTER
None of the above
Which statement is true about the No-SQL?
No-SQL follows ACID Model.
No-SQL does require object-relational mapping.
Dynamic schemas for unstructured data are used in No-SQL databases.
No-SQL databases are not preferable for storage of hierarchal data.
To rename the Index, we need to use which command?
RENAME
ALTER
UPDATE
ADD
In order to merge two or more strings, which string function is used?
CHAR
ALTER
CONCAT
MERGE
Select the statement which is TRUE?
In a table, there could be any number of rows and any number of columns.
In a table, there could be any number of rows and specified number of columns.
In a table, there could be any number of columns and specified number of rows.
In a table, there could be specified number of rows and specified number of columns.
What does this SQL database language design to?
Maintain the data in hierarchal database management systems.
Maintain the data in relational database management systems.
Maintain the data in network database management systems.
Maintain the data in object-oriented database management systems.
What does the SELECT Statement do?
Data is read from the SQL database by this statement and displayed to the database user.
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.
GROUP BY clause is placed before which clause in SQL?
HAVING
WHERE
ORDER BY
FROM
Using the ___ statement, a database can be renamed.
SQL CREATE DATABASE
SQL RENAME DATABASE
SQL DROP DATABASE
SQL SELECT DATABASE
Comments whose starting and ending lines are different are known as
Inline Comments
Multi-line Comments
Single Line Comments
Varied line Comments
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
In the case of the ____ Independence Rule, It shouldn't make a difference what the user sees (application) if the logical structure changes.
Physical Data
Logical Data
Integrity
Distribution
What does the DESCRIBE Statement do?
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
By executing this SQL statement, all records in the SQL database will be deleted.
Specify the columns of the table in this SQL statement to return distinct values.
The data specified in this table or view is reported in this SQL statement.
Which of the following statement is TRUE about SQL Injection?
SQL Injection is an Object Penetration Technique
SQL Injection is a Function Penetration Technique
SQL Injection is a Code Penetration Technique
SQL Injection is a Database Penetration Technique