C192 Pre-Assessment WGU

Beschreibung

College C192 Databases Quiz am C192 Pre-Assessment WGU, erstellt von Craig Willey am 23/03/2020.
Craig Willey
Quiz von Craig Willey, aktualisiert more than 1 year ago
Craig Willey
Erstellt von Craig Willey vor mehr als 4 Jahre
8
0

Zusammenfassung der Ressource

Frage 1

Frage
Which factor must be considered during physical database design?
Antworten
  • Determination of the specific DBMS vendor product to use
  • Specification of table definitions
  • Specification of entities and relationships between entities
  • Determination of the type of DBMS to be used

Frage 2

Frage
Which technique is used to test the correctness of a logical database design model?
Antworten
  • Prototyping
  • Normalization
  • Logical Grouping
  • Extensibility

Frage 3

Frage
Which database design phase uses normalization techniques to eliminate anomalies in the data model?
Antworten
  • XML Database Design
  • Physical Database Design
  • Logical Database Design
  • Conceptual Database Design

Frage 4

Frage
Which step would be seen in the conceptual phase of data model design?
Antworten
  • Specification of entities and relationships
  • Specification of trigger definitions
  • Specification of storage size
  • Specification of programming language to use

Frage 5

Frage
What describes a specialized grouping of entity type occurrences that must be represented in a data model?
Antworten
  • Superclass
  • Baseclass
  • Relationship
  • Subclass

Frage 6

Frage
Which concept does the SQL statement "SELECT * FROM Contacts, Employer" demonstrate?
Antworten
  • Difference
  • Cartesian product
  • Selection
  • Intersection

Frage 7

Frage
What is the difference between a conceptual model and a logical model?
Antworten
  • A conceptual model is refined based on the network data model, whereas the logical model is based on a multidimensional model.
  • A conceptual model assumes details of the underlying DBMS, whereas the logical model assumes details based on an abstraction.
  • A conceptual model is independent of all implementation details, whereas the logical model is based on a specific database model.
  • A conceptual model is dependent upon the programming language used to manage the data, whereas the logical model is dependent on implementation details.

Frage 8

Frage
Which data type is considered a non-interpreted byte stream for a database management system (DBMS)?
Antworten
  • Float
  • Character
  • Bit
  • BLOB
  • XML

Frage 9

Frage
Which database management systems (DBMS) architecture emerged in the third generation of DBMSs? Choose 2 answers
Antworten
  • Object structured
  • Object oriented
  • Object stacking
  • Object relational

Frage 10

Frage
What are strengths of database management systems (DBMS)? Choose 2 answers
Antworten
  • Size of software
  • Cost of DBMS
  • Control of data redundancy
  • Increased performance
  • Improved data integrity

Frage 11

Frage
Which DDL statement should be used to enforce referential integrity?
Antworten
  • CREATE TRIGGER AFTER GRANT
  • CREATE TRIGGER BEFORE UPDATE
  • CREATE TRIGGER AFTER SELECT
  • CREATE TRIGGER BEFORE DROP

Frage 12

Frage
What describes a package in PL/SQL?
Antworten
  • Organized SQL statements, DMBS encryption algorithms, and keys
  • The culmination of database schema, design, and log files
  • A collection of procedures, functions, variables, and SQL statements
  • A grouping of indexes, truples, and attributes

Frage 13

Frage
Which statement produces a PL/SQL stored procedure?
Antworten
  • ADD OR UPDATE PROCEDURE dataAbstraction AS BEGIN SELECT * FROM employees END
  • CREATE OR REPLACE PROCEDURE dataAbstraction AS BEGIN SELECT * FROM employees END
  • INSERT OR UPDATE PROCEDURE dataAbstraction AS BEGIN SELECT * FROM employees END
  • INSERT OR SET PROCEDURE dataAbstraction AS BEGIN SELECT * FROM employees END

Frage 14

Frage
Which SQL statement will select all the data from the branch table, whether or not there are entries in the employee table?
Antworten
  • SELECT * FROM branch LEFT JOIN employee ON branch.location = employee.location
  • SELECT * FROM employee LEFT JOIN branch ON employee.location = branch.location
  • SELECT * FROM branch INNER JOIN employee ON branch.location = employee.location
  • SELECT * FROM employee INNER JOIN branch ON employee.location = branch.location

Frage 15

Frage
Use the given code to answer the following question: SELECT branchNo, COUNT(staffNo) AS myCount, SUM(salary) AS mySum FROM staff GROUP BY branchNo ORDER BY branchNo; What does this code do?
Antworten
  • Finds the total number of branches
  • Orders the staff table by the ascending order of branchNo
  • Finds the number of staff and the sum of their salaries in each branch
  • Orders the staff by ascending order of salary

Frage 16

Frage
Which aggregate functions can be applied to both numeric and non-numeric fields? Choose 2 answers
Antworten
  • AVG
  • MAX
  • SUM
  • FLOOR
  • COUNT

Frage 17

Frage
Use the given query results from the following table to answer the question below: staffNo fName lName salary SL21 John White 30000.00 SG5 Susan Brand 24000.00 SG14 David Ford 18000.00 SG37 Ann Beech 12000.00 SA9 Mary Howe 9000.00 SL41 Julie Lee 9000.00 Which query should be executed to produce the results as displayed in this table?
Antworten
  • SELECT staffNo, fName, lName, salary FROM Staff ORDER BY 4 ASC
  • SELECT staffNo, fName, lName, salary FROM Staff ORDER BY fName DESC
  • SELECT staffNo, fName, lName, salary FROM Staff ORDER BY salary DESC
  • SELECT staffNo, fName, lName, salary FROM Staff ORDER BY salary ASC

Frage 18

Frage
Use the given SQL to answer the following question: SELECT staff_id, first_name, last_name, position, salary FROM Staff WHERE salary > 40000 AND position = 'Supervisor' What are the search conditions used by this statement? Choose 2 answers
Antworten
  • Range
  • Comparison
  • Pattern match
  • Set membership

Frage 19

Frage
Which statement will delete the staff member who is a manager with the staff ID "SG15"?
Antworten
  • DELETE FROM staff WHERE position='Manager', staffNo='SG15'
  • DELETE WHERE position=Manager AND staffNo=SG15
  • DELETE FROM staff WHERE position='Manager' AND staffNo='SG15'
  • DELETE WHERE position='Manager' AND staffNo='SG15'

Frage 20

Frage
Which statement must be used to increment staff salary by 4%?
Antworten
  • UPDATE staff SET salary = salary * 1.04
  • UPDATE staff SET salary = salary * 4%
  • UPDATE staff SET salary = salary * 0.04
  • UPDATE staff SET salary = salary * 104

Frage 21

Frage
Use the given statement to answer the following question: INSERT INTO Production VALUES ('Item123', 'Round'); Which function is performed in this statement?
Antworten
  • Inserting a table into the database
  • Inserting a single row of data
  • Inserting data into random columns
  • Inserting multiple rows of data

Frage 22

Frage
Use the given DDL statement to answer the following question: CREATE ASSERTION StaffNotHandlingTooMuch CHECK(NOT EXISTS (SELECT staffNo FROM PropertyForRent GROUP BY staffNo HAVING COUNT(*) > 100)) Which action is this statement performing?
Antworten
  • Creating a trigger
  • Creating a stored procedure
  • Creating a constraint
  • Creating an index

Frage 23

Frage
Which DDL statement creates an index that could be used as a candidate primary key?
Antworten
  • CREATE VIEW INDEX
  • CREATE UNIQUE INDEX
  • CREATE PRIMARY INDEX
  • CREATE DROP INDEX

Frage 24

Frage
Use the given DDL to answer the following question: CREATE VIEW Manager3Staff AS SELECT * FROM Staff WHERE branch_number = 3 WITH CHECK OPTION; What does this code do?
Antworten
  • It provides access to the entire Staff table.
  • It restricts the visible columns in the Staff table.
  • It creates a view that prohibits migrating rows.
  • It prevents insertions into Staff with branch_number = 3.

Frage 25

Frage
What is an example of the correct syntax for creating a new column in an existing table?
Antworten
  • ALTER TABLE person ADD email VARCHAR(200) NULL
  • MODIFY TABLE person CREATE COLUMN email VARCHAR(200) NULL
  • MODIFY TABLE person ADD email VARCHAR(200) NULL
  • EDIT TABLE person ADD COLUMN email VARCHAR(200) NULL

Frage 26

Frage
What is a benefit of using SQL?
Antworten
  • SQL is a standard used to define user interfaces.
  • SQL is a standard used for data interchange between enterprise systems.
  • SQL is recognized by all operating systems.
  • SQL is the strategic choice of many large and influential organizations.

Frage 27

Frage
A DBA needs to implement a data warehouse where avoiding redundant data is preferred over query performance. What is the appropriate multidimensional data model that should be chosen for the database design?
Antworten
  • Starflake schema
  • Network schema
  • Star schema
  • Snowflake schema

Frage 28

Frage
Which DM schema implements the given data model?
Antworten
  • Network schema
  • Star schema
  • Relational schema
  • Constellation schema

Frage 29

Frage
A database architect is tasked with designing and implementing a data warehouse using a star schema. Which design approach should the architect follow?
Antworten
  • One fact table surrounded by normalized dimension tables
  • One dimension table surrounded by normalized fact tables
  • One dimension table surrounded by normalized and denormalized fact tables
  • One fact table surrounded by denormalized dimension tables

Frage 30

Frage
How does dimensional modeling differ from entity-relationship modeling?
Antworten
  • Dimensional modeling is used to identify relationships among entities
  • Dimensional modeling's major goal is to remove redundancy in data
  • Dimensional modeling cannot efficiently and easily support ad-hoc queries
  • Dimensional modeling can model common business situations

Frage 31

Frage
Which data representation concept is associated with online analytical processing (OLAP)?
Antworten
  • The concept of "slice and dice"
  • The concept of "associate arrays"
  • The concept of "hash tables"
  • The concept of "facts"

Frage 32

Frage
Which online analytical processing (OLAP) operations can be used for driving business decisions on data cubes? Choose 2 answers
Antworten
  • Slicing
  • Equijoining
  • Pivoting
  • Cascading
  • Validating

Frage 33

Frage
What is a benefit of distributed database management systems (DDBMS)?
Antworten
  • It reduces the skills required of the database administrator.
  • It removes the requirement for global applications.
  • It stops fragments from replicating.
  • It helps resolve the islands of information problem.

Frage 34

Frage
What is a reason for creating a data mart versus a data warehouse?
Antworten
  • A data mart provides subject-oriented and time-variant data.
  • A data mart improves end-user response time.
  • A data mart stores infrequently analyzed data.
  • A data mart provides a superset of data.

Frage 35

Frage
What is the process of loading data extracted from different OLTP data sources into an enterprise data warehouse?
Antworten
  • EER (Enhanced Entity-Relationship)
  • Fragmentation
  • Replication
  • ETL (Extract/Transform/Load)

Frage 36

Frage
Which type of data will be found by utilizing data mining?
Antworten
  • Customer sales reports
  • Customer refund reports
  • Customer address lists
  • Customer loyalty identification

Frage 37

Frage
What is an advantage of using XML when presenting database management system (DBMS) data?
Antworten
  • It provides data redundancy.
  • It implements intrinsic data types.
  • It supports data integration.
  • It combines content and presentation.

Frage 38

Frage
Which MIME type is used to transfer a regular ASCII file hosted in a database management system (DBMS) to a web client?
Antworten
  • text/plain
  • application/pdf
  • text/html
  • image/gif

Frage 39

Frage
What is a common component of encoding data using asymmetric encryption?
Antworten
  • Same encryption and decryption keys
  • Uni-directional encryption
  • Different encryption and decryption keys
  • Identical encryption and decryption algorithms

Frage 40

Frage
Use the given statement to answer the following question: CREATE VIEW CarSales(dealerNo, salesNo, sales) AS SELECT s.dealerID, s.salesID, COUNT(*) FROM salesman s, monthlySales m WHERE s.salesID = m.salesID GROUP BY s.dealerID, s.salesID Which queries will properly run? Choose 2 answers
Antworten
  • SELECT * FROM CarSales WHERE dealerNo > 10
  • SELECT * FROM CarSales GROUP BY sales
  • SELECT * FROM CarSales WHERE COUNT(sales) > 5
  • SELECT * FROM CarSales WHERE salesNo > 3
  • SELECT COUNT(sales), dealerNo FROM CarSales

Frage 41

Frage
Which DCL command gives Director the privilege to SELECT on column Salary of the table Staff?
Antworten
  • ALLOW Director SELECT Salary FROM Staff;
  • GRANT SELECT(Salary) ON Staff TO Director;
  • GRANT SELECT(Staff) ON Salary TO Director;
  • PERMIT Director SELECT ON Staff(Salary);

Frage 42

Frage
Which security strategy should be used for creating roles in a database?
Antworten
  • Creating groupings of users with different data access privileges
  • Creating groupings of privileges for a specific user in the database
  • Creating groupings of users with the same data access privileges
  • Creating groupings of privileges by database transactions

Frage 43

Frage
Which phase is part of optimistic concurrency control protocol for read-only transactions?
Antworten
  • Shrinking
  • Write
  • Growing
  • Validation

Frage 44

Frage
Which statement describes timestamping?
Antworten
  • Transactions with newer dates get priority over older dates.
  • Locking is used to achieve serialization and to prevent conflicts.
  • Timeouts used on lock requests wait as a method of deadlock prevention.
  • Transactions involved in a conflict can be rolled back and restarted.

Frage 45

Frage
Which algorithms proposed by Rosenkrantz et al. are used for deadlock prevention? Choose 2 answers
Antworten
  • Wound-wait
  • Wait-die
  • Conservative 2PL
  • Indefinite wait
  • Wait-for graph

Frage 46

Frage
What is the difference between a transaction with a shared lock and a transaction with an exclusive lock?
Antworten
  • A shared lock cannot access the item.
  • A shared lock can read the item.
  • A shared lock can delete the item.
  • A shared lock can update the item.

Frage 47

Frage
What is the term used to describe operations in transactions performed in order, without interleaved operations from other transactions?
Antworten
  • Non-serial schedule
  • Exclusive schedule
  • Serial schedule
  • Sanitized schedule

Frage 48

Frage
What is the concurrency control technique of locking?
Antworten
  • Validation
  • Pessimistic
  • Optimistic
  • Reading

Frage 49

Frage
A transaction must transform the database from one consistent state to another consistent state.
Antworten
  • Isolation
  • Atomicity
  • Consistency
  • Durability

Frage 50

Frage
Transactions execute independently of one another.
Antworten
  • Isolation
  • Atomicity
  • Consistency
  • Durability

Frage 51

Frage
A transaction is an indivisible unit that is either performed in its entirety or is not performed at all.
Antworten
  • Isolation
  • Atomicity
  • Consistency
  • Durability

Frage 52

Frage
The effects of a successfully completed transaction are permanently recorded in the database.
Antworten
  • Isolation
  • Atomicity
  • Consistency
  • Durability

Frage 53

Frage
Which characteristic does static optimization have when compared with dynamic optimization?
Antworten
  • Static optimization is done at run time, whereas dynamic optimization is done prior to run time.
  • Static optimization requires more runtime overhead, whereas dynamic optimization has less overhead.
  • Static optimization is optimized prior to execution, whereas dynamic optimization is optimized during run time.
  • Static optimization is continually up to date, whereas dynamic optimization is updated once.

Frage 54

Frage
What are the methods for replicating data to mobile environments? Choose 2 answers
Antworten
  • DBMS installed in the mobile device
  • Store a subset of data in the mobile device
  • Store logs to dynamically generate data on a mobile device
  • Mobile device using a wired connection
  • Mobile device acting as a master replica

Frage 55

Frage
A transaction is committed before a failure occurs that prevents buffers from writing to secondary storage. Which action should be taken to ensure durability of this transaction?
Antworten
  • Roll forward
  • Roll back
  • Partial undo
  • Flush

Frage 56

Frage
Which factors should be considered in designing a backup plan? Choose 2 answers
Antworten
  • How often to test by restoring backup data
  • How to process application logic
  • Where to store backup data
  • Where to run query optimization
  • How to combine relations during backup to save space

Frage 57

Frage
When this SQL code runs, all associated objectives will also be removed. DROP SCHEMA testingHouse CASCADE What happens if any of these sub drops fail?
Antworten
  • The DROP SCHEMA fails.
  • The DROP SCHEMA reruns failed drops.
  • The DROP SCHEMA skips failed drops.
  • The DROP SCHEMA deadlocks.

Frage 58

Frage
Which criterion is used to conduct a usability evaluation as part of database system testing?
Antworten
  • Administration
  • Robustness
  • Redundancy
  • Concurrency

Frage 59

Frage
What is true of a starflake schema?
Antworten
  • A starflake schema has multiple fact tables.
  • A starflake schema must use denormalized dimension tables and natural keys.
  • A starflake schema uses a network of hierarchical fact tables.
  • A starflake schema uses both normalized and denormalized dimension tables.
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

Gedächtnis
Nicole Girard
Réclamation - Phrases - Chapitre 6
Gaelle Bourgeois
SB Soziale Ungleichheit
Bibische
Vektorendefinition
Sinan 2000
Φαρμακολογια 1 Ε
Lampros Dimakopoulos
Französische Verben
Sofia Spörri
Kommunikationssoziologie (KSOZ) Grimm 2017/18
Anna Huber
Vetie AVO 2016
Johanna Müller
MS-1.3 Foliensatz 6-7
Markus Voßmann
Vetie Chirurgie 2020
Henriette Greiner
Vetie Fleisch 2021
Mascha K.