educationalera

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

SQL

AddThis Social Bookmark Button

6.) You need to calculate the total of all salaries in the accounting department. Which group function should you use?

A.) MAX

B.) MIN

C.) SUM

D.) COUNT

E.) TOTAL

F.) LARGEST

View Answer 

Answer: Option C


7.) Which of the following functions are available in SQL? (Choose four)

A.)      INSTR.

B.)      NVL2.

C.)      TRUNCATE.

D.)      DECODE.

E.)      TRIM.

F.)      NVL.

  View Answer  

Answer: Option  C


8.) What does the TRUNCATE statement do?

A.) Removes the table

B.) Removes all rows from a table

C.) Shortens the table to 10 rows

D.) Removes all columns from a table

E.) Removes foreign keys from a table

  View Answer  

Answer: Option   B


9.) Which two statements about creating constraints are true? (Choose two)

A.) Constraint names must start with SYS_C.

B.) All constraints must be defines at the column level.

C.) Constraints can be created after the table is created.

D.) Constraints can be created at the same time the table is created.

  View Answer  

Answer:  Option  C, D


10.) Which is following Statements to create users?

A.) Create user user_name identified user_password;

B.) Create user user_name user_password;

C.) Create user user_name identified by user_password;

D.) None of these;

  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)