IncludeHelp_logo
Skip Navigation Links

Home » Aptitude Questions & Answers » DBMS Aptitude Questions

SQL Functions Aptitude Questions and Answers | Set 2

List of SQL Functions - Aggregate and Scalar Aptitude Questions

6) Which SQL command is used to get total number of records of a table?
  1. SELECT (*) FROM table_name
  2. SELECT COUNT FROM table_name
  3. SELECT COUNT(*) FROM table_name
  4. None of these
Answer

7) Which command is used to get total number of Unique cities from employee table?
  1. SELECT COUNT(*) FROM employee
  2. SELECT COUNT(UNIQUE cities) FROM employee
  3. SELECT DISTINCT COUNT(cities) FROM employee
  4. SELECT COUNT(DISTINCT cities) FROM employee
Answer

8) Which command is correct command to get first city name from cities column in employee table?
  1. SELECT FIRST(cities) FROM employee
  2. SELECT FIRST cities FROM employee
  3. SELECT (cities) FIRST FROM employee
  4. SELECT cities FROM employee
Answer

9) Which command is correct to find sum of all values of particular column?
  1. SELECT SUM column_name FROM table_name
  2. SELECT SUM(column_name) FROM TABLE table_name
  3. SELECT FROM table_name SUM(column_name)
  4. SELECT SUM(column_name) FROM table_name
Answer

10) Which command is correct to print column values in upper case?
  1. SELECT UCASE(column_name) FROM table_name
  2. SELECT UCASE column_name FROM table_name
  3. SELECT UCASE(column_name) FROM TABLE table_name
  4. SELECT UCASE column_name FROM TABLE table_name
Answer

SQL Functions Aptitude Questions | Set 1
SQL Functions Aptitude Questions | Set 3




Comments and Discussions!

Load comments ↻




Top MCQs
Top Programs/Examples
Top Tutorials
About
Student's Section
Subscribe

Copyright © 2024 www.includehelp.com. All rights reserved.