Copy and Edit

C192 Pre-Assessment WGU

Description

College C192 Databases Quiz on C192 Pre-Assessment WGU, created by Craig Willey on 23/03/2020.
Craig Willey
Quiz by Craig Willey, updated more than 1 year ago
Craig Willey
Created by Craig Willey about 4 years ago
8
0
0

Resource summary

Question 1

Question
Which factor must be considered during physical database design?
Answer
  • 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

Question 2

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

Question 3

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

Question 4

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

Question 5

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

Question 6

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

Question 7

Question
What is the difference between a conceptual model and a logical model?
Answer
  • 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.

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

Question
What describes a package in PL/SQL?
Answer
  • 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

Question 13

Question
Which statement produces a PL/SQL stored procedure?
Answer
  • 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

Question 14

Question
Which SQL statement will select all the data from the branch table, whether or not there are entries in the employee table?
Answer
  • 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

Question 15

Question
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?
Answer
  • 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

Question 16

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

Question 17

Question
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?
Answer
  • 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

Question 18

Question
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
Answer
  • Range
  • Comparison
  • Pattern match
  • Set membership

Question 19

Question
Which statement will delete the staff member who is a manager with the staff ID "SG15"?
Answer
  • 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'

Question 20

Question
Which statement must be used to increment staff salary by 4%?
Answer
  • 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

Question 21

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

Question 22

Question
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?
Answer
  • Creating a trigger
  • Creating a stored procedure
  • Creating a constraint
  • Creating an index

Question 23

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

Question 24

Question
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?
Answer
  • 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.

Question 25

Question
What is an example of the correct syntax for creating a new column in an existing table?
Answer
  • 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

Question 26

Question
What is a benefit of using SQL?
Answer
  • 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.

Question 27

Question
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?
Answer
  • Starflake schema
  • Network schema
  • Star schema
  • Snowflake schema

Question 28

Question
Which DM schema implements the given data model?
Image:
Screen+Shot+2020 03 24+At+6.45.19+Pm (binary/octet-stream)
Answer
  • Network schema
  • Star schema
  • Relational schema
  • Constellation schema

Question 29

Question
A database architect is tasked with designing and implementing a data warehouse using a star schema. Which design approach should the architect follow?
Answer
  • 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

Question 30

Question
How does dimensional modeling differ from entity-relationship modeling?
Answer
  • 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

Question 31

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

Question 32

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

Question 33

Question
What is a benefit of distributed database management systems (DDBMS)?
Answer
  • 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.

Question 34

Question
What is a reason for creating a data mart versus a data warehouse?
Answer
  • 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.

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

Question
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
Answer
  • 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

Question 41

Question
Which DCL command gives Director the privilege to SELECT on column Salary of the table Staff?
Answer
  • 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);

Question 42

Question
Which security strategy should be used for creating roles in a database?
Answer
  • 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

Question 43

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

Question 44

Question
Which statement describes timestamping?
Answer
  • 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.

Question 45

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

Question 46

Question
What is the difference between a transaction with a shared lock and a transaction with an exclusive lock?
Answer
  • 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.

Question 47

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

Question 48

Question
What is the concurrency control technique of locking?
Answer
  • Validation
  • Pessimistic
  • Optimistic
  • Reading

Question 49

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

Question 50

Question
Transactions execute independently of one another.
Answer
  • Isolation
  • Atomicity
  • Consistency
  • Durability

Question 51

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

Question 52

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

Question 53

Question
Which characteristic does static optimization have when compared with dynamic optimization?
Answer
  • 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.

Question 54

Question
What are the methods for replicating data to mobile environments? Choose 2 answers
Answer
  • 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

Question 55

Question
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?
Answer
  • Roll forward
  • Roll back
  • Partial undo
  • Flush

Question 56

Question
Which factors should be considered in designing a backup plan? Choose 2 answers
Answer
  • 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

Question 57

Question
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?
Answer
  • The DROP SCHEMA fails.
  • The DROP SCHEMA reruns failed drops.
  • The DROP SCHEMA skips failed drops.
  • The DROP SCHEMA deadlocks.

Question 58

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

Question 59

Question
What is true of a starflake schema?
Answer
  • 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.
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Market failure and government intervention - Definitions
clm3496
Cold War (1945-1975)
sagar.joban
Project Management Integration
craigmag
OCR GCSE Latin Vocab flash cards - all
jess99
Databases
Dean Whittle
Sociology- Family and Households Flashcards
Heloise Tudor
Present Simple vs. Present Continuous
Marek Mazur
The structure of the Heart, AS Biology
mill-bill
OCR AS CHEMISTRY A DEFINITIONS
awesome.lois
Latin Literature Exam Techniques
mouldybiscuit
Language Analysis
Connie Theobald
Browse Library