Q. |
Which statement in SQL allows us to change the definition of a table is?
Show Answer
|
Q. |
The virtual table that its created by data from the result of an SQL Select statement is called _________
Show Answer
|
Q. |
A database language used for defining the whole databasestructureand schema is called :
Show Answer
|
Q. |
What is the full form of DDL ?
B.
Detailed Data Language
C.
Data Definition Language
D.
Data Derivation Language
Answer :
Data Definition Language
Show Answer
|
Q. |
Which function is used to divides one numeric expression by another and get the remainder ?
Show Answer
|
Q. |
Which data type can store unstructured data in a column?
Show Answer
|
Q. |
The COUNT function in SQL returns the number of ______________
Show Answer
|
Q. |
DCL provides commands to performactionslike
A.
Change thestructureof Tables
B.
Insert, Update or Delete Records and Values
C.
Authorizing Access and othercontrolover Database
Answer :
Authorizing Access and othercontrolover Database
Show Answer
|
Q. |
Which of the following is a legal expression in SQL?
A.
SELECT NULL FROM SALES;
B.
SELECT NAME FROM SALES;
C.
SELECT * FROM SALES WHEN PRICE = NULL;
Answer :
SELECT NAME FROM SALES;
Show Answer
|
Q. |
A SQL query automatically eliminates duplicates (True / False) ?
Show Answer
|