Protection of data from unauthorized Disclosure results in loss of _______
Answer: C
Correct answer: Confidentiality
Confidentiality is the property that data is disclosed only to those authorised to see it, so unauthorised disclosure is precisely its loss. Integrity concerns unauthorised change and availability unauthorised denial of access.
Please log in or register to report this question.
_____ database is used to provide statistical information or summaries of values based on various criteria.
Answer: A
Correct answer: Statistical
A statistical database is one designed to answer questions about aggregates - counts, sums, averages - rather than about individual records, which raises the particular problem of preventing individual values from being deduced from a series of summaries.
Please log in or register to report this question.
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
Answer: B
Correct answer: Illustra
Illustra, the object-relational system built on the Postgres research work, was bought by Informix and became the Informix Universal Server.
Please log in or register to report this question.
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.
Answer: A
Correct answer: Data Manipulation
The Data Manipulation Language - SELECT, INSERT, UPDATE, DELETE - operates on the data in tables that already exist. Creating the tables themselves is the Data Definition Language's work.
Please log in or register to report this question.
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
Answer: B
Correct answer: AND
AND requires every condition to be satisfied, so a row appears only if all of them hold. OR would admit a row satisfying any one of them.
Please log in or register to report this question.
A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.
Answer: C
Correct answer: Transaction
A transaction is the unit of database processing: a group of operations that must all take effect or none, so that the database moves from one consistent state to another. That is what makes it the unit for recovery and concurrency control.
Please log in or register to report this question.
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Answer: D
Correct answer: Client
In client-server architecture the client runs on the user's own machine and handles the interface, while the server holds the data and does the shared work.
Please log in or register to report this question.
A data type or format is specified for each _________
Answer: B
Correct answer: Domain
Each attribute of a relation draws its values from a domain, and the data type or format is the specification of that domain. A tuple is a row and contains values of many different types.
Please log in or register to report this question.
The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E
Answer: A
Correct answer: Regular
A regular, or strong, entity type has its own key and maps directly to a relation containing its simple attributes. A weak entity has no key of its own and must borrow the key of its owner, so its mapping is a different rule.
Please log in or register to report this question.
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.
Answer: C
Correct answer: Single
A single-user system allows at most one user at a time, which is why concurrency control is unnecessary in it. Multi-user systems must handle simultaneous access, which is where locking and transactions become essential.
Please log in or register to report this question.
