Databases - Upwork

Question: Which of the following constraints can be defined only at the column level?
A
UNIQUE

B
NOT NULL

C
CHECK

D
PRIMARY KEY

E
FOREIGN KEY

Note: Not available
1. Report
Question: Which of the following SQL statements defines a FOREIGN KEY constraint on the DEPT NO column of the EMP table?
A
CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);

B
CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));

C
CRETE TABLE EM (empno NUMBER(4), ename VARCHAR2(35) deptno NUMBER (7,2) NOT NULL, CONSTRAINT em_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));

D
CREATE TABLE EMP (empno NUMBER (4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));

Note: Not available
1. Report
Question: Which of the following shows the correct use of the Trunc command on a date?
A
TRUNC=To_Date('09-Jan-02,DD-MON-YY,'YEAR',"Date" from Dual;

B
Select TRUNC(To_Date('09-Jan-02,DD-MON-YY,YEAR')) "DATE" from Dual;

C
Date =TRUNC(To_DATE('09-Jan-02','DD-MON-YY'),'YEAR'),'YEAR)"DATE: from DUAL;

D
SELECT TRUNC(TO_DATE('12-Feb-99','DD-MON-YY'), 'YEAR') "Date " FROM DUAL;

Note: Not available
1. Report
Question: Which type of join will you write to perform an outer join of tables A and B that returns all rows from B-:
A
Any outer join

B
A left outer join

C
A cross join

D
A right outer join

E
An inner join

Note: Not available
1. Report
Question: You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which of the following statements will accomplish this task?
A
ALTER TABLE students ADD PRIMARY KEY student_id;

B
ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

C
ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

D
ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

E
ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

Note: Not available
1. Report
Question: Which of the following SQL statements should be used to remove a view called EMP_DEPT_VU from the schema?
A
DROP emp_dept_vu;

B
DELETE emp_dept_vu;

C
REMOVE emp_dept_vu;

D
DROP VIEW emp_dept_vu;

E
DELETE VIEW emp_dept_vu;

F
REMOVE VIEW emp_dept_vu;

Note: Not available
1. Report
Question: _______ operator can be used with a multiple row subquery.
A
=

B
LIKE

C
BETWEEN

D
NOT IN

E
Is

Note: Not available
1. Report
Question: The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER (12) SEMESTER_END DATE GPA NUMBER (4, 3) Which of the following statements finds the highest Grade Point Average (GPA) per semester?
A
SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;

B
SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

C
SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;

D
SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;

E
SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

Note: Not available
1. Report
Question: Which two among the following programming constructs can be grouped within a package?
A
Cursor

B
Constant

C
Trigger

D
Sequence

E
View

Note: Not available
1. Report
Question: Which two statements, among the following, describe the state of a package variable after executing the package in which it is declared?
A
It persists across transactions within a session

B
It persists from session to session for the same user

C
It does not persist across transaction within a session

D
It persists from user to user when the package is invoked

E
It does not persist from session to session for the same user

Note: Not available
1. Report

First Prev 53 54 55 56 57 Next Last

Question: Which of the following constraints can be defined only at the column level?

Question: Which of the following SQL statements defines a FOREIGN KEY constraint on the DEPT NO column of the EMP table?

Question: Which of the following shows the correct use of the Trunc command on a date?

Question: Which type of join will you write to perform an outer join of tables A and B that returns all rows from B-:

Question: You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which of the following statements will accomplish this task?

Question: Which of the following SQL statements should be used to remove a view called EMP_DEPT_VU from the schema?

Question: _______ operator can be used with a multiple row subquery.

Question: The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER (12) SEMESTER_END DATE GPA NUMBER (4, 3) Which of the following statements finds the highest Grade Point Average (GPA) per semester?

Question: Which two among the following programming constructs can be grouped within a package?

Question: Which two statements, among the following, describe the state of a package variable after executing the package in which it is declared?