
DBMS_CSN_AW5_QUIZ
Quiz
•
Computers
•
University
•
Hard
K.vinay kumar
Used 7+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
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
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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%’;
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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;
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Every weak entity set can be converted into a
strong entity set by
using generalization
using aggregation
adding appropriate attributes
OPTION A AND B
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
15 questions
sistema de archivos
Quiz
•
University
10 questions
Adobe Photoshop
Quiz
•
University
11 questions
Access
Quiz
•
10th Grade - University
11 questions
Chapter 2 System Planning
Quiz
•
University
10 questions
Emerging technologies
Quiz
•
6th Grade - University
15 questions
After Effect Intoduction
Quiz
•
10th Grade - University
14 questions
Linux: Users and Groups
Quiz
•
9th Grade - University
10 questions
VR and AR in multimedia applications
Quiz
•
University
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
20 questions
christmas songs
Quiz
•
KG - University
20 questions
Holiday Trivia
Quiz
•
9th Grade - University
15 questions
Holiday Movies
Quiz
•
University
14 questions
Christmas Trivia
Quiz
•
3rd Grade - University
20 questions
Christmas Trivia
Quiz
•
University
8 questions
5th, Unit 4, Lesson 8
Lesson
•
KG - Professional Dev...
20 questions
Disney Trivia
Quiz
•
University
