[Trắc Nghiệm] Tìm hiểu về SQL Server - Phần 1

SQL Server/MySQL

[Trắc Nghiệm] Tìm hiểu về SQL Server - Phần 1

Câu hỏi 1: What is defined as an organized collection of data such that its contents can be easily accessed, managed, and updated?

A: Information
B: Database
C: Record
D: Field

Đáp án: B

Câu hỏi 2: According to the source, what is the result of gathered, analyzed, and intelligently interpreted data?

A: Information
B: Database
C: Table
D: Record

Đáp án: A

Câu hỏi 3: In a file-based system, what were the rows in a table called?

A: Fields
B: Attributes
C: Records
D: Items

Đáp án: C

Câu hỏi 4: Which of the following is a disadvantage of file-based systems mentioned in the slides?

A: Data sharing
B: Data redundancy and inconsistency
C: Security implementation
D: Data integrity maintenance

Đáp án: B

Câu hỏi 5: When did Database Systems evolve to address issues in data-intensive applications?

A: Late 1950s
B: Late 1960s
C: Early 1980s
D: Early 1990s

Đáp án: B

Câu hỏi 6: A DBMS is a set of programs used to enter, store, and manage data. What does DBMS stand for?

A: Data Business Management System
B: Database Maintenance System
C: Database Management System
D: Digital Base Management System

Đáp án: C

Câu hỏi 7: In which type of database system is the database stored in a central location accessible from multiple machines?

A: Hierarchical database system
B: Distributed database system
C: Centralized database system
D: Network database system

Đáp án: C

Câu hỏi 8: Which example is listed as a database application in Slide 1?

A: Word processor
B: Web browser
C: Automated teller machines
D: Operating system

Đáp án: C

Câu hỏi 9: What is a group of conceptual tools that describes data, its relationships, and semantics?

A: Data model
B: Database Engine
C: Data integrity
D: Normalization

Đáp án: A

Câu hỏi 10: Which of these is a component of an E-R model representing a real-world object that is distinguishable from others?

A: Attribute
B: Relationship
C: Entity
D: Key

Đáp án: C

Câu hỏi 11: What are the features that help distinguish every entity from another, such as 'roll_number' or 'name' for a student?

A: Entities
B: Attributes
C: Records
D: Relationship sets

Đáp án: B

Câu hỏi 12: A relationship between entities of the same entity set (e.g., manager and team member in 'employee' set) is called:

A: Binary relationship
B: Self-relationship
C: Ternary relationship
D: Many-to-Many relationship

Đáp án: B

Câu hỏi 13: Which type of relationship exists between entities of two different entity sets?

A: Self-relationship
B: Binary relationship
C: Ternary relationship
D: Internal relationship

Đáp án: B

Câu hỏi 14: What is an attribute that can uniquely define an entity in an entity set?

A: Weak key
B: Foreign key
C: Primary key
D: Compound key

Đáp án: C

Câu hỏi 15: Entity sets that do not have enough attributes to establish a primary key are called:

A: Strong entity sets
B: Weak entity sets
C: Abstract entity sets
D: Dependent entity sets

Đáp án: B

Câu hỏi 16: The E-R diagram is a ______ representation of the E-R model.

A: Textual
B: Logical
C: Graphical
D: Physical

Đáp án: C

Câu hỏi 17: In E-R diagram symbols, what does an oval/ellipse typically represent?

A: Entity
B: Relationship
C: Attribute
D: Weak Entity

Đáp án: C

Câu hỏi 18: SQL Server is an RDBMS developed by which company?

A: Oracle
B: Google
C: Microsoft
D: IBM

Đáp án: C

Câu hỏi 19: Which feature of SQL Server allows only authorized personnel access to the database?

A: Transparent data compression
B: Policy-Based Management
C: One-click installation
D: Transparent encryption

Đáp án: B

Câu hỏi 20: Which major head of the SQL Server 2022 architecture contains CPU, Memory, and Configuration files?

A: Tools
B: Services
C: Instances
D: Connectivity

Đáp án: C

Câu hỏi 21: Which tool is a GUI-based application used to create databases, objects, and query data in SQL Server 2022?

A: SQLCMD
B: SQL Server Configuration Manager
C: SQL Server Management Studio (SSMS)
D: SQL Server Profiler

Đáp án: C

Câu hỏi 22: Which tool is the command-line equivalent of SSMS?

A: SSDT
B: SQLCMD
C: DQS
D: ODBC

Đáp án: B

Câu hỏi 23: What is the core service of SQL Server used for storing, processing, and securing data?

A: Analysis Services
B: Reporting Services
C: Database Engine
D: Integration Services

Đáp án: C

Câu hỏi 24: Which service is used for Online Analytical Processing (OLAP) and data mining?

A: Reporting Services
B: Analysis Services (SSAS)
C: Integration Services (SSIS)
D: Master Data Services (MDS)

Đáp án: B

Câu hỏi 25: Which service is responsible for moving, copying, and transforming data?

A: Integration Services (SSIS)
B: Reporting Services (SSRS)
C: Analysis Services
D: Database Engine

Đáp án: A

Câu hỏi 26: In what year was SQL Server 1.0 released?

A: 1985
B: 1989
C: 1995
D: 2000

Đáp án: B

Câu hỏi 27: Which SQL Server edition is designed for development and testing in non-production environments?

A: Express
B: Standard
C: Enterprise
D: Developer

Đáp án: D

Câu hỏi 28: Which edition of SQL Server 2022 uses unlimited cores of CPU and unlimited memory?

A: Standard
B: Enterprise
C: Express
D: Azure SQL Instance

Đáp án: B

Câu hỏi 29: Which connectivity tool is mentioned in Slide 3 as a way to communicate between clients and servers?

A: SSDT
B: ODBC
C: SQL Profiler
D: MDS

Đáp án: B

Câu hỏi 30: What is the name of the sample database mentioned in the objectives of Session 3?

A: Northwind
B: Pubs
C: Adventure Works 2022
D: SQL Demo

Đáp án: C

Developer Toolbox

INPUT AREA

OUTPUT AREA

TEXT CASE

FORMAT & CLEAN

ENCODE & DECODE

JSON & CRYPTO

Đã sao chép!!!

Hotline: 0967025996

Gozic | Blog Chia Sẻ Kiến Thức Lập Trình - Công Nghệ - Trắc Nghiệm Từ Lớp 1 - Đại Học