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