PRIMARY KEY Constraint

UNIQUE KEY Constraint

CHECK Constraint

FOREIGN KEY Constraint

NOT NULL Constraint

BETWEEN

IN

EXISTS

LIKE

UNION

1, 2, 4 are correct

1, 3 and 5 are correct

3, 4 and 5 are correct

2, 3 and 4 are correct

All are correct

CREATE TABLE STUDENTS( STUDENT_ID INT NOT NULL, STUDENT_NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL CHECK (AGE >= 18), ADDRESS CHAR (25) , MARKS INT, PRIMARY KEY (STUDENT_ID));

CREATE TABLE STUDENTS( STUDENT_ID INT NOT NULL, STUDENT_NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL , ADDRESS CHAR (25) , MARKS INT, PRIMARY KEY (STUDENT_ID)); ALTER TABLE STUDENTS MODIFY AGE INT NOT NULL CHECK (AGE >= 18 );

CREATE TABLE STUDENTS( STUDENT_ID INT NOT NULL, STUDENT_NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL , ADDRESS CHAR (25) , MARKS INT, PRIMARY KEY (STUDENT_ID));ALTER TABLE STUDENTS ADD CONSTRAINT myCheckConstraint CHECK(AGE >= 18);

Check constraint has introduced only from ORACLE 10g onwards.

All Option 1, Option 2 and Option 3 are correct.

A

B

C

D

All are valid types of JOINS in ORACLE

A

B

C

All of the JOINS produce NULL values to every result table

JOINS never produce NULL values in the result tables when the source tables have no NULL values.

CREATE TABLE STUDENTS( STUDENT_ID INT NOT NULL, STUDENT_NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL, ADDRESS CHAR (25) , MARKS INT DEFAULT 35,
PRIMARY KEY (STUDENT_ID) );

CREATE TABLE STUDENTS( STUDENT_ID INT NOT NULL, STUDENT_NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL, ADDRESS CHAR (25) , PRIMARY KEY (STUDENT_ID) ); ALTER TABLE STUDENTS ADD MARKS INT DEFAULT 35;

Both option 1 and option 2 are correct.

DEFAULT is not a valid constraint in ORACLE.

DEFAULT constraint was discontinued from ORACLE 9i onwards.

INNER JOIN

OUTER JOIN

NORMAL JOIN

CROSS JOIN

SELF JOIN

20 rows only

20 + 5 = 25 rows

20 * 5 = 100 rows

20 - 5 = 15 rows

20 / 5 = 4 rows

BID INT REFERENCES BRANCH(BRANCH_ID)

BID INT FOREIGN KEY(BRANCH_ID)

BID INT FOREIGN KEY CONSTRAINT (BRANCH_ID) TABLE BRANCH

All the above 3 are correct

Foreign Key Constraint or Referential integrity can not be defined along with the table definition

ALTER TABLE STUDENTS STATUS = ENABLE CONSTRAINT constraint_name

ALTER TABLE STUDENTS ENABLE constraint_name

ALTER TABLE STUDENTS ENABLE CONSTRAINT constraint_name

ALTER TABLE STUDENTS TURN ON CONSTRAINT constraint_name

ALTER TABLE STUDENTS TURN ON constraint_name

We represent the missing values with SPACES, i.e, ' '

We represent the missing values with ZEROES, i.e. 0

We represent the missing values with SPACES, ZEROES, etc. based on the datatype of the column.

We represent the missing values with NULL.

ORACLE tables should not have any missing values at any point of time.

A is correct

B is correct

C is correct

None of A, B and C are correct

All A, B and C are correct

Constraints can be defined along with the table definition using CREATE.

Constraints can be imposed on the table columns using ALTER statement after the table is defined.

Constraints can be enabled and/or disabled.

Constraints can be dropped if not required using ALTER - DROP.

All the above are correct.

SELECT * FROM STUDENTS WHERE STUDENT_ID BETWEEN 1001 AND 1050

SELECT * FROM STUDENTS WHERE STUDENT_ID >= 1001 AND STUDENT_ID <= 1050

SELECT * FROM STUDENTS WHERE STUDENT_ID > 1001 AND STUDENT_ID < 1050

Both option 1 and option 2 are correct.

None of the options are correct

A and C are correct

B and D are correct

A, B and C are correct

A, B and D are correct

All 4 are correct

SELECT STUDENT_ID, STUDENT_NAME, BRANCH_ID, BRANCH_NAME, MARKS FROM STUDENTS, BRANCH WHERE BR_ID = BRANCH_ID

SELECT STUDENT_ID, STUDENT_NAME, BRANCH_ID, BRANCH_NAME, MARKS FROM STUDENTS INNER JOIN BRANCH WHERE BR_ID = BRANCH_ID

SELECT S.STUDENT_ID, S.STUDENT_NAME, B.BRANCH_ID, B.BRANCH_NAME, S.MARKS FROM STUDENTS S, BRANCH B WHERE S.BR_ID = B.BRANCH_ID

SELECT S.STUDENT_ID, S.STUDENT_NAME, B.BRANCH_ID, B.BRANCH_NAME, S.MARKS FROM STUDENTS S INNER JOIN BRANCH B WHERE S.BR_ID = B.BRANCH_ID

All the above 4 queries are correct.

SELECT AGENT_ID, AGENT_NAME, SALARY, SALES_QTY, COMMISSION_PAID FROM AGENTS WHERE COMMISSION_PAID != NULL

SELECT AGENT_ID, AGENT_NAME, SALARY, SALES_QTY, COMMISSION_PAID FROM AGENTS WHERE COMMISSION_PAID IS NOT NULL

SELECT AGENT_ID, AGENT_NAME, SALARY, SALES_QTY, COMMISSION_PAID FROM AGENTS WHERE COMMISSION_PAID NOT NULL

SELECT AGENT_ID, AGENT_NAME, SALARY, SALES_QTY, COMMISSION_PAID FROM AGENTS WHERE COMMISSION_PAID = NOT NULL

None of the above are correct

SELECT STUDENT_ID, 
                 STUDENT_NAME, 
                 BRANCH_ID, 
                 BRANCH_NAME, 
                 MARKS
FROM STUDENTS
LEFT JOIN BRANCH
WHERE BR_ID = BRANCH_ID

SELECT STUDENT_ID, 
                 STUDENT_NAME, 
                 BRANCH_ID, 
                 BRANCH_NAME, 
                 MARKS
FROM STUDENTS, BRANCH
WHERE BR_ID = BRANCH_ID
ON LEFT

SELECT STUDENT_ID, 
                 STUDENT_NAME, 
                 BRANCH_ID, 
                 BRANCH_NAME, 
                 MARKS
FROM STUDENTS LEFT, BRANCH
WHERE BR_ID = BRANCH_ID

SELECT STUDENT_ID, 
                 STUDENT_NAME, 
                 BRANCH_ID, 
                 BRANCH_NAME, 
                 MARKS
FROM STUDENTS INNER JOIN BRANCH
WHERE BR_ID = BRANCH_ID

All the four queries are correct.

Syntax error in the Query.