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?
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
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
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?
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?
Frage 36
Frage
Which type of data will be found by utilizing data mining?
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.