21482523
Descripción
Test por Craig Willey, actualizado hace más de 1 año
|
Creado por Craig Willey
hace más de 4 años
|
|
Pregunta 1
Pregunta
Which factor must be considered during physical database design?
Respuesta
-
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
Pregunta 2
Pregunta
Which technique is used to test the correctness of a logical database design model?
Respuesta
-
Prototyping
-
Normalization
-
Logical Grouping
-
Extensibility
Pregunta 3
Pregunta
Which database design phase uses normalization techniques to eliminate anomalies in the data model?
Respuesta
-
XML Database Design
-
Physical Database Design
-
Logical Database Design
-
Conceptual Database Design
Pregunta 4
Pregunta
Which step would be seen in the conceptual phase of data model design?
Respuesta
-
Specification of entities and relationships
-
Specification of trigger definitions
-
Specification of storage size
-
Specification of programming language to use
Pregunta 5
Pregunta
What describes a specialized grouping of entity type occurrences that must be represented in a data model?
Respuesta
-
Superclass
-
Baseclass
-
Relationship
-
Subclass
Pregunta 6
Pregunta
Which concept does the SQL statement "SELECT * FROM Contacts, Employer" demonstrate?
Respuesta
-
Difference
-
Cartesian product
-
Selection
-
Intersection
Pregunta 7
Pregunta
What is the difference between a conceptual model and a logical model?
Respuesta
-
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.
Pregunta 8
Pregunta
Which data type is considered a non-interpreted byte stream for a database management system (DBMS)?
Respuesta
-
Float
-
Character
-
Bit
-
BLOB
-
XML
Pregunta 9
Pregunta
Which database management systems (DBMS) architecture emerged in the third generation of DBMSs?
Choose 2 answers
Respuesta
-
Object structured
-
Object oriented
-
Object stacking
-
Object relational
Pregunta 10
Pregunta
What are strengths of database management systems (DBMS)?
Choose 2 answers
Respuesta
-
Size of software
-
Cost of DBMS
-
Control of data redundancy
-
Increased performance
-
Improved data integrity
Pregunta 11
Pregunta
Which DDL statement should be used to enforce referential integrity?
Respuesta
-
CREATE TRIGGER AFTER GRANT
-
CREATE TRIGGER BEFORE UPDATE
-
CREATE TRIGGER AFTER SELECT
-
CREATE TRIGGER BEFORE DROP
Pregunta 12
Pregunta
What describes a package in PL/SQL?
Respuesta
-
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
Pregunta 13
Pregunta
Which statement produces a PL/SQL stored procedure?
Respuesta
-
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
Pregunta 14
Pregunta
Which SQL statement will select all the data from the branch table, whether or not there are entries in the employee table?
Respuesta
-
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
Pregunta 15
Pregunta
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?
Respuesta
-
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
Pregunta 16
Pregunta
Which aggregate functions can be applied to both numeric and non-numeric fields?
Choose 2 answers
Respuesta
-
AVG
-
MAX
-
SUM
-
FLOOR
-
COUNT
Pregunta 17
Pregunta
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?
Respuesta
-
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
Pregunta 18
Pregunta
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
Respuesta
-
Range
-
Comparison
-
Pattern match
-
Set membership
Pregunta 19
Pregunta
Which statement will delete the staff member who is a manager with the staff ID "SG15"?
Respuesta
-
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'
Pregunta 20
Pregunta
Which statement must be used to increment staff salary by 4%?
Respuesta
-
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
Pregunta 21
Pregunta
Use the given statement to answer the following question:
INSERT INTO Production
VALUES ('Item123', 'Round');
Which function is performed in this statement?
Respuesta
-
Inserting a table into the database
-
Inserting a single row of data
-
Inserting data into random columns
-
Inserting multiple rows of data
Pregunta 22
Pregunta
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?
Respuesta
-
Creating a trigger
-
Creating a stored procedure
-
Creating a constraint
-
Creating an index
Pregunta 23
Pregunta
Which DDL statement creates an index that could be used as a candidate primary key?
Respuesta
-
CREATE VIEW INDEX
-
CREATE UNIQUE INDEX
-
CREATE PRIMARY INDEX
-
CREATE DROP INDEX
Pregunta 24
Pregunta
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?
Respuesta
-
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.
Pregunta 25
Pregunta
What is an example of the correct syntax for creating a new column in an existing table?
Respuesta
-
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
Pregunta 26
Pregunta
What is a benefit of using SQL?
Respuesta
-
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.
Pregunta 27
Pregunta
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?
Respuesta
-
Starflake schema
-
Network schema
-
Star schema
-
Snowflake schema
Pregunta 28
Pregunta
Which DM schema implements the given data model?
Respuesta
-
Network schema
-
Star schema
-
Relational schema
-
Constellation schema
Pregunta 29
Pregunta
A database architect is tasked with designing and implementing a data warehouse using a star schema.
Which design approach should the architect follow?
Respuesta
-
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
Pregunta 30
Pregunta
How does dimensional modeling differ from entity-relationship modeling?
Respuesta
-
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
Pregunta 31
Pregunta
Which data representation concept is associated with online analytical processing (OLAP)?
Respuesta
-
The concept of "slice and dice"
-
The concept of "associate arrays"
-
The concept of "hash tables"
-
The concept of "facts"
Pregunta 32
Pregunta
Which online analytical processing (OLAP) operations can be used for driving business decisions on data cubes?
Choose 2 answers
Respuesta
-
Slicing
-
Equijoining
-
Pivoting
-
Cascading
-
Validating
Pregunta 33
Pregunta
What is a benefit of distributed database management systems (DDBMS)?
Respuesta
-
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.
Pregunta 34
Pregunta
What is a reason for creating a data mart versus a data warehouse?
Respuesta
-
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.
Pregunta 35
Pregunta
What is the process of loading data extracted from different OLTP data sources into an enterprise data warehouse?
Respuesta
-
EER (Enhanced Entity-Relationship)
-
Fragmentation
-
Replication
-
ETL (Extract/Transform/Load)
Pregunta 36
Pregunta
Which type of data will be found by utilizing data mining?
Respuesta
-
Customer sales reports
-
Customer refund reports
-
Customer address lists
-
Customer loyalty identification
Pregunta 37
Pregunta
What is an advantage of using XML when presenting database management system (DBMS) data?
Respuesta
-
It provides data redundancy.
-
It implements intrinsic data types.
-
It supports data integration.
-
It combines content and presentation.
Pregunta 38
Pregunta
Which MIME type is used to transfer a regular ASCII file hosted in a database management system (DBMS) to a web client?
Respuesta
-
text/plain
-
application/pdf
-
text/html
-
image/gif
Pregunta 39
Pregunta
What is a common component of encoding data using asymmetric encryption?
Respuesta
-
Same encryption and decryption keys
-
Uni-directional encryption
-
Different encryption and decryption keys
-
Identical encryption and decryption algorithms
Pregunta 40
Pregunta
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
Respuesta
-
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
Pregunta 41
Pregunta
Which DCL command gives Director the privilege to SELECT on column Salary of the table Staff?
Respuesta
-
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);
Pregunta 42
Pregunta
Which security strategy should be used for creating roles in a database?
Respuesta
-
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
Pregunta 43
Pregunta
Which phase is part of optimistic concurrency control protocol for read-only transactions?
Respuesta
-
Shrinking
-
Write
-
Growing
-
Validation
Pregunta 44
Pregunta
Which statement describes timestamping?
Respuesta
-
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.
Pregunta 45
Pregunta
Which algorithms proposed by Rosenkrantz et al. are used for deadlock prevention?
Choose 2 answers
Respuesta
-
Wound-wait
-
Wait-die
-
Conservative 2PL
-
Indefinite wait
-
Wait-for graph
Pregunta 46
Pregunta
What is the difference between a transaction with a shared lock and a transaction with an exclusive lock?
Respuesta
-
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.
Pregunta 47
Pregunta
What is the term used to describe operations in transactions performed in order, without interleaved operations from other transactions?
Respuesta
-
Non-serial schedule
-
Exclusive schedule
-
Serial schedule
-
Sanitized schedule
Pregunta 48
Pregunta
What is the concurrency control technique of locking?
Respuesta
-
Validation
-
Pessimistic
-
Optimistic
-
Reading
Pregunta 49
Pregunta
A transaction must transform the database from one consistent state to another consistent state.
Respuesta
-
Isolation
-
Atomicity
-
Consistency
-
Durability
Pregunta 50
Pregunta
Transactions execute independently of one another.
Respuesta
-
Isolation
-
Atomicity
-
Consistency
-
Durability
Pregunta 51
Pregunta
A transaction is an indivisible unit that is either performed in its entirety or is not performed at all.
Respuesta
-
Isolation
-
Atomicity
-
Consistency
-
Durability
Pregunta 52
Pregunta
The effects of a successfully completed transaction are permanently recorded in the database.
Respuesta
-
Isolation
-
Atomicity
-
Consistency
-
Durability
Pregunta 53
Pregunta
Which characteristic does static optimization have when compared with dynamic optimization?
Respuesta
-
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.
Pregunta 54
Pregunta
What are the methods for replicating data to mobile environments?
Choose 2 answers
Respuesta
-
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
Pregunta 55
Pregunta
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?
Respuesta
-
Roll forward
-
Roll back
-
Partial undo
-
Flush
Pregunta 56
Pregunta
Which factors should be considered in designing a backup plan?
Choose 2 answers
Respuesta
-
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
Pregunta 57
Pregunta
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?
Respuesta
-
The DROP SCHEMA fails.
-
The DROP SCHEMA reruns failed drops.
-
The DROP SCHEMA skips failed drops.
-
The DROP SCHEMA deadlocks.
Pregunta 58
Pregunta
Which criterion is used to conduct a usability evaluation as part of database system testing?
Respuesta
-
Administration
-
Robustness
-
Redundancy
-
Concurrency
Pregunta 59
Pregunta
What is true of a starflake schema?
Respuesta
-
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.
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.