CS403P Final Term Current Paper

Cs403p Final Term Current Paper

Paid Current paper By Sir Ray Afzal

Q1. Which of the following is the correct way to generate an Index?

1. INSERT INDEX index_name ON database_name;
2. INSERT INDEX index_name ON table_name;
3. CREATE INDEX index_name ON database_name;
4. CREATE INDEX index_name ON table_name;

Q2. Which of the following is the correct syntax to create UNIQUE Indexes?

1. CREATE INDEX index_name ON table_name (column_name);
2. CREATE INDEX index_name on UNIQUE table_name (column_name);
3. CREATE INDEX UNIQUE index_name on table_name (column_name);
4. CREATE UNIQUE INDEX index_name on table_name (column_name);

Q3. Which of the following is the name of view in the following SQL statement?

CREATE VIEW Class1 AS

SELECT ClassID, Course Code, Venue

FROM CLASS;

A. ClassID B. CourseCode C. Class 1 D. CLASS

Q4. Which of the following is also known as a virtual table?

1. Schema
2. Database
3. View
4. Join

Q5. What is "xyz" in the following MySQL statement?

CREATE VIEW xyz as SELECT a, b FROM t;

A. Table name B. Column name C. Database name D. View name

Q6. Which of the following provides the least details about the working of the system?

1. Detailed diagram
2. Context diagram
3. Level 1 diagram
4. Level 2 diagram

Q7. In which normal forms, partial dependency is being removed?

1. INF
2. 2NF
3. 3NF
4. BCNF

Q8. _________dependency occurs when one non-key attribute determines another non-key attribute.

1. Transitive
2. Partial
3. Functional
4. Associative