1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
ANTONII [103]
3 years ago
13

(6-7) Question 1: Use a create table statement to create a new copy of the 1_employees table, with a new name of course. Then us

e an insert statement with a select clause to copy all the data from the 1_employees table to your new copy of the table. create table copy_of_employees as select EMPLOYEE_ID, FIRST_NAME, LAST_NAME, DEPT_CODE, HIRE_DATE, CREDIT_LIMIT, PHONE_NUMBER, MANAGER_ID from l_employees; INSERT INTO copy_of_employees SELECT * FROM l_employees; SELECT * FROM copy_of_employees;
Computers and Technology
1 answer:
stiks02 [169]3 years ago
6 0

Answer:

The SQL query is used to create a copy of a table like the 1_employee table in the SQL database.

Explanation:

create table copy_of_employees as select EMPLOYEE_ID, FIRST_NAME, LAST_NAME, DEPT_CODE, HIRE_DATE, CREDIT_LIMIT, PHONE_NUMBER, MANAGER_ID from l_employees;

INSERT INTO copy_of_employees SELECT * FROM l_employees;

SELECT * FROM copy_of_employees;

This SQL creates a table called copy_of_employees and copies the selected query of the 1_employees table and inserts it to the newly created table.

You might be interested in
What changes do you need to a algorithm to compare 100 numberst
Aliun [14]

Answer:

It really depends - in general every data structure has its use.

Explanation:

Furthermore, traversing the list will be inefficient because the data items are not contiguous in memory, forcing the CPU to jump all over the RAM memory causing further slowdown.

3 0
4 years ago
Which property of a DBMS lets you change the database structure without requiring you to change the programs that access the dat
Gala2k [10]

Answer:

"Integrity constraints " is the correct answer.

Explanation:

  • A successful DBMS offers integrity constraints, which have been an option that allows you to modify the database layout without modifying the applications accessing the repository.
  • A principle or requirement which the data in something like a database should therefore obey.

So that the above is the correct choice.

8 0
4 years ago
Excerpt from "How Prepared Are Students for College Level Reading? Applying a Lexile-Based Approach."
Verizon [17]

Answer: Students graduating from high school are not prepared for college-level work.

Explanation:

From the excerpt, it was written that there is a high rates of enrollment in remedial college courses which shows that there are many students are graduating from high school who are unprepared for college-level work.

Therefore, based on this, the best summary of the paragraph is that the students graduating from high school are not prepared for college-level work.

Therefore, the correct option is C.

7 0
3 years ago
Sherri is considering replacing a processor on her laptop. The laptop is running slower than she would like. What should Sherri
Schach [20]

Answer:

Option b, Option c, and Option d  are the correct options.

Explanation:

While Sherri is replacing the laptops processor because her's laptop working slow as compared to the past performance then, she decided to ensure to use the right processors for her laptop's motherboard. Then, she verifies that not under the warranty, and she also determines that the teardown procedure is available or not.

4 0
4 years ago
When starting a computer running Windows Vista, a technician sees that the error message "BOOTMGR is missing" appears after the
docker41 [41]

Answer:

B and C

Explanation:

Possible solution to solving "BOOTMGR is missing" error in Windows Vista is to use the Windows Recovery Environment.

Another option is to run "bootrec/fixboot" command from the comman prompt and the command prompt is also accessible from the windows recovery environment.

8 0
3 years ago
Other questions:
  • Is this statement true or false?
    13·1 answer
  • Which letter indicates the amplitude of the wave?<br> a. A<br> b. B<br> c. C<br> d. D
    12·1 answer
  • EDI stands for__________________ a) Electronic digital interface b) Electronic data interchange c) Enterprise data interface d)
    5·1 answer
  • 10 disscused reasons why organisatoions use electronic spreedsheet​
    14·1 answer
  • QUESTION 16
    14·1 answer
  • How are computers 35 years ago and how are they presently and how are they going to be in the next 35 years
    9·1 answer
  • You have used loops for repetitive processes.
    11·1 answer
  • Please help coding assignments i will give brainliest :)
    6·1 answer
  • Define a function OutputValues() that takes two integer parameters and outputs all integers between the first and the second par
    15·1 answer
  • How have these advances in-home technology changed the role of technicians in our society?
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!