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. 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

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

View Answer

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

View Answer

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

View Answer

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

View Answer

6. ________________ 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
CPU Utilization
Performance
Scalability

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer