educationalera

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

SQL

AddThis Social Bookmark Button

31.) Evaluate the SQL statement

DROP TABLE SACHIN;

Which four statements are true of the SQL statement? (Choose Two)

A.) You cannot roll back this statement.

B.) All views based on the DEPT table are deleted.

C.) All data in the table is deleted, and the table structure is also deleted.

D.) All data in the table is deleted, but the structure of the table is retained.

E.) All synonyms based on the DEPT table are deleted.

View Answer

Answer: Option A, C


32.) Which statement creates a new user?

A.) CREATIVE USER susan;

B.) CREATIVE OR REPLACE USER susan;

C.) CREATE NEW USER susan DEFAULT

D.) CREATE USER sachin IDENTIFIED BY gupta;

E.) CREATE OR REPLACE USER susan IDENTIFIED BY blue;

View Answer

Answer: Option D


33.) A functional dependency is a relationship between or among:

A.)     tables

B.)     rows

C.)     relations

D.)     attributes.

View Answer 

Answer: Option  D


34.) Which statement is valid?

A.) ALTER TABLE EMPLOYEE

MODIFY (last_name CHAR2(2000));

B.) ALTER TABLE EMPLOYEE

CHANGE (last_name CHAR2(2000));

C.) ALTER TABLE EMPLOYEE

CHANGE (last_name VARCHAR2 (2000));

D.) ALTER TABLE EMPLOYEE

MODIFY (last_name VARCHAR2 (2000));

View Answer 

Answer: Option  D


35.) What does the DROP 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

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)