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. A systematic collection of data stored in a central location is known as? Database
Excel
CSV
None of Them

View Answer

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

View Answer

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

View Answer

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

View Answer

5. A__________ is used to group related files that together store a database object Data file
Filegroup
Data Sheet
MetaData

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer