educationalera

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

Database

AddThis Social Bookmark Button

43.) Which of the following database object does not physically exist?

A)      Base table

B)      Index

C)      View

D)      None of the above

View Answer 

Answer: Option  C


44.) A data dictionary is a special file that contains:

A)      The name of all fields in all files.

B)      The width of all fields in all files.

C)      The data type of all fields in all files.

D)      All of the above.

View Answer 

Answer: Option  D


 

45.) A primary key is combined with a foreign key creates

A) Parent-Child relationship between the tables that connect them.

B) Many to many relationship between the tables that connect them.

C) Network model between the tables that connect them.

D) None of the above.

View Answer 

Answer: Option  A


46.) Which one of the following is not true for a view:

A)      View is derived from other tables.

B)      View is a virtual table.

C)      A view definition is permanently stored as part of the database.

D)      View never contains derived columns.

  View Answer  

Answer:   Option   C


47.) Which two files are used during operation of the DBMS?

A)      Query languages and utilities

B)      DML and query language

C)      Data dictionary and transaction log

D)      Data dictionary and query language

  View Answer 

Answer:  Option   C


48.) _________ data type can store unstructured data

A)      RAW

B)      CHAR

C)      NUMERIC

D)      VARCHAR

  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)