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
WordPress Development
Tutorials
Feedback
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. which of the following commands is used view the default installed database?
VIEW DATABASE
DISPLAY DATABASE
SELECT DATABASE
SHOW DATABASE
View Answer
2. Character? limit to create database name in mysql?
44
40
54
64
View Answer
3. A view is nothing but a ________ table.
Real
Static
Dynamic
Virtual
View Answer
4. Which of the following command is used to select a particular database?
Select
Display
Show
USE
View Answer
5. A good example of a distributed application is ____________.
Twitter
Computer application
System application
Collaboration application
View Answer
6. Which of the following function returns the number of unique values in a column?
COUNT(DISTINCT)
COUNT(expression)
sUM()
COUNT(*)
View Answer
7. A__________ is used to group related files that together store a database object
Data Sheet
Data file
MetaData
Filegroup
View Answer
8. Which of the following command is used to get current date/time?
select curdate();
select curtime();
All of Them
select currenttime();
View Answer
9. ________________ 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
Scalability
CPU Utilization
Performance optimization
Performance
View Answer
10. What is a candidate key?
Used to uniquely identify a Tuple
Alias for foreign key
Used to identify a column
None of Them
View Answer
11. Which is the default order of sort in ORDER BY clause?
Both Ascending and Descending
Descending
Not in Order by Default
Ascending
View Answer
12. Microsoft SQL Server data base engine provides a relational__________ named as Azure SQL Database.
All of them
Infrastructure as a service (IAAS)
Database-As-A Service (DBaaS)
Platform as a Service (PaaS)
View Answer
13. A view is a __________ Table.
Real
Virtual
Dynamic
Static
View Answer
14. Which MySQL statement is used to delete data from a database?
EDIT
REMOVE
COLLAPSE
DELETE
View Answer
15. ______________ Command is used to remove rights or privileges from user accounts
CANCEL
REMOVE
REVOKE
DELETE
View Answer
16. A_________ attribute may itself contain two or more attributes, which represent basic attribute having independent meanings of their own.
Composite
Derived
multi-valued
Dependent
View Answer
17. How much storage space does DATETIME require?
2 bytes
1 byte
4 bytes
8 bytes
View Answer
18. Which of the following are types of synchronization?
Asynchronous
None of them
Semisychronous
Both Asynchronous & Semisychronous
View Answer
19. Hot data means:
Data which is not processed
Data in Database
Data being processed
Data not in use
View Answer
20. A systematic collection of data stored in a central location is known as?
Excel
None of Them
Database
CSV
View Answer