12th class (Fsc) computer unit 2 MCQs
26. SQL is used for:
a. Data definition and manipulation
b. Data definition
c. Searching records
d. Data manipulation
27. Views are also called:
a. Virtual tables
b. Complex tables
c. Actual tables
d. Simple tables
28. To find all names start with M from student table, the criteria is:
a. Like “M# ”
b. Like “M?”
c. Like “M * ”
d. Like “M – ”
29. A virtual table that is constructed form other tables is called:
a. View
b. Tuple
c. Report
d. Table
30. The foreign key is found in:
a. Pivot table
b. Parent table
c. Index table
d. Dependent table
31. A table must have:
a. Composite key
b. Primary key
c. Sort key
d. Secondary key
32. A key that consists more than one attributes is called:
a. Primary key
b. Foreign key
c. Control key
d. Composite key
33. The selected candidate key is called:
a. Primary key
b. Foreign key
c. Sort key
d. Composite key
34. Which of the following is also known as control key?
a. Candidate key
b. Sort key
c. Primary key
d. Composite key
35. ……… key does not hold uniqueness property.
a. Primary
b. Foreign
c. Secondary
d. Candidate
36. A table must have a:
a. Composite key
b. Primary key
c. Sort key
d. Secondary key
38. How many primary keys can a relation have?
a. No limit
b. At least once
c. Three
d. Only one
39. Which of the following is also known as control key?
a. Primary key
b. Foreign key
c. Sort key
d. Composite key
40. Which of the following can be a primary key:
a. Customer ID
b. Lase name
c. Region
d. Salary
41. A primary key that consists of two or more attributes of a relation is called:
a. Sub key
b. Sort key
c. Composite key
d. Candidate key
42. A key is:
a. The first field of table
b. A field that identifies only one record
c. The most important field in a record
d. None
43. Which of the following describe the primary key?
a. It makes sorting quicker
b. It must be unique
c. It helps in indexing of a large database
d. All of the above
44. Which of the following is not a good primary key?
a. Zip code
b. Social security number
c. Student ID number
d. Order number
45. Which of the following should be a primary key?
a. a person’s birth date
b. A person’s last name
c. a person’s social security number
d. An employee’s salary
46. Which field listed below is the most appropriate primary key?
a. A person’s birth date
b. A person’s name
c. A person’s social security number
d. A person’s street address
47. One field or combination of fields for which more than one record may have the same combination of values is called:
a. Composite key
b. Secondary key
c. Linked key
d. Index
48. An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:
a. Foreign key
b. Global key
c. None
d. Link key
49. A primary key that consists of more than one attribute is called a:
a. Multivalued key
b. Foreign key
c. Global key
d. Composite key
50. A table in which the foreign key is found is called:
a. View
b. Parent table
c. Dependent table
d. All
51. A key that is used strictly for data retrieval purposes:
a. Composite key
b. Secondary key
c. Primary key
d. Candidate key
52. Who is responsible to design, implement and maintain a database?
a. Application programmer
b. Database administrator
c. Web designer
d. End user
53. DBA stands for:
a. Database application
b. Database administrator
c. Database authority
d. Data basic administration
Click here to go directly on chapter no.3