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

