Sawaal
  • Home/
  • Searching for V

 Searching for "V"

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:

 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:

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

A) Two B) Three
C) Four D) Six
 
Answer & Explanation Answer: D) Six

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:

A) first step. B) second step.
C) third step. D) fourth step.
 
Answer & Explanation Answer: C) third step.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

A) ONLY B) DISTINCT
C) UNIQUE D) SINGLE
 
Answer & Explanation Answer: B) DISTINCT

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:

 Stored procedures have which of the following advantages?

A) It takes a longer time to write them as compared to writing Visual Basic. B) Data integrity improves as multiple applications access the same stored procedure.
C) Network traffic increases D) Result in thicker client and thinner database server.
 
Answer & Explanation Answer: B) Data integrity improves as multiple applications access the same stored procedure.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 Which of the following improves a query's processing time?

A) Write complex queries. B) Combine a table with itself.
C) Query one query within another. D) Use compatible data types.
 
Answer & Explanation Answer: D) Use compatible data types.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database