Test Your Programming Skills with Safcode!

---

Here is all important interview / exams questions.
Student doing practice apptitude test on safcode platform.
Instruction: "Total Number of Questions: 20
Each question carry 10 mark , no negative marking"

---

Quiz Start

1. which of the following commands is used view the default installed database? DISPLAY DATABASE
SHOW DATABASE
VIEW DATABASE
SELECT DATABASE

View Answer

2. Character? limit to create database name in mysql? 64
40
54
44

View Answer

3. Which of the following function returns the number of unique values in a column? COUNT(expression)
COUNT(DISTINCT)
COUNT(*)
sUM()

View Answer

4. What SQL clause is used to restrict the rows returned by a query? Where
And
From
Having

View Answer

5. A good example of a distributed application is ____________. System application
Collaboration application
Twitter
Computer application

View Answer

6. How much storage space does DATETIME require? 8 bytes
4 bytes
2 bytes
1 byte

View Answer

7. Which of the following command is used to select a particular database? Show
Display
USE
Select

View Answer

8. ______________ Command is used to remove rights or privileges from user accounts REMOVE
DELETE
CANCEL
REVOKE

View Answer

9. Which is the default order of sort in ORDER BY clause? Ascending
Descending
Not in Order by Default
Both Ascending and Descending

View Answer

10. Hot data means: Data being processed
Data in Database
Data not in use
Data which is not processed

View Answer