DBMS_CSN_AW5_QUIZ

Which is the correct SQL command to create the table borrower having two foreign keys customer name and loan number by using the following schemas? Primary keys are underlined in the schemas.

• loan(loan number, branch name, amount) • customer(customer name, customer street, customer city) • borrower(customer name, loan number)

• CREATE TABLE borrower( customer_name VARCHAR(20), loan_number NUMERIC(12,2), PRIMARY KEY(customer_name, loan_number), FOREIGN KEY(customer_name) REFERENCES customer, FOREIGN KEY(loan_number) REFERENCES loan);

• CREATE TABLE borrower(

  customer_name VARCHAR(20),

  loan_number NUMERIC(12,2),

  PRIMARY KEY(customer_name),

  FOREIGN KEY(customer_name) REFERENCES customer,

  FOREIGN KEY(loan_number) REFERENCES loan);

• CREATE TABLE borrower( customer_name VARCHAR(20) PRIMARY KEY, loan_number NUMERIC(12,2) PRIMARY KEY, FOREIGN KEY(customer_name) REFERENCES customer, FOREIGN KEY(loan_number) REFERENCES loan);

• NONE OF THE ABOVE

• OPTION B AND C

Choose the correct SQL command to display the customer name and loan number of customers

who have a loan from bank and whose name starts with ’A’. Primary keys are underlined in

the schema.

• borrower(customer name, loan number)

• SELECT * FROM borrower WHERE customer_name = ’A’;

• SELECT * FROM borrower WHERE customer_name LIKES ’A%’;

• SELECT * FROM borrower WHERE customer_name LIKE ’%A’;

• SELECT * FROM borrower WHERE customer_name LIKE ’A%’;

Which is/are the correct SQL command/s to display the loan numbers of the customers in

ascending order of their loan amounts. Primary key is underlined in the schemas.

• loan(loan number, branch name, amount)

• SELECT loan_number FROM loan SORT BY amount;

• SELECT loan_number FROM loan GROUP BY amount;

• SELECT loan_number FROM loan ORDER BY amount;

• SELECT loan_number FROM loan ORDER BY amount ASC;

Every weak entity set can be converted into a

strong entity set by

• using generalization

• using aggregation

• adding appropriate attributes

• OPTION A AND B

How to Add unique constraint to a table during it’s creation at table level with user choice of unique constraint name.

choose the correct answer from the given options

• ALTER TABLE DEPT ADD CONSTAINTS uk_dept_deptno UNIQUE(DEPTNO);

• CREATE TABLE DEPT (DEPTNO NUMBER(2), DNAME VARCHAR2(15), CONSTRAINT u1 UNIQUE(DEPTNO));

• CREATE TABLE DEPT (DEPTNO NUMBER(2), DNAME VARCHAR2(15), CONSTRAINTS u-1 UNIQUE(DEPTNO));

• OPTION A AND C

• NONE OF THE ABOVE

Data modeling is performed for the following reasons:

• We draw an ER solely to please the users; once completed, the ERD is never referred to again

  as it serves no purpose in the real world.

• We do not need datamodels; we can just start coding right away.

• The ERD becomes a blueprint for designing the actual system

• OPTION A AND B

• NONE OF THE ABOVE

A/an _________'s value can be a number, a character string, a date, an image, a sound

• Table

• Entity

• Attribute

• Disjoint partial

• None of the above

In EER model the association between subclass and super class is as

• sub class is subset of super class

• super class is a subset of sub classes

• super class is a combinations of specialization

• none of the above

Evaluate this SELECT statement:

SELECT first_name, last_name, email

FROM employees

ORDER BY last_name;

Which statement is true?

• The rows will be sorted alphabetically by the FIRST_NAME and then the LAST_NAME values

• The rows will be sorted in reverse alphabetical order by the LAST_NAME values.

• The rows will be sorted alphabetically by the LAST_NAME values

• Option A and B

• NONE OF THE ABOVE

From left to right, what is the correct order of Precedence?

• Arithmetic, NOT, Logical, Comparison

• NOT, AND, OR, Arithmetic

• Arithmetic, NOT, Concatenation, Logical

• Arithmetic, Concatenation, Comparison, OR

• None of the above