Create database syntax - Study guides, Class notes & Summaries

WGU - Pre-Assessment: Data Management - Applications (FJO1) (PFJO) Questions and Answers Already Passed A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? Many-to-many Which two examples are attributes? A person attending a meeting An employee number A sales meeting A meeting code An employee number A meeting code Which delete rule sets column values in a child tab...

The syntax of the DECODE function starts with _____. correct answers DECODE(e, x, y, d) String manipulation functions are rarely used in programming correct answers False If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause. correct answers JOIN ON An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value correct answers True In Oracle, the _____ function...

Which kind of relationship is displayed in this entity-relationship diagram? A Many-to-many unary B Many-to-many binary C One-to-one unary D One-to-one binary A Which kind of relationship is displayed in this entity-relationship diagram? A Binary many-to-many B Unary one-to-one C Ternary many-to-many D Ternary one-to-one D Unary many-to-many E Binary one-to-one B How is this portion of the entity-relationship diagram read, from left to right? A At least one book was written by an author. B Only ...

Which command creates a database only if it does not already exist? o :## CREATE DATABASE IF NOT EXISTS db_name; SELECT PRODNUM, SUM(QUANTITY)FROM SALESPERSONWhich line, when added to the end of the statement, returns the total number of each kind of product by product number? o :## GROUP BY PRODNUM; Which data definition language statement affects databases or objects in them? o :## ALTER Which two SQL data types can represent images or sounds? o :## Binary, Tinyblob Which method cr...

WGU CS1011 Sophia Introduction to Relational Databases Milestone 2 Retake Questions and Answers Score 20/25. 20/25  that's 80% RETAKE  20 questions were answered correctly. 4 questions were answered incorrectly. 1 question was skipped. These were marked incorrect. In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. Which of the fol...

WGU CS1011 Sophia Introduction to Relational Databases Milestone 2 Retake Questions and Answers Score 20/25. 20/25  that's 80% RETAKE  20 questions were answered correctly. 4 questions were answered incorrectly. 1 question was skipped. These were marked incorrect. In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. Which of the fol...

OutSystems Exam 3 Questions and Answers Already Passed In OutSystems, User Groups allow you to ... A. ... create new user Sessions for multiple users at the same time. B. ... assign the same password to multiple users at the same time. C. ... grant the access to the same Screens to multiple users at the same time. D. ... assign and revoke a Role to multiple users at the same time. D Select the correct option regarding Server Action. A. A Server Action can only have one Output Param...

C170 - PRE-ASSESSMENT QUESTIONS AND ANSWERS GRADED A+ A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? One-to-one One-to-many Many-to-many One-to-one binary Many-to-many Which two examples are attributes? Choose 2 answers A person attending a meeting An employee number A sales meeting A meeting code An employee number A meeting code Brainpower Rea...

What is the main goal of database normalization? - correct answer To reduce data redundancy and improve data integrity. Which normal form is primarily concerned with the concept of removing duplicate data? - correct answer First Normal Form (1NF) A table is in 2NF if it is in 1NF and which of the following conditions is met? - correct answer All non-key attributes are fully functionally dependent on the primary key. Which normal form deals with transitive dependency? - correct answer 3N...