SAFCODE

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: 10
Each question carry 10 mark , no negative marking"

---

Quiz Start

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

View Answer

2. What is a candidate key? Used to identify a column
Alias for foreign key
Used to uniquely identify a Tuple
None of Them

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

10. A_________ attribute may itself contain two or more attributes, which represent basic attribute having independent meanings of their own. Composite
Dependent
multi-valued
Derived

View Answer