Search This Blog

Tuesday, May 22, 2018

Computer gk 22 may

1. A data dictionary is a special file that contains?

(1) the data types of all fields in all files 

(2) the names of all fields in all files 

(3) the widths of all fields in all files 

(4) All of above 

(5) None of above 

Q.2. A command that lets you change one or more fields of a record is?

(1) Insert 

(2) Modify 

(3) Look-up 

(4) All of above 

(5) None of above 

Q.3. In a large DBMS?

(1) Each user can see only a small part of the entire database 

(2) Each user can access every sub schema 

(3) Each sub schema contains every field in the logical schema 

(4) All of above 

(5) None of above 

Q.4. It is better to use files than a DBMS when there are _______ .

(1) Stringent real-time requirements 

(2) Multiple users who wish to access the data 

(3) Complex relationships among data 

(4) All of the above 

(5) None of these 

Q.5. The conceptual model is _______ .

(1) dependent on hardware 

(2) dependent on software 

(3) dependent on both hardware and software 

(4) independent of both hardware and software 

(5) None of these 

Q.6. What is a relationship called when it is maintained between two entities? 

(1) Unary 

(2) Binary 

(3) Ternary 

(4) Quaternary 

(5) 1 and 2 

Q.7. Which of the following operation is used if we are interested in only certain columns of a table?

(1) PROJECTION 

(2) SELECTION 

(3) UNION 

(4) JOIN 

(5) Intersect 

Q.8. Which of the following is a valid SQL type?

(1) CHARACTER 

(2) NUMERIC 

(3) FLOAT 

(4) DATE 

(5) All of the above 

Q.9. The RDBMS terminology for a row is _______?

(1) Tuple 

(2) Relation 

(3) Attribute 

(4) Degree 

(5) Field 

Q.10. Which of the following operations need the participating relations to be union compatible?

(1) UNION 

(2) INTERSECTION0 

(3) DIFFERENCE 

(4) All of the above 

(5) None of these 

ANSWERS

Q.1. (4) the data types of all fields in all files, the names of all fields in all files and the widths of all fields in all files

Q.2. (2) Modify

Q.3. (1) Each user can see only a small part of the entire database.

Q.4. (2) Multiple users who wish to access the data

Q.5. (4) Independent of both hardware and sofware.

Q.6. (2) Binary

Q.7. (1) Projection operation is used if we are interested in only certain columns of a table.

Q.8. (5) All are valid SQL data type.

Q.9. (1) The RDBMS terminology for a row is Tuple.

Q.10. (4) Union, Intersection and d

Monday, May 21, 2018

Computer gk 21 may

Q.1. Snapshot of the data in the database at a given instant of time is called _____.

(1) Database Schema 

(2) Database Instance 

(3) Database Snapshot 

(4) All of the above 

(5) None of these 

Q.2. Which of the following is not Unary operation?

(1) Select 

(2) Project 

(3) Rename 

(4) Union 

(5) None of these 

Q.3. Which of the following is not binary operation?

(1) Union 

(2) Project 

(3) Set Difference 

(4) Cartesian Product 

(5) None of these 

Q.4. The raw facts and figures are:

(1) Program 

(2) Information 

(3) Snapshot 

(4) Reports 

(5) None of these 

Q.5. A command to remove a relation from an SQL database is ____.

(1) Delete table  

(2) Drop table  

(3) Erase table  

(4) Alter table  

(5) None of these 

Q.6. Entities having primary key are called?

(1) Primary Entities 

(2) Strong Entities 

(3) Weak Entities 

(4) Primary Key 

(5) None of these 

Q.7. In the E-R diagrams, the term cardinality is a synonym for the term?

(1) Attribute 

(2) Degree 

(3) Entities 

(4) Cartesian 

(5) None of these 

Q.8. TRUNCATE statement in SQL is a ____.

(1) DML statement 

(2) DDL statement 

(3) DCL statement 

(4) TCL statement 

(5) None of above 

Q.9. The default date format in SQL is?

(1) DD-MON-YY 

(2) DD-MM-YY 

(3) DD-MM-YYY 

(4) DD-MM-YYYY 

(5) None of these 

Q.10. For adding number of hours to a date, which of the following statement is used ? 

(1) Date + Number 

(2) Date + Number/24 

(3) Date+Number of Hours 

(4) Date +Hour/30 

(5) None of above 

ANSWERS

Q.1. (2) Snapshot of the data in the database at a given instant of time is called Database Instance.

Q.2. (4) Union is not Unary operation.

Q.3. (5) Project is not binary operation.

Q.4. (5) None of these

Q.5. (2) Drop table

Q.6. (2) Strong Entities

Q.7. (4) Cartesian

Q.8. (2) TRUNCATE statement in SQL removes all records from table, including all spaces allocated for the records are removed.

Q.9. (4) The default date format in SQL is DD-MM-YYYY.

Q.10. (2) Date + Number/24