In a 1:N relationship, the foreign key is placed in: the parent table. the child

CuriousTab

CuriousTab

Home Aptitude

Discussion

Home ‣ Technical Questions ‣ Database Comments

Question
In a 1:N relationship, the foreign key is placed in:
Options
A. the parent table.
B. the child table.
C. either table without specifying parent and child tables.
D. either the parent table or the child table.

Correct Answer

the child table.

Database problems

Search Results

1. Using OQL, you may do which of the following?
Options
A. Return an entire collection of elements including duplicates.
B. Return a collection of elements without duplicates.
C. Return a specific subset of elements using a given criteria.
D. All of the above.

2. The object definition language (ODL) is which of the following?
Options
A. Used to develop logical schemas
B. A data definition language for OODB
C. A method to implement a logical schema
D. All of the above.

3. A distributed database is which of the following?
Options
A. A single logical database that is spread to multiple locations and is interconnected by a network
B. A loose collection of file that is spread to multiple locations and is interconnected by a network
C. A single logical database that is limited to one location.
D. A loose collection of file that is limited to one location.

4. A distributed database can use which of the following strategies?
Options
A. Totally centralized one location and accessed by many sites
B. Partially or totally replicated across sites
C. Partitioned into segments at different sites
D. All of the above

5. Stored procedures have which of the following advantages?
Options
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.

6. The process of reading a database schema and producing a data model from that schema is known as:
Options
A. data modeling.
B. database design.
C. reverse engineering.
D. None of the above is correct.

7. To drop a column that is used as a foreign key, first:
Options
A. drop the primary key.
B. drop the table containing the foreign key..
C. drop the foreign key constraint.
D. All of the above must be done.

8. 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?
Options
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.

9. Of the three ways to create an Oracle database, which one is the easiest and most recommended?
Options
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.

10. An Oracle System Change Number (SCN):
Options
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.

Comments

More in Technical Questions: