Quiz
MNSU CIS 440 Fall 2020 Quiz 4
Perguntas do quiz (35)
1Cursors are created using the DECLARE statement.
- AVerdadeiro
- BFalso
2What are the common threats to database security?
- ADisgruntled employees
- BNatural disasters
- CTechnical failures
- DPoor physical security
- Eb, c, and d
- FAll of the above
3Which law regulates the privacy and security of healthcare data?
- AHIPPA
- BFERPA
- CGLB
- DPatriot Act
4Which law regulates privacy and security of student data?
- AHIPPA
- BFERPA
- CGLB
- DPatriot Act
5The following method actually creates a new table when you insert data into a table.
- AINSERT INTO
- BSELECT INTO
- CUPDATE
- DNone of the above
6Which one of the following changes the structure of the database?
- AUPDATE
- BALTER
- CCHANGE
- DRENAME
7Unlike stored procedures, triggers are executed only when a user or application attempts to modify data.
- AVerdadeiro
- BFalso
8Which one is the most common type of trigger?
- AAFTER
- BINSTEAD OF
- CCLR
- DBEFORE
9What do triggers enforce?
- AData integrity
- BReferential integrity
- CBusiness Rules
- DAll of the above
- Ea and b only
10Which one of the following is not generally classified as "restricted data" in public organizations?
- AAggregate crime incidence data
- BSocial Security numbers
- CIdentifiable human subject research data
- DCredit card data
- ENone of the above as all are examples of restricted data
11An organization should avoid disclosing an incidence of public data breach.
- AVerdadeiro
- BFalso
12Which one of the following is NOT related to protecting data centers physically?
- AVideo surveillance system
- BEnvironmental monitoring
- CTheft mitigation system
- DFirewalls
13A special local network configuration designed to improve security by segregating computers on each side of a firewall is called _________.
- AFirewall perimeter
- BIDS
- CDMZ
- DExtranet
14Which law is related to protecting credit card data?
- AHIPPA
- BFERPA
- CPCI-DSS
- DGLB
15Which transaction property ensures that the schedule for the concurrent execution of several transactions should yield consistent results?
- AAtomicity
- BConsistency
- CIsolation
- DDurability
- ESerializability
16Which one is a special DBMS table that contains a description of all the database transactions by the DBMS?
- Atempdb
- Bmaster
- Cscheduler
- Dtransaction log
17If concurrency control is not maintained, which one of the following problems is least likely to occur?
- ALost updates
- BUncommitted date
- CInconsistent retrievals
- DDatabase login issues
18Which lock granularity is meant for a disk block of fixed size?
- ATable-Level
- BDatabase-Level
- CPage-Level
- DField-Level
19Which lock granularity is less likely to negatively affect concurrency of the database?
- ADatabase-Level
- BTable-Level
- CField-Level
- DPage-Level
20Which one of the following is NOT true about data lakes?
- AThey are meant for primarily unstructured data.
- BThey require schema on write.
- CThey need distributed file system.
- DNone of the above
21Which one of the following is true about data warehouses?
- AThey require schema on write.
- BThey require schema on read.
- CThey are schema-less.
- DThey are key-value pairs.
22Which one of the following statements is NOT true about data warehouses (DWs)?
- AThey are historical repository of data.
- BThey use normalization to reduce data duplication.
- CBatch updates are common with DWs.
- DThey use the multi-dimensional cubes to store data.
23The smallest detail in a warehouse is known as:
- Adimension
- Bfact
- Cgrain
- Dkey-value pair
24A historical data repository for marketing data:
- Adata warehouse
- Bdata lake
- Cdata mart
- Dmetadata
25Which one of the following is focused on consistent data definitions across an organization?
- AMaster data
- BMetedata
- CGrain
- DFact
26The change of customer address is an example of the following type dimension in a DW.
- ASCD 0
- BSCD 1
- CSCD 2
- DSCD 25
27The fact table maintains one-to-many relations with all the dimension tables in:
- Asnowflake schema
- Bstar schema
- Cgalaxy schema
- Dstar cluster schema
28Which module in the SQL Server is used for creating OLAP cubes?
- ASQL Server MDM
- BSQL Server Analysis Services
- CSQL Server Integration Services
- DSQL Server Data Transformation Services (DTS)
- ESQL Server Reporting Services
29Which one of the following statements is INCORRECT?
- AIf you are encrypting lots of data, you should encrypt the data using a symmetric key, and encrypt the symmetric key with an asymmetric key.
- BIf you are encrypting lots of data, you should encrypt the data using an asymmetric key, and encrypt the asymmetric key with a symmetric key.
- CIf you are encrypting lots of data, you should encrypt the data using a symmetric key, and encrypt the symmetric key with a symmetric key.
- DIf you are encrypting lots of data, you should encrypt the data using an asymmetric key, and encrypt the asymmetric key with an asymmetric key.
30Only full backups are available for the master database.
- AVerdadeiro
- BFalso
31According to the rules of precedence, which of the following computations should be completed first?
- Aperforming additions and subtractions
- Bperforming multiplications and divisions
- Cperforming operations within parentheses
- Dperforming power operations
32Which one of the following is NOT true about indexes?
- AToo many indexes can result in a slow database response.
- BWhen a table is updated, the indexes will need to be updated.
- CIndexes make the retrieval of data faster and efficient in most cases.
- DIndexes reside in the same file that has the associated table.
33The top node of the B-tree index is called:
- ALeaf node
- BRoot node
- CIndex node
- DIntermediate node
34Clustered indexes are NOT a good choice for the following attributes.
- AAttributes that are unique or contain many distinct values.
- BAttributes that need to be accessed sequentially.
- CAttributes that undergo frequent changes.
- DAttributes that are frequently used to sort the data retrieved from a table.
35How many non-clustered indexes per table are allowed in SQL Server?
- A1
- B99
- C999
- DUnlimited
Informações
- Descrição
- Quiz 4 given during Fall 2020 for CIS 440 at Minnesota State University, Mankato.
- Autor
- Kyle Peterson
- Idioma
- English
- Visualizações
- 17
- Etiquetas
- Avaliação
- Ainda sem avaliações Avalie este quiz