Search This Blog

Sunday, May 20, 2018

Computer gk 20 may

Q.1. Which of the following is a type of DBMS Software?

(1) Data 

(2) My SQL 

(3) MS-office 

(4) utility 

(5) None of these 

Q.2. Which of the following is NOT a type of Microsoft Access database object?

(1) Queries 

(2) Workbooks 

(3) Forms 

(4) Tables 

(5) None of these 

Q.3. The complete picture of data stored in database is known as

(1) System flowchart 

(2) Schema 

(3) record 

(4) DBMS 

(5) None of these 

Q.4. A subset of characters within a data field is known as

(1) Record 

(2) File 

(3) Data string 

(4) Byte 

(5) None of these 

Q.15. Data items grouped together for storage purposes are called-

(1) Record 

(2) Title 

(3) List 

(4) string 

(5) None of these

Q.6. Which of the following terms does not describe a database structure used by a DBMS to link data from several files?

(1) Relational 

(2) Structural 

(3) Network 

(4) All of the above 

(5) None of these 

Q.7. The feature that database allows to access only certain records in database is:

(1) Forms 

(2) Reports 

(3) Queries 

(4) Tables 

(5) None of these 

Q.8. Set of permitted values of each attribute is called ______.

(1) Domain 

(2) Relation 

(3) Tuple 

(4) Schema 

(5) None of these 

Q.9. The primary key must be ____.

(1) Unique 

(2) Not null 

(3) Both 1 and 2 

(4) Either 1 or 2 

(5) None of these 

Q.10. Logical design of the database is called ______.

(1) Database Snapshot 

(2) Database Instance 

(3) Database Schema 

(4) All of the above 

(5) None of these 

ANSWERS

Q.1. (2) My SQL

Q.2. (2) Workbooks

Q.3. (2) Schema

Q.4. (3) Data string

Q.5. (1) Record

Q.6. (2) Structural

Q.7. (3) Queries

Q.8. (1) Domain

Q.9. (3) Primary key must satisfy unique and not null condition for sure.

Q.10. (3) Logical design of database is called Database Schema.

Saturday, May 19, 2018

Computer gk 19 may

.1. Database utility exist in —————— menu?

(1) Format 

(2) tools 

(3) File 

(4) Edit 

(5) None of these 

Q.2. In which object sql is used?

(1) Query 

(2) Form 

(3) Report 

(4) Macro 

(5) None of these 

Q.3. What is the function of relationship?

(1) Relate multiple table 

(2) Relate multiple form 

(3) Relate table and form 

(4) Relate queries and forms 

(5) None of these 

Q.4. What is there in record?

(1) Collection of field 

(2) collection of Number 

(3) Collection of rows 

(4) All of above 

(5) None of these 

Q.5. Which operation is not permitted by query?

(1) delete 

(2) entry 

(3) Modify 

(4) create table 

(5) None of these 

Q.6. Which is not related to database?

(1) Table 

(2) Query 

(3) Form 

(4) Macro 

(5) None of these 

Q.7. The language used by application programs to request data from the DBMS is referred to the-

(1) DML 

(2) DDL 

(3) query language 

(4) All of the above 

(5) None of these 

Q.8. COMMIT and ROLLBACK in DBMS are the example of -

(1) DDL 

(2) DML 

(3) TQL 

(4) DQL 

(5) None of these 

Q.9. In Data base , properties of any entity are represented by its -

(1) Setting 

(2) Tuples 

(3) Attributes 

(4) Degree 

(5) None of these 

Q.10. Type of a file is identified by -

(1) File 

(2) Attribute 

(3) Extension 

(4) Properties 

(5) None of these 

ANSWERS

Q.1. (2) Tools

Q.2. (1) Query

Q.3. (1) Relate Multiple Table

Q.4. (1) Collection of field

Q.5. (2) Entry

Q.6. (3) Form

Q.7. (1) DML

Q.8. (3) TQL (Transaction Query Language)

Q.9. (3) Attributes