Which functions are supported within a database management system (DBMS)? Choose 2 answers Requirements gathering Controlled access to the database@@ Data manipulation@@ Logical data correctness verification Data business rules generation Match each model with its corresponding product Answer options may be used more than once or not at all Hierarchical �
...[Show More]
Which functions are supported within a database management system (DBMS)?
Choose 2 answers
Requirements gathering
Controlled access to the database@@
Data manipulation@@
Logical data correctness verification
Data business rules generation
Match each model with its corresponding product
Answer options may be used more than once or not at all
Hierarchical IMS
Network IDMS
Relational oracle
Which binary data type is used within a database management system (DBMS)?
BLOB @@@@
NVARCHAR2
ROWID
FLOAT
Which term can be described as the immunity of the external schemas to changes in the conceptual schema?
Logical data independence@@@
Database management system (DMBS) independence
Object independence
Physical data independence
Consider the input relation staff with attributes staff_number, first_name, last_name, and salary
Which operations need to be used to produce a new relation containing those staff tuples with a salary greater than $8,000 and attributes first_name, last_name, and salary?
Choose 2 answers
Projection@@
Selection@@@
Cartesian product
Difference
Join
Union
Which type of relationship is used to represent how data will be stored in an enhanced entity-relationship (EER) model?
Aggregation@@
Anomaly
Security
Consistency
What is the first phase of database design called?
Object-oriented database design
Physical database design
Logical database design
Conceptual database design@@
Which technique is used to test the correctness of the logical data model during the design phase?
Composition
Indexing
Aggregation
Normalization@@
What is a characteristic of a logical database design?
Logical database design specifies system triggers
Logical database design is based upon the relational model
Logical database design occurs before conceptual database design
Logical database design is independent of a system’s physical requirements@@@
What is physical database design tailored to?
The number of tables
The hard disk manufacturer
The query language
The specific DBMS@@@
What is a valid data definition language (DDL) command?
Alter @@@
Execute
Update
Grant
CREATE TABLE Students(
studentNo StudentNumber NOT NULL,
firstName FirstName NOT NULL,
lastName LastName NOT NULL,
collegiateLevel CollegiateLevel NOT NULL DEFAULT ‘undergraduate’,
enrollment Enrollment NOT NULL DEFAULT ‘fulltime’,
tuitionRate NOT NULL DEFAULT 500,
PRIMARY KEY (studentNo) );
Which value would be saved for a student if that student was inserted without a specified tuitionRate , based on this CREATE TABLE ?
NULL
‘undergraduate’
‘fulltime’
500@@@@
What is an example of the correct syntax for creating a view?
CREATE VIEW StateCity INTO (State, City) SELECT DISTINCT State, City FROM StateCityZip
ADD VIEW StateCity (SELECT DISTINCT State, City FROM StateCityZip)
ADD VIEW StateCity AS (SELECT DISTINCT State, City FROM StateCityZip)
CREATE VIEW StateCity AS SELECT DISTINCT State, City FROM StateCityZip@@@@
What is an example of the correct syntax for creating an index?
ADD INDEX xStateCity ON TABLE StateCity (State, City)
CREATE INDEX xStateCity ON TABLE StateCity (State Ascending, City)
CREATE INDEX xStateCity ON StateCity (State, City)@@@@
ADD INDEX xStateCity ON StateCity (State, City)
Use the given DDL for a child table to answer the question below:
CREATE TABLE invoice
(
invoiceNumber INT NOT NULL,
clientID INT NOT NULL DEFAULT 1000,
PRIMARY KEY (invoiceNumber),
FOREIGN KEY (clientID) REFERENCES clients (clientID)
ON DELETE ________________
)
Which code snippet will complete the child table and allow the DDL to reject the delete operation from the parent table?
SET DEFAULT
CASCADE
NO ACTION@@@
SET NULL
[Show Less]