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