Save
Upgrade to remove ads
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

info man

midterm

QuestionAnswer
E-R models are found in the conceptual schema of the database. True or false? True
What is the storehouse for metadata? Repository
Expand the words in CASE. Computer-aided software engineering
In program data dependency, each application program needs to include code for the metadata of each file. Is the statement true or false? True
The purpose of Planning in SDLC is the preliminary understanding of what the system is. True or false? True
In a three tiered client server database architecture, what is the database that contains all organizational data or summaries of data on department servers web tier
The database approach stores a data in a standardized, convenient form. Is the statement true or false? True
A metadata is a data that characterizes the properties and context of user data. True
Which among the following is an example of an unstructured data large text documents
What approach in database development that is time-consuming, but comprehensive? SYSTEM DEVELOPMENT LIFE CYCLE / SDLC
Operational programs, documentation and training materials are the deliverables of the implementation step in SDLC. True or false? True
What kind of database technology started in the 1980s and is under active development as of 2020? Relational
E-R models are found in the internal schema of the database. True or false? False
A data warehouse is an integrated decision support system derived from various operational databases. True or false? True
Implementation and maintenance activities are done repetitively with new prototype versions. True or false? True
The associative entity may participate in other relationships other than the entities of the associated relationship. True or false? True
There may be a value for every entity in an optional attribute. True or false? True
What is an attribute or combination of attributes that uniquely identifies individual instances of an entity type? Identifier
A required attribute must contain no value for every entity. True or false? False
What is a type of attribute whose values can be calculated from related attribute value? Derived
Entities of two different types related to each other is a binary degree of relationship. True or false? True
What is the number of instances of one entity that can be associated with each instance of another entity? Cardinality
The associative entity preferably has a unique identifier, and should also have other attributes. True or false? True
What is the relationship that links strong entities to weak entities? Identifying relationship
An optional attribute means that the value can be left blank. True or false? True
All relationships for the associative entity should be many. True or false? True
True or false. The total specialization rule in completeness constraints is represented by a double line True
What is an attribute of the supertype whose values determine the target subtype(s)? Subtype discriminator
What is a model that extends the original ER model with new modeling constructs? Enhanced ERD
When EERDs are difficult to read, the solution to this is to group entities and relationships into entity clusters? True
True or false. If supertype A has a relationship with supertype B, the subtypes under supertype A will also have a relationship with supertype B. True
These is a set of one or more entity types and associated relationships grouped into a single abstract entity type. Entity Cluster
True or false. The instances of a subtype must participate in a relationship unique to that subtype. False
True or false. A subtype can have a relationship with other subtypes. True
True or false. An instance of a subtype is also an instance of the supertype. True
True or false. The disjoint rule in disjointness constraints is where an instance of the supertype could be more than one of the subtypes. False
It is a generic entity type that has a relationship with one or more subtypes. supertype
A well-structured relation contains minimal redundancy and allows users to insert, delete, and update rows without cause data inconsistencies. TRUE OR FALSE True
A 2NF is a 1NF plus every non-key attribute is fully functionally dependent on the entire primary key. True
A well-structured relation contains no redundancy and allows users to insert, delete, and update rows without cause data inconsistencies. False
A table that pertains to more than one entity type is a well-structured relation. False
A 2NF is a 1NF plus no transitive dependencies. False
What is a primarily a tool to validate and improve a logical design so that it satisfies certain constraints that avoid unnecessary duplication of data. Data normalization
A transitive dependency is when a non-key is functionally dependent on another non-key. True
When there is an existing multivalued attribute in a 1NF table, it means its relation. False
A table with no multivalued attributes is considered to be in what form? 1NF
True or false. In functional dependencies, each key field is functionally dependent on every candidate key. False
Dependence on a single vendor is a benefit of a standardized relational languag False
During the maintenance phase of the database development process the controlling of the database is found here, like grant add and revoked commands? True
The transaction control has the following commands: commit, rollback and save point. True
In 1986, ANSI first released the SQL standard. True
In 1970, the relational database concept was developed. True
In which year did Oracle markets its first relational database with SQL? 1979
What is a data type that stores string values containing any characters in the character set? Character
Loading the database by inserting data, updating the database, and manipulating the database are parts of the implementation process during the database development process. True
The rename and the update are both commands in data definition language. False
What is a data type the store's exact numbers with a defined precision and scale numeric
Writing and executing SQL, PL/SQL an SQL *plus statements are done on notepad in SQL developer? False
What is a data type in SQL that stores a moment and event occurs using a definable fraction of a second precision? Time stamp
What is a foreign key constraint keyword that identifies the table and column in the parent table. References
Given the SQL statement: CREATE TABLE SAMPLE1 (ID NUMERIC(10) NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR2(100)); ,which command makes an attribute a unique key? primary key
The table names and column names should have a duplicate name with other tables and other columns False
What is a variable length numeric data kind of data type number
Given the SQL statement: Alter table sample1 drop column ID; , this statement deletes the table sample1. TRUE OR FALSE False
What statement can you use to put the table back into a read or write mode from a read mode only table? Read Write
Which among the following statements will create a table with two columns CREATE TABLE STUDENT (Studentid numeric(4,2), studentfirstname varchar2(50));
A user can name a constraint or Oracle server generates a name by using the SYS_CN format True
You can view a constraint inside a table in the database False
What data type is a fixed length character data car
Creating a constraint can be done at the same time as the creation of the table or after the creation of the table True
A DDL SQL statement that removes all rows from a table, leaving the table empty and the table structure intac TRUNCATE
When you drop a table from the database it moves the table to the recycle bin. True
To remove the table and all its data entirely, use purge after the drop table command. True
Given the SQL statement: CREATE TABLE SAMPLE1 (ID NUMERIC(10) NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR2(100));, which command that makes an attribute not nullable not null
Projects are initiated and planned during the maintenance stage of SDLC. True or false? True
A ____ is a software for managing the database Database Management System
A Text is an example of what kind of data Structured Data
The purpose of the physical design step in SDLC is develop technology and organizational specifications True
Information requirement elicitation and structure is the purpose of the logical design in SDLC. True or false? True
What do you call a planned execution of related tasks to accomplish a goal with a start and finish? Project
What is the kind of database technology that has started in the 1960s and has became a legacy system in the mid 1980s Flat files
External schema is the subset of the conceptual schema. True or false? True
SDLC is a detailed, well-planned development process. True or false? True
The deliverable of the logical design of SDLC is the detailed design specification. True or false? False
What are a graphical system that captures the nature and relationship of data? Data Models
What is a component of a database environment that is the storehouse of the data? Database
Attributes that contains data that will change overtime is the best attribute for an identifier. True or false? False
A composite attribute has meaningful component parts. True or false? True
This cardinality of relationships is an entity in the relationship will have exactly one related entity. One to one
A ternary relationship should be converted to an associative entity. True or false? True
Multivalued attributes can be represented as relationships. True or false? True
A strong entity does not have an identifier. True or false? False
All relationships for the associative entity should be one to many. True or false? False
The associative entity could have meaning independent of the other entities. True or false? True
What is an entity that is a combination of relationship and entity? Associative entity
These are the or characteristics of an entity or relationship type. Attributes
What is a composite attribute whose subparts pertain to different subtypes? Overlapping
What is a simple attribute with alternative values to indicate the possible subtypes? Disjoint
True or false. The partial specialization rule in completeness constraints is represented by a single line True
It is the process of defining one or more subtypes of the supertype and forming supertype or subtype relationships. Top-down
True or false. An instance of a subtype cannot be instance of the supertype. False
A deletion anomaly is when adding a row in a table forces users to create duplicate data. False
A candidate key is not allowed to be a primary key. False
It is said to be that a table is in 1NF, if it is in 2nd normal form and every non-key attribute is fully functionally dependent of the entire primary key. False
What is the purpose of data normalization? The purpose of data normalization is to decompose relations with anomalies to produce smaller, well structured relations
A 2NF has no partial dependencies. True
The create command is one of the commands of data manipulation language. False
Standardization of SQL allows for later growth/enhancement of the standard. True
Who is the person who developed the relational database concept? Edgar F. Codd
Launching of the SQL worksheet is found in the source tab of the SQL developer. False
What is the datatype that stores binary string values in hexadecimal format? BLOB
During the database development process the defining of the database is done in the physical design True
You can review the definitions of objects at a glance in the connections navigator of your SQL developer. True
Legrant command is one of the commands of the DCL. True
What is the abbreviation of DDL? Data Definition Language
What is a statement that allows you to rename an existing column in an existing table in any schema rename column
Naming table names and column names should not duplicate the name of another object owned by the same user. True
Defining constraint can be done at the column or at the table level True
In naming table names and column names, the name should not be an Oracle server reserved word. True
The flashback table statement enables you to recover tables to a specified point in time with a single statement. True
Relational integrity is enforced via the primary-key to foreign-key match. True
What is a foreign key constraint keyword the defines the column in the child table at table-constraint level? Foreign key
What statement can you use to put the table into read mode which prevents DDL or DML changes during table maintenance? Read only
Which among the following is not an advantage of a database approach? Lack of standards
What is an element of the database approach wherein it is composed of attributes and it’s a noun form describing a person, place, object or concept? Entities
Who are the personnel that is responsible for designing databases and software? Database administrators
The internal schema is the underlying design and implementation of the database. True or false? False
What is an organized collection of logically related data? Relation
Which schema in the database consists of the user views? External Schema
One problems of a database approach is compromised data integrity. Is the statement true or false? False
One of the costs in database approach is hiring new and specialized personnel to manage the DBMS. Is the statement true or false? True
The waste of space caused by having duplicate data is a challenge with database approaches. Is the statement true or false? False
What do you call the people who use the applications and the database? End users
The purpose of the physical design step in SDLC is information requirements elicitation and structure. True or false? False
Is limited data sharing with no centralized control of data a disadvantage of file processing? Yes
The biggest problem in data redundancy is changes in one file could cause inconsistencies. This problem compromises what? Data integrity
In choosing an identifier for an entity, choose an entity that will not change in value and will not be null. True or false? True
These are the or characteristics of an entity or relationship type. one to one
Unary relationships should be converted to associative entities. True or false? False
Perfect identifiers are the attributes that contain locations. True or false? False
If supertype A has three subtypes, which are subtypes 1, 2 and 3, and subtypes 1 and 2 have a relationship, this means that subtype 3 has also a relationship with subtypes 1 and 2. False
What is a constraint in supertype/subtype that identifies whether an instance of a supertype may simultaneously be a member of two or more subtypes? Disjointness Constraint
True or false. The disjoint rule in disjointness constraints is an instance of the supertype can be only one of the subtypes. True
True or false. Relationships at the supertype level indicate that all subtypes will participate in the relationship. True
True or false. A completeness constraint identifies whether an instance of a supertype must also be a member of at least one subtype. True
How do you know if a table has no anomalies? A table should not pertain to more than one entity type.
When there is an existing multivalued attribute in a 1NF table, it means its not a relation. True
True or false. A 1NF table is a table with no multivalued attributes and every attribute is atomic. True
A modification anomaly is when revising data in a row forces changes to other rows because of duplication. True
To execute a sequence of SQL statements, you should click the run script button instead of the execute statement button. False
What is the language that is standard for relational database management system SQL
What is a database management system that manages data as a collection of tables in which all relationships are represented by a common values in related tables? RDBMS
The system R with sequel later became SQL. True
IBM created the system R with sequel. True
Reduce dependence on single vendor is one of the benefits of a standardized relational language. True
The abbreviation of SQL is Structured Query Language. True
What is a data type that stores exact numbers with a predefined precision and scale of zero Integer
Creating a constraint is only done at the time when the table is created False
What data type has a variable length character data varchar2
These enforces rules at the table level and prevents the deletion of a table if there are dependencies EXCLUSIVE
You can define a constraint of the column level only False
In naming tables and column names in database it must begin with the letter and must contain only alphanumeric characters, an underscore, a dollar sign or a number sign. True
Created by: f3xo
 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards