We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

Salam to all. Dear fellows, plz share current quiz solved files. thanx and JAZAK ALLAH.

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 3428

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’ ORDERBY Age;
The statement has a syntax error
Which of the following function falls in the category of Aggregate functions.
SUM
MIN
MAX
All of the above = Correct Option
REVOKE is a ______________ statement.
Data Definition
Control Access = Correct Option
Data manipulation
Data description


Truncate is an alternative of Delete command.
False
The ________ condition allows to retrieve values within a specific range.
from
Which of the following SQL statements used to control access to the data and to the database
GRANT
REVOKE 
Both GRANT and REVOKE = Correct Option
SELECT
Which of the following is used to retrieve and insert information from database?
DML
DDL
DCL
Both DML and DDL = Correct Option
Value of a function in SQL is always determined by the input parameters
True
False
Which of the following is used with INSERT command to insert values in a DB table?
Onto
INTO = Correct Option
UPTO
WITH
Is the given SQL Statement prompt error? Select * from relation1;


Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’ ORDERBY Age;
DCL
In SQL, which command is used to modify the rows of tables.
UPDATE = Correct Option
INSERT
BROWSE
APPEND
The ________ operator allows to use wild cards in the where clause of an SQL statement.
LIKE = Correct Option

Truncate command response time is ______ as compared to Delete command.
Worst = Correct Option
Which of the following is not DML command?
Select
Update = Correct Option

Identify the language which is used to specify database schema.
Non of the above = Correct Option
Which of the following prevents duplicate values to be displayed as a result of an SQL statement?
DISTINCT = Correct Option
DELETE
UPDATE
ALTER
SQL stands for ______________. I - Structured Query Language II – Standard Query Language lll- Status Query Language
ONLY I = Correct Option
ONLY II
BOTH I AND II
ONLY III
Which language is used to permit or prohibit access to a table?
DCL = Correct Option
SQL is used for:
Creating, managing and deleting tables and manage the relationships among the stored date.
Generating queries, organizing, managing and retrieving data stored in a database.
Maintaining data integrity and coordinate data sharing.
All of the above = Correct Option

DDL, DML and DCL commands


DDL

Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:
CREATE - to create objects in the database
ALTER - alters the structure of the database
DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
COMMENT - add comments to the data dictionary
RENAME - rename an object
DML

Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:
SELECT - retrieve data from the a database
INSERT - insert data into a table
UPDATE - updates existing data within a table
DELETE - deletes all records from a table, the space for the records remain
MERGE - UPSERT operation (insert or update)
CALL - call a PL/SQL or Java subprogram
EXPLAIN PLAN - explain access path to data
LOCK TABLE - control concurrency
DCL

Data Control Language (DCL) statements. Some examples:
GRANT - gives user's access privileges to database
REVOKE - withdraw access privileges given with the GRANT command
TCL

Transaction Control (TCL) statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions.
COMMIT - save work done
SAVEPOINT - identify a point in a transaction to which you can later roll back
ROLLBACK - restore database to original since the last COMMIT
SET TRANSACTION - Change transaction options like isolation level and what rollback segment to use

read it befor quiz

Attachments:

CS403_Quiz_04_Mega_File

Attachments:

Cs403 quizz:

SQL stands for ______________. I - Structured Query Language II – Standard Query Language lll- Status Query Language

  • Only I                                     ANS
  • Only II
  • Both I and II
  • Only lll



Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’ ORDERBY Age;

  • The statement has a syntax error
  • The statement displays the entire fields from emp in which the Empname is ALI in any order                  (ANS)

 

  • The statement displays the entire fields from emp in which the Empname is ALI in descending order of their age
  • The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age

 

 

Which of the following syntax of the functions in SQL is used to add column values?

  • COUNT(*)
  • COUNT(expression)
  • MAX(expression)
  • SUM(expression)                      ANS

 

 

Which of the following is NOT a DDL command?

  • Create DB
  • Create table
  • Delete                            ANS
  • Drop

 

 

Which of the following is not DML command?

  • Select
  • Update
  • Delete
  • Truncate                                  ANS:


 REVOKE is a ______________ statement.

  • Data definition
  • Control access                             ANS
  • Data manipulation 

 

 

__________ User Interface is preferred over ________ User Interface with respect to user.

  • Easy to understand, efficient
  • Hard to understand, efficient
  • Easy to understand, effective                            ANS:       
  • Hard to understand, effective

Truncate is an alternative of Delete command.

  • True                                                     ANS:
  • False


Consider the two relations, Supplier (S_no, S_name, Contact_No, Address) and Supply (S_no, Item_no). Which of the following

statements give(s) a list of supplier names supplying the item with Item_no ‘555’?

 

  • SELECT S_name FROM Supplier WHERE Item_no=’555’                      (ANS)

 

  • SELECT S_name FROM Supplier, Supply WHERE Supplier.S_no=Supply.S_no AND Item_no=’555’ 
  • SELECT S_name FROM Supplier WHERE S_no EXISTS (SELECT S_no FROM Supply WHERE Item_no=’555’) 
  • SELECT S_name FROM Supplier WHERE S_name EXISTS (SELECT S_name FROM Supply WHERE Item_no='555')

 

 

GRANT is a ______________ Command.

  • DDL
  • DML
  • DCL
  • None of given                          ( ANS)

 

 

Funcation is an alternative of Delecte command

True                             (ANS)

False

 

DML (data manipulation Language ) is the set of command used to maintain and query a database including updating. inserting , modifying and retrieving data

True                           (ANS)

false

 


UPDATE command belongs to which type of Classification
DML
DDL
DCL
DQL

The _________ function helps reduce the need to use multiple OR conditions.
Like
IN
AND
Between

 Which of the flowing clauses allows to sort the records in result set?
Where
Order by
From
Having

In SQL queries, while creating tables or relations in database, key columns may be specified by
Null
Not Null
Data Type
None of the above

Identify the language which is used to specify database schema.
DCL
DML
DDL
Non of the above

_______ Operators are the ones that require two operands on both sides of the operator.
Double
Tow Sided
Binary
None of the given options

What happened if the Where clause is omitted from a Delete Statement?
All record from the table are deleted
No record from the tables will be deleted
First record of the tables will be deleted
The statement will not be executed and will give a syntax error

Which of the following is a String function in SQL
Count
LEN
SQRT
SIN

Revoke is a __________ Statement
Data Definition
Control Access
Data Manipulation
Data Description

Truncate command response time is ____ as compared to Delete command.
Select correct option:
Poor
Same
Better
worst

 

Which of the following syntax of the functions in SQL is used to add column values?
Select correct option:
COUNT(*)
COUNT(expression)
MAX(expression)
SUM(expression) 

 

SQL is used for: 


Select correct option: 
Creating, managing and deleting tables and manage the relationships among the stored date. 
Generating queries, organizing, managing and retrieving data stored in a database. 
Maintaining data integrity and coordinate data sharing. 
All of the above

 

Which of the following is used to filter rows according to some condition(s)? 
Select correct option: 
SELECT 
FROM 
WHERE 
UPDATE

 

Which language is used to permit or prohibit access to a table? 
Select correct option: 
DCL 
DDL 
DML 
All of the above.

 

Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data. 
Select correct option: 
True 
FALSE

 

Which of the following is NOT a DDL command? 
Select correct option: 
Create DB 
Create table 
Delete 
Drop

 

Which of the following function falls in the category of Aggregate functions. 
Select correct option: 
SUM 
MIN 
MAX 
All of the above

 

Value of a function in SQL is always determined by the input parameters
TRUE
FALSE

            

Which of the following is a service provided by a DBMS?

 

            A)        It ensures and enforces data integrity at all levels

            B)        It maintains an environment in which security is created and enforced

            C)        It manages the metadata in the data dictionary

            D)        All of the above are services of a DBMS

 

2         

What is the difference between a DBMS and an RDBMS?

 

            A)        A RDBMS uses metadata while a DBMS does not.

 

            B)        A DBMS is used for data warehousing.

 

            C)        Because a relational database is more complicated than a conventional database, the RDBMS requires much more computing power than the conventional DBMS requires.

 

            D)        Because a conventional database is less complicated than a relational database, the DBMS is used more often for transactional databases.

 

3                     

Which of the following statements best describes a data warehouse?

 

            A)        A data storage facility dedicated to using the existing data to generate information.

            B)        Frequent and complex transactions characterize its use.

            C)        The most common type of database in use today.

            D)        Generally used in environments with large inventories, thus the term warehouse.

 

 

4         

Which of the following justifies the inclusion of derived attributes in a database?

 

            A)        Inclusion of derived attributes is a standard procedure and does not require justification.

            B)        Derived attributes should be used when they add to design elegance.

            C)        Query speed is enhanced by not computing derived attributes.

            D)        Poor design is the only excuse for the inclusion of derived attributes.

 

 

5         

Select the statement that best defines a candidate key.

 

            A)        An attribute or combination of attributes that allows the user to search for non-unique data.

            B)        An attribute or combination of attributes that is calculated from existing data.

            C)        An attribute or combination of attributes that establishes relationships between tables.

            D)        An attribute or combination of attributes that could be, but is not, used as a PK

 

Normalizing the Database table Structures

 

 

1                     

A __________ is established when the value of one attribute is dependent on the value of another attribute.

 

            A)        primary key

            B)        data anomaly

            C)        dependency

            D)        transitive relationship

 

 

2         

The room ID + building ID determines the room schedule. This is written:

 

            A)        ROOM_ID, BUILD_ID ? ROOM_SCH

            B)        ROOM_ID + BUILD_ID ? ROOM_SCH

            C)        ROOM_ID, ROOM_SCH ? BUILD_ID

            D)        ROOM_ID, BUILD_ID ? ROOM_SCH

 

 

3

The database data storage standard requires that, with some exceptions, data must occur in only one place at one time. What are the exceptions?

 

            A)        Foreign key and replicated data requirements

            B)        Transitive dependencies and foreign keys

            C)        Replicated data and primary keys

            D)        Transitive dependencies and primary keys

 

4                     

Data redundancies produce unusual and undesirable data management problems caused by __________.

 

            A)        transitive requirements

            B)        dependencies

            C)        normalization

            D)        data anomalies

 

 

5                     

Removing the __________ is part of the database design process.

 

            A)        foreign keys

            B)        primary key dependencies

            C)        recursive relationships

            D)        partial and transitive dependencies

 

 

 

The POS Database Design Process

 

 

1                     

In a POS system, what do the major transaction modules define?

 

            A)        Inventory management, shipping, invoice calculations, and product returns

            B)        Sales, inventory management, shipping, back ordering, and product returns

            C)        Sales, invoice calculations, back ordering, and product returns

            D)        Inventory management, shipping, invoice calculations, back ordering, and product returns

 

 

2

What are the fourth and fifth steps in developing a POS?

 

            A)        Define the entities, attributes, relationships, connectivities, cardinalities, and constraints. Create the initial ERD segments.

            B)        Develop business rules. Create the initial ERD segments.

            C)        Develop business rules. Define the entities, attributes, relationships, connectivities, cardinalities, and constraints.

            D)        Define the major transaction modules. Create the initial ERD segments.

 

3

After creating the initial ERD segments, the next step is to

 

            A)        define the major transaction modules.

            B)        perform the appropriate normalization checks based on the data dictionary contents.

            C)        create a basic data dictionary for all the components found in each ERD segment.

            D)        define the entities, attributes, relationships, connectivities, cardinalities, and constraints.

 

 

4

What will the following questions help you define? What types of transactions take place? How many different types of transactions are there?

 

            A)        Available resources

            B)        Data environment

            C)        Current operations

            D)        Business objectives

 

 

5         

Which of the following is an advantage of having a precisely written set of current operations.

 

            A)        It clarifies the assignment of data types.

            B)        It highlights the best possible way to perform each task.

            C)        It forces careful assessment of the procedures.

            D)        It makes the creation of the data dictionary much easier.

 

 

Implementing the Database Design

 

 

1                     

You have created a table in Access, but not yet designated a PK. What happens if you save the table now?

 

            A)        The save fails because no PK is defined.

            B)        The save works as usual.

            C)        Access warns you that no primary key is defined, and forces you to define a PK before saving.

            D)        Access warns you that no primary key is defined, but lets you save the table if you want to.

 

 

2

You want to create a composite PK using the first and third fields in the table. How is this done?

 

            A)        Hold down the Shift key and click the first and third fields. Click the Key icon on the toolbar.

            B)        Hold down the Ctrl key and click the first and third fields. Click the Key icon on the toolbar.

            C)        Hold down the Shift key and click the first and third fields. Select Primary Key under the Table.

            D)        Hold down the Ctrl key and click the first and third fields. Select Primary Key under the Table.

 

 

3                     

What is required to establish a 1:1 relationship between two tables that do not contain a supertype and subtype?

 

            A)        1:1 relationships are only possible if the tables contain a supertype and subtype.

            B)        Make sure that the PK in the related table has unique values.

            C)        Make sure that the FK in the related table has an index property that specifies unique values.

            D)        Nothing special is required.

 

 

4         

In Access, how do you tell if referential integrity is enforced for a relationship?

 

            A)        The relationship lines are thick and dark, and the nature of the relationships is labeled.

            B)        The relationship lines are thin, and the nature of the relationships is labeled.

            C)        Right-click the relationship line to see if enforce referential integrity is checked.

            D)        Right-click the relationship line, select referential integrity, and look at the relationship's properties.

 

 

5

The relationship between STORE and EMPLOYEE is defaulted to mandatory, that is, the FK value in EMPLOYEE is required. How do you eliminate a record from STORE?

 

            A)        Delete the employees from the STORE to be deleted.

            B)        Permanently remove the referential integrity enforcement.

            C)        Open the EMPLOYEE table in the design format; then change the Required property of the EMPLOYEE's FK to No and make sure that its default value is set to null.

            D)        Delete all relationships between STORE and EMPLOYEE. Redesign the database to work without them.

quiz # 4 CS403

Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’;

The statement has a syntax error
The statement only displays the EmpID of those employees whose name is ALI
The statement displays the entire fields from emp in which the Empname is ALI..
The statement must have an ORDERBY clause

Truncate is an alternative of Delete command.
True,,

Which of the following syntax of the functions in SQL is used to add column values?
COUNT(*)
COUNT(expression)
MAX(expression)
SUM(expression) 222..

SQL stands for ______________. I - Structured Query Language II – Standard Query Language lll- Status Query Language
Only I..
Only II
Both I and II
Only lll

REVOKE is a ______________ statement.
Data Definition
Control Access..
Data manipulation
Data description

Value of a function in SQL is always determined by the input parameters
true..
false

Is the given SQL Statement prompt error? Select * from relation1;
Logical Error
No Error
Parameter Error
Time out Error

DML stands for _____________.
Dynamic Modeling Language
Data Manipulation Language..
Data Management Language

Which of the following is not DML command?
Select
Update
Delete
Truncate..

Functions in SQL return a single value
True..
False

RSS

Latest Activity

Ateeqa liked +++A++R+++'s profile
23 minutes ago
+++A++R+++ and Ateeqa are now friends
26 minutes ago
Iram Rahim joined + M.Tariq Malik's group
1 hour ago
+ M.Tariq Malik liked Jabra's discussion Mere Sth Aysa howA hai ap k Sth??
2 hours ago
Profile IconAtten Lly, xtylish bubble, Bakhtiyar Malik and 2 more joined Virtual University of Pakistan
2 hours ago
Rimsha Ali khan replied to Zain Kazimi's discussion Self Poetry Dedicated to some one special
7 hours ago
Aisar Karim updated their profile
7 hours ago
Aisar Karim liked Aisar Karim's profile
7 hours ago
〘٢٦ دن〘چکن برگر updated their profile
7 hours ago
彡JK彡 ❤️ replied to Zain Kazimi's discussion Self Poetry Dedicated to some one special
8 hours ago
彡JK彡 ❤️ replied to Jabra's discussion Mere Sth Aysa howA hai ap k Sth??
8 hours ago
hareem mughal and Esha mirza are now friends
9 hours ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.