Please don\'t answer if you are not sure! Denormalization is never a good practi
ID: 3765332 • Letter: P
Question
Please don't answer if you are not sure!
Denormalization is never a good practice.
true
false
-------------------------------------------------
The purpose of concurrency control is:
preventing users from working on a database concurrently
ensuring that one user's work does not influence another user's work inappropriately
providing an opportinuty for users to work on databases concurrently
stopping all concurrent transactions.
--------------------------------------------------------
3.Locks placed automatically by the DBMS are called:
implicit locks
explicit locks
automated locks
DBMS locks
-----------------------------------------------------
4.Locks placed by the user for exclusive rights to the data are called:
implicit locks
explicit locks
user-defined locks
exclusive locks
----------------------------------------------------
5.A pointer into a set of rows that are the result set from an SQL SELECT statement is called a:
SQL pointer
selector
row pointer
cursor
---------------------------------------------
6.Reprocessing is not typically the best method of recovery from a failure in a multiuser system.
true
false
-------------------------------------------
7."User-defined function” and “stored procedure” are synonyms.
true
false
-----------------------------------------
8.The standard developed in the early 90’s to provide a DBMS-independent means for processing relational database data is:
ADO
AMP
ODBC
API
---------------------------------------------------------
9.A database system that has data, programs, and personnel specializing in the preparation of data for BI processing is called:
a data mart
an ETL system
OLAP
a data warehouse
---------------------------------------------------------
10.Dimensional database use which type of design:
normalized database design
star schema
operational database design
dimensional schema
Explanation / Answer
1.True
2.The purpose of concurrency control is ensuring that one user's work does not influence another user's work inappropriately.
3.implicit locks
4.exclusive lock
5.cursor
6.true
7.True
8.ODBC
9.Datawarehouse
10. Start schema