Management homework help

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

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