1D0-541 Questions and Answers

Metadata

Data model

Table data

Metafile

It is the primary key for an entity.

It uniquely identifies every instance of an entity.

One or more keys are joined together to form a composite key.

One or more keys may be used to form a primary key.

The user accesses a database server using a terminal.

The user interface, data-processing logic, database access and data validation functions are performed on a mainframe server.

The user interface and data validation functions are performed by the client whereas the data-processing logic is performed on a server.

The user interface and data-processing logic are performed by the client whereas the server handles database access and data validation functions.

A Web browser is used as the application server.

The application logic is centralized on a dedicated server.

A thick client is used to perform business application logic functions locally.

Database application logic and database functionality are integrated and reside on a common server.

Data that is stored as tables

Software that manipulates data

Data that is stored in a structured manner

Data records that are stored sequentially in a file

OptionA

OptionB

OptionC

OptionD

1 = attribute, 2 = entity, 3 = relationship

1 = entity, 2 = relationship, 3 = attribute

1 = relationship, 2 = entity, 3 = attribute

1 = relationship, 2 = attribute, 3 = entity

Second normal form

First normal form

Boyce-Codd normal form

Third normal form

STUDENT( Student_Number: integer NOT NULL Name:

variable length character string length 20 NOT NULL)

Primary Key Student_Number CLASS( Class_Num: integer

NOT NULL Class_Name: integer NOT NULL) Primary Key

Class_Num

STUDENT( Student_Number: integer NOT NULL Name:

variable length character string length 20 NOT NULL)

Primary Key Student_Number CLASS( Class_Num: integer

NOT NULL Class_Name: integer NOT NULL) Primary Key

Class_Num Foreign Key Class_Num References STUDENT

STUDENT( Student_Number: integer NOT NULL Name:

variable length character string length 20 NOT NULL)

Primary Key StudenMMumber STU_CLASS(

Student_Number: integer NOT NULL Class_Num: integer

NOT NULL) Primary Key Student_Number CLASS(

Class_Num: integer NOT NULL Class_Name: integer NOT

NULL) Primary Key Class_Num

SELECT *FROM

Dept1_Parts

EXCEPT(SELECT

PartJD FROM

Dept2_Parts);

SELECT * FROM

Dept1_Parts MINUS

(SELECT Part_ID

FROM Dept2_Parts);

SELECT*FROM

Dept1_Parts

DIFFERENCE

(SELECT Part_ID

FROM Dept2_Parts);

SELECT*FROM

Dept1_Parts WHERE

Part_ID NOT IN

(SELECT Part_ID FROM

Dept2_Parts);

Concurrent transactions read data from the same data structure.

Concurrent transactions write data to different data structures.

Concurrent transactions read or write the same data structure.

Concurrent transactions read or write from different data structures.

GRANT UPDATE ON Project TO Rubio, Doe;

GRANT SELECT ON Project TO Temp;

GRANT ALL PRIVILEGES ON Project TO Rubio, Doe;

GRANT UPDATE ON Project TO Temp;

GRANT SELECT ON Project

WHERE Manager = 'Rubio';

GRANT SELECT ON Project

WHERE Manager = 'Doe';

GRANT UPDATE ON Project

WHERE Manager = 'Rubio';

GRANT UPDATE ON Project

WHERE Manager = 'Doe';

GRANT SELECT ON Project TO Temp;

The database designer tests the software because he or she is able to make necessary changes to the underlying code for the software.

A user who has no knowledge of the softwares underlying code tests the software.

Someone other than the database designer tests the software. This person has no access to the underlying code and attempts to use the software only in ways not considered by the software designers.

A person tests the software and submits suggestions to the software's underlying code. This person is someone other than the database designer, but has access to the softwares underlying code.

Weak

Strong

Foreign

Primary