Searching for "at"

Q:

A ternary relationship involves how many entities?

A) 3 or less B) 3
C) More than 3 D) 3 or more
 
Answer & Explanation Answer: B) 3

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:

A shared database should:

A) be accurate and available. B) provide for backup and recovery.
C) be secure. D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

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:

________ is an open source DBMS product that runs on UNIX, Linux and Windows.

A) MySQL B) JSP/SQL
C) JDBC/SQL D) Sun ACCESS
 
Answer & Explanation Answer: A) MySQL

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 ________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

A) ASP B) XML
C) ODBC D) ADO
 
Answer & Explanation Answer: D) ADO

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