Answer Posted / antonis flangofas

ofc you can, stop giving to ppl wrong answers here it is

CREATE TABLE track(
album CHAR(10),
disk INTEGER,
posn INTEGER,
song VARCHAR(255),
PRIMARY KEY (album, disk, posn)
)

if you want to avoid to have id you use this way.

Can unique keys be null?

850

---

What is thread join () in threading?

944

---

what is a record in a database ? : Sql dba

995

---

what is myisam? : Sql dba

1000

---

What is the purpose of normalization?

995

---

How do you select unique values in sql?

935

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1537

---

How many scalar data types are supported in pl/sql?

975

---

What is cursor status?

1135

---

What is write ahead logging in sql server?

987

---

what is a database? : Sql dba

1098

---

how does a local variable is defined using t-sql? : Transact sql

947

---

What is rowid in sql?

905

---

What are different types of queries in sql?

1046

---

How do you modify a table in sql?

1061

---