Safcode | Code Your Ideas by Sir Safder
+923132835245
safcodeinstitute@gmail.com
Online Quiz
10000+ Questions!
Students Works
Ideas & Topics!
Live Coding
HTML & CSS
Home
(current)
About
Courses
CIT
Web Designing
Office Automation
Graphics Designing
Web Development
Software Development
Digital Marketing
App Development
Amazon Virtual Assistant
YouTube Earning
Tutorials
Softwares
Programming Notes
Contact
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?
64
54
44
40
View Answer
2. Which of the following command is used to select a particular database?
Show
Display
USE
Select
View Answer
3. Which of the following are types of synchronization?
Asynchronous
Both Asynchronous & Semisychronous
None of them
Semisychronous
View Answer
4. A view is nothing but a ________ table.
Virtual
Dynamic
Real
Static
View Answer
5. Which of the following function returns the number of unique values in a column?
sUM()
COUNT(expression)
COUNT(*)
COUNT(DISTINCT)
View Answer
6. A view is a __________ Table.
Static
Real
Virtual
Dynamic
View Answer
7. ________________ 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
CPU Utilization
Performance
Scalability
Performance optimization
View Answer
8. How much storage space does DATETIME require?
8 bytes
1 byte
2 bytes
4 bytes
View Answer
9. A good example of a distributed application is ____________.
Collaboration application
Twitter
Computer application
System application
View Answer
10. A_________ attribute may itself contain two or more attributes, which represent basic attribute having independent meanings of their own.
Dependent
multi-valued
Composite
Derived
View Answer
11. What SQL clause is used to restrict the rows returned by a query?
And
From
Having
Where
View Answer
12. Hot data means:
Data which is not processed
Data being processed
Data not in use
Data in Database
View Answer
13. Which MySQL statement is used to delete data from a database?
REMOVE
DELETE
EDIT
COLLAPSE
View Answer
14. which of the following commands is used view the default installed database?
SHOW DATABASE
SELECT DATABASE
DISPLAY DATABASE
VIEW DATABASE
View Answer
15. A__________ is used to group related files that together store a database object
MetaData
Data file
Data Sheet
Filegroup
View Answer
16. Microsoft SQL Server data base engine provides a relational__________ named as Azure SQL Database.
Database-As-A Service (DBaaS)
Infrastructure as a service (IAAS)
All of them
Platform as a Service (PaaS)
View Answer
17. Which is the default order of sort in ORDER BY clause?
Both Ascending and Descending
Descending
Ascending
Not in Order by Default
View Answer
18. What is a candidate key?
None of Them
Alias for foreign key
Used to identify a column
Used to uniquely identify a Tuple
View Answer
19. A systematic collection of data stored in a central location is known as?
None of Them
CSV
Database
Excel
View Answer
20. Which of the following command is used to get current date/time?
All of Them
select curdate();
select curtime();
select currenttime();
View Answer