CSC 240 Questions and Answers
What two types of databases were commonly used prior to the relational database?
hierarchal and network
What type of database is primarily used for OLTP (Online Transaction Processing)?
operational database
Previous
Play
Next
Rewind 10 seconds
Mo...
CSC 240 Questions and Answers
What two types of databases were commonly used prior to the relational database? -
answer hierarchal and network
What type of database is primarily used for OLTP (Online Transaction Processing)? -
answer operational database
Which type of databse is used to analyze statistical data? - answer analytical
In a parent/child relationship, a parent table can be associated with one or more child
tables, but a single child table can be associated with only one parent table. T/F -
answer true?
A set structure is a transparent construction that establishes and represents a
relationship in a network database. - answer true
The relational model is based on two branches of mathematics: ______ and ______. -
answer set theory, predicate logic
A network database stores data in relations, which the user perceives as tables. -
answer false
Name the 3 types of relationships in a relational database - answer one-to-one
on-to-many
many-to-many
How do you retrieve in a relational database? - answer select statements
State 2 advantages of a relational database: - answer easy to modify and maintain
the structure
easy retrieval of information
What is a relational database management system? - answer A DBMS that manages
data as a collection of tables in which relationships are represented by a common
values in related tables.
In which type of database is information organized into a tree-like structure that allows
repeating information using parent/child relationships in such a way that it cannot have
too many relationships. - answer Hierarchical
Which type of database creates a flexible schema, viewed as a graph in which object
types are nodes and relationship types are arcs. - answer network
,Which type of databse stores information in the form of logically related two-dimensional
tables where order if fields/columns does not matter, and has unique value ids allowing
each record/row to be unique. - answer relational
Who is credited with creating the relational database model? - answer Dr. Edgar F.
Codd
Another term for Tuple is: - answer row
Another term for Attribute is: - answer field
_______ is used to create, modify, maintain, and query relational DBs. - answer SQL
When Data is converted into a meaningful and useful context we call it - answer
information
The way to represent nothing; used for missing or unaccounted for information - answer
Null
Which of the following are drawbacks to the client-server model? - answer Increased
knowledge required to manage the implementation.,
Increased implementation cost due to specialized hardware and software requirements.
Which of the following BEST describes the stand-alone model? - answer
Communication takes place using a commonly available public network, such as the
internet.
Which of the following are drawbacks to the workgroup model? - answer Lack of
centralized configuration control.
Lack of centralized authentication.
You have completed the installation of Windows Server 2022.
Which of the following tasks is best to perform before joining the server to an Active
Directory domain? - answer Change the computer name.
Which server edition supports an unlimited number of VMs? - answer Windows
Server 2022 Datacenter Server Core
You are preparing to install Windows Server 2022 Standard Edition on a new server.
The server has the following hardware. Which component will need to be upgraded to
fully support the operating system?
1.4 GHz 32-bit processor
PCI Express network adapter with 1 gigabit per second throughput
2 TB hard drive with a 64 GB system partition.
6 GB RAM - answer Processor
,After you install Windows Server 2022, you must activate the server if you want to
receive updates from Microsoft to keep your server secure and running smoothly. You
have a 30-day grace period in which to activate the server. The vendor who sold the
Windows Server license should provide a piece of information that you need to activate
your installation.
Which of the following do you need to activate your Windows server? - answer The
product key
You are installing Windows Server 2022 on a system that has a used hard drive that
contains important data. The hard drive does not contain any operating system files.
Which steps must you perform to complete this installation and save the data? (Select
two.) - answer Use the Custom installation type.
Back up the data to another drive.
Which server edition requires the least amount of system resources to install? - answer
Windows Server 2022 Standard
During the installation of Windows Server, several properties of the local server are
configured by default. One of these properties is the time zone.
Which time zone is selected for the server by default? - answer US Pacific
Your manager has asked you to install the Web Server (IIS) role on one of your
Windows Server 2022 systems so it can host an internal website.
Which Windows feature can you use to do this? - answer Add Roles and Features
Which role or feature protects a server by encrypting the operating system volume and
verifying the integrity of other startup components? - answer BitLocker Drive
Encryption
Drag the type of server software listed on the left to its appropriate description on the
right.
A set of software features that provides a specific server function.
A software program that adds functionality to all server functions.
A specific program that adds functions to a role. - answer Role
Feature
Role service
Which of the following provides network host IP addresses and other IP configuration
information? - answer DHCP Server
Which of the following enables an organization to share identity information outside its
network? - answer Active Directory Federation Services
You've been assigned to manage a Windows Server system named AccServer. This
server was deployed using a Server Core installation.
You need to make several configuration changes to the system.
, Which utility could you use to do this? - answer PowerShell
Which of the following are roles of Remote Access? (Select two.) - answer Web
Application Proxy
DirectAccess and VPN (RAS)
To save disk space on your Windows Server 2022 system, you decide to remove
unneeded roles and features.
Which Windows feature can you use to do this? - answer Remove Roles and
Features
You are at the PowerShell command line, and you need to enter the command that will
remove the Telnet Client feature from the server.
Use the drop-down list to fill in the blank with the part of the command that is missing:
_______________________ -Name Telnet-Client -Restart - answer remove-
windowsfeature
Which of the following is a disk imaging solution that you can use for remote
deployment and automated installation of Microsoft Windows operating systems? -
answer Windows Deployment Services
Which of the following are used in PowerShell to specify an option in the command? -
answer Flags
Which PowerShell command would you use to get help for a particular cmdlet? - answer
get-help cmdletname
Which of the following commands should be used to access help files that have been
downloaded to the local file share? - answer Get-Help
Which of the following PowerShell cmdlets is used to retrieve information about an
existing object? - answer get
You are at the PowerShell command-line, and you need to see a list of all available
roles and features that you can install on the Windows server.
Fill in the blank with the PowerShell command that will display this list. - answer Get-
WindowsFeature
What is a Windows Powershell provider? (Select two.) - answer A program that
allows you to access data stores.
A .NET program.
Which of the following commands are used when making changes to an existing entity?
- answer Set
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Pogba119. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
