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 is the default order of sort in ORDER BY clause? Ascending
Both Ascending and Descending
Not in Order by Default
Descending

View Answer

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

View Answer

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

View Answer

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

View Answer

5. Microsoft SQL Server data base engine provides a relational__________ named as Azure SQL Database. All of them
Database-As-A Service (DBaaS)
Infrastructure as a service (IAAS)
Platform as a Service (PaaS)

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer