Started on | Saturday, March 5, 2022, 1:28 AM |
---|---|
State | Finished |
Completed on | Saturday, March 5, 2022, 1:39 AM |
Time taken | 11 mins 9 secs |
Grade | 196.00 out of 200.00 (98%) |
Started on | Saturday, March 5, 2022, 1:15 AM |
---|---|
State | Finished |
Completed on | Saturday, March 5, 2022, 1:22 AM |
Time taken | 7 mins 40 secs |
Grade | 19.00 out of 20.00 (95%) |
SQL supports the conditional execution of procedures (IF-THEN-ELSE statements) that are typically supported by a programming language.
CORRECT
A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about an entity is said to be in _____.
CORRECT
The SQL cache stores the end-user written SQL.
CORRECT
See: Ch. 11: Datab
The first step in developing the conceptual model using ER diagrams is to _____.
CORRECT
A derived attribute is indicated in the Chen notation by a _____ that connects the attribute and an entity.
CORRECT
Of the following events, which is defined by ANSI as being equivalent to a COMMIT?
CORRECT
In the context of developing a data administration strategy, a(n) _____ provides a framework that includes computerized, automated, and integrated tools such as a DBMS and CASE tools.
CORRECT
A relational table must not contain a(n) _____.
CORRECT
_____ fragmentation refers to the division of a relation into attribute subsets.
CORRECT
Relational data warehouses use the star schema design technique to handle multidimensional data.
CORRECT
Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set.
CORRECT
You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.
CORRECT
Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.
CORRECT
The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.
CORRECT
Database design is a(n) _____ process based on repetition.
CORRECT
Which of the following is a reason why a DBMS's daily operations must be clearly documented?
CORRECT
A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.
CORRECT
The transaction processor (TP) is the software component found in each computer that requests data.
CORRECT
A _____ key is defined as a key that is used strictly for data retrieval purposes.
CORRECT
A(n) _____ is an orderly arrangement used to logically access rows in a table.
CORRECT
_____ is a higher-level, object-oriented application interface used to access remote database servers.
CORRECT
Which of the following is a characteristic of the XML metalanguage?
CORRECT
A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.
CORRECT
The _____ must be set large enough to permit as many data requests to be serviced from cache as possible.
CORRECT
See: Ch. 11: Database
A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind.
CORRECT
Relational models view data as part of a table or collection of tables in which all key values must be identified.
CORRECT
In the Systems Development Life Cycle(SDLC), the design of the system's processes begins in the detailed systems design phase.
CORRECT
When using a HDFS, the ______ node creates new files by communicating with the ______ node.
CORRECT
Which of the following refers to the situation where different versions of the same data are stored at different places because they weren't updated consistently?
CORRECT
In the Chen and Crow's Foot notations, an entity is represented with a rectangle containing the entity's name.
CORRECT
In the wait/die scheme, the:
CORRECT
The database structure in a DBMS is stored as a _____.
CORRECT
The main disadvantage of using CGI scripts is that:
CORRECT
Which command would be used to delete the table row where the P_CODE is 'BRT-345'?
CORRECT
The Common Gateway Interface (CGI) is a newer web server interface standard that is much more efficient and faster than a dynamic link library (DLL).
CORRECT
No matter what language you use, if it contains embedded SQL statements, it is called the _____ language.
CORRECT
The _____ data model uses the concept of inheritance.
CORRECT
A(n) ______ is a tag that is used to associate a collection of nodes as being of the same type or belonging to the same group.
CORRECT
Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.
CORRECT
When performing user access management, a DBA defines each user to the database at the _____ levels.
CORRECT
The "_____" characteristic of a primary key states that the primary key must uniquely identify each entity instance, must be able to guarantee unique values, and must not contain nulls.
CORRECT
_____ tools focus on the strategic and tactical use of information.
CORRECT
The property of _____ enables an entity subtype to inherit the attributes and relationships of the supertype.
CORRECT
A(n) _____ join will select only the rows with matching values in the common attribute(s).
CORRECT
A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
CORRECT
See: Ch. 13: Business
A(n) _____ is anything about which data are to be collected and stored.
CORRECT
Relational databases rely on unstructured data.
CORRECT
During the _____ phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.
CORRECT
A field-level lock allows concurrent transactions to access the same row, as long as they require the use of different fields within that row.
CORRECT
Comments
Post a Comment