Ara BOSS
Quiz by , created more than 1 year ago

Quiz on SDP6 part B, created by Ara BOSS on 15/12/2017.

66
1
0
No tags specified
Ara BOSS
Created by Ara BOSS almost 7 years ago
Close

SDP6 part B

Question 1 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 2 of 70

1

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

Select one of the following:

  • a) DBMS

  • b) PHP Extension and Application Repository (PEAR)

  • c) MYSQL

  • d) PHP SQL

Explanation

Question 3 of 70

1

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

Select one of the following:

  • a) $d->query

  • b) post

  • c) $r

Explanation

Question 4 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 5 of 70

1

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

Select one of the following:

  • Normalization

  • Normal

  • Nf2

  • Nf3

Explanation

Question 6 of 70

1

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

Select one of the following:

  • o LEFT OUTER JOIN

  • o RIGHT OUTER JOIN

  • o FULL OUTER JOIN

  • o LEFT INNER JOIN

Explanation

Question 7 of 70

1

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

Select one of the following:

  • o Candidate

  • o Primary

  • o Public

  • o Foreign

Explanation

Question 8 of 70

1

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

Select one of the following:

  • o Domain

  • o Type

  • o Norming

  • o Constraints

Explanation

Question 9 of 70

1

117. UML _________ diagrams describe the dynamic relationships among components

Select one of the following:

  • o Behavioral

  • o Structural

  • o Class

  • o Direct

Explanation

Question 10 of 70

1

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

Select one of the following:

  • o persistent object

  • o instance variable

  • o attribute

  • o object structure

Explanation

Question 11 of 70

1

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

Select one of the following:

  • o Independence mismatch

  • o Denormalisation

  • o Redundancy

  • o Duplication

Explanation

Question 12 of 70

1

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

Select one of the following:

  • o Cursor {iterator variable}

  • o Shared variable

  • o Communication variables

  • o fetch

Explanation

Question 13 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 14 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 15 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 16 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 17 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 18 of 70

1

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

Select one of the following:

  • o Atomicity

  • o Transaction

  • o Isolation

  • o Concurrency

Explanation

Question 19 of 70

1

128. ____________________occurs when the same data is stored multiple times

Select one of the following:

  • o Redundancy

  • o Normalisation

  • o Denormalization

  • o Persistent

Explanation

Question 20 of 70

1

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

Select one of the following:

  • o Redundancy

  • o Normalization

  • o Denormalization

  • o Persistent

Explanation

Question 21 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 22 of 70

1

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.

Select one of the following:

  • True
  • False

Explanation

Question 23 of 70

1

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

Select one of the following:

  • o Atomicity

  • o Transaction

  • o Isolation

  • o Concurrency

Explanation

Question 24 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 25 of 70

1

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

Select one of the following:

  • First normal form

  • Second normal form

  • Third normal form

  • Forth normal form

Explanation

Question 26 of 70

1

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

Select one of the following:

  • a. Consistency, Atomicity, Partition Tolerance

  • b. Consistency, Availability, Partition Tolerance

  • c. Commitment, Availability, Partition Tolerance

  • d. Consistency, Availability, Persistence

Explanation

Question 27 of 70

1

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

Select one of the following:

  • 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

Explanation

Question 28 of 70

1

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

Select one of the following:

  • a. Available, Consistent, Isolation, and Durability

  • b. Atomic, Consistent, Isolation, and Durability

  • c. Atomic, Consistent, Isolation, and Dependent

  • d. Atomic, Consistent, Index, and Durability

Explanation

Question 29 of 70

1

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

Select one of the following:

  • a. Pi (Greek)

  • b. Sigma (Greek)

  • c. Lambda (Greek)

  • d. Omega (Greek)

Explanation

Question 30 of 70

1

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

Select one or more of the following:

  • data redundancy

  • insertion anomaly

  • , update anomaly

  • deletion anomaly

Explanation

Question 31 of 70

1

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

Select one of the following:

  • a. Relational

  • b. Structural

  • c. Procedural

  • d. Fundamental

Explanation

Question 32 of 70

1

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

Select one of the following:

  • a. JSON

  • b. SQL

  • c. Document databases

  • d. All of the mentioned

Explanation

Question 33 of 70

1

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

Select one of the following:

  • a. Wide-column

  • b. Document

  • c. Key-value

  • d. All of the mentioned

Explanation

Question 34 of 70

1

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

Select one of the following:

  • a. Cassandra

  • b. None of the mentioned

  • c. SQL Server

  • d. MondoDB

Explanation

Question 35 of 70

1

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

Select one of the following:

  • a. Multivalued Dependencies

  • b. Join Dependency

  • c. Trivial Functional Dependency

  • d. Transitive Dependency

Explanation

Question 36 of 70

1

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

Select one of the following:

  • a. Structured

  • b. Semi-structured

  • c. Unstructured

  • d. All of the mentioned

Explanation

Question 37 of 70

1

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

Select one of the following:

  • 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

Explanation

Question 38 of 70

1

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.

Select one of the following:

  • a. Candidate

  • b. Join

  • c. Functional

  • d. None of the Mentioned

Explanation

Question 39 of 70

1

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)

Select one of the following:

  • a. Transitive Dependency

  • b. Insertion Anomaly

  • c. Referential Integrity Constraint

  • d. Normal Form

Explanation

Question 40 of 70

1

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

Select one of the following:

  • a. Scalability

  • b. Processing

  • d. Replication

  • c. All of the mentioned

Explanation

Question 41 of 70

1

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

Select one of the following:

  • a. Functional Dependencies

  • b. Transitive Dependencies

  • c. Trivial Functional Dependency

  • d. Multivalued Dependencies

Explanation

Question 42 of 70

1

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.

Select one of the following:

  • True
  • False

Explanation

Question 43 of 70

1

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

Select one of the following:

  • 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’

Explanation

Question 44 of 70

1

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

Select one of the following:

  • a. Data mining

  • b. Expression

  • c. Query

  • d. Clause

  • e. Statement

Explanation

Question 45 of 70

1

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?

Select one of the following:

  • 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’);

Explanation

Question 46 of 70

1

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

Select one of the following:

  • 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

Explanation

Question 47 of 70

1

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

Select one of the following:

  • 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

Explanation

Question 48 of 70

1

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”?

Select one of the following:

  • 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%’;

Explanation

Question 49 of 70

1

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

Select one of the following:

  • a. Query

  • b. Index

  • c. Table

  • d. Program

Explanation

Question 50 of 70

1

159. Which of the following DROP statements is INCORRECT?

Select one of the following:

  • a. DROP INDEX

  • b. DROP ROW

  • c. DROP TABLE

  • d. DROP DATABASE

Explanation

Question 51 of 70

1

160. The information system life cycle has been called

Select one of the following:

  • macro life cycle

  • micro life cycle

  • logical design

Explanation

Question 52 of 70

1

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

Select one of the following:

  • macro life cycle

  • micro life cycle

  • logical design

Explanation

Question 53 of 70

1

162. Data model mapping is also called

Select one of the following:

  • macro life cycle

  • micro life cycle

  • logical design

Explanation

Question 54 of 70

1

163. XML attribute values must always be enclosed in quotes

Select one of the following:

  • True
  • False

Explanation

Question 55 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 56 of 70

1

165. How will you concatenate two strings?

Select one of the following:

  • a. Using append() function

  • b. Using . operator

  • c. Using + operator

  • d. Using add() function

Explanation

Question 57 of 70

1

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

Select one of the following:

  • a. Named iterator

  • b. Positional iterator

  • c. Cursor

Explanation

Question 58 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 59 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 60 of 70

1

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

Select one of the following:

  • a. Atomicity property

  • b. Data abstraction

  • c. Attribute

  • d. Data dictionary (or data repository system or information repository)

Explanation

Question 61 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 62 of 70

1

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

Select one of the following:

  • a. I, III

  • b. I, II

  • c. I, II, III

  • d. II, III

Explanation

Question 63 of 70

1

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.

Select one of the following:

  • a. $_SERVER[‘REMOTE_ADDRESS’]

  • b. $_SERVER[‘SERVER_NAME’]

  • c. $_SERVER[‘REMOTE_HOST’]

  • d. $_SERVER[‘QUERY_STRING’]

  • e. $_SERVER['PATH_INFO']

Explanation

Question 64 of 70

1

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

Select one of the following:

  • True
  • False

Explanation

Question 65 of 70

1

174. What does XML stand for?

Select one of the following:

  • a. eXtra Modern Link

  • b. Example Markup Language

  • c. eXtensible Markup Language

  • d. X- Markup Language

Explanation

Question 66 of 70

1

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

Select one of the following:

  • Indexed

  • numeric

  • none

  • associative

Explanation

Question 67 of 70

1

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

Select one of the following:

  • a. Transaction

  • b. Virtual data

  • c. Relational data model

  • d. Relationship

Explanation

Question 68 of 70

1

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

Select one of the following:

  • a. Positional

  • b. Named

  • c. Cursor

Explanation

Question 69 of 70

1

178. XQuery is the language for querying XML data

Select one of the following:

  • True
  • False

Explanation

Question 70 of 70

1

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})

Select one of the following:

  • overlapping

  • joint

  • disjoint

  • union

Explanation

Previous
Check answer
Next