Databases | SQL | Oracle | MS Access Answers

Table CUSTOMER has all customers, and it has a column STATE for the Customer Address' State. What statement below would return all customers from California ('CA') and Texas ('TX')?


SELECT *

FROM CUSTOMER

WHERE STATE = 'CA'

OR STATE = 'TX'


SELECT *

FROM CUSTOMER

WHERE STATE = 'CA' OR 'TX'


SELECT *

FROM CUSTOMER

WHERE STATE = 'CA','TX'


SELECT *

FROM CUSTOMER

WHERE STATE = 'CA'

AND STATE = 'TX'

What is CUST in the statement below?

SELECT CUST.CUSTOMERNAME

FROM CUSTOMER_T CUST

WHERE CUSTOMER_STATE = 'TX'


a column alias


a synonym


a table alias


an aggregate function

Table A has one column, COL1, an INTEGER. Select the command below that would add a row with value 10 to the table.


A (COL1) VALUES (10)


ADD ROW TO A (COL1) VALUES (10)


SELECT A (COL1) VALUES (10)


INSERT INTO A (COL1) VALUES (10)

Referential Integrity is enforced via...


foreign keys


NOT NULL values


NULL values


primary keys

When adding a column to a table, what is the keyword used to make values for the column required? Think how you would avoid that column being empty (no value).


NULL


NOT NULL


PRIMARY KEY


UNIQUE

Difference between natural join and inner join

What would be the right setting for a column that should always have a value?


NULL


Primary key


NOT NULL


INTEGER

What is the main benefit of denormalizing a normalized table?


Less data redundancy


Less space needed


More security


Improved speed of data retrieval

When building the Physical Data Model, one of the decisions that needs to be made is...


normalize all relations


insert an instance


define attributes' data type


name the entity

A _______________________ dependency is a functional dependency on non-primary key attributes.


Transitive


Adjacent


Partial


Functional