Safcode | Code Your Ideas by Sir Safder
Ideas & Topics!
HTML & CSS
Amazon Virtual Assistant
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"
1. Character? limit to create database name in mysql?
2. A view is nothing but a ________ table.
3. What SQL clause is used to restrict the rows returned by a query?
4. Which MySQL statement is used to delete data from a database?
5. ______________ Command is used to remove rights or privileges from user accounts
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)
7. A view is a __________ Table.
8. Which is the default order of sort in ORDER BY clause?
Not in Order by Default
Both Ascending and Descending
9. A systematic collection of data stored in a central location is known as?
None of Them
10. which of the following commands is used view the default installed database?
11. What is a candidate key?
Used to uniquely identify a Tuple
None of Them
Alias for foreign key
Used to identify a column
12. A_________ attribute may itself contain two or more attributes, which represent basic attribute having independent meanings of their own.
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
14. Which of the following command is used to select a particular database?
15. A__________ is used to group related files that together store a database object
16. Hot data means:
Data which is not processed
Data in Database
Data being processed
Data not in use
17. Which of the following are types of synchronization?
None of them
Both Asynchronous & Semisychronous
18. A good example of a distributed application is ____________.
19. Which of the following command is used to get current date/time?
All of Them
20. Which of the following function returns the number of unique values in a column?