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. Character? limit to create database name in mysql? 44
54
40
64

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

13. ________________ 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
Scalability
Performance

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer