cis 407 unit 1
The difference between a 1-tier and 2-tier computing architecture is: In 1-tier architecture we use single monitors; whereas 2-tier requires two each 1-tier setup is for personal non-sharing database. 2-Tier allows for a group of clients to share the same database They are really the same. Vendors use these labels to charge more for 2-Tier solutions 1-tier is for single-core processor. 2-Tier is for dual-core processors (these are faster) 1-tier is all we need. We have 2-Tier because IT engineers always like to keep a spare tier
1-tier setup is for personal non-sharing database. 2-Tier allows for a group of clients to share the same database
Your performance in this class is assessed primarily through __ exams (ignore quizzes) 2 - a midterm and a final 3 - two exams and a final 4 - three exams and a final 0 - This instructor does not believe in exams
3 - two exams and a final
If the students in this class are required to connect to the "CIS" instance of the database server the name you enter in the connection dialog of the database server is ____ murraystate\CIS\ SQLserver\CIS COB-sqlserver\CIS (or COB-SQLServer01\CIS) SQLServer-CIS (or SQLServer01-CIS) COB-SQLServer.CIS (or COB-SQLServer01.CIS)
COB-sqlserver\CIS (or COB-SQLServer01\CIS)
The best way to contact the instructor for course-related matters is through ____ Canvas Inbox Emailing the assistant, Amy Calling the assistant, Amy (270-809-2094) None of these. You cannot contact this instructor
Canvas Inbox
Both XLSX and CSV files are popular for sharing data between systems. CSV stands for ____ Comma separated values Correctly saved values Compressed Shared Values Corporations Safe Values Completely Shareable Values
Comma separated values
Both Access and Excel are great products for storing data. However, Access is the better product ______ Always Never Depends on the user's need Neither; Google sheets are the future
Depends on the user's need
Although there are many objects in the object explorer (SSMS) in this class, we will be limiting our exposure to "Databases" and "Management" True False
False
Excel allows you to customize the predefined column headers True False
False
One of the weaknesses of the two-tier architecture is that it can be shared only by two clients True False
False
each database can accommodate one table but many columns and rows True False
False
You do not know your grade till the very end of the term as the grades are curved based on the final exam True False - grades are not curved
False - grades are not curved
This year the spring break is _____ Mar 14 - 18 Mar 17-18 (2 days only) March 20 - 24 Cancelled due to COVID vaccine side effects
March 20 - 24
The college's academic honesty policy identifies several distinct forms of policy violations. One of these is listed below: The submission of substantial portions of the same academic work, including oral reports, for credit more than once without authorization from the instructor. This is labelled as _________ Fabrication and falsification Multiple submission Plagiarism cheating
Multiple submission
The college's academic honesty policy identifies several distinct forms of policy violations. One of these is listed below: "Intentionally using or attempting to use unauthorized information such as books, notes, study aids, or other electronic, online, or digital devices in any academic exercise; as well as unauthorized communication of information by any means to or from others during any academic exercise." This is labelled as _________ Fabrication and Falsification Multiple submission Plagiarism None of these
None of these
________ is an example of a database server Excel workbook Google sheets Stack of documents stored in well-labeled cubby-holes SQL server Excel files stored in well planned folder system
SQL server
Information about the SSMS project you create is found in the _______ window Solution explorer Object explorer Results Messages Project explorer
Solution explorer
SQL server is a product put out by Microsoft to manage data. SQL is an abbreviation for _______ Sequential Querying Linguist Speedy Query Language Search Quickly and Learn Structured Query Language Stop Quibbling and Learn
Structured Query Language
One of the weaknesses of the single-tier architecture is that the database cannot be shared across users True False
True
The "security" folder in SSMS appears in two or more places True False
True
The name of our server and instance was given as cob-sqlserver\CIS407 (or cob-sqlserver01\CIS407). The instance name is wrong. True False
True
The final grade for this course is based on _____ Points - a total of 900 is needed for an A Average of scores earned in all activities weighted average (with some activities weighted more than others)
weighted average (with some activities weighted more than others)
When we talk about "entities" in the world of database, a rough equivalent in spreadsheets is ______ Rows Columns Fields worksheet None of these
worksheet
With the easy availability of data and powerful tools to manage them, the industry has found new job title that didn't exist 5-10 years ago. These include BI, ETL, Data scientist, Data analyst etc. BI stands for Business Instruction Big Information Big Intelligence Business Intelligence Business Integrity
Business Intelligence
