Midterm Exam- advanced database

in the ________ normal form, a composite attribute is converted to individual attributes. A) 1NF B) 2NF C) 3NF D)BCNF

A) 1NF

When an asterisk (*) is used with SQL statements, You will retrieve_____________ from the specified table A) All attributes B) All primary key attributes C) All attributes with null values D) All attributes without a NULL value

A) All attributes

NOT NULL constraint can be specified for which of the following table attributes? A) Any Attribute B) Only primary key attributes C) Only secondary key attributes D) Only foreign key attributes

A) Any Attribute

Which of the following clauses can be missing in an SQL statement? A) GROUP BY B) SELECT C) FROM D) None of the above

A) GROUP BY

When using an ORDER BY clause with SQL SELECT statement, the default order for the specified attribute is A) Descending B) Ascending C) (A) and (B) D) No default order allowed

B) Ascending

A single SQL UPDATE statement can be used to A) Modify one value in a single table B) Modify one or more values in a single table C) Modify one or more values in a multiple table D) All of the above

B) Modify one or more values in a single table

Which of the functional dependencies are not present in the following dependencies ? EmpNo -> Name, Salary, Deptno, Dname DeptNo-> DName EmpNo -> DName A) full functional dependencies B) Partial functional dependencies C) Transitive functional dependencies D) Both (B) and (C)

B) Partial functional dependencies

When creating an access query, which of the following is correct regarding the query search criteria A) The query result must meet all criteria written in different rows B) The query result must meet all criteria written in the same rows C) the query result must meet either of the criteria written in the same rows D) None of the above

B) The query result must meet all criteria in the same rows

If one attribute is determined of the second, which in turn is determined of third, then the relation cannot be: A) Well structured B) 1NF C) 2NF D) 3NF

D) 3NF

A functional Dependency is a relationship between or among A) Entities B) Rows C) Attributes D) Tables

C) Attributes

Which of the following formats is allowed for an aggregate function COUNT when used with SQL SELECT statement(s)? A) COUNT() B) COUNT(Stud_ID) C) COUNT(Distinct Stud_ID) D) COUNT(Stud_ID, Hours)

C) COUNT(Distinct Stud_ID)

Which of the following statements is not an SQL DDL statement? A) Create B) Alter C) Delete D) None of the above

C) Delete

Aliased table names are defined in which of the following clauses of an SQL SELECT statements? A) GROUP BY B) SELECT C) FROM D) None of the above

C) FROM

A table in third normal form is also in_______ normal form(S) A) First B) Second C) First and Second D) Boyce-Codd

C) First and Second

The database design prevents some data from being stored due to A) Deletion anomalies B) Update anomalies C) Insertion anomalies D) Selection anomalies

C) Insertion anomalies

When an SQL SELECT statement is used to retrieve tuples from more than one table you must specify, _______ within the WHERE clause of that statement A) Distinct conditions B) Merge conditions C) Join conditions D) Any of the above

C) Join conditions

There is a conflict between which of the following pair of database constraints? A) NOT NULL and UNIQUE B) NOT NULL and DEFULT C) UNIQUE and DEFULT D) All of the above

C) UNIQUE and DEFULT

Using the WHERE Clause with SQL SELECT statements: A) You can retrieve only all tuples with NULL values in a specific attribute B) You can retrieve only all tuples without NULL values in a specific attribute C) You can retrieve all tuples with or without NULL values in a specific attribute D) You cannot specify any condition regarding NULL values in a specific attribute

C) You can retrieve all tuples with or without NULL values in a specific attribute

Access allows you to create which of the following types of queries? A) Append Query B) Update query C) Crosstab query D) All of the above

D) All of the above

Nesting queries can be used with which of the following statements? A) DELETE B) UPDATE C) SELECT D) All of the above

D) All of the above

Which of the following statements is not an SQL DML statement? A) Insert B) Update C) Delete D) All of the above

D) All of the above

which of the following has a specified meaning with LIKE substring comparison in SQL SELECT statement A) Asterisk (*) B) Underscore ( _ ) C) Percent (%) D) All of the above

D) All of the above

Tables in second normal form (2NF) A) Must have a composite Key B) Eliminate all hidden dependencies C) Eliminate the possibility of an insertion anomalies D) Have all non-key fields depend on the whole primary key

D) Have all non-key fields depend on the whole primary key

All database's constraints specified in any SQL statement are automatically enforced when _____________ statement(s) are applied to that database A) INSERT B) INSERT and UPDATE C) INSERT and DELETE D) INSERT, DELETE, and UPDATE

D) INSERT, DELETE, and UPDATE

Which of the following is not a valid view for access queries? A) Design View B) Datasheet View C) SQL view D) None of the above

D) None of the above