SELECT
WHERE
Both A and B
None of the above
C. Both A and B
SELECT
FROM
HAVING
None of the above
Relation, Tuple
Tuple, Tuple
Tuple, Relation
Relation, Relation
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
None of the above
1
2
3
4
Transaction
Commit
Rollback
Control
REVOKE
COMMIT
ROLLBACK
SAVE
USE DATABASES;
SELECT DATABASES;
SHOW DATABASES;
None of the above
UNION
INTERSECT
MINUS
All of the above
SQL Equal Operator
SQL ANY Operator
SQL BETWEEN Operator
SQL IN Operator
ROUND()
MID()
FORMAT()
NOW()
Data Control Language
Data Commit Language
Data Common Language
Data Concatenate Language
Table integrity is not enforced by the primary key.
The data in a primary key is always multiple.
900 bytes is the maximum length of a primary key.
Null values are allowed in primary keys.
SELECT Operand1+Operand2;
SELECT Operand1*Operand2;
SELECT Operand1**Operand2;
Local Temp
Global Temp
Both A) and B)
None of the above
%
_
Both A. and B.
None of the above
IF
AS
WHERE
EXCEPT
7000
8000
9000
10000
FORM()
DISPLAY()
COL()
FORMAT()
Using this command, you can remove or erase recorded information from a database table.
Database objects such as tables, table views, and other objects can be deleted using this command.
One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
It enables you to create new databases, tables, table views, and other objects using this command.
If p comes between 0 to 25, data type becomes FLOAT(). If p comes between 26 to 54, data type becomes DOUBLE().
If p comes between 26 to 54, data type becomes FLOAT(). If p comes between 0 to 25, data type becomes DOUBLE().
If p comes between 25 to 53, data type becomes FLOAT(). If p comes between 0 to 24, data type becomes DOUBLE().
If p comes between 0 to 24, data type becomes FLOAT(). If p comes between 25 to 53, data type becomes DOUBLE().
It cannot ignore the NULL values
It can ignore the NULL values
Its query can return multiple values
None of the above
DATE
TIME
MONTH
DATE & TIME
SQL databases are vertically scalable.
SQL follows BASE Model.
SQL database cannot handle complex queries.
SQL database does not require object-relational mapping.
To add or insert data
To retrieve or fetch data
To update the data
To delete the data
RETRIEVE
SELECT
CREATE
ALTER
AVG()
FIRST()
LAST()
All of the above
Primary Key
Foreign Key
Composite Key
Alternate Key
Relational
Logical
Additional
Unique
SQL CREATE DATABASE
SQL RENAME DATABASE
SQL DROP DATABASE
SQL SELECT DATABASE
Compile the results from two queries
Compile the results from three queries
Compile the results from four queries
Compile the results from five queries