SDP6 part B

Question 1

Question

101. The $d->query function takes an SQL command as its string argument and sends it to the database server for execution.

Answer

True
False

Question 2

Question

102. The _____ is a collection of several libraries of functions for enhancing PHP.

Answer

a) DBMS
b) PHP Extension and Application Repository (PEAR)
c) MYSQL
d) PHP SQL

Question 3

Question

103. The _____ variable is similar to cursor and iterator variables.

Answer

a) $d->query
b) post
c) $r

Question 4

Question

105. The PHP function $d->nextID creates a sequence of unique values for a particular table.

Answer

True
False

Question 5

Question

106. Creating a database design that only stores each logical data item in only one place in the database.

Answer

Normalization
Normal
Nf2
Nf3

Question 6

Question

114. The ___________ R S keeps tuple in the first {left} relation R; if no matching tuple found in S, then the attribute of S in the join are filled with NULL values

Answer

o LEFT OUTER JOIN
o RIGHT OUTER JOIN
o FULL OUTER JOIN
o LEFT INNER JOIN

Question 7

Question

115. If a relation schema has more than one key, each is called a _______ key.

Answer

o Candidate
o Primary
o Public
o Foreign

Question 8

Question

116. A ¬¬¬_________conflict arises when an attribute may have different domains in two schemas, e.g. pounds vs kilograms

Answer

o Domain
o Type
o Norming
o Constraints

Question 9

Question

117. UML _________ diagrams describe the dynamic relationships among components

Answer

o Behavioral
o Structural
o Class
o Direct

Question 10

Question

118. Objects in an object-oriented programming language exist only during program execution, therefore they are called transient objects; an object-oriented database can extend the existence of objects so that they are stored permanently, therefore they are called

Answer

o persistent object
o instance variable
o attribute
o object structure

Question 11

Question

119. __________________ is the term used to refer to the problems that occur because of difference between the database model and the programming language model.

Answer

o Independence mismatch
o Denormalisation
o Redundancy
o Duplication

Question 12

Question

120. A __________________ is typically used to loop over the tuples in a query result

Answer

o Cursor {iterator variable}
o Shared variable
o Communication variables
o fetch

Question 13

Question

122. A THETA JOIN uses any of the comparison operators =,<,>

Answer

True
False

Question 14

Question

123. For structured data, the schema information is mixed in with the data values, so it is sometimes referred to as self-describing data

Answer

True
False

Question 15

Question

124. The main advantage of using a function call interface is that it makes it easier to access multiple databases within the same application program

Answer

True
False

Question 16

Question

125. In PHP, Interpolating variables may occur within double-quoted or single-quoted strings

Answer

True
False

Question 17

Question

126. In PHP, the $d->query function takes an SQL command as its string argument and sends it to the database server for execution.

Answer

True
False

Question 18

Question

127. The ________________ property ensures that either all the database operations in a transaction are executed or none are

Answer

o Atomicity
o Transaction
o Isolation
o Concurrency

Question 19

Question

128. ____________________occurs when the same data is stored multiple times

Answer

o Redundancy
o Normalisation
o Denormalization
o Persistent

Question 20

Question

129. Creating a database design that only stores each logical data item in only one place is the database is called______________________.

Answer

o Redundancy
o Normalization
o Denormalization
o Persistent

Question 21

Question

131. An entity cannot exist in a database merely by being a member of a subclass, it must also be a member of the superclass

Answer

True
False

Question 22

Question

132. An entity that is a member of a subclass may inherit one, some, or all the attributes of the entity as a member of the superclass.

Answer

True
False

Question 23

Question

133. The ________________ property allows several users to update the same data in a controlled manner so that result of the updates is correct

Answer

o Atomicity
o Transaction
o Isolation
o Concurrency

Question 24

Question

134. A functional dependency is a property of the relation schema R not of a particular legal relation state r or R, therefore it must be defined explicitly by someone who understands the semantics of the attributes of R

Answer

True
False

Question 25

Question

When a database design is in ____________, each value in a tuple is in atomic value.

Answer

First normal form
Second normal form
Third normal form
Forth normal form

Question 26

Question

135. What does CAP stand for?///////////////////////////

Answer

a. Consistency, Atomicity, Partition Tolerance
b. Consistency, Availability, Partition Tolerance
c. Commitment, Availability, Partition Tolerance
d. Consistency, Availability, Persistence

Question 27

Question

136. What does BASE stand for?///////////////////////////

Answer

a. Basically Available, System-State, Eventually Consistent
b. Basically Available, Soft-State, Eventually Consistent
c. Broadly Available, Soft-State, Eventually Consistent
d. Basically Available, Soft-State, Evenly Consistent

Question 28

Question

137. What does ACID stand for?/////////////////////

Answer

a. Available, Consistent, Isolation, and Durability
b. Atomic, Consistent, Isolation, and Durability
c. Atomic, Consistent, Isolation, and Dependent
d. Atomic, Consistent, Index, and Durability

Question 29

Question

138. Which of the following is used to denote the selection operation in the relational algebra?///////////////////////

Answer

a. Pi (Greek)
b. Sigma (Greek)
c. Lambda (Greek)
d. Omega (Greek)

Question 30

Question

139. Normalization is a process of organizing the data in database to avoid

Answer

data redundancy
insertion anomaly
, update anomaly
deletion anomaly

Question 31

Question

140. Relational Algebra is a _____ query language that takes two relation as input and produces another relation as output of the query.///////////////////////////////////

Answer

a. Relational
b. Structural
c. Procedural
d. Fundamental

Question 32

Question

141. Which of the following is a NoSQL Database Type?///////////////////////////////

Answer

a. JSON
b. SQL
c. Document databases
d. All of the mentioned

Question 33

Question

142. Which of the following are simplest NoSQL databases?///////////////////////////////////

Answer

a. Wide-column
b. Document
c. Key-value
d. All of the mentioned

Question 34

Question

143. Which of the following is not a NoSQL database?//////////////////////////////

Answer

a. Cassandra
b. None of the mentioned
c. SQL Server
d. MondoDB

Question 35

Question

144. A ______ is an indirect functional dependency, one I which X->Z only by virtue of X->Y and Y->Z.//////////////////////

Answer

a. Multivalued Dependencies
b. Join Dependency
c. Trivial Functional Dependency
d. Transitive Dependency

Question 36

Question

145. NoSQL database is used mainly for handling large volumes of _____ data.

Answer

a. Structured
b. Semi-structured
c. Unstructured
d. All of the mentioned

Question 37

Question

146. What is the correct order of clauses for a proper SQL query?

Answer

a. SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY
b. SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING
c. SELECT, FROM, GROUP BY, WHERE, HAVING, ORDER BY
d. SELECT, FROM, WHERE, HAVING, GROUP BY, ORDER BY
e. SELECT, FROM, ORDER BY, WHERE, GROUP BY, HAVING

Question 38

Question

147. In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the _____ key.

Answer

a. Candidate
b. Join
c. Functional
d. None of the Mentioned

Question 39

Question

148. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n)

Answer

a. Transitive Dependency
b. Insertion Anomaly
c. Referential Integrity Constraint
d. Normal Form

Question 40

Question

149. Most NoSQL databases support automatic ______, meaning that you get high availability and disaster recovery

Answer

a. Scalability
b. Processing
d. Replication
c. All of the mentioned

Question 41

Question

150. A table is in 3NF if it is in 2NF and if it has no

Answer

a. Functional Dependencies
b. Transitive Dependencies
c. Trivial Functional Dependency
d. Multivalued Dependencies

Question 42

Question

151. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true.

Answer

True
False

Question 43

Question

152. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Person table?

Answer

a. MODIFY Persons SET LastName=’Hansen’ WHERE LastName=’Nilsen’
b. UPDATE Persons SET LastName=’Hansen’ WHERE LastName=’Nilsen’
c. UPDATE FROM Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
d. UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Question 44

Question

153. Which of the following is NOT a language element of SQL?

Answer

a. Data mining
b. Expression
c. Query
d. Clause
e. Statement

Question 45

Question

154. Publisher table contains id and name columns. Id is auto incremented and name is a varchar(40) type. Which of the following queries will execute NOT correctly?

Answer

a. INSERT INTO Publisher (name) values(‘OReilly’);
b. INSERT INTO Publisher (name) values(‘O-Reilly’);
c. INSERT INTO Publisher (name) values(‘O’Reilly’);
d. INSERT INTO Publisher (name) values(‘O Reilly’);

Question 46

Question

155. With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?

Answer

a. SELECT * FROM Persons GROUP BY FirstName DESC
b. SELECT * FROM Persons ORDER BY FirstName
b. SELECT * FROM Persons GROUP BY FirstName DESC
d. SELECT * FROM Persons WHERE FirstName DESC

Question 47

Question

156. With SQL, how can you delete the records where the “Address” is “Almaty” in the Student Table?

Answer

a. DELETE ROW Address=’Almaty’ FROM Student
b. DELETE FROM Student ROW Address=’Almaty’
c. DROP ROW Address=’Almaty’ FROM Student
d. DROP ROW Address=’Almaty’ FROM Address

Question 48

Question

157. With SQL, how do you return all the records from a table named “Persons” where the value of the column “FirstName” starts with an “a”?

Answer

a. SELECT * FROM Persons WHERE FirstName LIKE ‘%a%’;
b. SELECT ALL FROM Persons WHERE FirstName LIKE ‘a’;
c. SELECT * FROM Persons WHERE FirstName LIKE ‘a’;
d. SELECT * FROM Persons WHERE FirstName LIKE ‘a%’;

Question 49

Question

158. Which term is used to describe data organized in rows and columns?

Answer

a. Query
b. Index
c. Table
d. Program

Question 50

Question

159. Which of the following DROP statements is INCORRECT?

Answer

a. DROP INDEX
b. DROP ROW
c. DROP TABLE
d. DROP DATABASE

Question 51

Question

160. The information system life cycle has been called

Answer

macro life cycle
micro life cycle
logical design

Question 52

Question

161. The database system life cycle has been referred to as

Answer

macro life cycle
micro life cycle
logical design

Question 53

Question

162. Data model mapping is also called

Answer

macro life cycle
micro life cycle
logical design

Question 54

Question

163. XML attribute values must always be enclosed in quotes

Answer

True
False

Question 55

Question

164. Numeric array – An array with a numeric index. Values are stored and accessed in linear fashion

Answer

True
False

Question 56

Question

165. How will you concatenate two strings?

Answer

a. Using append() function
b. Using . operator
c. Using + operator
d. Using add() function

Question 57

Question

166. A ______ iterator lists only the attribute types that appear in a query result in SQLJ.

Answer

a. Named iterator
b. Positional iterator
c. Cursor

Question 58

Question

167. A safer way to do inserts and other queries is through the use of placeholders (specifies by ? symbol) in PHP

Answer

True
False

Question 59

Question

168. The Web Services Architecture supports interaction between a server provider, service requestor, and service registry.

Answer

True
False

Question 60

Question

169. Characteristic that allows program-data independence and program-operation independence

Answer

a. Atomicity property
b. Data abstraction
c. Attribute
d. Data dictionary (or data repository system or information repository)

Question 61

Question

170. The interpreter identifies variable names within double-quoted strings by their initial character $ and replaces them with the value in the variable. This is known as interpolating variables within strings. Interpolation does not occur in single-quoted strings

Answer

True
False

Question 62

Question

171. Identify the three factors to consider in choosing one DBMS over another I.Organization-wide adoption of a certain philosophy (data model, vendor, methodology, tools) II.Familiarity of personnel with the system III. Availability of vendor services

Answer

a. I, III
b. I, II
c. I, II, III
d. II, III

Question 63

Question

172. This auto-global built-in array variables which provides the part of the URL address that comes after a backslash (/) at the end of the URL.

Answer

a. $_SERVER[‘REMOTE_ADDRESS’]
b. $_SERVER[‘SERVER_NAME’]
c. $_SERVER[‘REMOTE_HOST’]
d. $_SERVER[‘QUERY_STRING’]
e. $_SERVER['PATH_INFO']

Question 64

Question

173. SQLJ was developed after JDBC, which is used for accessing SQL data-bases from Java using function calls

Answer

True
False

Question 65

Question

174. What does XML stand for?

Answer

a. eXtra Modern Link
b. Example Markup Language
c. eXtensible Markup Language
d. X- Markup Language

Question 66

Question

175. In which type of PHP arrays the element values can be strings or integers?

Answer

Indexed
numeric
none
associative

Question 67

Question

176. Data that is derived from the database files but not explicitly stored.

Answer

a. Transaction
b. Virtual data
c. Relational data model
d. Relationship

Question 68

Question

177. A ________ iterator is associated with a query result in SQLJ by listing the attribute names and types that appear in the query result

Answer

a. Positional
b. Named
c. Cursor

Question 69

Question

178. XQuery is the language for querying XML data

Answer

True
False

Question 70

Question

180. The case of specialization what the same (real-world) entity may be a member of more than one subclass of the specialization for example, an alumnus may also be an employee and may also be a student pursuing an advanced degree (PERSON entity type, which is specialized into the subclasses {EMPLOYEE, ALUMNUS, STUDENT})

Answer

overlapping
joint
disjoint
union

	Created by Ara BOSS over 6 years ago

Next up

SDP6 part B

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Question 26

Question 27

Question 28

Question 29

Question 30

Question 31

Question 32

Question 33

Question 34

Question 35

Question 36

Question 37

Question 38

Question 39

Question 40

Question 41

Question 42

Question 43

Question 44

Question 45

Question 46

Question 47

Question 48

Question 49

Question 50

Question 51

Question 52

Question 53

Question 54

Question 55

Question 56

Question 57

Question 58

Question 59

Question 60

Question 61

Question 62

Question 63

Question 64

Question 65

Question 66

Question 67

Question 68

Question 69

Question 70

Similar