educationalera

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

SQL Objective Question and answer

AddThis Social Bookmark Button
://pagead2.googlesyndication.com/pagead/show_ads.js">

1.) Which of the following statements contains an error?

A) SELECT * FROM emp WHERE empid = 493945;

B) SELECT empid FROM emp WHERE empid= 493945;

C) SELECT empid FROM emp;

D) SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;

View Answer

Answer: Option D


2.) The command to remove rows from a table 'CUSTOMER' is:

A.)     REMOVE FROM CUSTOMER...

B.)     DROP FROM CUSTOMER...

C.)     DELETE FROM CUSTOMER WHERE...

D.)     UPDATE FROM CUSTOMER...

View Answer

Answer: Option C


3.) Which is an /SQL*Plus command?

A.) DELETE

B.) UPDATE

C.) SELECT

D.) ALTER

E.) DESCRIBE

View Answer 

Answer:  Option  E


4.) In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?

A.) Immediately after the SELECT clause

B.) Before the WHERE clause

C.) Before the FROM clause

D.) After the ORDER BY clause

E.) After the WHERE clause

View Answer 

Answer: Option E


5.) Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000?

A.) ORDER BY SALARY > 5000.

B.) GROUP BY SALARY > 5000

C.) HAVING SALARY > 5000

D.) WHERE SALARY > 5000

View Answer 

Answer: Option  D


 

 
  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  3 
  •  4 
  •  5 
  •  6 
  •  7 
  •  8 
  •  9 
  •  Next 
  •  End 
  • »
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)