Become a GOLD member of Deccansoft and get access to 40+ courses!!
NewBatches/Webinars
Packages
Gold Membership
Bestseller
Microsoft Azure Suite & Suite Plus
Power Platform Acadamy
New
Azure DevOps Expert & Expert Plus
MS.NET Foundation For Beginners
MS.NET Full Stack Developer
UI / Web Development
SQL Server & MSBI Tools
Software Testing
Courses
MS.NET Courses (Includes Live Project)
Complete C#, OOPs and Windows Programing
ASP.NET MVC Online Training
ASP.NET WebForms
ASP.NET Core
WCF incl. Web Services and Remoting
WPF incl. MVVM and Prism
LINQ and Entity Framework
Live Project Training for Developing Enterprise Application
Live Project using Ntier Arch (.NET5 + EF Core + Angular)
Microservices using .NET Core
Gold Membership
CareerStep IT Program
Client-side UI Technologies
Building Static Web Pages using HTML and CSS
JavaScript and HTML DOM
jQuery, AJAX and JSON
Building Interactive Web Pages using HTML5 and CSS3
BootStrap + Live Examples
AngularJS + Live Project
Angular + Typescript
ReactJS
KnockoutJS
Xamarin
SQL Server + MSBI
SQL Server 2017
Querying Data with Transact-SQL(70-761)
SQL Server Integration Service (SSIS)
SQL Server Reporting Service (SSRS)
SQL Service Analysis Service (SSAS)
Cloud Computing / Azure / AWS
AZ-900: Microsoft Azure Fundamentals
Azure Suite (AZ-104+AZ-204+AZ-305+ AZ-500)
AZ-104: Microsoft Azure Administrator
AZ-204: Developing Solutions for Microsoft Azure
AZ-305: Microsoft Azure Architect Technologies and Design
DP-203: Data Engineering on Microsoft Azure
Amazon Web Services (AWS)
DevOps Expert
AZ-400: Microsoft Azure DevOps
Docker by Sandeep Soni
Kubernetes by Sandeep Soni
Docker & Kubernetes by Rahul Rampurkar
IaC Using Terraform
Powershell
Microsoft Power Platform
Microsoft Power Platform
Data Analytics using PowerBI (DA-100)
Testing Tools
Manual Testing
Selenium Testing with Java(Live Training)
Others
Python Programming
C and Data Structure
Core Java
OOPs and C++
Advance Java
Complete Azure Training
Pricing
Videos
Testimonials
Azure Certification
Contact Us
Login
Login or Register
×
Sign In
Register
Forgot Password?
How did you find us
WhatsApp
YouTube
LinkedIn
Facebook
Telegram
Twitter
Google
Referred by Friend
Refresh
Input symbols
By clicking Register, you accept to the
terms and conditions
and that you have read our
privacy policy.
Recover Password
×
Submit
Enquiry Now
Where did you come to know about us
WhatsApp
YouTube
LinkedIn
Facebook
LinkedIn Ad
Email
Twitter
Google
Referred
Other
Refresh
Input symbols
Introduction to SQL Server
Interview Questions and Answer
1. How many types of authentication are provided in SQL Server
Options:
a. 1
b. 3
c. 2
Reveal Answer
2. How is a named instance of SQL Server identified?
Options:
a. By the Network name of the computer
b. By the instance name
c. By both the instance name and the network name of the computer
Reveal Answer
3. Can we install more than one instance of the SQL Server?
Options:
a. Yes
b. No
Reveal Answer
4. What kind of data does nchar data type hold?
Options:
a. Unicode
b. Non-unicode
Reveal Answer
5. Which of the following is true regarding a bit data type?
Options:
a. It is an integer data type
b. It can hold either a 0 or 1 value
c. It can hold either true or false value
Reveal Answer
6. Can we create a user defined data type?
Options:
a. Yes
b. No
Reveal Answer
7. How many system databases are present in SQL Server
Options:
a. 3
b. 4
Reveal Answer
8. The SQL Server cannot start if which of the following databases is not present?
Options:
a. Model
b. Master
c. Msdb
Reveal Answer
9. Which system database functions as a template database?
Options:
a. Master
b. Msdb
c. Model
d. Tempdb
Reveal Answer
10. Which database is recreated everytime the SQL Server starts?
Options:
a. Master
b. Msdb
c. Model
d. Tempdb
Reveal Answer
11. The tempdb database is created from the model dtabase
Options:
a. true
b. false
Reveal Answer
12. Which of the following data type stores variable length characters?
Options:
a. varchar
b. nvarchar
Reveal Answer
13. ________ language allows u to create,alter and delete database objects
Options:
a. DML
b. DDL
c. DCL
d. DQL
Reveal Answer
14. ______ an organized form of data for easy access, storing,retrieval and managing of data.
Options:
a. FIELD
b. DATA
c. RECORD
d. DATABASE
Reveal Answer
15. _______is a combination of fields which uniquely specify a row.
Options:
a. PRIMARY KEY
b. FOREIGN KEY
c. INSERT KEY
d. JOIN
Reveal Answer
16. ______ is a standard language used to perform tasks such as to retrieve, update, insert and delete of data from a database
Options:
a. DQL
b. SQL
c. RDBMS
d. DATABASE
Reveal Answer
17. _______is a set of data that are organized in a model with Columns and Rows.
Options:
a. DATA
b. FIELD
c. TABLE
d. RECORD.
Reveal Answer
18. A table contains specified number of column called ___________
Options:
a. FIELD
b. DATA
c. RECORD
d. TABLE
Reveal Answer
19. A field can have any number of rows which is known as
Options:
a. DATA
b. RECORD
c. DATABASE
d. FIELD
Reveal Answer
20. What are the disadvantages of File Management System
Options:
a. EFFICIENT DATA STORAGE
b. SECURITY
c. DATA INCONSISTENCY
d. NON OF THESE
Reveal Answer
21. What are the advantages of Data Base Management System
Options:
a. DATA REDUNDANCY
b. DIFFICULTY IN ACCESSING DATA
c. EFFICIENT DATA STORAGE
d. SECURITY PROBLEM
Reveal Answer
22. Which level is the lowest level of abstraction
Options:
a. LOGICAL LEVEL
b. PHYSICAL LEVEL
c. VIEW LEVEL
d. ALL OF THESE
Reveal Answer
23. Which level is the user's view of data base
Options:
a. VIEW LEVEL
b. LOGICAL LEVEL
c. PHYSICAL LEVEL
d. NON OF THESE
Reveal Answer
24. Which was the first data base model
Options:
a. RELATIONAL MODEL
b. HIERARICHICAL MODEL
c. NETWORK MODEL
d. RELATION MODEL
Reveal Answer
25. A named property or characteristic of an entity is
Options:
a. ENTITY
b. ATTRIBUTE
c. ENTITY SET
d. DATA
Reveal Answer
26. _____________ is the step by step process of decomposing the data into tables and establishing a Relationship between them
Options:
a. DATABASE
b. NORMALIZATION
c. RECORD
d. TABLE
Reveal Answer
27. ___________ statement is used to retrieve data in the database.
Options:
a. UPDATE
b. DELETE
c. INSERT
d. SELECT
Reveal Answer
Packages
Gold Membership
Microsoft Azure Suite &Suite Plus
Azure DevOps Expert &Expert Plus
MS.NET Foundation For Beginners
MS.NET Full Stack Developer
UI / Web Development
SQL Server & MSBI Tools
Software Testing
Resources
Blog
Deccansoft
AzureA2Z
Wall of Fame
On-Job Tech Support
About
About BestDotNetTraining
About Trainer
Testimonials
FAQ
Other links
About Us
Contact Us
Leave us a feedback
Sitemap
Privacy Policy
Terms & Conditions
Proudly Powered by