educationalera

  • Increase font size
  • Default font size
  • Decrease font size

SQL

AddThis Social Bookmark Button

26.) Which constraint can be defined only at the column level?

A.) UNIQUE

B.) NOT NULL

C.) CHECK

D.) PRIMARY KEY

E.) FOREIGN KEY

View Answer 

Answer: Option  B


27.) Which Statements to Calculate total Sal of “DEPTT” table?

A.)    Select max(Sal) from DEPTT;

B.)     Select Sal*12 from DEPTT;

C.)     Select count(Sal) from DEPTT;

D.)     Select total(Sal) from DEPTT;

View Answer 

Answer:  Option  C


28.) Description of the EMP table:

emp_id number(4) not null

last_name varchar2(30) not null

first_name varchar2(30)

dept_id number(2)

Which statement produces the number of different departments that have employees with last name ‘SACHIN’?

A.) SELECT COUNT (*) FROM EMP WHERE last _name=' SACHIN ';

B.) SELECT COUNT (dept_id) FROM EMP WHERE last _name=' SACHIN ';

C.) SELECT DISTINCT (COUNT (dept_id) FROM EMP WHERE last _name=' SACHIN ';

D.) SELECT COUNT (DISTINCT dept_id) FROM EMP WHERE last _name=' SACHIN ';

E.) SELECT UNIQE (dept_id) FROM EMP WHERE last _name=' SACHIN ';

View Answer 

Answer:  Option  D


29.) Which statements are true (Choose Two)?

A.) SELECT ENAME E, SALARY S, DNAME D, SAL D FROM EMP E, DEPTT D

WHERE E.SALARY = D.SAL

B.) SELECT ENAME, SALARY, DNAME, SAL FROM EMP JOIN DEPTT

WHERE E.SALARY = D.SAL;

C.) SELECT ENAME, SALARY, DNAME, SAL FROM EMP E JOIN DEPTT D

ON   E.SALARY = D.SAL;

D.) SELECT ENAME, SALARY, DNAME, SAL FROM EMP, DEPTT

ON E.SALARY = D.SAL

View Answer 

Answer: Option  A,  C


 30.) You are granted the CREATE VIEW privilege. What does this allow you to do?

A.) Create a table view.

B.) Create a view in any schema.

C.) Create a view in your schema.

D.) Create a sequence view in any schema.

E.) Create a view that is accessible by everyone.

F.) Create a view only of it is based on tables that you created.

View Answer 

Answer: Option  C


 

 
JPAGE_CURRENT_OF_TOTAL


Oracle Certification

oracle_logo

The Oracle Certification Program is a professional certification program offered by the Oracle Corporation. There are three levels of Oracle Certification in several disciplines: Oracle Certified Associate (OCA), Oracle Certified Professional (OCP), and Oracle Certified Master (OCM).

Java Certification

java_logo

Sun Certified Professional (SCP) is a professional certification program by Sun Microsystems, a subsidiary of Oracle Corporation. There are two levels of java Certification in several disciplines: Sun Certified Java Associate (SCJA), Sun Certified Java Programmer (SCJP), and Sun Certified Java Developer (SCJD)

Red Hat Certification

red_hat_logo

The Red Hat Certification Program is Red Hat's professional certification program for Red Hat and general Linux related skills such as system administration on Red Hat Enterprise Linux Red Hat Certified Technician (RHCT)  and Red Hat Certified Engineer (RHCE)