Tentamen (uitwerkingen)
WGU D427 - Database Management Applications
- Vak
- Instelling
WGU D427 - Database Management Applications
[Meer zien]Voorbeeld 2 van de 9 pagina's
Voorbeeld 2 van de 9 pagina's
In winkelwagen
In winkelwagen
gesponsord bericht van onze partner
Verkoper
Volgen
EvaTee
Ontvangen beoordelingen
Voorbeeld van de inhoud
WGU D427 - Database Management ApplicationsSchema - Answer The definition of how data in a database will be organized.
- Create
- Read
- Update
- Delete - Answer The basis of interacting with databases can be defined using the CRUD acronym. What does CRUD stand for?
DATE: YYYY-MM-DD
DATETIME: YYYY-MM-DD HH:MM:SS - Answer What is the DATE datatype syntax?
What is the DATETIME datatype syntax?
It will have 3 numbers before the decimal and 2 after. - Answer What does DECIMAL(3,2) indicate?
Stored Procedures - Answer a series of commands stored on the database. This allows the reuse of long or detailed queries instead of writing them for each use. It also provides a safe way to deal with sensitive data, especially with those unfamiliar with SQL syntax.
Data definition language (DDL) - Answer involves instructing the DBMS software on what tables will be in the database, what attributes will be in the tables, which attributes will be indexed, and so forth.
data manipulation languages (DMLs) - Answer refers to the four basic operations that can and must be performed on data stored in any DBMS (or in any other data storage arrangement, for that matter): data retrieval, data update, insertion of new records, and deletion of existing records.
SELECT *
FROM CUSTOMER
WHERE CUSTNUMB BETWEEN 1 AND 2; - Answer What would the SELECT statement look like if you use a BETWEEN.
SELECT *
FROM CUSTOMER
WHERE HQCITY IN ('Atlanta', 'Chicago', 'Washington'); - Answer What would the SELECT statement look like if you use a IN.
SELECT *
FROM CUSTOMER
WHERE HQCITY LIKE 'W%'; - Answer What would the SELECT statement look like if you use a LIKE. WGU D427 - Database Management Applications
A% - The "%" means that any string of characters can follow afterwards. The percent
sign represents zero or more arbitrary regular characters
A_ - The _ means that there will be exactly one letter following the A. The underscore represents a single arbitrary regular character. - Answer What are the two ways of using the LIKE command?
The clause can include the term ASC at the end to make ascending explicit or it can include DESC for descending order. - Answer The default order for ORDER BY is ascending. How can you make it descending order?
SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name)
FROM SALES
WHERE Name = 'Matt'; - Answer Command to use AVG/SUM/MIN/MAX/COUNT aggregate functions?
o One is that the tables to be joined must be listed in the FROM clause.
o Two is that the join attributes in the tables being joined must be declared and matched to each other in the WHERE clause. - Answer There are two specifications to make in the SELECT statement to make a join work.
SELECT SPNAME
FROM SALESPERSON, CUSTOMER
WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM - Answer Example of JOIN
CAUSE.
Dr. CODD - Answer In 1970, Dr. _________ of IBM published in Communications of the ACM a paper entitled "A Relational Model of Data for Large Shared Data Banks."
This paper marked the beginning of the field of relational databases.
CREATE TABLE
DROP TABLE - Answer Commands to create and drop a table?
- When you create the column definition (known as a column constraint).
- When you use the CONSTRAINT keyword (known as a table constraint). - Answer The CREATE TABLE command lets you define constraints in two different places:
NOT
WHERE Location NOT IN ('WV', TN' 'CA');
WHERE Total NOT Between '1000', 2000';
WHERE Name NOT LIKE 'Ma%'; - Answer You can exclude rows with other types of
conditions by using the ______ operator.
USE
Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:
Bewezen kwaliteit door reviews
Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!
In een paar klikken geregeld
Geen gedoe — betaal gewoon eenmalig met iDeal, creditcard of je Stuvia-tegoed en je bent klaar. Geen abonnement nodig.
Direct to-the-point
Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper EvaTee. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €13,73. Je zit daarna nergens aan vast.
Is Stuvia te vertrouwen?
4,6 sterren op Google & Trustpilot (+1000 reviews)
Afgelopen 30 dagen zijn er 68175 samenvattingen verkocht
Opgericht in 2010, al 15 jaar dé plek om samenvattingen te kopen