SQL/ Transactions / Data Integrity

Beschreibung

SQL/ Transactions / Data Integrity
Brandon Gagon
Quiz von Brandon Gagon, aktualisiert more than 1 year ago
Brandon Gagon
Erstellt von Brandon Gagon vor etwa 7 Jahre
47
0
1 2 3 4 5 (0)

Zusammenfassung der Ressource

Frage 1

Frage
Which of the following is a benefit of using a DBMS?
Antworten
  • They provide full security to data using private/public key encryption
  • They create automatic backups
  • They help create an environment for end users to have access to more data
  • They provide seamless Internet access to database data

Frage 2

Frage
The hierarchical database model is based on a ____.
Antworten
  • tree structure
  • lack of a parent segment
  • lack of a child segment
  • matrix

Frage 3

Frage
Because an RDBMS hides the system's complexity from the user/designer, ____.
Antworten
  • it does not exhibit data independence
  • it does not exhibit structural independence
  • data management is easier
  • data management is very difficult

Frage 4

Frage
The ERD is used to graphically represent the ____ database model.
Antworten
  • condensed
  • physical
  • logical
  • conceptual

Frage 5

Frage
The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.
Antworten
  • subtype discriminator
  • inheritance
  • specialization hierarchy
  • entity supertype

Frage 6

Frage
At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a ____ relationship.
Antworten
  • none
  • 1:1
  • 1:M
  • M:N

Frage 7

Frage
Which command would be used to delete the table row where the P_Code = '2238/QPD'?
Antworten
  • DELETE FROM PRODUCT WHERE P_CODE = '2238/QPD';
  • REMOVE FROM PRODUCT WHERE P_CODE = '2238/QPD';
  • ERASE FROM PRODUCT WHERE P_CODE = '2238/QPD';
  • ROLLBACK FROM PRODUCT WHERE P_CODE = '2238/QPD';

Frage 8

Frage
Which command is used to select partial table contents?
Antworten
  • SELECT <column(s)> FROM <Table name> WHERE <Item>;
  • LIST <column(s)> FROM <Table name> WHERE <Conditions>;
  • SELECT <column(s)> FROM <Table name> WHERE <Conditions>;
  • LIST<column(s)> FROM <Table name> WHERE <Item>;

Frage 9

Frage
Which query will output the table contents when the value of V_CODE is equal to 21344?
Antworten
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344;
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <= 21344;
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;

Frage 10

Frage
What is the command used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the Product table in ascending order by P_PRICE?
Antworten
  • SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT SEQUENCE BY P_PRICE;
  • SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT LIST BY P_PRICE;
  • SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;
  • SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ASCENDING BY P_PRICE;

Frage 11

Frage
The basic SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____.
Antworten
  • COUNT
  • MIN
  • MAX
  • SUM

Frage 12

Frage
____ is used to tally the number of specific "values" of an attribute.
Antworten
  • SUM
  • TOTAL
  • COUNT
  • ADD

Frage 13

Frage
UPDATE tablename ***** [WHERE conditionlist]; What command replaces the ***** in the above statement?
Antworten
  • SET columnname = expression
  • columnname = expression
  • expression = columnname
  • LET columnname = expression

Frage 14

Frage
When using a(n) ____ join, only rows that meet the given criteria are returned.
Antworten
  • full
  • inner
  • outer
  • set

Frage 15

Frage
What is the syntax for a left outer join?
Antworten
  • SELECT column-list FROM table1 OUTER JOIN table2 LEFT WHERE join-condition
  • SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition
  • SELECT column-list WHERE LEFT table1 = table 2
  • SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition

Frage 16

Frage
In subquery terminology, the first query in the SQL statement is known as the ____ query.
Antworten
  • outer
  • left
  • inner
  • base

Frage 17

Frage
In a subquery, which query is executed first?
Antworten
  • leftmost
  • rightmost
  • innermost
  • outermost

Frage 18

Frage
Creating the conceptual design, selecting DBMS software, creating the logical design, and creating the physical design are part of the ____ phase.
Antworten
  • database initial study
  • database design
  • implementation and loading
  • testing and evaluation

Frage 19

Frage
Which of the conceptual design steps defines entities, attributes, and relationships?
Antworten
  • Database analysis and requirements
  • Entity relationship modeling and normalization
  • Data model verification
  • Distributed database design

Frage 20

Frage
What is the primary objective of database design?
Antworten
  • To create the most efficient database possible
  • To create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models
  • To create the fastest queries
  • To be able to add data quickly

Frage 21

Frage
The most common algorithms for concurrency control are locks, ____ stamping, and optimistic methods.
Antworten
  • date
  • time
  • hour
  • minute

Frage 22

Frage
____ requires that all operations of a transaction be completed.
Antworten
  • Specificity
  • Atomicity
  • Durability
  • Time Stamping

Frage 23

Frage
The ____ establishes the order in which the operations within concurrent transactions are executed.
Antworten
  • transaction log
  • timer
  • lock manager
  • scheduler

Frage 24

Frage
When is the implicit beginning of a transaction?
Antworten
  • When the database is started
  • When a table is accessed for the first time
  • When the first SQL statement is encountered
  • When the COMMIT command is issued

Frage 25

Frage
A(n) ____ phase in a two-phase lock is when a transaction releases all locks and cannot obtain any new lock.
Antworten
  • growing
  • shrinking
  • locking
  • unlocking

Frage 26

Frage
What is a consistent database?
Antworten
  • One in which all tables have foreign keys
  • One in which all data integrity constraints are satisfied
  • One in which all tables are normalized
  • One in which all SQL statements only update one table at a time

Frage 27

Frage
A transaction acquires a ____ prior to data access.
Antworten
  • grain
  • timestamp
  • lock
  • key

Frage 28

Frage
Changes are permanently applied to the database during the ____ phase of a transaction.
Antworten
  • commit
  • write
  • input
  • output

Frage 29

Frage
The phenomenon of ____ occurs when two transactions, T1 and T2, are executed concurrently and the first transaction (T1) is rolled back after the second transaction (T2) has already accessed the uncommitted data—thus violating the isolation property of transactions.
Antworten
  • lost updates
  • uncommitted data
  • transaction failure
  • inconsistent retrieval

Frage 30

Frage
____ occur when a transaction calculates some summary (aggregate) functions over a set of data while other transactions are updating the data.
Antworten
  • lost updates
  • uncommitted data
  • transaction failures
  • inconsistent retrievals

Frage 31

Frage
The scheduler facilitates data ____ to ensure that two transactions do not update the same data element at the same time.
Antworten
  • durability
  • isolation
  • atomicity
  • serializability

Frage 32

Frage
Which is not a DML statement?
Antworten
  • CREATE TABLE
  • SELECT
  • INSERT
  • DELETE

Frage 33

Frage
What feature is a DDBMS disadvantage?
Antworten
  • Data is located near the "greatest demand" site
  • Growth facilitation
  • Reduced operating cost
  • lack of standards

Frage 34

Frage
What feature is a DDBMS advantage?
Antworten
  • Greater difficulty in managing the data environment
  • Less danger of a single-point failure
  • Increased training cost
  • Complexity of management and control

Frage 35

Frage
____ distributed database systems integrate different types of centralized DBMSs over a network.
Antworten
  • Homogeneous
  • Heterogeneous
  • Fully homogeneous
  • Fully heterogeneous

Frage 36

Frage
____ transparency allows a transaction to update data at several network sites.
Antworten
  • Transaction
  • Distribution
  • Failure
  • Performance

Frage 37

Frage
____ transparency ensures that the system will continue to operate in the event of a node failure.
Antworten
  • Transaction
  • Distribution
  • Failure
  • Performance

Frage 38

Frage
The ____ contains the description of the entire database as seen by the database administrator.
Antworten
  • distributed global dictionary
  • distributed data dictionary
  • distributed global schema
  • distributed data schema

Frage 39

Frage
____ query optimization means that the DDBMS finds the most cost-effective access path without user intervention.
Antworten
  • Static
  • Dynamic
  • Automatic
  • Commit

Frage 40

Frage
____ query optimization takes place at execution time.
Antworten
  • Automatic
  • Static
  • Manual
  • Dynamic
Zusammenfassung anzeigen Zusammenfassung ausblenden

0 Kommentare

There are no comments, be the first and leave one below:

ähnlicher Inhalt

Globalisierung
AntonS
Grundlagenwissen DaZ
p s
BAS1 - Bau und Funktion des Bewegungsapparates (1)
susi.spakowski08
Vetie - Tierzucht & Genetik - T II
Fioras Hu
Φαρμακολογία Ι Σεπτεμβρίου 2017
Christina Martzi
Kommunikationssoziologie (KSOZ) Grimm 2017/18
Benedikt Zöchling
BM13 Swertz 2018 Quiz 1
Daniel Martinovic
Vetie Pharma 2015
Anna Auferkamp
Vetie Para 2019
Lea AvS
Vetie Tierseuchen 2019
Tropsi B