Safcode Institute 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
Graphic Designing
Web Development
Digital Marketing
App Development
Amazon Virtual Assistant
YouTube Earning
WordPress Development
Tutorials
Feedback
Programming Notes
Verification
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. Which of the following function returns the number of unique values in a column?
COUNT(*)
sUM()
COUNT(expression)
COUNT(DISTINCT)
View Answer
2. Character? limit to create database name in mysql?
44
40
64
54
View Answer
3. ______________ Command is used to remove rights or privileges from user accounts
DELETE
REVOKE
REMOVE
CANCEL
View Answer
4. What is a candidate key?
None of Them
Used to uniquely identify a Tuple
Used to identify a column
Alias for foreign key
View Answer
5. A_________ attribute may itself contain two or more attributes, which represent basic attribute having independent meanings of their own.
Composite
multi-valued
Dependent
Derived
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
CPU Utilization
Performance
Performance optimization
Scalability
View Answer
7. How much storage space does DATETIME require?
1 byte
8 bytes
2 bytes
4 bytes
View Answer
8. What SQL clause is used to restrict the rows returned by a query?
From
Having
Where
And
View Answer
9. which of the following commands is used view the default installed database?
DISPLAY DATABASE
VIEW DATABASE
SELECT DATABASE
SHOW DATABASE
View Answer
10. Which is the default order of sort in ORDER BY clause?
Not in Order by Default
Both Ascending and Descending
Ascending
Descending
View Answer