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. How much storage space does DATETIME require? 8 bytes
2 bytes
4 bytes
1 byte

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

7. A systematic collection of data stored in a central location is known as? Excel
CSV
Database
None of Them

View Answer

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

View Answer

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

View Answer

10. A view is nothing but a ________ table. Real
Static
Dynamic
Virtual

View Answer