Skip to main content

FAQS


welcome to TECHKEYS ....
So far we received many request for FAQs on CSHARP, ASP.NET AND SQLSERVER for fresher who are in finishing schools. We are actively working with these Technologies  to bring  KEY  Resources for  TECHIES.
If you are interested in helping others  bring TECHKEYS  to your Friends through Social Media, please Leave the Comment to us to improve our work and subscribe  for more information.

DATABASE MANAGEMENT SYSTEM FUNDAMENTALS


  1. Which statement is false regarding the Benefits of Database Approach?
  1. Redundancy can be reduced                                
  2. Data cannot be shared.
  3. Security restrictions can be applied.
  4. Integrity can be maintained.

  1. Cardinality refers to:                                                                  
A.    a row in a table
B.     number of attributes
C.    number of tuples
D.    a unique identifier for the table

  1. List the Types of Database Models                                             
                 Hierarchical, Network, Relational, object oriented
      
  1. Name few users of Database:
             End users, Application Programmers, Database Administrator, Database              
                   Designers

  1. Basic Operations of Relation Algebra are:                                    
A.    Projection
B.     Selection 
C.     Locks
D.    Serialization
E.     Union

  1.  Indicate whether this statement is true or false.
       The primary key column must contain unique values.
A.    True
B.     False in de onderstelling dat de PK uit slechts 1 kolom bestaat; vandaar het bepaald lidwoord.
  1. The rule that requires that each non-key field (attribute) should be fully functionally dependent on the primary key is :
A.    First Normal Form.
B.     Third Normal Form. 
C.    Second Normal Form

  1. The rule that specifies that there should be  no repeating fields and the fields should be Atomic is :
A.    Third Normal Form
B.     Second Normal Form
C.    First Normal Form.

  1. In relational algebra the intersection of two sets .this corresponds to :
A.    A-B  
B.     A and B  
C.     A or B.


  1. The process of combining two tables in a relational database is known as
A.    a Join.
B.     a Construct.
C.     a Combine.
D.    a Relates.

  1. Which data model provides the concepts to describe the physical storage structure of database.
A.    High Level
B.     Low level
C.     Representational

  1. The rule that prohibits transitive dependencies is :
A.    Third Normal Form
B.     Second Normal Form.
C.     First Normal Form.

  1.  The terminology used to describe the characteristics of real world object is:
A.    Entity
B.     Attribute
C.     Relationship

  1. The end users use the database at:
A.    Conceptual level
B.     Internal level
C.    External level      

  1. Logical data independence is with respect to:
A.    Internal and Conceptual level
B.     Internal and External level
C.    Conceptual and External level


RDBMS

  1. The heart of an IS is  ___________ because IS has to handle massive amounts of data
    1. Tables
    2. Database Management
    3. Computers
    4. Records
  2. A Database Management System is a collection of
    1. Tables
    2. Records
    3. Tuples
    4. Programs
  3. Constructing the Database is the process of
    1. Retrieving data
    2. Storing  the  data
    3. Deleting the data
    4. Updating the data
  4. This metadata helps management in maintaining an effective and efficient database system.
    1. Database
    2. Tables
    3. Metadata
    4. Programs
  5. They Interact with the system from the interface or terminal    
    1. Operators
    2. End Users
    3. Application Programmers
    4. DBA
  6. The main components of DBMS are
    1. Query Language, Query Processor
    2. Query Language, Database Manager
    3. Query Processor, File Manager
    4. Query Language, Query Processor, Database Manager, File Manager                   
    5. QL,QP,DB Manager, File Manger, Concurrency controller, Recovery Manager
  7. One fundamental characteristic of the database approach is that it provides some level of
    1. Programming
    2. GUI
    3. Data Abstraction
    4. None of these

  8. Conceptual data model
    1. Provides concepts that provide details of data
    2. Represents information such as record formats, Record Orderings  and access paths
    3. Provide concepts that are close to the way many users perceive data.
    4. All the above
  9. Physical Model
    1. Provide concepts that describe the details of how data is stored in the computer. 
    2. Concepts provided by low-level data models are generally meant for computer specialists, not for typical end users.
    3.  Represent information such as record formats, record orderings, and access paths
    4. All the above
    5. None of these
  10. The goal of the three schema architecture 
    1. is to separate the user applications and the physical database.
    2. To Provide and GUI interface to the Database
    3. To Connect to a Client
    4. To create an Interface
  11. They will be many distinct
    1. Internal Views
    2. Conceptual views
    3. External views
    4. Both a and b
    5. All the above
  12. The internal level
    1. it is the one concerned with the way data is physically stored
    2.  it is the one concerned with the way data is viewed by individual users
    3.  is a level of indirection between the other two levels
    4. none of these
  13. The conceptual/internal mapping:
    1. defines the correspondence between a particular external view and the conceptual view
    2. defines the correspondence between the conceptual view and the stored database
    3. it is a level of interaction between the other two levels
    4. all of these

  14. The three-schema components include all, but:
    1. internal schema.
    2. External Schema
    3. Programming schema
    4. Conceptual schema
  15. The description of data in terms of data model is
    1. Table
    2. Tuple
    3. Schema
    4. Records
  16. Which of the following database activities determines the entities, attributes, and relationships of data?
    1. Conceptual data modeling
    2. Logical database design
    3. Physical database design and definition
    4. Database implementation
  17. Which of the following database activities require a specific knowledge of a DBMS?
    1. Enterprise modeling
    2. Conceptual data modeling
    3. Logical database design
    4.  
    5. Physical database design and definition

  1. The Internal View / Schema
    1. The internal view (or stored database) is a low-level representation of the entire database.
    2.  The internal view is defined by the internal schema, which defines the various stored record types and specified what indexes exist.
    3.  is a representation of the entire content of the database, in a form that is somewhat abstract in comparison with the way in which the data is physically stored.
    4. Both a and c
    5. Both a and b
    6. None of these .
  2. There must be a definition of the mapping
    1.  External an internal schema
    2. Conceptual model
    3.  between the external schema and the underlying conceptual schema.
    4. None of these

  3.  the ability  to separate the three different views of data is
    1. Redundancy
    2.  data independence
    3. Anomalies
    4. Database management system
  4. Defining the conceptual and internal schema is done by
    1. End user
    2. Database management system
    3. Oracle
    4. Database Administrator
  5. this model represents data as record types
    1. Relational Model
    2. Hierarchical model
    3. Network model
    4. Object oriented Database Model
  6. Implementation Schema is programmed using
    1. DDL
    2. DML
    3. C
    4. TCL
  7. Which of the following database activities allow for the actual retrieval and use of a database?
a.   Enterprise modeling
b.   Logical database design
c.   Physical database design and definition
d.   Database implementation
  1. an entity type is which of the following?
                                 i.    A major category of data about people, place, and things
                                ii.    The various departments of an organization
                               iii.    The application software
                              iv.    The business processes the support the mission of an organization
  1. The first step in database development is which of the following?
a.Enterprise modeling
b.Logical database design
c.  Physical database design and
definition
           d .Database implementation
  1. Select Extracts
    1. Specified rows from  a table
    2. Specified columns from a table          
    3. Joins together the two table
    4. None of the above

  2. Operations are all
    1. Row-at –a -time
    2. Column-at-a-time
    3. Set-at-a-time
    4. None of the above
  3.  all the information of various schemas are consisted in
    1. Tables
    2. Catalog
    3. Database
    4. Records
  4. the set of possible values a given attribute can have is called
    1. Entity
    2. Domain
    3. Tuple
    4. Table
  5. Primary Key
    1.  Unique Identifier for a Table
    2. Table
    3. Represents a tuple
    4. None of these
  6. any key consisting of single attribute is
    1. Super Key
    2. Simple Key
    3. Key
    4. Determinant
  7. if all foreign  key constrains are enforced
    1. table is created
    2. relation is complete
    3. referential integrity is achieved
    4. all of these
  8.  what are entities and relationships in the enterprise is addressed in
    1. DBMS
    2. Normalization
    3. Conceptual Design
    4. Schema Refinement
    5. Logical Design
  9. ER model is based on
    1. Rules
    2. Entities
    3. Conceptual desing
    4. Physical Design
    5. All  desing phases

  10. the group of similar entities is
    1. domain
    2. entity set
    3. tuples
    4. records
  11. it is a  association between two or more entities
    1. normalization
    2. redundancy
    3. relationships
    4. attributes
  12. A regular entity
    1. Depends on weak entity
    2. Does not depend on any other entity
    3. Depends on relation
    4. Depends on attributes
  13.  A relations ship is depicted by
    1. Diamond
    2. Circle
    3. Square
    4. Dark line
  14.  attributes are
    1. Instances
    2. Inherited
    3. Entities
    4. None of these
  15. Aggregation
    1. is meant to represent a relationship between a whole object and its component parts.-not correct
    2. Used when we have to model a relationship involving (entity sets and) a relationship set .
    3. allows us to treat a relationship set as an entity set for purposes of participation in (other) relationships
    4. all of the above-answer by us
  16. Each regular entity type
    1. Maps into a  base relation
    2. Is weak
    3. Is dependent on weak entity
    4. None of the above
  17.  normalization is a process of
    1.  ER diagram
    2. Breaking composite table into smaller ones
    3. Defining the database                                                   
    4. None of the above

  18. A table is said to be in 2NF
    1.  when it is in 1NF and every non-prime attribute in the record is functionally dependent upon the whole key, and not just part of the key.
    2.  When every non-prime attribute in the record is functionally dependent upon the whole key, and not just part of the key.
    3.  No prime attribute is transitively dependant
    4. None ot the above
  19. Normalisation
    1. The Key the Whole Key and Nothing but the Key
    2. Defining Primary key
    3. Defining constraints
    4. None of the above
  20. Strategic Planning factors do not include which of the following?
    1. Organizational goals
    2. Critical success factors
    3. Information engineering
    4. Problem areas
  21. Whose role is it to determine the requirements and design for a database?
    1. Database analysts
    2. Database administrators
    3. Both A and B.
    4. Neither A or B.
  22. User views are included as part of which schema?
    1. Internal
    2. Conceptual
    3. External
    4. None of the above.
  23. A rectangle represents which of the following in an ERD?
a.     Attribute
b.     Entity
c.     Optional
d.     Relationship
  1. An oval represents which of the following in an ERD?
a.     Attribute
b.     Entity
c.     Optional
d.     Relationship
  1. An entity name should be which of the following?
    1. A singular noun
    2. Specific to the organization
    3. Concise
    4. All of the above.
  1. A binary relationship cannot be which of the following?
    1. One-to-One
    2. One-to-Many
    3. Many-to-Many
    4. Zero-to-Zero
  2. If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?
    1. Derived attribute
    2. Optional one cardinality
    3. Multi-valued attribute
    4. Weak entity
  3. A binary relationship is which of the following?
    1. A relationship between two attributes
    2. A relationship between two entities
    3. An attribute with two different relationships
    4. An entity with two different relationships
  4. Which of the following conditions should exist if you want to convert a relationship to an associative entity?
    1. Some of the relationships for the participating entities are "many".
    2. The resulting associative entity has an independent meaning
    3. The resulting associative entity has no attributes.
    4. All of the above
  5. A ternary relationship involves how many entities?
    1. 3 or less
    2. 3
    3. More than 3
    4. 3 or more
  6. A relationship is which of the following?
    1. A person, place, or thing
    2. Property or characteristic of an entity
    3. Link between entities
    4. Weak entity
  7. The relational model consists of:
    1. data in the form of tables.
    2. data redundancy.
    3. operations using non-SQL languages
    4.  unorganized data.
  8. A primary key is which of the following?
    1. Any attribute
    2. An attribute that uniquely identifies each row
    3. An attribute that uniquely identifies each column
    4. A derived attribute
  9. A foreign key is which of the following?
    1. Any attribute
    2. The same thing as a primary key
    3. An attribute that serves as the primary key of another relation
    4. An attribute that serves no purpose
  10. The entity integrity rule states that:
    1. no primary key attribute may be null.
    2. no primary key can be composite.
    3. no primary key may be unique
    4. . no primary key may be equal to a value in a foreign key.
  11. If no multivalued attributes exist in a relation, then the relation is in what normal form?
    1. First Normal form
    2. Second normal form
    3. Third normal form
    4. Fourth normal Form
  12. If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
    1. First Normal form
    2. Second normal form
    3. Third normal form
    4. Fourth normal Form
  13. A transitive dependency is which of the following?
    1. A functional dependency between two or more key attributes.
    2. A functional dependency between two or more nonkey attributes
    3. A relation that is in first normal form.
    4. A relation that is in second normal form
  14. Consider the following table
SREF(Key field)
INIT
SNAME
DOB
Kids
RES
Skills
HTOWN
DISTANCE



    1. The table is in second normal form
    2. The table is in third normal form
    3. The table is in first normal form
    4. This table is not normalized

  1. Referential integrity refers to rules that a RDBMS will enforce. What are these rules?(more than one answer)
    1. Every table must have a primary key (a field of fields) and that primary key must not contain a NULL value
    2. It is not permitted to delete a record (row) from the secondary table if there are matching records in the primary table
    3. It is not permitted to delete a record (row) in the primary table if there are matching records in the secondary table
    4. A Foreign Key must have either a matching value in the referring (primary) table OR be NULL
  2. Normalization is
    1. a process whereby the design of a table (relation) is decomposed into more tables that more precisely fit the relational model
    2. the process of ensuring that a relational database has at least two tables in it.
    3. the process of ensuring that each table has a key
    4. a process whereby a limit is put on the number of fields a record can contain
  3. A dependant field
    1. must be of the same data type of the key field
    2. must be numerical
    3. depends upon the foreign key
    4. depends upon the key field

Similar interview Questions



  1.  Why do we need mappings between schema level?
  2.  What are the disadvantages of using database systems?
  3.  When is the concept of weak entity used in data modelling?
  4.  Distinguish between logical and physical data independence.
  5. Why is data replication useful in distributed database systems?
  6. Define domain calculus and tupple calculus.
  7. How can a database be protected from unauthorized use?
  8. What is cascading roll back?
  9. What do you mean by data integrity?
  10.  How can we eliminate the duplicate records in the select statement?
  11. Why do we need mappings between schema level?
  12. What are the disadvantages of using database systems?
  13. When is the concept of weak entity used in data modelling?
  14. Distinguish between logical and physical data independence.
  15. Why is data replication useful in distributed database systems?
  16. Define domain calculus and tupple calculus.
  17. How can a database be protected from unauthorized use?
  18. What is cascading roll back?
  19. What do you mean by data integrity?
  20. How can we eliminate the duplicate records in the select statement?

1) A check constraint can be used to restrict a numeric column to have only positive values including zero.True or False

2) Primary Key column must contain unique values only.  True / False

3) Null values are allowed in Primary Key Column.True or False

4) Only unique values allowed in a Foreign Key column.   True or False

5) View can store data.    True or False

6) Foreign Key value can  be NULL.    True / False

7) Referential Integrity can be implemented using triggers.     True / False

8) A check constraint is mandatory if a column has to have date type value. True / False

9) A check constraint can be replaced by a trigger.  True / False

10) A NULL value is valid for True/False type column.     True / False






SQLSERVER

CREATE TABLE departments
    ( department_id    int primary key,
    , department_name  VARCHAR(30)
      CONSTRAINT  dept_name_nn  NOT NULL
    , manager_id       int
    , location_id      int
    ) ;

CREATE TABLE employees
    ( employee_id    int
    , first_name     VARCHAR(20) , last_name      VARCHAR(25)
             CONSTRAINT     emp_last_name_nn  NOT NULL
email VARCHAR(25)     CONSTRAINT     emp_email_nn  NOT NULL,  
 phone_int   VARCHAR(20),  job_id         VARCHAR(10)
            CONSTRAINT     emp_job_nn  NOT NULL ,
 salary    int , commission_pct int , manager_id  int , department_id  int ,
 CONSTRAINT     emp_salary_min   CHECK (salary > 0)
 CONSTRAINT     emp_email_uk  UNIQUE (email)
    ) ;

  1. Output from a table called PLAYS with two columns, PLAY_NAME and AUTHOR, is shown next. Which of

the following SQL statements produced it?
PLAY_TABLE
-------------------------------------
"Midsummer Night’s Dream", SHAKESPEARE
"Waiting For Godot", BECKETT
"The Glass Menagerie", WILLIAMS

1.   select PLAY_NAME+AUTHOR from PLAYS;
2.   select PLAY_NAME, AUTHOR from PLAYS;
3.   select PLAY_NAME+’, ’ + AUTHOR from PLAYS;
4.   select PLAY_NAME+’, ’ + AUTHOR play_table from PLAYS;

  2 Which of the following statements contains an error?

1.   select * from EMP where EMPID = 493945;
2.   select EMPID from EMP where EMPID = 493945;
3.   select EMPID from EMP;
4.   select EMPID where EMPID = 56949 and LASTNAME = ’SMITH’;

3.. Which of the following statements are NOT TRUE about ORDER BY clauses?

1.   Ascending or descending order can be defined with the asc or desc keywords.
2.   Only one column can be used to define the sort order in an order by clause.
3.   Multiple columns can be used to define sort order in an order by clause.
4.   Columns can be represented by numbers indicating their listed order in the select clause within order by.
 4.A Cartesian product is

1.   A group function
2.   Produced as a result of a join select statement with no where clause
3.   The result of fuzzy logic
4.   A special feature of Oracle server

5. In order to perform an inner join, which criteria must be true?

1.   The common columns in the join do not need to have shared values.
2.   The tables in the join need to have common columns.
3.   The common columns in the join may or may not have shared values.
4.   The common columns in the join must have shared values.
6. The number of columns in a table is known as its
1.   Degree
2.   Cardinality
3.   Domain
4.   Range

7. In a query with a GROUP BY clause, the columns in the SELECT clause

1.   must be aggregate functions only
2.   must also appear in the GROUP BY clause
3.   must also appear in the GROUP BY and HAVING clauses
4.   Both (1) and (2)
5.   Can be selected arbitrarily

8. The wild card character % used in strings means

1.   any number of characters
2.   one or more characters
3.   at least one character
4.   at least one alphabet

9. How many columns are presented after executing this query:
SELECT address1+','+address2+','+address2 "Adress" FROM employee;

A) 1
B) 2
C) 3
D) 0
E) 4

10. Which character is used to continue a statement in SQL?

A) *
B) /
C) -
D) go
E) =

11. To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

A) 8
B) 2
C) 3
D) 4
E) 5
F) There is no such criteria

12. What is a 'tuple'?

1.   An attribute attached to a record.
2.   Another name for the key linking different tables in the database
3.   A row or record in a database
4.   Another name for a table in an RDBMS

13. A row in a database can also be called a domain.
1.   True
2.   False

14. A first step in database creation should be needs analysis.
1.   True
2.   False

16. In entity attribute modelling a many to many relationship is represented by M:M.
1.   True
2.   False

17. You have been asked to construct a query in the company's RDBMS. You have deployed a Right Outer Join operation.  Referring to the scenario above, what will happen to the final results when there is NO match between the tables?

1 . The right table will return ALL rows.
2. The right table will return NULL.
3. Both tables will return NULL.
4. The left table will return ALL rows.
5. The left table will return NULL.

18. You are running a query against a relational database.  Referring to the scenario above, what clause or command do you use in the query to help avoid a costly tablescan?

1. GROUP BY clause
2. INDEX command
3. HAVING clause
4. FROM clause
5. WHERE clause

19. Which of the following are legal queries? (choose one or more)

1.   SELECT deptno, count(deptno)  FROM emp  GROUP BY ename;
2.   SELECT deptno, count(deptno), job  FROM emp  GROUP BY deptno;
3.   SELECT deptno, avg(sal)  FROM emp;
4.   SELECT deptno, avg(sal)  FROM emp  GROUP BY deptno;
5.   SELECT avg(sal)  FROM emp  GROUP BY deptno;

20. How would you display a listing of the sums of employee salaries for those employees not making a commission, for each job type, including only those sums greater than 2500? (choose one)

a.  select job, sum(sal) from emp where sum(sal) > 2500 and comm is null;
B. select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;
C. select job, sum(sal) from emp where sum(sal) > 2500 and comm is null group by job;
D. select job, sum(sal) from emp group by job having sum(sal) > 2500 and comm is not null;
E. none of the above

21. The following SQL statement is illegal because: (choose one)

SELECT deptno, AVG(sal) FROM emp WHERE AVG(sal)> 2000 GROUP BY deptno;

1.   it requires data from more than one table, yet only one table is listed.
2.   sal is not a legal column name
3.   instead of a WHERE clause, a HAVING clause must be used to restrict groups
4.   the GROUP BY clause must contain AVG(sal)
5.   this SELECT statement is perfectly legal

22. All of the following can ONLY be used with numeric datatypes except: (choose one)
AVG
COUNT
SUM
STDDEV
VARIANCE

23. What operator would you choose to prevent this Oracle error message? (choose one)
ORA-01427:single -row subquery returns more than one row

1.   Use the IN operator
2.   Use the >= operator
3.   Use the CAN EXIST operator 
4.   Use the = operator
5.   Use the <= operator

24 A user is setting up a join operation between tables EMP and DEPT. There are some newly added departments in the DEPT table that the user wants returned by the query, but the departments do not have employees assigned to them yet. Which select statement is most appropriate for this user? (choose one)?
1.   Select e.empid, d.head  from emp e, dept d;
2.   Select e.empid, d.head  from emp e, dept d  where e.deptno = d.deptno;
3.   Select e.empid, d.head  from emp e left outer join dept d  on e.deptno = d.deptno;
4.   Select e.empid, d.head  from emp e right outer join dept d  on e.deptno = d.deptno;
5.   Select e.empid, d.head  from emp e, dept d where e.deptno outer join d.deptno
25. With SQL, how can you return the number of records in the "Persons" table
1.   SELECT COLUMNS(*) FROM Persons
2.   SELECT COUNT() FROM Persons
3.   SELECT COUNT(*) FROM Persons

4.   SELECT COLUMNS() FROM Persons


PREVIOUS FAQS
                                                                                   next

Comments

Popular posts from this blog

FAQS PART 3

data integrity depends on data sharing accuracy  redundency 2&4                              ANS: accuracy which is lightweight protocal?         ANS:soap class is which based memory      ANS: Heap  csharp code is                          ANS: managed sn.exe generates what?             ANS: Strong Name file and fileinfo classes doesn't offer the set of functionality moving creating copying  deleting                                   ANS: Creating datareader field count return type        ANS: integer type dataset and untype dataset difference? type dataset have schema information of database(primary key and FK info) untype does not have schema information GOALS OF INTEROPERABILITY ANSWER net does not affect existing COM objects .Net and COM components interoperate with each other COM components can be upgraded into .NET components if u build the application what file with extension generated                   ANS: .exe null is a string ?    

FAQS on DOTNET

Hello to every one who are fallowing my blog, today i attend one call from one Technical Recruiter (name is not required i think ) he asked some couple of question...ok i answered ....mean while  he asked one question (in my life never i feel it is relevant  for developer) who will use oops development environment? ha.. ha.. expect answer and update  to me   So far we received many request for FAQs on CSHARP, ASP.NET AND SQLSERVER for fresher who are in finishing schools. We are actively working with these Technologies  to bring   KEY   Resources for   TECHIES.                                   you are interested in helping others  bring  TECHKEYS   to your Friends through Social Media, please Leave the Comment to us to improve our work and subscribe  for more information .   Q 1) levels of nesting in a subquery?      a)2        b)6         c)32        d)64 Q 2) static method correct syntax:      a.private static main()                            b.public stat