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
140
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
146
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
135
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
127
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
135
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
147
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
149
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
148
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
96
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
141
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
123
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
152
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
145
Total:
5601
Previous
74
75
76
77
78
Next
Go
