Sawaal
  • Home/
  • Searching for ING

 Searching for "ING"

Q:

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

A) Equi-join B) Natural join
C) Outer join D) Cartesian join
 
Answer & Explanation Answer: D) Cartesian join

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

When mapping a supertype/subtype relationship which of the following is true?

A) The supertype primary key is assigned to each subtype. B) The subtype primary key is assigned to each supertype.
C) There is no link between the supertype/subtype entities. D) There is no primary key/foreign key relationship between a supertype/subtype.
 
Answer & Explanation Answer: A) The supertype primary key is assigned to each subtype.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 A transitive dependency is which of the following?

A) A functional dependency between two or more key attributes. B) A functional dependency between two or more nonkey attributes.
C) A relation that is in first normal form. D) A relation that is in second normal form.
 
Answer & Explanation Answer: B) A functional dependency between two or more nonkey attributes.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 A composite attribute is which of the following?

A) An attribute that can be broken into components B) An attribute that cannot be broken into components
C) Multiple attributes D) An identifier
 
Answer & Explanation Answer: A) An attribute that can be broken into components

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 Legacy data is which of the following?

A) Data contained in a newly-installed system B) Data rejected during the installation of a new system
C) Data contained in a file system D) Data contained by a system used prior to the installation of a new system
 
Answer & Explanation Answer: D) Data contained by a system used prior to the installation of a new system

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

Which of the following are goals of OLE DB?

A) Create object interfaces for DBMS functionality pieces only. B) Increase flexibility only.
C) Object interface over any type of data only. D) All of the above as goals of OLE DB.
 
Answer & Explanation Answer: D) All of the above as goals of OLE DB.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 The ODBC Level 1 API contains which of the following functions?

A) Browse possible connections and data sources only B) Connect to data sources with driver-specific information only
C) Process a scrollable cursor only D) Both 1 and 3 above are in the OBDC Level 1 API.
 
Answer & Explanation Answer: B) Connect to data sources with driver-specific information only

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

The ODBC core API consists of which of the following functions?

A) Commit or rollback transactions only B) Connect to data sources only
C) Connect to data sources with driver-specific information only D) Both 1 and 2 above are in the OBDC core API.
 
Answer & Explanation Answer: D) Both 1 and 2 above are in the OBDC core API.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database