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. ________________ is the capability of a system, network, or process to manage a growing amount of work, or its ability to enlarge so as to adapt to that growth Performance optimization
Performance
CPU Utilization
Scalability

View Answer

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

View Answer

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

View Answer

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

View Answer

5. Which MySQL statement is used to delete data from a database? DELETE
COLLAPSE
EDIT
REMOVE

View Answer

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

View Answer

7. Which of the following command is used to get current date/time? All of Them
select curtime();
select currenttime();
select curdate();

View Answer

8. Which of the following are types of synchronization? None of them
Both Asynchronous & Semisychronous
Semisychronous
Asynchronous

View Answer

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

View Answer

10. A view is a __________ Table. Static
Dynamic
Real
Virtual

View Answer