-
You can combine all the records that have identical values in a particular field or a group of fields by using ORDER BY statement
A)
True
done
clear
B)
False
done
clear
C)
None of theses
done
clear
D)
All of the above
done
clear
View Answer play_arrow
-
To filter the conditions for groups, WHERE clause is used,
A)
True
done
clear
B)
False
done
clear
C)
None of theses
done
clear
D)
All of the above
done
clear
View Answer play_arrow
-
Single row function and ............................ Function are the two type of functions supported by MySql.
A)
scalar functions
done
clear
B)
multi row functions
done
clear
C)
both a and b
done
clear
D)
none of the above
done
clear
View Answer play_arrow
-
............................function is also termed as Group Functions.
A)
aggregate
done
clear
B)
scalar
done
clear
C)
both a and b
done
clear
D)
none of the above
done
clear
View Answer play_arrow
-
.......................... statement helps you to consider only unique values from the given column.
A)
all
done
clear
B)
distinct
done
clear
C)
both a and b
done
clear
D)
none of the above
done
clear
View Answer play_arrow
-
To count the total number of records in a table, we use sum() function.
A)
True
done
clear
B)
False
done
clear
C)
None of theses
done
clear
D)
All of the above
done
clear
View Answer play_arrow
-
....................clause is used to specify filtering condition for groups.
A)
where
done
clear
B)
having
done
clear
C)
group by
done
clear
D)
none of the above
done
clear
View Answer play_arrow
-
Group functions can be applied on any data type i.e. numeric, date, string.
A)
True
done
clear
B)
False
done
clear
C)
None of theses
done
clear
D)
All of the above
done
clear
View Answer play_arrow
-
Which of the following is not an aggregate functions
A)
Max()
done
clear
B)
AVG()
done
clear
C)
SUM()
done
clear
D)
WITH()
done
clear
View Answer play_arrow
-
.........................function applied on Integer (numeric) column which returns the heighest value from the column
A)
MAX()
done
clear
B)
MAXIMUM()
done
clear
C)
LARGEST()
done
clear
D)
BIG()
done
clear
View Answer play_arrow
-
A .....................is a column of a relation which uniquely identifies each row of a table.
A)
Primary Key
done
clear
B)
Candidate Key
done
clear
C)
Alternate Key
done
clear
D)
Foreign Key
done
clear
View Answer play_arrow
-
...................commands are used to change the structure of the table
A)
TCL/DCL
done
clear
B)
DDL
done
clear
C)
DML
done
clear
D)
none of the above
done
clear
View Answer play_arrow
-
To change data stored in the table, you will use.....................commands
A)
TCL/DCL
done
clear
B)
DDL
done
clear
C)
DML
done
clear
D)
none of the above
done
clear
View Answer play_arrow
-
DELETE and UPDATE commands comes under................command
A)
TCL/DCL
done
clear
B)
DDL
done
clear
C)
DML
done
clear
D)
none of the above
done
clear
View Answer play_arrow
-
Write a query to display the record of all students from "Study" table whose last name contains 6 letters ending with "A".
A)
done
clear
B)
done
clear
C)
done
clear
D)
done
clear
View Answer play_arrow
-
Write a query to return the number of not null records in the Project field of" Study" table?
A)
done
clear
B)
done
clear
C)
done
clear
D)
done
clear
View Answer play_arrow
-
Write a query to find the average salary of all employee from Salary field of "Employee" table
A)
SELECT AVERAGE(SALARY) FROM EMP;
done
clear
B)
SELECT AVG(SALARY) FROM EMP;
done
clear
C)
SELECT SALARY(AVG) FROM EMPLOYEE;
done
clear
D)
None of the above.
done
clear
View Answer play_arrow
-
Select correct SQL query from below to find the temperature in increasing order of all cities from weather table
A)
SELECT city FROM weather ORDER BY temperature;
done
clear
B)
SELECT city, temperature FROM weather;
done
clear
C)
SELECT city, temperature FROM weather ORDER BY temperature;
done
clear
D)
SELECT city, temperature FROM weather ORDER BY city;
done
clear
View Answer play_arrow
-
................wild card (symbol) is used for matching a single character in a string.
A)
done
clear
B)
done
clear
C)
%
done
clear
D)
-
done
clear
View Answer play_arrow
-
The HAVING clause does which of the following?
A)
Acts EXACTLY like a WHERE clause.
done
clear
B)
Acts like a WHERE clause but is used for columns rather than groups.
done
clear
C)
Acts like a WHERE clause but is used for group rather than rows.
done
clear
D)
Acts like a WHERE clause but is used for rows rather than columns.
done
clear
View Answer play_arrow