educationalera

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

SQL

AddThis Social Bookmark Button

16.)Which one is a system privilege?

A.) DROP

B.) DELETE

C.) TRUNCATE

D.) ALTER TABLE

E.) CREATE TABLE

View Answer

Answer: Option E


17.) Which four are types of functions available in SQL? (Choose 4)

A.) string

B.) character

C.) integer

D.) calendar

E.) numeric

F.) translation

G.) date

H.) conversion

View Answer

Answer: Option B, E, G, H


18.) The primary key is selected from the:

A.)     composite keys.

B.)     determinants.

C.)     candidate keys.

D.)     foreign keys.

View Answer

Answer: Option C


19.) Which is a valid CREATE TABLE statement?

A.) Create table emp add(id number(3));

B.) Create table emp (id number(3));

C.) Create table emp modified (id number(3));

D.) Create table emp (id numbers(3));

View Answer

Answer: Option B


20.) A tuple is a?

A.)     row of a table.

B.)     key of a table.

C.)     column of a table.

D.)     Two dimensional 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)