1D0-541 Exam Dumps - CIW Web Development Series Questions and Answers

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.

SELECT * FROM

Registration WHERE

Course_Code = #

SELECT * FROM

Registration WHERE

Course_Code LIKE _

SELECT * FROM

Registration WHERE

Course_Code LIKE %

SELECT * FROM

Registration WHERE

Course Code = %

Entity

Matrix

Relation

Data dictionary

A system catalog containing user data

An area of the database that is directly accessible by the user

Data that is stored in tables and is only accessible by the DBMS

Metadata that is stored in tables and is only accessible by the DBMS

Update

Transaction

Encapsulation

Operational group

UPDATE Recreation SET Activity,

Activity_Fee (‘Tennis’,100) WHERE

Student_ID = 1003;

UPDATE TABLE Recreation ALTER COLUMN ACTIVITY

SET ACTIVITY =‘Tennis', Activity_Fee = 100 WHERE

Student__ID = 1003 AND Activity = wimming?AND Activity=

?wimming?

UPDATE Recreation SET Activity =

‘Tennis', Activity_Fee = 100 WHERE

Student_ID = 1003 AND Activity =

'Swimming';

DELETE Activity FROM

Recreation WHERE

Student_ID = 1003; INSERT

INTO Recreation VALUES (1003,‘Tennis', 100);

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

The number of domains changes.

The attributes in the domain change.

The cardinality of the relation is fixed but the degree varies.

The degree of the relation is fixed but the cardinality varies.

Cust_Name is the determinant.

Cust_Name is transitively dependent on Cust_ID.

Cust_ID is transitively dependent on Cust_Name.

Cust_Name is functionally dependent on Cust_ID.

CREATE TABLE RESIDENT (

R_ID INTEGER NULL PRIMARY KEY,

Room_Num FLOAT,

Res_Name VARCHAR,

Building_ID INTEGER NULL,

FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

CREATE TABLE RESIDENT (

R_ID INTEGER NOT NULL PRIMARY KEY,

Room_Num BINARY,

Res_Name VARCHAR (20),

Building_ID INTEGER NOT NULL,

FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

CREATE TABLE RESIDENT (

R_ID INTEGER NOT NULL PRIMARY KEY,

Room_Num INTEGER,

Res_Name VARCHAR (20),

Building_ID INTEGER NOT NULL);

CREATE TABLE RESIDENT (

R_ID INTEGER NOT NULL PRIMARY KEY,

Room_Num INTEGER,

Res_Name VARCHAR (20),

Building_ID INTEGER NOT NULL,

FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));