Class 10 Info Tech RDBMS Session 2 Create and Edit Tables Using Wizard and SQL Commands MCQs

26. You can create a table in OpenOffice.org in following ways?

a. Create table in Design View

b. Use Wizard to Create Table

c. Both a and b

d. None of these

Answer: c. Both a and b

27. A table, which is created by using the predefined steps and table structure(s) in Base _________.

a. Create table in Design View

b. Use Wizard to Create Table

c. Both a and b

d. None of these

Answer: b. Use Wizard to Create Table

28. To start ‘Use Wizard to Create Table’, click on __________.

a. Tables

b. Forms

c. Queries

d. Reports

Answer: a. Tables

29. By default all the fields will have ________ data type under the Table Wizard.

a. Text[VARCHAR]

b. Text [CHAR]

c. INTEGER

d. DATE

Answer: a. Text[VARCHAR]

30. _________ which will help the user to enter the unique values and helps in creating the relationship with the other table to extract the data from multiple tables.

a. Primary Key

b. Foreign Key

c. Candidate Key

d. Alternate Key

Answer: a. Primary Key

31. When the Primary Key will be set, during the Create Table using Wizard, then window to _________ the table will open.

a. rename

b. modify

c. save as

d. open

Answer: a. rename

32. After the changing the name of table or go ahead with the same table name, you gill get the following options –

a. Insert data immediately

b. Modify the table design

c. Create a form based on this table

d. All of the above

Answer: d. All of the above

33. “Create Table in Design View…” option is available under ________.

a. Database

b, Tasks

c. Forms

d. None of these

Answer: b. Tasks

34. The name of the column is specified under __________ field.

a. Name

b. Type

c. Length

d. None of these

Answer: a. Name

35. The data type of the field is specified under __________ field dropdown list.

a. Name

b. Type

c. Length

d. None of these

Answer: b. Type [Data Type]

36. The default name is table in OpenOffice.org is _______.

a. Database1

b. Table1

c. Field1

d. Base1

Answer: b. Table1

37. Does the OpenOffice.org Base is asked to set a primary key for the table you just created.

a. Yes

b. No

Answer: a. Yes

38. Can you leave a table without primary key?

a. Yes

b. No

Answer: a. Yes

39. Which field is set as Primary key by default in OpenOffice.org Base, in case you have click on Yes in set primary key dialog box.

a. first field

b. second field

c. third field

d. any field can be set primary key, select randomly.

Answer: a. first field

40. In OpenOffice base, Data types are broadly classified into _______ categories.

a. 3

b. 4

c. 5

d. 6

Answer: c. 5

41. Which of the following is a invalid data types in OpenOffice Base?

a. Integer

b. Binary

c. Float

d. Tuple

Answer: d. Tuple

42. Which of the following is a invalid Numeric Datatypes?

a. Boolean

b. Integer

c. Smallint

d. Char

Answer: d. Char

43. Which of the following data type is not used to store number with decimal value?

a. NUMERIC

b. Real

c. Double

d. Boolean

Answer: d. Boolean

44. Which of the following is a Memo data type?

a. LONGVARCHAR

b. CHAR

c. VARCHAR

d. VARCHAR_IGNORECASE

Answer: a. LONGVARCHAR

45. _____________ in a database can be used for storing information such as mobile number, roll number, door number, year of school admission, true or false statements, statistical values, etc.

a. Binary Types

b. Alphanumeric Types

c. Numeric Types

d. Other Variable Types

Answer: c. Numeric Types

46. _____________ data types are used for storing data in binary formats.

a. Binary Types

b. Alphanumeric Types

c. Numeric Types

d. Other Variable Types

Answer: a. Binary Types

47. _____________ data types in a database can be using for storing photos, music files, etc.

a. Binary Types

b. Alphanumeric Types

c. Numeric Types

d. Other Variable Types

Answer: a. Binary Types

48. Files of any format can be stored using the _____________ data types.

a. Binary Types

b. Alphanumeric Types

c. Numeric Types

d. Other Variable Types

Answer: a. Binary Types

49. _____________ data types in a database can be used for storing information such as date of birth, date of admission, date of product sale, etc..

a. Binary

b. Alphanumeric

c. Numeric

d. Date time

Answer: d. Date time

50. _________ data types is use to stores date and time information.

a. Date

b. Time

c. Timestamp

d. None of these

Answer: c. Timestamp

51. Which data type comes under the category of Other Data Types?