Subquery - Study guides, Class notes & Summaries

WGU C170 SQL Data Management Exam Questions Terms with Accurate Answers 2024/2025 cross join - correct answer cartesian product of T1 and T2 USING - correct answer returns only rows with matching values in column indicated ON - correct answer returns rows that meet specified join condition subquery can return: - correct answer single value (1 column, 1 row) list of values (1 column, multiple rows) virtual table (multicolumn, multirow) union - correct answer combines 2 simila...

Question 1 (2 marks) Which of the following is an aggregate expression that will find the oldest date in the invoiceDate column? 1. MIN(invoiceDate) 2. MAX(invoiceDate) 3. HIGH(invoiceDate) 4. LOW(invoiceDate) Question 2 (2 marks) Which of the following LIMIT clauses will return a maximum of five rows starting with the eleventh row in the result set? 15 ICT3612/102/0/2024 1. LIMIT 10, <= 5 2. LIMIT 11, <= 5 3. LIMIT 10, 5 4. LIMIT 11, 5 Question 3 (2 marks) When coded in a...

Associative Entity An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute An attribute is a property or characteristic of an entity. Binary relationship A binary relationship is a relationship between two entity types. Candidate Key Is any column or a combination of columns that can qualify as unique key in database. Cardinality Cardinality represents the maximum number of entities that can be involved in...

Associative Entity - An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute - An attribute is a property or characteristic of an entity. Binary relationship - A binary relationship is a relationship between two entity types. Candidate Key - Is any column or a combination of columns that can qualify as unique key in database. Cardinality - Cardinality represents the maximum number of entities that can be i...

A relational database _____. - Answer- consists of tables called relations Which command(s) can you use to delete an entire table and its data? - Answer- DROP TABLE Which element belongs in the blank if you want to display data from all rows with a credit limit greater than the credit limit of one or more category B cardholders? WHERE (CREDIT_LIMIT > _____ (SELECT CREDIT_LIMIT FROM CARDHOLDER WHERE CATEGORY = 'B')) - Answer- ANY Which of the following is a valid SQL command? - Ans...

join - relational operation that causes two or more tables with a common domain to be combined into a single table or view - can use "JOIN" or "INNER JOIN"..."ON" - common columns appear redundantly in the result table - can use "=", ">","<" ,"<>" equi-join - join in which the joining condition is based on equality between values in the common columns natural join - equi-join in which one of the duplicate columns is eliminated in the result table outer join ...

Associative Entity An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute An attribute is a property or characteristic of an entity. Brainpower Read More Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:11 / 0:15 Full screen Binary relationship A binary relationship is a relationship between two entity types. Candidate Key Is any column or a combinatio...

DDL (Data Definition Language) Correct Answer: commands to create database objects such as tables, indexes, and views, as well as commands to define access rights to those objects DML (Data Manipulation Language) Correct Answer: commands to insert, update delete and retrieve data within database tables Type of integrity is enforced when a primary key is declared Correct Answer: Entity, in create table command sequence referential constraint actions Correct Answer: Makes sure that if a p...

CSC 345 Lab 5-1 Exam | Questions with Verified Answers Task 1: For each invoice, list the invoice number and invoice date along with the ID, first name, and last name of the customer for which the invoice was created. SELECT INVOICE_NUM, INVOICE_DATE, CUSTOMER.CUST_ID, FIRST_NAME, LAST_NAME FROM INVOICES, CUSTOMER WHERE INVOICES.CUST_ID = CUSTOMER.CUST_ID; Task 2: For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name, and last name of the customer...

CREATE TABLE AS - ️️Creates a new table based on a query in the user's database schema SELECT Syntax - ️️Command to list the content SELECT columnlist FROM tablename; Data definition language - ️️DDL Data manipulation language - ️️DML CREAT SCHEMA AUTHORIZATION - ️️Creates a database schema CREATE TABLE - ️️Creates a new table in the user's databse schema NOT NULL - ️️Ensures that a column will not have null values UNIQUE - ️️Ensures that a column w...