Discover
Questions library
Collections library
Find online teacher
login
Discover
questions library
Find online teacher
login
Popular searches:
if-else
class-diagram
flowchart
Polymorphism
Home
Questions
Questions
Study lists
hamza shaheen Questions
5601 Questions
Write a postgre SQL statement to create a table employees including columns employee_id, first_name, last_name, job_id, salary and make sure that, the employee_id
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
157
Write a postgre SQL statement to rename the table countries to country_new
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
185
Write a postgre SQL statement to add a column region_id to the table locations
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
171
Write a postgre SQL statement to change the data type of the column region_id to text in the table locations
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
146
Write a postgre SQL statement to drop the column city from the table locations
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
172
Write a postgre SQL statement to change the name of the column state_province to state, keeping the same size and data type and size
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
195
Write a postgre SQL statement to add a primary key for a combination of columns location_id and country_id
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
191
Write a postgre SQL statement to drop the existing primary from the table locations on a combination of columns location_id and country_id
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
192
Write a postgre SQL statement to add a foreign key on job_id column of job_history table referencing to the primary key job_id of jobs table
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
114
Write a postgre SQL statement to add a foreign key constraint named fk_job_id on job_id column of job_history table referencing to the primary key job_id of jobs table
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
164
Write a postgre SQL statement to drop the existing foreign key fk_job_id from job_history table on job_id column, which is referenced to the job_id of jobs table
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
151
Write a postgre SQL statement to add an index named index_job_id on job_id column in the table job_history
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
180
Write a postgre SQL statement to drop the index indx_job_id from job_history table
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
181
Total:
5601
Previous
74
75
76
77
78
Next
Go
