Sawaal
  • Home/
  • Searching for CH

 Searching for "CH"

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

Q:

An Oracle System Change Number (SCN):

A) is a value that is incremented whenever a dirty read occurs. B) is incremented whenever a deadlock occurs.
C) is a value that keeps track of explicit locks. D) is a value that is incremented whenever database changes are made.
 
Answer & Explanation Answer: D) is a value that is incremented whenever database changes are made.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

Of the three ways to create an Oracle database, which one is the easiest and most recommended?

A) Using the Oracle Database Configuration Assistant. B) Using the Oracle-supplied database creation procedures.
C) Using the SQL CREATE DATABASE command. D) None of the above is correct.
 
Answer & Explanation Answer: A) Using the Oracle Database Configuration Assistant.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

A) ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0); B) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
C) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0); D) None of the above is correct.
 
Answer & Explanation Answer: C) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 The process of reading a database schema and producing a data model from that schema is known as:

A) data modeling. B) database design.
C) reverse engineering. D) None of the above is correct.
 
Answer & Explanation Answer: C) reverse engineering.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 The HAVING clause does which of the following?

A) Acts like a WHERE clause but is used for groups rather than rows. B) Acts like a WHERE clause but is used for rows rather than columns.
C) Acts like a WHERE clause but is used for columns rather than groups. D) Acts EXACTLY like a WHERE clause.
 
Answer & Explanation Answer: A) Acts like a WHERE clause but is used for groups rather than rows.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 ON UPDATE CASCADE ensures which of the following?

A) Normalization B) Data Integrity
C) Materialized Views D) All of the above.
 
Answer & Explanation Answer: B) Data Integrity

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database