Page 380 - TP_IT_V1.0_C10_flipbpookl
P. 380

5.  Assertion (A): A primary key is a set of columns that uniquely identifies each row in a table.
                    Reasoning (R): A primary key can contain unique values to ensure data integrity.
                  Statement Based Questions:
                  Two statements are given. Statement 1 and Statement 2. Examine the statements and answer the question according to the
                  instruction given below.
                    a. Statement 1 is TRUE, Statement 2 is TRUE
                    b. Statement 1 is FALSE, Statement 2 is False
                    c. Statement 1 is TRUE, Statement 2 is False
                    d. Statement 1 is FALSE, Statement 2 is TRUE
                 6.  Statement 1: The TINYINT data type is always signed and can store values between -128 and 127.
                    Statement 2: The NUMERIC data type is designed to store floating-point numbers with variable precision.

                Ans.  4. d  5. d  6. b


                                                               Unsolved


                                                SECTION A (Objective Type Questions)
              A.  Choose the correct option.

                 1.  The intersection point between a row and column is called    .
                    a. Row                                             b. Column
                    c. Table                                           d. Cell
                 2.  In database,            helps us to retrieve the filtered data based upon some conditions.
                    a. Forms                                           b. Reports
                    c. Queries                                         d. Table
                 3.  A table is a set of data elements that is organised using a model of vertical    and horizontal   .
                    a. Rows, Tables                                    b. Columns, Rows
                    c. Rows, Columns                                   d. Forms, Reports

                 4.  Vinay wants to store a huge amount of information about his firm in a database. Which type of table organisation would
                    be most suitable for this purpose?
                    a. Relational                                      b. Flat File
                    c. Either Relational or Flat file                  d. Hierarchical
                 5.  The user cannot enter data in the field that is assigned as    .
                    a. AutoValue                                       b. Default Value
                    c. Format value                                    d. Entry required
                 6.  Which of the following is not an example of Numeric data type?
                    a. DateofBirth                                     b. Rollno
                    c. Price                                           d. Marks
                 7.  Identify the mode, where we can modify in the structure of table?
                    a. Datasheet view                                  b. Design view
                    c. Structure view                                  d. All of these
                 8.  Identify the property which help to set the number of characters in text/ varchar type field of a table in DBMS.
                    a. Entry Required                                  b. Size
                    c. Default Value                                   d. Length
                 9.              are formatted presentations of data generated from a database.
                    a. Query                                           b. Table
                    c. Reports                                         d. RDBMS


                378   Trackpad Information Technology (Ver. 1.0)-X
   375   376   377   378   379   380   381   382   383   384   385