educationalera

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

SQL

AddThis Social Bookmark Button

21.) The DROP TABLE statement:

A.)     deletes the table structure only.

B.)     deletes the table structure along with the table data.

C.)     works whether or not referential integrity constraints would be violated.

D.)     is not an SQL statement.

View Answer

Answer: Option B


22.) How do you select all the records from a table named "EMP" where the value of the column "Last_Name" is "KING"?

A.) SELECT [all] FROM EMP WHERE Last_Name ='KING'

B.) SELECT * FROM EMP WHERE Last_Name ='KING'

C.) SELECT * FROM EMP WHERE Last_Name LIKE 'KING'

D.) SELECT [all] FROM EMP WHERE Last_Name LIKE 'KING'

View Answer

Answer: Option C


23.) Which SQL statement is used to insert new data in a database?

A.) ADD RECORD

B.) ADD NEW

C.) INSERT INTO

D.) INSERT NEW

View Answer 

Answer:  Option  C


24.) Which command is used to remove the table 'DEPTT'?

A.)     REMOVE FROM DEPTT

B.)     DROP TABLE DEPTT

C.)     DELETE FROM DEPTT

D.)     UPDATE FROM DEPTT

View Answer 

Answer:  Option  B


25.) The SQL ALTER statement can be used to:

A.)     change the table structure.

B.)     change the table data.

C.)     add rows to the table.

D.)     delete rows from the table.

View Answer 

Answer:  Option  A


 

 
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)