header1.html

Monday 8 April 2013

C# Quiz-1


C# Quiz-1
1.Every class directly or indirectly extends the______class
System
Drawing
Console
Object


2.In order for a class to use an interface, it must
)inherit the properties of the interface
contain the same methods as the interface
create an interface objects
all of the above


3.What is the proper header for a class that intends to use an interface.
class MyClass IFace
class MyClass ; IFace
class MyClass : IFace
class MyCalss {IFace}


4.Is it possible to pass methods as arguments for other methods without modification.
True
false


5.String mystring; Creates a(n)
Class
Constructor
Object
a and b


6. In the body of a method, C# uses the variable named_____to refer to the current object whose method is being invoked.
call
this
do
that


7. Find any errors in the following BankAccount constructor: Public int BankAccount() { balance = 0; }
Name
Formal parameters
Return type
No errors


8.Defining two methods with the same name but with different parameters is called.
Loading
Overloading
Multiplexing
Duplexing


9.A variable declared inside a method is called a________variable
static
private
local
Serial


10.An instance method
Represents the attribute of an object
Represents the behavior of an object
Represents another class
a and b

DBMS Quiz-5(SQL)


DBMS Quiz-5
1.________ key in the where clause specifies an inclusive list to search
IN
BETWEEN
LIKE
NULL


2.________ key with WHERE clause specifies an inclusive range to search
IN
BETWEEN
LIKE
NULL


3. __________are the Wildcards Used for Single Character and Multi Character pattern matching
_ and %
% and _
* and _
_ and *


4.The (*) asterisk in select statement is to specify ___________
All Columns from a table
All Rows from a table
None of above


5.The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2), HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL Statement displays the desired results?
SELECT ENAME FROM EMP WHERE SYSDATE – HIRE_DATE > 5
SELECT ENAME FROM EMP WHERE HIRE_DATE – SYSDATE > 5
SELECT ENAME FROM EMP WHERE (SYSDATE – HIRE_DATE) /365 > 5;
SELECT ENAME FROM EMP WHERE (SYSDATE * HIRE_DATE) * 365 > 5;


6.Add a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Which of the following command do you use to add phone numbers to all the 100 records
INSERT
UPDATE
ADD
ENTER


7.Evaluate the following SQL Statement: SELECT e.employee_id, (0.15 *salary) + (0.5 * e.commission_pct) + (s.sales_amount) * (.35 * e.bonus)) CALC_VALUE FROM employees e, sales s Where e.employee_id = s.emp_id; What happens if parentheses is removed from the formula (choose the correct option)
The Value displayed in the CALC_VALUE column will be lower.
The value displayed in the CALC_VALUE column will be higher
There will be no difference in the value displayed in the CALC_VALUE column
An error will be reported


8.SELECT empname ename from employee; What is the resulting column heading
empname
ename
empname ename
None of the above


9.What is the output of the following SQL Statement SELECT empname, empsal from employee ORDER BY empsal desc; SELECT empname,empsal from employee ORDER BY 2 desc;
Both will produce identical results
Second statement will give an error
Second statement will not give any result
Both will produce results, but both will be different.


10.___________ data type supports a variable length character string
varchar2
varchar
char
None of the above

DBMS Quiz-4


DBMS Quiz-4
1.What is Constraint?
Constraint is a rule or set of rules that apply to a column or combination of columns
It does not achieve data integrity
It allows data corruption
None of the above


2.Check constraint is also known as _________
Referential integrity
Domain integrity
Entity integrity
None of the above


3.To maintain relationship between two related tables
Domain integrity
Referential integrity
Entity integrity
None of the above


4.Foreign key constraint is also known as
Domain integrity
Entity integrity
Referential integrity
None of above


5.___________ allows null values to be stored
primary key
unique key
composite key
None of above


6.By default a table allows null records
True
False


7.Which of the following statement is true about tables
A table can have only one primary key constraint but can have several UNIQUE constraints
A table can have multiple primary keys
Null value can be stored in the primary key
None


8.What is Control data concurrency?
A properly set-up database minimizes data redundancy. It will avoid data repetition in the databases
Databases allow you to set up rules that ensure that data remains consistent when add or modify data
Databases allows multiple users to access the same database simultaneously
None


9.For a DBMS to be relational Codd’s rules have to be followed
False
True


10.A set of related tables forms a database and all data is represented as tables, the data can be viewed in no other way”, is the _________ codd’s rule
Codd’s 1 rule
Codd’s 2 rule
Codd’s 3 rule
None of the above

DBMS-Normalization Quiz-3


DBMS Quiz-3(Normalization)
1.The Redundancy in a table in order to improve performance is called
Demoralization
Normalization
Boyce-Codd Normal Form
None of the above


2. When is a table is said to be 3NF (choose the appropriate option)
Normalization improves performance by reducing redundancy.
If and only if it is in 2NF and every non key attribute is Non-transitively dependent on the primary key
It involves introduction of redundancy in data
None of the above


3.The best definition of normal form is (choose the correct option)
A relational table is said to be in a normal form if it satisfied a certain set of constraints
They are special forms, or properties, or constraints that a table scheme may possess, in order to achieve certain desired goals, such as minimizing redundancy
Both a & b
None


4.A table is said to be 2NF
When it is in 1NF and every attribute in the row is functionally dependent on the whole key
A table is said to be in the 2NF when each cell of the table contains precisely One value
All of the above
None of the above


5.There are _________ number of Normal forms that has been defined
5
6
4
9


6.A design is said to be in 1NF if and only if (choose all the correct options)
There are no repeating groups
All the key attributes are defined
All attributes are dependent on the primary key
All of the Above


7.The Normalization theory is based on functional dependency when?
When every attribute of a table functionally dependent on each other
When non key attribute is functionally dependent on the primary key
None of the above


8.What is mean by Transitive dependency?
. which the value in a non-key field is determined by the value in another non-Key field
When every attribute of a table functionally dependent on each other
None of the above


9.A relation is in 1NF if it doesn't contain any ____________?
Determinants
Repeating groups
Null values in primary key fields
Functional dependencies


10.A table is in 2NF if the table is in 1NF and what other condition is met?
There are no functional dependencies.
There are no null values in primary key fields.
There are no repeating groups.
There are no attributes that are not functionally dependent on the relation's primary key.

DBMS Quiz-2


DBMS Quiz-2
1.What is Relationship?
It is an association among two or more entities.
It is an association among the one entity
It as an association among the three entities
None of the above.


2.What is Relationship type?
Relationship type defines a set of associations or a relationship Set among a given set of entity types.
Relationship set among a given set of attributes
Relationship its association among the three attributes
None of the above


3.What is an Entity set in Entity relation Diagram?
It is a collection of all attributes of particular entity type in the database
It is a collection of all entities of particular entity type in the database
It is a collection of all relationship of particular entity type in the Database
None of the above.


4.What is an Entity?
It is a Object in the real world with an independent existence.
It is a ‘thing’ in the real world with a dependent existence.
It is a ‘thing’ in the real world with a relationship existence
None of the above.


5.What is an attribute?
It is a particular property, which describes the entity.
It is a particular property, which describes the Relationship.
It is a particular property, which describes the attribute properties
None of the above


6.The primary key constraint allows null values
True
False

7.Which of the integrity constraints enforces relationship between tables ( choose the most suitable option)
Referential Constraint
Referential key
Referential integrity
None of the above


8.A Composite Key is __________
A key composed of more than one column is called composite key or Concatenated Key
A key composed only one column is called composite key or Concatenated Key
A key which initiated the concatenated key
None of the above


9. A user that manages the files of application in DBMS is called:
Administrator
Database analyst
File Manager
None of these


10. _________is the real world object, such as a person, place etc.
Entity
Attribute
Records
All of these

DBMS Quiz-1


DBMS Quiz-1
1.The _______ is a set of programs to use and / or modify this data.
DBMS
System
Program
Software


2.The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.
Clustered
Hashed
Un-clustered
Collision


3.The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain


4.The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None


5.The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.
Primary
Foreign
Candidate
Alternate


6.E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R


7.Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security


8. _____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized


9.The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.
Data Manipulation
Data Definition
Data Control
None


10.The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
OR
AND
NOT
ALL