Create view customerView with a join query to join tables customer and cityState to do the following: a. Select column firstName from table customer b. Select column lastname from table customer c. Select column address from table customer d. Select column city from table cityState e. Select column state from table city State f. Select column zipCode from table customer g. Select column phone from table customer h. Select column email from table customer

Create view customerView with a join query to join tables customer and cityState to do the following: a. Select column firstName from table customer b. Select column lastname from table customer c. Select column address from table customer d. Select column city from table cityState e. Select column state from table city State f. Select column zipCode from table customer g. Select column phone from table customer h. Select column email from table customer

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter2: Basic Sql Select Statements

Section: Chapter Questions

Problem 10MC: When must a comma be used in the SELECT clause of a query? a. when a field name is followed by a...

See similar textbooks

Similar questions

A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns: emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009
When must a comma be used in the SELECT clause of a query? a. when a field name is followed by a column alias b. to separate the SELECT clause and the FROM clause when only one field is selected c. Its never used in the SELECT clause. d. when listing more than one field name and the fields arent concatenated e. when an arithmetic expression is included in the SELECT clause
A table can have a maximum of how many PRIMARY KEY constraints?
What is the maximum number of columns you can define as a primary key when using the column-level approach to creating a table? a. 0 b. 1 c. 30 d. 255
In the initial creation of a table, if a UNIQUE constraint is included for a composite column that requires the combination of entries in the specified columns to be unique, which of the following statements is correct? a. The constraint can be created only with the ALTER TABLE command. b. The constraint can be created only with the table-level approach. c. The constraint can be created only with the column-level approach. d. The constraint can be created only with the ALTER TABLE MODIFY command.
Add a constraint to make sure the Rep_ID value entered in the BOOK_STORES table is a valid value contained in the STORE_REPS table. The Rep_ID columns of both tables were initially created as different datatypes. Does this cause an error when adding the constraint? Make table modifications as needed so that you can add the required constraint.
You’re creating a new table consisting of three columns: Col1, Col2, and Col3. Col1 should be the primary key and can’t have any NULL values, and each entry should be unique. Col3 must not contain any NULL values either. How many total constraints do you have to create? 1 2 3 4
What does the funnel symbol that appears next to a field’s name in the Query Builder dialog box indicate? The field is used in a SELECT statement’s ORDER BY clause. The field is used in a SELECT statement’s WHERE clause. The field is the primary key. The field is the foreign key.
Select employees and managers with inner join USING MYSQL The Employee table has the following columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string ManagerID - integer Write a SELECT statement to show a list of all employees' first names and their managers' first names. List only employees that have a manager. Order the results by Employee first name. Use aliases to give the result columns distinctly different names, like "Employee" and "Manager". Hint: Join the Employee table to itself using INNER JOIN.
Select all columns from the jobs table using an asterisk.2. Select only job title, min salary, and max salary columns from the jobs table.3. Select all columns from the d_partners table by writing out all of the columns inthe select statement.4. Using the d_partners table, display the id, and then concatenate the first_nameand last_name together with a space in between the two columns. Give theconcatenated column an alias of NAME. Be sure to use the optional ASkeyword.5. Using the job_grades table, show the grade level, and then subtract thelowest_sal from the highest_sal to show the amount of variance there is for eachgrade level. Give the calculated column an alias of Salary_Variance. Do notuse the optional AS keyword.6. Using the employees table, show an unduplicated list of department_id’s.7. Change the SELECT statement you built for question 4, adding a single columncalled Partner_Information that concatenates the partner’s expertise,auth_expense_amt, and manager_ id, so the…
Which type of join is demonasted by the folloing query? Select from make. model where make modelID to mode ID a) Non-Equlion b) Self Join c) Cross Join d) Equijoin
SQL JOIN clauses are used to combine rows from two or more tables based on a related column between them. True False