Smart Learning

Digital Learning

Sunday, December 29, 2024

Information Technology-Class-10 Unit-3(B) DBMS-ADVANCED(2024-25):

CBSE Solutions-2024-25 ,
Information Technology-Class-10 Unit-3(B) DBMS-ADVANCED(2024-25):
Information Technology
Class-10
Unit- 3(B) Database Management System (Advanced) PART-I

A. Multiple Choice Questions:
1. What identifies the content of a field?
a. Data            b. Field value                c. Field name            d. Table name
Answer: Field Name
2. Which of the following is not a field type in MS Access?
a. Hyperlink    b. Number                    c. Currency                d. True/False
Answer: True/False
3. Field validation is set in fields:
a. Input Mask property        b. Validation rule property    c. Default value property        d. Validation act property
Answer: Validation Rule property
4. Which of the following wizard is used to create lookup fields?
a. Table wizard        b. Form wizard        c. Field wizard        d. Lookup wizard
Answer: Lookup Wizard
5. Text datatype in MS Access stores:
a. Upto 64000 characters    b. Upto 255 character    c. Upto 1024 character        d. Upto 13064 characters
Answer: Upto 64000 characters
6. Which of the following is not a Microsoft Access database object?
a. Queries        b. Tables            c. Forms                    d. SQL
Answer: SQL
7. What is the full form of SQL?
a. Sequence query language    b. Structured Query language        c. Structured Query layout    d. Sequential Query language
Answer: Structured Query Language
8. Which of the following is a basic object of a database?
a. form                b. query                c. table                    d. report
Answer: Table
9. A form can be prepared for:
a. Automating the task    b. Accepting input        c. Printing labels    d. None of these
Answer: Accepting input
10. Which of the following is not an aggregate function in SQL?
a. SUM()            b. MAX()                c. AVG()                    d. CONCAT()
Answer: CONCAT()

Read more »
By
at No comments:
Tags

Saturday, December 28, 2024

Information Technology-Class-10 Unit-3(B) DBMS-BASIC(2024-25):

CBSE Solutions-2024-25 ,
Information Technology-Class-10 Unit-3(B) DBMS-BASIC(2024-25):
Information Technology
Class-10
Unit- 3(B) Database Management System (Basic)

A. Multiple Choice Questions:
1. Full form of RDBMS is:
a. Relation Disadvantages Based Management System
b. Relational Database Management System
c. Random Data By Management System
d. Relational Data by Managing System
Answer: Relational Database Management System
2. Information is the collection of;
a. Facts            b. Records            c. Tables                d. Database
Answer: Records
3. The Database Management System is a:
a. Collection of Data    b. Software        c. Hardware        d. File
Answer: Software
4. Which of the following term is not related to DBMS?
a. Table            b. Record    c. HTML        d. Field
Answer: HTML
5. Which of the following is not included in Microsoft office suite?
a. Microsoft word    b. Microsoft access    c. Microsoft Excel        d. Dynamics ERP
Answer: Dynamics ERP
6. Duplication of data is called______________.
a. Consistency        b. Inconsistency        c. Redundancy            d. Foreign key
Answer: Redundancy
7. Which of the following will help to maintain unique record in the table?
a. Foreign key        b. Primary key            c. Composite key        d. Null key
Answer: Primary key
8. A foreign key is a reference of the _________ key in another table.
a. Alternate            b. Primary                c. Candidate                d. Composite
Answer: Primary
9. Primary key cannot accept__________ values.
a. Binary                b. Duplicate                c. Text                        d. Numeric
Answer: Duplicate
10. When primary key is made up of two or more columns, then it is called____ primary key.
a. Mixed                b. Foreign                    c. Composite             d. Combined
Answer: Composite
11. Which of the following is not a good naming field for the table "Student"?
a. Roll number    b. Name                        c. Fees                        d. Salary
Answer: Salary
12. A field which is ______________ for each and every record is called Primary key.
a. Common            b. Same                    c. Unique            d. Candidate
Answer: Unique
13. Which of the following key define a relationship between two tables?
a. Foreign key            b. Primary key        c. Composite key        d. Alternate key
Answer: Foreign key

Read more »
By
at No comments:
Tags

Thursday, December 26, 2024

Computer-Science-Class-8 Chapter-8(2024-25):

CBSE Solutions-2024-25 ,
Computer-Science-Class-8 Chapter-8(2024-25):
Computer Science
Class-8
Chapter-8 Introduction to Adobe Photoshop

A. Tick the correct option:
1. Which one of the following software is used for image editing?
a. MS Word            b. MS Excel            c. Photoshop         d. None of these
Answer: Photoshop
2. Which one of the following tools is used to make polygon and magnetic selection?
a. Marquee tool      b. Lasso tool         c. Quick selection tool    d.  None of these
Answer: Lasso tool
3. Which of the following tools is used to erase part of an image?
a. Type                     b. Eraser                 c. Crop                    d. None of these
Answer: Eraser
4. _________ tool enables you to move the image within the window.
a. Zoom                   b. Hand                    c. Move                    d. None of these
Answer: Hand

B. Name the tools:
1. ___________________

2. _________________

3._________________

4._________________

5. _________________

6. _________________
Answer: 
1. Crop tool
2. Shape tool
3. Eraser tool
4. Magic wand tool
5. Type tool
6. Lasso tool

Read more »
By
at No comments:
Tags