In order to manage or store the data in the database, WEB SQL Database is used which is a
Web site
Web page
Web browser
None of the above
Correct Answer :
B. Web page
In order to manage or store the data in the database, WEB SQL Database is used which is a Webpage.
Related Questions
What is the functionality of SQL COUNT?
It returns the no of record of table
It returns the no of record of database
It returns the no of record of row
It returns the no of record of column
Which one of the syntaxes given below is of Binary Operator?
Operator SQL _Operand
Operand2 SQL _Operator Operand1
Operand1 SQL _Operator Operand1
Operand1 SQL _Operator Operand2
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
Which of the following statement is correct?
Comparison Operator has higher precedence than Conjuction Operator.
Identity Operator has higher precedence than Multiplication Operator.
Both A and B
None of the above
In order to format, how the column should be displayed, which function is used?
FORM()
DISPLAY()
COL()
FORMAT()
What is the difference between UNION & UNION ALL operators?
Combining the results of two select statements will be done using UNION whereas combined records from both queries are returned by UNION ALL operator.
Combining the results of two select statements will be done using UNION ALL whereas combined records from both queries are returned by UNION operator.
After performing the UNION operation, duplicate rows will not be removed whereas after performing the UNION ALL operation, duplicate rows will be removed.
None of the above
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
SQL ___ can be used to delete or drop existing databases in a SQL schema.
CREATE DATABASE
RENAME DATABASE
DROP DATABASE
SELECT DATABASE
Commands that comes under DDL is/are
CREATE
DROP
TRUNCATE
All of the above
Savepoint command is used with _____ command.
Commit
Transaction
Rollback
None of the above
Host-based IDS can be used to monitor
Web server logs
When something weird occurs
Both A) and B)
None of the above
Using the SQL last() function, one can return the ______ value of the selected column.
First
Second
Third
Last
What is TRUE about SQL EXCEPT clause?
The result is purged of duplicates
Duplicate records are not removed
Only one column can be compared by a clause
None of the above
What does SQL stand for?
SQL stands for Sample Query Language
SQL stands for Structured Query List
SQL stands for Structured Query Language
SQL stands for Sample Query List
When two or more columns are combined to be used to uniquely identify each row in the table, it is known as -
Primary Key
Unique Key
Composite Key
Foreign Key
Which of the following is a SQL Logical Operator?
SQL ALL Operator
SQL OR Operator
SQL LIKE Operator
All of the above
Which of the following statement is true?
SQL statements are used for most operations in a database.
Relational algebra and tuple relationship calculus are needed for SQL syntax.
All of the above
None of the above
In case of ____ data, recursive CTE is used?
Round
Hierarchal
Linear
None of the above
Which of the following clause cannot be optional in SQL SELECT Statement?
WHERE
GROUP BY
ORDER BY
None of the above
Select the statement which is TRUE?
In case a transaction is rolled back, the data allied with table variable also get rolled back.
In case a transaction is rolled back, the data allied with table variable does not roll back.
In case a transaction is not rolled back, the data allied with table variable get rolled back.
None of the above.
Primary keys can be contained in a table only ____?
Once
Twice
Thrice
None of the above
In order to sort the records according to the columns, which clause is used?
HAVING
GROUP BY
ORDER BY
None of the above
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.
Full form of DCL is -
Data Control Language
Data Commit Language
Data Common Language
Data Concatenate Language
Which of the following is TRUE about UNIQUE constraint?
In columns that are subject to the UNIQUE constraint, duplicate values are not allowed.
Unique values will always be present in the column containing the unique constraint.
A single table can have more than one unique constraint, since it can be applied to more than one column.
All of the above
In order to build a link between two tables, which key is used?
Primary
Foreign
Composite
Unique
Select the correct order of precedence among the following?
OR > NOT > + > **
NOT > OR > ** > +
** > + > OR > NOT
** > + > NOT > OR
In LIKE clause, to represent a single character, _____ is used.
-
_
!
&
To connect strings, which function is used
CONNECT
ADD
COMBINE
CONCAT
Which clause is used to retrieve a unique element from the table?
SELECT UNIQUE
SELECT DISTINCT
Both A) and B)
None of the above