ZuoTi.Pro
Question

Question 63 Based on the Customer table below, which command lists all information from the table concerning customer 282? Cu

Question 37 You have your project all set locally and on the server. You want to now make changes to your site. Which of the

Question 11 Refer to the list of databases produced by SHOW DATABASES; Database information_schema mysql performance_schema sTrue or false?

Question 8 Refer to the statement below. CREATE TABLE Department ( Code TINYINT UNSIGNED, Name VARCHAR(20), Manager SMALLINT,Question 3 Refer to the list of databases produced by SHOW DATABASES; Database information_schema mysql performance_schema syTrue or false?

Question 1 The INSERT statement adds a student to the student table. How many clauses are in the INSERT statement? INSERT INT

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Answer : here are the answers for your questions:

Answer 63) SELECT * FROM Customer WHERE CustomerNum=282

Answer 11) True

Answer 8) Name VARCHAR(20) DEFAULT 'Accounting

Answer 3) False

Answer 1) 0 clause are present in insert statement . Valid clause in sql are GROUPBY ,HAVING, ORDERBY'

qustion 37 - 40 do not have any option . so please add some options first , then i will be able to provide solution

I hope this would help you out

If you have any doubt, you can provide comment /feedback below the answer

Thanks

0 0
Add a comment
Know the answer?
Add Answer to:
True or false? True or false? Question 63 Based on the Customer table below, which command...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Overview: Database management plays an integral role in nearly every area of business. Databases house customer, accoun...

    Overview: Database management plays an integral role in nearly every area of business. Databases house customer, accounting, and employee data, and these different data sets must all be efficiently managed in order to make the data accessible. Companies rely on database engineers to ensure that their records are accurate, updated, and tracked in real time. This course covers structured query language (SQL) and how it can be used to manage database schemas, manipulate data, and analyze data. For your final...

  • Q.5] Answer the following questions based on the company database (based on the homework assignment 2) y dat...

    Q.5] Answer the following questions based on the company database (based on the homework assignment 2) y database (based on the homework assignment 2) 3 IPage 1. For each department whose average employee salary is more than $30,000, write a SQL statement to retrieve the department name and the number of employees working for that department 2. Write a SQL statement to retrieve first name, last name, and address of each employee who lives in Houston, TX. 3. Write a...

  • Using the Premier Products database answer the following questions 1. Using a union, display all customers...

    Using the Premier Products database answer the following questions 1. Using a union, display all customers that have rep number 65 or live in the town of Sheldon. Display all customer information. Insert your snip of the query and resultset together here: 2. Using a subquery, list the rep information for all customers who have the same credit limit as customer number 725. To receive credit for this question, do not explicitly query for rep number 35. Let MySQL do...

  • Question 32 Which view would you use to see only the tables you have created ALL_TABLES...

    Question 32 Which view would you use to see only the tables you have created ALL_TABLES USER_TABLES USER_TABS ALL_OBJECTS 2 points Question 33 Which script will you execute to create new user DAVE and give him the ability to connect to the database and the ability to create tables, sequences, and procedures? CREATE USER dave IDENTIFIED BY dave18; GRANT create table, create sequence, create procedure TO dave; CREATE USER dave IDENTIFIED BY dave18; GRANT create session, create table, create sequence,...

  • 6. With respect to database systems, which of the following statement(s) is (are) true? a. The...

    6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....

  • IN THE PREVIOUS CHAPTER WE MADE A DATABASE USING OUR LAST NAME AS ITS NAME. QUESTION...

    IN THE PREVIOUS CHAPTER WE MADE A DATABASE USING OUR LAST NAME AS ITS NAME. QUESTION 1 STATES THIS. PLEASE TYPE WHAT NEEDS TO BE TYPED FOR ALL STEPS. THIS USES CODIO a. 1. Connect to the database you created and named in Module One (for example, Jetson). Type after the prompt mysql> a. use (table you named); i. Example: mysql> use Jetson; 2. Create the Employee table using the SQL statement shown here. Press Return after each line. CREATE...

  • Answer the following questions using mysql. Please show screenshots to make sure the queries work...

    Answer the following questions using mysql. Please show screenshots to make sure the queries work. 1. Use a sub-query and the IN operator to find the number and name of each customer that placed an order on October 23, 2007. 2. Repeat step 2, but this time use the EXISTS operator in your answer. 3. Using a sub-query, find the number and name of each customer that did not place an order on October 23, 2007. 4. Using a sub-query,...

  • 4. Write SQL data definition commands for each of the following queries: a. How would you add an attribute, Class, to the Student table? b. How would you remove the Registration table? c. How would you change the FacultyName field from 25 characters

    Problems and Exercises 1 through 9 are based on the dass scheduling 3NF relations along with some sample data shown in Figure 6-11. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections.4. Write SQL data definition commands for each of the following queries:a. How would you add an attribute, Class, to the Student table?b. How would you remove the Registration table?c. How would you change the FacultyName field from...

  • The lab for this week addresses taking a logical database design (data model) and transforming it...

    The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of the lab, you will need to download the zip file titled CIS336Lab3Files from Doc Sharing. This zip file contains the ERD, Data Dictionary, and test data for the tables you create as you complete this exercise. Your job will be to use the ERD Diagram found below as a guide to define the...

  • QUESTION 27 The SET command is used in which statement UPDATE SELECT DISTINCT DELETE FROM INSERT...

    QUESTION 27 The SET command is used in which statement UPDATE SELECT DISTINCT DELETE FROM INSERT VALUES QUESTION 28 Which view would you use to see only the tables you have created ALL_TABLES USER_TABLES USER_TABS ALL_OBJECTS QUESTION 29 Which command should you use to write logical units of work to disk permanently SAVEWORK COMMIT ROLLBACK INSERT QUESTION 30 A Top-N Analysis is capable of ranking a top or bottom set of results. True False QUESTION 31 If you are performing...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT