vu quiz solution solved moaz and waqar

question	answer

question	answer
what is computer	A computer is a machine or device that performs processes, calculations and operations based on instructions provided by a software or hardware program.
what is internet?	The Internet, sometimes called simply "the Net," is a worldwide system of computer networks - a network of networks in which users at any one computer can, if they have permission, get information from any other computer (and sometimes talk directly to users at other computers).
what is pakistan	Pakistan is a country in southern Asia. It is next to India, Iran, Afghanistan, and China. It is officially called the Islamic Republic of Pakistan. It has a long coastline along the Arabian Sea in the south.
Consider the following statement written in JavaScript:  str = ”Hello” + ” World”  What will be the value of str ?	HelloWorld
'	Plz enter the word
Which of the following statements is true about the views?	Rows can not be updated or deleted in the view
Which of the following statements is true about the views	Rows can not be updated or deleted in the view
What is the alternate name of Data Dictionary?	Metadata
IN function helps reduce the need to use multiple AND conditions.	FALSE
Browser based forms are developed in the following tools EXCEPT	Web-based Forms
Which of the following are the general activities, which are performed during the development of application programs?	All of given
Which of the following is not true about De-normalization?	De-normalization is a technique to move from lower to higher normal forms of  database modeling
Which of the following gives all the fields from employee table named as EMP?	SELECT * from EMP;
Which of the following types of partitioning reduces the chances of unbalanced partitions?	List
While recovering data, which of the following files does a recovery manager examines at first?	Log file
Which of the following is NOT a feature of Indexed sequential files?	Track overflows and file overflow areas can not be ensured.
Which of the following statements is correct with respect to the two relations given above?	The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these two relations.
ALTER TABLE exams RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID. Syntax of ALTER TABLE is NOT correct.	FALSE
Which of the following SQL commands deletes a record of an employee with the employee_id 12345, from a table named PERSON.	DELETE FROM person WHERE employee_id = ‘12345’
Which of the following is not a form of optical disk?	EEPROM
Which of the following is the correct description of cache hit?	When data is found in the cache
In which of the following situations, Clustering is suitable:	Relatively static
Which of the following is NOT a component of a DFD?	External entities
_______ records data by burning microscopic holes in the surface of the disk with a laser.	Optical disk
Which of the following concepts is applicable with respect to 3NF?	Transitive dependency
Which of the following is NOT a feature of a good interface?	Data structure based
Which feature of database provides conversion from inconsistent state of DB to  a consistent state ensuring minimum data loss?	Recovery service
Which of the following statements is true about the views?	Rows can not be updated or deleted in the view
Which of the following is true about TRUNCATE?	is DML Command.
Which of the following is the correct way to find out the size of cartesian product  incase of CROSS JOIN?	the number of rows in the first table multiplied by the number of rows in the second table.
Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN  between these two tables?	24
Which of the following is not one of the properties of Transaction?	redundancy
Which of the following is INCORRECT about VIEWS?	It is not possible to left out the data which is not required for a specific view.
Each course section is assigned a particular faculty member, and each course  section corresponds to a particular course. Conceptually, what is the relationship  between faculty and course (not course section).	M.M
Which of the following is used to add or drop columns in an existing table?	ALTER
Which of the following is a correct way of selecting all the columns from a table  called PERSONS?	SELECT * FROM Persons
Which of the following is NOT a feature of Indexed sequential files?	Track overflows and file overflow areas can not be ensured.
Which of the following serves as a milestone or reference point in the log file?	Check points
Which of the following is not true regarding DB transactions?	A database transaction is a logical unit of database operations
Which of the following are the general activities, which are performed during the  development of application programs?	All of given
Browser based forms are developed in the following tools EXCEPT	Web-based Forms
Which of the following is not a form of optical disk?	EEPROM
Which of the following is the correct description of cache hit?	When data is found in the cache
Only one type of constraint can be enforced in any table by CREATE command	FALSE
Which of the following is disadvantage of chaining technique to handle the  collisions?	Overhead of multiple linked lists
An entity type is	a specific type such as an integer, text, date, logical etc
Which of the following statements is true about the views?	Rows can not be updated or deleted in the view
What is the alternate name of Data Dictionary?	Metadata
IN function helps reduce the need to use multiple AND conditions.	FALSE
Browser based forms are developed in the following tools EXCEPT	Web-based Forms
Which of the following are the general activities, which are performed during the  development of application programs?	All of given
Which of the following is not true about De-normalization?	De-normalization is a technique to move from lower to higher normal forms of database modeling
Which of the following gives all the fields from employee table named as EMP?	SELECT * from EMP;
Which of the following types of partitioning reduces the chances of unbalanced  partitions?	List
While recovering data, which of the following files does a recovery manager examines  at first?	Log file
Which of the following is NOT a feature of Indexed sequential files?	Track overflows and file overflow areas can not be ensured.
Which of the following statements is correct with respect to the two relations	The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these two relations.
ALTER TABLE exams  RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID.  Syntax of ALTER TABLE is NOT correct.	FALSE
Which of the following SQL commands deletes a record of an employee with the  employee_id  12345, from a table named PERSON.	DELETE FROM person WHERE employee_id = ‘12345’
Which of the following is not a form of optical disk?	EEPROM
Which of the following is the correct description of cache hit?	When data is found in the cache
In which of the following situations, Clustering is suitable:	Relatively static
Laser records data by burning microscopic holes in the surface of the disk with a	Optical disk
Which of the following concepts is applicable with respect to 3NF?	Transitive dependency
Which of the following is NOT a feature of a good interface?	Data structure based
Making a change to the conceptual schema of a database but not affecting the existing external  schemas is an example of	Logical data independence.
Which of the following is NOT a feature of Context DFD?	sub-processes (which explain and decomposed the major process into small processes)
A relation (from the relational database model) consists of a set of tuples, which implies that	all tuples in a relation must be distinct.
Choose the symbol that corresponds to a discriminator attributes.	A_t_t_r_i_b_u_t_e
Identify the constraint that limits the values that can be placed in a column.	NOT NULL
Which relational algebra operation could have been applied on the pair of relations Student and  Instructor to obtain the above data?	Instructor – Student
Identify the correct statement with respect to normalization.	Normalization can be used as a top-down standalone database design technique.
Consider the relation Interview(CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo)  and the following functional dependencies	The relation Interview is in 3NF
Identify the INCORRECT statement among the given.	One cannot consider something which has conceptual existence like a course in a degree program as an entity.
Structural constraints of a relationship type refer to	whether the existence of an entity depends on it being related to another entity via the relationship type.
A collection of concepts that can be used to describe the structure of a database	Data model
An entity can be logically connected to another by defining a ____.	common attribute
The ____ constraint specifies whether each entity supertype occurrence must also be a  member of at least one subtype.	completeness
Database management systems, operating systems, applications and utilities are all  examples of ____.	software
Which of the following concepts is applicable with respect to 2NF?	Full functional dependency
What do you know about Insertion anomaly?	Insertion anomaly indicates that we cannot insert a fact about one entity until we have an additional fact about another entity.
Define domain of an attribute.	In computing, the attribute domain is the set of values allowed in an attribute. For the relational model it is a requirement that each part of a tuple be atomic. The consequence is that each value
Controlling redundancy in a database management system DOES NOT help to  Select correct option:	avoid unnecessary wastage of storage space
User rights information is stored in	Logical database
Which levels are mostly used for Detailed DFD?	Level-0, Level-1
Within a table, each primary key value ____.	must be unique
A primary key is an attribute (or set of attributes) that has been chosen for an entity,  whose values are used to uniquely identify a particular instance of an entity. True or  false?	TRUE
Who is responsible for authorizing access to the database, for coordinating and  monitoring its use?	Database Administrator
Incase of Context-level Diagram, the system is represented by  Select correct option:	Any number of processes
In a three-level DBMS architecture, the ______ level interacts directly with the users.	external
Which feature of database provides conversion from inconsistent state of DB to a  consistent state ensuring minimum data loss?	Recovery service
Which of the following describes a database system?	A collection of stored data organised in such a way that all user requirements are satisfied by the database. In general there is only one copy of each item of data although there may be controlled repetition of some data.
Which of the following is INCORRECT statement concerning the database design  process?	By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.
User rights information is stored in	Logical database
The Entity Relation Model models	Entities, Relationships and Processes
Which of the following is NOT a component of a DFD?	External entities
Making a change to the conceptual schema of a database but not affecting the existing  external schemas is an example of	Logical data independence
Incase of Context-level Diagram, the system is represented by	Any number of processes
An instance is	a particular occurance of an entity
A________is used to maintain a connection between the users of the database system.	client-server
Which of the following statements is true about the views?	Rows can not be updated or deleted in the view
What is the alternate name of Data Dictionary?	Metadata
IN function helps reduce the need to use multiple AND conditions.	FALSE
Browser based forms are developed in the following tools EXCEPT	Web-based Forms
Which of the following are the general activities, which are performed during the  development of  application programs?	All
Which of the following is not true about De-normalization?	De-normalization is a technique to move from lower to higher normal forms of database modeling
Which of the following types of partitioning reduces the chances of unbalanced  partitions?	List
While recovering data, which of the following files does a recovery manager examines at  first?	Log file
Which of the following is NOT a feature of Indexed sequential files?	Track overflows and file overflow areas can not be ensured.
Which of the following statements is correct with respect to the two relations given  above?	The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these two relations.
ALTER TABLE exams  RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID.  Syntax of ALTER TABLE is NOT correct.	FALSE
ALTER TABLE exams  RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID.  Syntax of ALTER TABLE is NOT correct.	FALSE
What does the abbreviation DBMS stand for?	Database Management System
The advantages of Standard Query Language (SQL) include which of the following in relation to GIS databases?	It is good at handling geographical concepts.
Which of the following are characteristics of an RDBMS?	Tables are linked by common data known as keys.
Which of the following are issues to be considered by users of large corporate GIS databases?	The need for multiple views or different windows into the same databases.
Which of the following are features of the object-oriented approach to databases?	The ability to develop more realistic models of the real world
Which of the following are features of the object-oriented approach to databases?	The ability to develop more realistic models of the real world
Redundancy is minimised with a computer based database approach.	TRUE
The relational database model is based on concepts proposed in the 1960s and 1970s.	TRUE
A row in a database can also be called a domain.	FALSE
A first step in database creation should be needs analysis.	TRUE
In a networked web based GIS all communications must go through an internet map server.	FALSE
In an OO database objects may inherit some or all of the characteristics of other objects.	TRUE
Which of the following statements are Data Definition Language command?	TRUNCATE
How many clustered index(es) do each database table have?	1
Suppose there are 4 rows and 3 columns in TABLE1 and 6 rows and 5 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?	24
Which of the following types of partitioning reduces the chances of unbalanced partitions?	Hash  ( not confirm)
quizzes	Plz Enter Your Question ( Your Answer Will be Appear On Screen)
Which of the following statements is true about the views?	Rows can not be updated or deleted in the view
What are the three generic phases of software engineering?	definition, development, support
In the context of requirements analysis, partitioning results in the  elaboration of data, function, or behavior.	TRUE
Quantitative methods for assessing the quality of proposed  architectural designs are readily available.	FALSE
In refining the DFD during transaction mapping it is unnecessary to  create a PSPEC since only the CSPEC is relevant to this type of  architectural style.	FALSE
In transaction mapping the first level factoring results in  the______________	derivation of the control hierarchy
Variable names must be in mixed case starting with upper case.	FALSE
Class variables should be declared public. This concept violates  which of the following.	Information hiding and Encapsulation
Real-time applications add a new and potentially difficult element to  the testing mix	time
Configuration reviews are not needed if regression testing has been  rigorously applied during software integration.	FALSE
is Authorized, assess Performance, get item for UPC, get cashier for  number, are the examples of	Services
the development view describes the -----------organization of the  software in its development environment	Static
#NAME?	Smalltalk
Hungarian Notation was first discussed by Charles Simonyi of-------- ----------	Microsoft.
The language does not specify whether ------------- is signed or  unsigned.	char
A number of invisible execution paths can exist in simple code in a  language that allows --------------	exceptions
Bugs Fixing is done by which of the teams in Software Development  lifecycle?	Development Team
Software Bugs have multiple names, Which one of the below is not  the name of Software Bugs -------------	Mistakes
Symptoms of logical errors are ------------------------------	all of the given
First hand accounts of the problem are always useful in Debugging  process.	TRUE