Management homework help

By

Management homework help. Database Design
 
 

What is a data model?
method of storing files on a disk drive
simple representation of complex real-world data structures
name of system for designing software
method of designing invoices for customers

 

Which of the following are the most important elements of a security program for databases:

Integrity, referential index, user rights
Integrity and Availability
Availability, multi-master replication, high-bandwidth
DBA, System Admin, and PMO

 

Suppose that you have a table with a number of product sales. The product code may repeat in the table as it is likely the same product could be sold multiple times. If you want to produce a list of the unique products that are sold, you could use which of the following keywords in the SELECT statement:
LIKE
ORDERED BY
DISTINCT
DIFFERENT

 

What does the column represent in a table?

Attribute of the table records
A complete record in the table
The system log from the database
A list of database tables

 

What does a row in the table represent?

A complete data record
List of system logs
A list of file systems on database server
The primary keys from all the tables.

 

Which of the following is an example of data definition language (DDL)?

UPDATE
V$SYSLOG
CREATE
DETAIN

 
 
7 . Which of the following is an example of data manipulation language (DML)?

SELECT
ABORT
GRANT
REVOKE
A _____________ key is an attribute that uniquely identifies a record in a table.
A _____________ key is an attribute that is a primary key in one table and is used as a reference in a second table to establish a relationship between the two tables.
When running a ‘SELECT’ join, what is returned from the table:
ROW
Column
single attribute
all tables in the database

 

When running a ‘PROJECT’ join, what is returned from the table:
COLUMN
ROW
Single Attribute
a list of tables in the database

 

What are the 3 types of relationships commonly shown on an entity relationship diagram?
1 to 1
1 to Many
Many to Many
All the above
None of the above

 

What is an entity relationship diagram (ERD)?
graphical representation of all entities in a database and how the entities are related
list of the log files in the database.
list of all the tablespace names in a database
A diagram that shows how data is written to a physical disk drive.

 

The definition of an attribute in a table that has no value is:
ZERO
NULL
ZILTCH
NONE

 

A __________ attribute can either be stored on retrieve on an ad hoc basis.

 

Which of the following is not considered a characteristic of distributed management systems:
Concurrency Control
Business intelligence
Transaction management
query optimization

 

A database can process many types of data classifications. Which of the following is not a data classification or architecture that databases can process:
Structured
Semi-structured
undelimited
Unstructured
The process by which functional/partial dependency and transitive dependency is removed from a database table is called:
sharding
normalization
defragmentation
reallocation

 

A type of database that is used for decision making and business intelligence is what type of database:
general purpose database
content management database
analytical database
cloud database

 

All of the following are disadvantages to database systems except which of the choices below:
Vendor dependence
increased security
increased management complexity
Frequent upgrade cycles

 
 

A methodology that is made up of 5 phases that cover the creation of the database and the operation of the database is called:
Agile Programming
System Development Lifecyle (SDLC)
Design and Analysis
Capability Maturity Model
The following object in a database can speed up access to the data as well facilitate searching and sorting operations:
Shards
two-phase commit
Indexes
Views
Which of the following is not a data structure used to implement indexes:
Hash
stack
bitmap
b-tree
Which of the following lead to the development of distributed databases:
Applications as a service
Mobile and wireless applications
Big Data and Business Intelligence
All the above
Suppose that a query is created to list the Lastname, Firstname and Address of each individual in a table. If the results are needed to be returned in alphabetical order based on the lastname, which of the following would achieve the result:
SELECT Lastname, Fistname, address from Tbl_Persons ORDERED BY Lastname;
SELECT Lastname, Firstname, address from tbl_persons where Lastname = “ORDERED BY”;
SELECT Lastname, Firstname, address from tbl_persons;
SELECT count(Lastname) from tbl_persons;

 
Management homework help

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services