One advantage of indexes is to make some data retrieval more efficient.

A table may have many rows or no rows at all.

If the Tasks table has been defined , the following SQL query is valid in Access. SELECT * FROM TABLE Tasks ;

QBE is a procedural language of 3GL.

The FD: A -> B implies the FD: B -> A

The FD: ( L , F ) -> SID is NOT in the Student table as defined below: Student ( SID , L , F , GPA )

A table must have some columns or fields.

The following SQL command will drop or remove or delete the Client table’s definition and all its data rows. DELETE FROM Client ;

The FD: A -> B implies the FD: B -> A

Access does not use the term “trigger”, but Access offers the functionality of triggers through data macros.

A PC with a 3.4-GHz CPU can execute up to 3.4 million instructions per second.

In the following SQL command, ON DELETE SET NULL means if instructor 6 is deleted from the Instructor table, all students with adviser being instructor 6 will be deleted at the same time. CREATE TABLE Student ( StudentID int NOT NULL, AdvisorID int , LastName varchar(45) NOT NULL, FirstName varchar(45) NOT NULL ) PRIMARY KEY ( StudentID ) FOREIGN KEY ( AdvisorID ) REFERENCES Instructor ( InstructorID ) ON DELETE SET NULL ;

The binary number 110011010011 is = ________ in hexadecimal.

In a relational database, an entry of a field can be a set of values.

Some advantages of using database approach are to control redundancy and to maintain referential integrity.

The following query is valid in Relational Algebra. PROJECT Client OVER (ClientNum , ClientName) GIVING Answer ;

An attribute, column, or field is a property of an entity.

Given that a professor can teach many courses, the relationship from Professor entity to Course entity is one-to-many.

We can NOT write queries using Relational Algebra in Access.

The FD: SID -> ( L , F , GPA ) is valid in the Student table as defined below: Student ( SID , L , F , GPA )

An index for any column must be unique.

A trigger is an action that occurs automatically in response to an associated database operation such as an INSERT, UPDATE, or DELETE.

The following SQL command will only remove or delete all the records in the Client table. DROP TABLE Client ;

System catalog contains only information of those tables that are commonly used by DBA.

In a relational database, a relationship is implemented through some common fields or columns between two relations or tables.

In a relational database, an entity is represented by a table.

The following SQL command is valid to create an unique index of one column on a table. CREATE UNIQUE INDEX IXClientNum ON Client ( ClientNum ) ;

An index for any column may or may not be unique.

To select data from two tables, we need to join two tables based on the matching fields in the corresponding columns.

Decimal number 43 is = ________________ in binary.

We can NOT create an un-normalized table in Access or any relational DBMS.

The FD: ( L , F , G ) -> SID is valid in the Student table as defined below: Student ( SID , L , F , G )

The binary number 001001 is = _______in Octal.

In a table, order of columns is not important, but is meaningful to users and developers.

The FD: A -> B means that each value for A is associated with exactly one value of B.

An un-normalized relation is a structure that satisfies all properties of a relation except that some entries in the table are NOT single-valued.

  

DBA stands for Data Base Administrator.

In Relational Algebra, division of 2 tables is to create a table by concatenating every row in first table with every row in second table.

The decimal number 10 is equal to _________ in binary.

In a relational DBMS, we can create a table that is not in 1NF.

The SQL commands for security mechanisms are GRANT and REVOKE.

We may use DELETE command to completely remove the whole table’s definition and records.

Big data may be structured, unstructured, or a combination of both.

In a relational database, each entity is stored in a table or relation.

The following SQL command will only remove or delete all the rows or records of the Class table. DROP TABLE Class ;

In QBE queries, we may use aggregate functions such as Count, Sum, Avg, Max, and Min.

Outer join is to join records from each original table that is common to both tables.

In QBE query, we may add a computed field like "AvailableCredit: CreditLimit - Balance" using the Zoom dialog box.

Normalization is a method to convert tables into 2NF, 3NF, or 4NF.

Given that a professor can advise many students, the relationship from Professor entity to Student entity is many-to-one.

A table can have many primary keys since a table may have many candidate keys.

A table can have only one primary key and one foreign key.

Table in 1NF is better than the table in 2NF, which is better than the table in 3NF or 4NF.

To select data from two tables, we need to join two tables based on the matching fields in the corresponding columns.

A relationship is an association between two attributes.

We can create an un-normalized table in Access or any relational DBMS.

In Access, referential integrity (RI) is specified by defining a relationship between two tables.

Some advantages of using database approach are to control redundancy and to maintain referential integrity.

Binary number 101100110 is = _________ in decimal.

ACCESS is a relational DBMS.

QBE stands for _______ By Example. (hint: Q_____y)

A table can have only one primary key, but can have many foreign keys.

To specify referential integrity (RI) in SQL, we may add FOREIGN KEY clause in either the CREATE TABLE or ALTER TABLE commands.

( A -> B and B -> C ) implies A -> C

A table may have many columns or no columns at all.

If the Tasks table has been defined , the following SQL query is valid in Access. SELECT ALL FROM Tasks ;

The primary key of a table R is the column(s) (in R) that can uniquely identify every row in R.

The following SQL command will only remove or delete all the rows from the EMP table. DELETE FROM EMP ;

The primary key for Student table in a relational database can be StudentID.

In a relational DBMS, we can NOT create a table that is not in 1NF.

A table can have many primary keys since a table may have many candidate keys.

A table may have many columns or no columns at all.

A , which is a column or a set of columns, is a candidate key for table R if all columns in R are functionally dependent on A, and no subset of A can functionally determine all columns in R.

Access does not offer the functionality of triggers through data macros.

A table may have many rows or no rows at all.

QBE stands for Query By __________. (hint: E_____e)

The binary number 101110111 is = _______in Octal.

One disadvantage of using a DBMS is the complexity of referential integrity.

A relationship is an association between two tables through their common fields.

An un-normalized relation is a structure that satisfies all properties of a relation except that some entries in the table are NOT single-valued.

In a table, an entry is NOT single-valued if it contains repeating groups.

A PC with a 3.4-GHz CPU can execute up to 3.4 million instructions per second.

Normalization process may not guarantee to make all tables free of all anomalies or problems.

A table should have a primary key, but a table may have many candidate keys.

In the Relationships diagram of Access, a line connects a primary key to a foreign key with one-to-many relationship.

In a relational database, some duplicate rows are allowed in a table.

Normally, a DBA would design a database with tables whose FDs are documented clearly in users’ manuals/policies.

In QBE query, we may specify " > 21 " on Criteria: row under Age column.

The hex number 00000F is equal to _____ in decimal.

Normally, a DBA would design a database with tables whose FDs are documented clearly in users’ manuals/policies.

In Access, referential integrity (RI) is specified by defining a relationship between two tables.

The following SQL command will drop or delete the field EMP from the SSN table. ALTER TABLE EMP DROP COLUMN SSN ;

The binary number 10001001 is equal to _____ in hex.

Normalization process may not guarantee to make all tables free of all anomalies or problems.

( A -> B and A -> C ) implies B -> C

In Access, we cannot join multiple tables in a query.

The FD: SID -> ( L , F , GPA ) is valid in the Student table as defined below: Student ( SID , L , F , GPA )

Table W ( N, D , T , C , S ) is in 2NF if it has the following 2 FDs: FD1: N -> D FD2: N, T -> ( D , C , S )

The FD: A -> B means that each value for A is associated with exactly one value of B.

We can write queries using Relational Algebra in Access.

We cannot create an index on many columns of a table.

1KB of main memory actually contains __________ (exactly how many) bytes of memory. (Hint: More than 1000)

The FD: ( L , F ) -> SID is NOT in the Student table as defined below: Student ( SID , L , F , GPA )

The FD: SID -> GPA is valid in the Student table as defined below: Student ( SID , LastName , FirstName , GPA )

The following SQL query will display all rows and all columns of the Employee table. SELECT * FROM Employee ;

ACCESS is NOT a relational DBMS.

The primary key of the Student table (as shown below) can be LastName and FirstName. Student ( StudentID, LastName, FirstName, Address, Phone, GPA, Major, BirthDate )

We can always determine a FD by just carefully examining the contents/records of a table or relation.

The following SQL command is to add a new field called GPA to the Student table. ALTER TABLE Student ADD GPA CHAR(1) ;

ERD stands for ________ Relationship Diagram. (hint: E_________y )

( A -> B and A -> C ) implies B -> C

In a relational database, some duplicate rows are allowed in a table.

To specify primary key in SQL, we may enter a PRIMARY KEY clause in either an ALTER TABLE or a CREATE TABLE command.

SQL stands for ________ Query Language. (hint: S______d)

The binary number 10001001 is equal to _____ in hex.

A , which is a column or a set of columns, is a candidate key for table R if and only if all columns in R are functionally dependent on A.

In Access, we cannot join multiple tables in a query.

An un-normalized table can be in 1NF sometimes.

In Access, a join line indicates that the tables are related between primary key (PK) and foreign key (FK).