wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

SQL Server and OOP Concepts Quiz

Total questions: 60

Worksheet time: 30mins

Name
Class
Date
1.

Stored (a)   are reusable SQL scripts that can perform operations such as querying, updating, or modifying data.

2.

SSOX supports multiple database systems.

a)

True

b)

False

3.

(a)   are automated scripts that run in response to specific database events like INSERT, UPDATE, or DELETE.

4.

Seamless Integration means that integration of (a)   with Visual Studio enables you to manage both the application and its database from a single interface.

5.

SQL Server Express typically runs in user mode and is designed for simplified setup.

a)

True

b)

False

6.

SSOX is a lightweight version of the SQL Server Express Database Engine.

a)

True

b)

False

7.

SSOX allows users to connect to both local and cloud-based databases.

a)

True

b)

False

8.

SSOX provides a visual editor to design and modify table schemas.

a)

True

b)

False

9.

SQL Server Object Explorer (SSOX) is integrated within Microsoft Visual Studio.

a)

True

b)

False

10.

SSOX allows developers and database administrators to manage and interact with databases directly from the Visual Studio environment.

a)

True

b)

False

11.

(a)   are reusable SQL code that can return a single value (scalar functions) or a table (table-valued functions).

12.

SSOX starts on demand by using a connection string.

a)

True

b)

False

13.

In SSOX, users can browse through database objects.

a)

True

b)

False

14.

Tables are used to store the core data in relational databases.

a)

True

b)

False

15.

Clear (a)   Structure: means objects are displayed in an organized, tree-structured layout, making it easy to find and interact with database components.

16.

(a)   are virtual tables based on SQL queries.

17.

SSOX allows the user to manage server objects like databases, logins, jobs, and linked servers within SQL Server instances.

a)

True

b)

False

18.

(a)   are database structures that improve the speed of data retrieval operations.

19.

Quick Access to (a)   Operations means right-clicking on any object reveals a context menu with essential actions like View Data, Modify, Delete, and Script.

20.

SSOX is installed by default with Visual Studio.

a)

True

b)

False

21.

SSOX offers a graphical interface for interacting with database objects.

a)

True

b)

False

22.

Developers and database administrators use SQL Server Object Explorer (SSOX) within Visual Studio to access and manage databases without leaving the development environment.

a)

True

b)

False

23.

Query execution allows running SQL queries directly from Visual Studio using the SQL Query Editor.

a)

True

b)

False

24.

(a)   are used to store the core data in relational databases.

25.

SSOX lets you view data stored in tables and allows inline editing of records directly within the Visual Studio interface.

a)

True

b)

False

26.

Which of the following is NOT one of the four basic principles of Object-Oriented Programming?

a)

Abstraction

b)

Encapsulation

c)

Compilation

d)

Polymorphism

27.

What file extension do User Controls in ASP.NET use?

a)

.aspx

b)

.ascx

c)

.vb

d)

.cs

28.

Which data source control is used to bind to hierarchical data like XML files?

a)

SqlDataSource

b)

AccessDataSource

c)

XmlDataSource

d)

ObjectDataSource

29.

Which of the following allows a class to inherit properties and methods from another class?

a)

Encapsulation

b)

Inheritance

c)

Polymorphism

d)

Abstraction

30.

What is the purpose of a constructor in a class?

a)

To destroy the object

b)

To initialize the object

c)

To hide data

d)

To inherit properties

31.

Which OOP principle focuses on hiding implementation details and protecting data within a class?

a)

Abstraction

b)

Inheritance

c)

Encapsulation

d)

Polymorphism

32.

What principle of OOP is described as "focusing only on the most important information about an object"?

a)

Encapsulation

b)

Inheritance

c)

Abstraction

d)

Polymorphism

33.

Which of the following is a tabular data source control?

a)

SiteMapDataSource

b)

XmlDataSource

c)

SqlDataSource

d)

None of the above

34.

Static classes contain members that:

a)

Can only be accessed by creating an instance

b)

Can be accessed without creating an instance

c)

Cannot be accessed at all

d)

Are always private

35.

What is the main purpose of an Interface in OOP?

a)

To create objects

b)

To define a contract that classes must implement

c)

To store data

d)

To hide implementation details

36.

Which OOP principle allows different classes to share the same method name but implement it differently?

a)

Encapsulation

b)

Inheritance

c)

Polymorphism

d)

Abstraction

37.

What does the term "Polymorphism" allow in programming?

a)

Data hiding

b)

Code reusability through inheritance

c)

Different classes to share the same method name but implement it differently

d)

Object creation

38.

Custom controls in ASP.NET are deployed as:

a)

.ascx files

b)

.aspx files

c)

Dynamic Link Library (DLL)

d)

XML files

39.

Which of the following is used to organize and group related classes into a hierarchy?

a)

Interface

b)

Namespace

c)

Constructor

d)

Destructor

40.

The ObjectDataSource control enables binding to:

a)

XML files

b)

Custom .NET business objects

c)

SQL Server only

d)

Microsoft Access databases

41.

What is the main purpose of Encapsulation?

a)

To inherit properties

b)

To hide implementation details and protect data

c)

To allow multiple implementations

d)

To focus on important details

42.

Which OOP concept is described as "passing traits from one thing to another"?

a)

Abstraction

b)

Encapsulation

c)

Inheritance

d)

Polymorphism

43.

What is the correct way to call a base class constructor in C#?

a)

base()

b)

super()

c)

parent()

d)

main()

44.

Which design pattern is commonly used in ASP.NET Core to separate business logic, presentation, and user interaction?

a)

Singleton

b)

MVC (Model-View-Controller)

c)

Factory

d)

Observer

45.

User Controls in ASP.NET are derived from which class?

a)

System.Web.UI.Page

b)

System.Web.UI.Control

c)

System.Web.UI.UserControl

d)

System.Web.UI.WebControl

46.

Which data binding type involves attaching any collection that implements the IEnumerable interface?

a)

Declarative data binding

b)

Complex data binding

c)

Simple data binding

d)

Hierarchical data binding

47.

What is a "destructor" used for in C#?

a)

To initialize objects

b)

To release resources when an object is destroyed

c)

To inherit properties

d)

To define interfaces

48.

Which OOP component defines a template or blueprint from which objects are created?

a)

Object

b)

Method

c)

Class

d)

Property

49.

The SqlDataSource control connects to data using which two important properties?

a)

DataFile and SelectCommand

b)

ConnectionString and ProviderName

c)

DataSource and DataMember

d)

CommandText and Parameters

50.

What does OOP stand for?

a)

Object-Oriented Programming

b)

Object-Optimized Programming

c)

Operational Object Programming

d)

Organized Object Procedures

51.

Which of the following is NOT a characteristic of User Controls?

a)

They have an .ascx extension

b)

They may contain or tags

c)

They have a Control directive instead of a Page directive

d)

They behave like miniature ASP.NET pages

52.

Which of the following is NOT a tabular data source control?

a)

SqlDataSource

b)

ObjectDataSource

c)

AccessDataSource

d)

SiteMapDataSource

53.

What is the relationship between a class and an object?

a)

An object is a blueprint for a class

b)

A class is a specific instance of an object

c)

An object is a specific instance of a class

d)

They are the same thing

54.

Which method do all ASP.NET web form controls inherit for data binding?

a)

BindData()

b)

DataBind()

c)

LoadData()

d)

AttachDataSource()

55.

What is the main benefit of using Namespaces in C#?

a)

To create objects

b)

To avoid name conflicts and organize code

c)

To improve performance

d)

To enable inheritance

56.

The AccessDataSource control is based on which other control?

a)

XmlDataSource

b)

ObjectDataSource

c)

SqlDataSource

d)

LinqDataSource

57.

Which OOP principle helps in code reusability by allowing new classes to be based on existing ones?

a)

Abstraction

b)

Encapsulation

c)

Polymorphism

d)

Inheritance

58.

In ASP.NET Core, methods and properties are used to:

a)

Only display data

b)

Connect to databases only

c)

Define behavior and characteristics of classes

d)

Create user interfaces

59.

Which of the following best describes "Abstraction" in OOP?

a)

Hiding implementation details

b)

Protecting data within a class

c)

Focusing on essential features while ignoring less relevant details

d)

Allowing multiple forms of the same method

60.

What is the primary purpose of the "using" directive in C#?

a)

To create objects

b)

To import namespaces

c)

To define interfaces

d)

To implement inheritance

Similar Resources on Wayground

Pengenalan Kecerdasan Buatan

60 questions

Pengenalan Kecerdasan Buatan

quiz

Worksheet

•

10th Grade - University

TIK MANAJEMEN PENDIDIKAN AP KLS B

60 questions

TIK MANAJEMEN PENDIDIKAN AP KLS B

quiz

Worksheet

•

University

Wireshark Assessment

60 questions

Wireshark Assessment

quiz

Worksheet

•

University

Network+ Days 1 - 10

65 questions

Network+ Days 1 - 10

quiz

Worksheet

•

University

Soal Tes Wawasan Kebangsaan Paskibraka

57 questions

Soal Tes Wawasan Kebangsaan Paskibraka

quiz

Worksheet

•

University

Text, Visual, Audio and Motion Media Quiz #2

62 questions

Text, Visual, Audio and Motion Media Quiz #2

quiz

Worksheet

•

11th Grade - University

S2 Sumatif Kelas 4 - Microsoft Powerpoint & Presentasi

60 questions

S2 Sumatif Kelas 4 - Microsoft Powerpoint & Presentasi

quiz

Worksheet

•

4th Grade - University

Ujian Akhir Semester (UAS) Keamanan Sistem

60 questions

Ujian Akhir Semester (UAS) Keamanan Sistem

quiz

Worksheet

•

University