Answer Posted / alien

1>
2> CREATE TABLE employee (emp_no INTEGER NOT NULL
CONSTRAINT prim_empl PRIMARY KEY,
3> emp_fname CHAR(20) NOT NULL,
4> emp_lname CHAR(20) NOT NULL,
5> dept_no CHAR(4) NULL)
6>
7> CREATE TABLE project (project_no CHAR(4) NOT NULL
CONSTRAINT prim_pro PRIMARY KEY,
8> project_name CHAR(15) NOT NULL,
9> budget FLOAT NULL)
10>
11> CREATE TABLE works_on1
12> (emp_no INTEGER NOT NULL,
13> project_no CHAR(4) NOT NULL,
14> job CHAR (15) NULL,
15> enter_date DATETIME NULL,
16> CONSTRAINT prim_works1 PRIMARY KEY(emp_no,
project_no),
17> CONSTRAINT foreign1_works1 FOREIGN KEY
(emp_no) REFERENCES employee(emp_no) ON DELETE CASCADE)

Is sql a backend language?

1086

---

Why do we create views in sql?

1142

---

What is a temporal table?

922

---

What is mdb stand for?

1003

---

Is mariadb nosql?

1036

---

What does over partition by mean in sql?

968

---

What are the string functions in sql?

965

---

Is sql dba a good career? : SQL DBA

983

---

What are the types of variables use in pl sql?

1034

---

how can we find the number of rows in a table using mysql? : Sql dba

1076

---

Why use subqueries instead of joins?

1075

---

what is row? : Sql dba

1220

---

Enlist the characteristics of pl/sql?

1791

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1004

---

how would you get the current date in mysql? : Sql dba

961

---