Kopieren und bearbeiten

MNSU CIS 440 Fall 2020 Quiz 4

Beschreibung

Quiz 4 given during Fall 2020 for CIS 440 at Minnesota State University, Mankato.
Kyle Peterson
Quiz von Kyle Peterson, aktualisiert more than 1 year ago
Kyle Peterson
Erstellt von Kyle Peterson vor etwa 4 Jahre
7
0
0

Zusammenfassung der Ressource

Frage 1

Frage
Cursors are created using the DECLARE statement.
Antworten
  • True
  • False

Frage 2

Frage
What are the common threats to database security?
Antworten
  • Disgruntled employees
  • Natural disasters
  • Technical failures
  • Poor physical security
  • b, c, and d
  • All of the above

Frage 3

Frage
Which law regulates the privacy and security of healthcare data?
Antworten
  • HIPPA
  • FERPA
  • GLB
  • Patriot Act

Frage 4

Frage
Which law regulates privacy and security of student data?
Antworten
  • HIPPA
  • FERPA
  • GLB
  • Patriot Act

Frage 5

Frage
The following method actually creates a new table when you insert data into a table.
Antworten
  • INSERT INTO
  • SELECT INTO
  • UPDATE
  • None of the above

Frage 6

Frage
Which one of the following changes the structure of the database?
Antworten
  • UPDATE
  • ALTER
  • CHANGE
  • RENAME

Frage 7

Frage
Unlike stored procedures, triggers are executed only when a user or application attempts to modify data.
Antworten
  • True
  • False

Frage 8

Frage
Which one is the most common type of trigger?
Antworten
  • AFTER
  • INSTEAD OF
  • CLR
  • BEFORE

Frage 9

Frage
What do triggers enforce?
Antworten
  • Data integrity
  • Referential integrity
  • Business Rules
  • All of the above
  • a and b only

Frage 10

Frage
Which one of the following is not generally classified as "restricted data" in public organizations?
Antworten
  • Aggregate crime incidence data
  • Social Security numbers
  • Identifiable human subject research data
  • Credit card data
  • None of the above as all are examples of restricted data

Frage 11

Frage
An organization should avoid disclosing an incidence of public data breach.
Antworten
  • True
  • False

Frage 12

Frage
Which one of the following is NOT related to protecting data centers physically?
Antworten
  • Video surveillance system
  • Environmental monitoring
  • Theft mitigation system
  • Firewalls

Frage 13

Frage
A special local network configuration designed to improve security by segregating computers on each side of a firewall is called _________.
Antworten
  • Firewall perimeter
  • IDS
  • DMZ
  • Extranet

Frage 14

Frage
Which law is related to protecting credit card data?
Antworten
  • HIPPA
  • FERPA
  • PCI-DSS
  • GLB

Frage 15

Frage
Which transaction property ensures that the schedule for the concurrent execution of several transactions should yield consistent results?
Antworten
  • Atomicity
  • Consistency
  • Isolation
  • Durability
  • Serializability

Frage 16

Frage
Which one is a special DBMS table that contains a description of all the database transactions by the DBMS?
Antworten
  • tempdb
  • master
  • scheduler
  • transaction log

Frage 17

Frage
If concurrency control is not maintained, which one of the following problems is least likely to occur?
Antworten
  • Lost updates
  • Uncommitted date
  • Inconsistent retrievals
  • Database login issues

Frage 18

Frage
Which lock granularity is meant for a disk block of fixed size?
Antworten
  • Table-Level
  • Database-Level
  • Page-Level
  • Field-Level

Frage 19

Frage
Which lock granularity is less likely to negatively affect concurrency of the database?
Antworten
  • Database-Level
  • Table-Level
  • Field-Level
  • Page-Level

Frage 20

Frage
Which one of the following is NOT true about data lakes?
Antworten
  • They are meant for primarily unstructured data.
  • They require schema on write.
  • They need distributed file system.
  • None of the above

Frage 21

Frage
Which one of the following is true about data warehouses?
Antworten
  • They require schema on write.
  • They require schema on read.
  • They are schema-less.
  • They are key-value pairs.

Frage 22

Frage
Which one of the following statements is NOT true about data warehouses (DWs)?
Antworten
  • They are historical repository of data.
  • They use normalization to reduce data duplication.
  • Batch updates are common with DWs.
  • They use the multi-dimensional cubes to store data.

Frage 23

Frage
The smallest detail in a warehouse is known as:
Antworten
  • dimension
  • fact
  • grain
  • key-value pair

Frage 24

Frage
A historical data repository for marketing data:
Antworten
  • data warehouse
  • data lake
  • data mart
  • metadata

Frage 25

Frage
Which one of the following is focused on consistent data definitions across an organization?
Antworten
  • Master data
  • Metedata
  • Grain
  • Fact

Frage 26

Frage
The change of customer address is an example of the following type dimension in a DW.
Antworten
  • SCD 0
  • SCD 1
  • SCD 2
  • SCD 25

Frage 27

Frage
The fact table maintains one-to-many relations with all the dimension tables in:
Antworten
  • snowflake schema
  • star schema
  • galaxy schema
  • star cluster schema

Frage 28

Frage
Which module in the SQL Server is used for creating OLAP cubes?
Antworten
  • SQL Server MDM
  • SQL Server Analysis Services
  • SQL Server Integration Services
  • SQL Server Data Transformation Services (DTS)
  • SQL Server Reporting Services

Frage 29

Frage
Which one of the following statements is INCORRECT?
Antworten
  • If you are encrypting lots of data, you should encrypt the data using a symmetric key, and encrypt the symmetric key with an asymmetric key.
  • If you are encrypting lots of data, you should encrypt the data using an asymmetric key, and encrypt the asymmetric key with a symmetric key.
  • If you are encrypting lots of data, you should encrypt the data using a symmetric key, and encrypt the symmetric key with a symmetric key.
  • If you are encrypting lots of data, you should encrypt the data using an asymmetric key, and encrypt the asymmetric key with an asymmetric key.

Frage 30

Frage
Only full backups are available for the master database.
Antworten
  • True
  • False

Frage 31

Frage
According to the rules of precedence, which of the following computations should be completed first?
Antworten
  • performing additions and subtractions
  • performing multiplications and divisions
  • performing operations within parentheses
  • performing power operations

Frage 32

Frage
Which one of the following is NOT true about indexes?
Antworten
  • Too many indexes can result in a slow database response.
  • When a table is updated, the indexes will need to be updated.
  • Indexes make the retrieval of data faster and efficient in most cases.
  • Indexes reside in the same file that has the associated table.

Frage 33

Frage
The top node of the B-tree index is called:
Antworten
  • Leaf node
  • Root node
  • Index node
  • Intermediate node

Frage 34

Frage
Clustered indexes are NOT a good choice for the following attributes.
Antworten
  • Attributes that are unique or contain many distinct values.
  • Attributes that need to be accessed sequentially.
  • Attributes that undergo frequent changes.
  • Attributes that are frequently used to sort the data retrieved from a table.

Frage 35

Frage
How many non-clustered indexes per table are allowed in SQL Server?
Antworten
  • 1
  • 99
  • 999
  • Unlimited
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

CCNA Security 210-260 IINS - Exam 3
Mike M
Application of technology in learning
Jeff Wall
Innovative Uses of Technology
John Marttila
Ch1 - The nature of IT Projects
mauricio5509
The Internet
Gee_0599
CCNA Answers – CCNA Exam
Abdul Demir
SQL Quiz
R M
Translations and transformations of functions
Christine Laurich
Professional, Legal, and Ethical Issues in Information Security
mfundo.falteni
System Analysis
R A
Flash Cards Networks
JJ Pro Wrestler
Bibliothek durchsuchen