101. The $d->query function takes an SQL command as its string argument and sends it to the database server for execution.
102. The _____ is a collection of several libraries of functions for enhancing PHP.
a) DBMS
b) PHP Extension and Application Repository (PEAR)
c) MYSQL
d) PHP SQL
103. The _____ variable is similar to cursor and iterator variables.
a) $d->query
b) post
c) $r
105. The PHP function $d->nextID creates a sequence of unique values for a particular table.
106. Creating a database design that only stores each logical data item in only one place in the database.
Normalization
Normal
Nf2
Nf3
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
o LEFT OUTER JOIN
o RIGHT OUTER JOIN
o FULL OUTER JOIN
o LEFT INNER JOIN
115. If a relation schema has more than one key, each is called a _______ key.
o Candidate
o Primary
o Public
o Foreign
116. A ¬¬¬_________conflict arises when an attribute may have different domains in two schemas, e.g. pounds vs kilograms
o Domain
o Type
o Norming
o Constraints
117. UML _________ diagrams describe the dynamic relationships among components
o Behavioral
o Structural
o Class
o Direct
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
o persistent object
o instance variable
o attribute
o object structure
119. __________________ is the term used to refer to the problems that occur because of difference between the database model and the programming language model.
o Independence mismatch
o Denormalisation
o Redundancy
o Duplication
120. A __________________ is typically used to loop over the tuples in a query result
o Cursor {iterator variable}
o Shared variable
o Communication variables
o fetch
122. A THETA JOIN uses any of the comparison operators =,<,>
123. For structured data, the schema information is mixed in with the data values, so it is sometimes referred to as self-describing data
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
125. In PHP, Interpolating variables may occur within double-quoted or single-quoted strings
126. In PHP, the $d->query function takes an SQL command as its string argument and sends it to the database server for execution.
127. The ________________ property ensures that either all the database operations in a transaction are executed or none are
o Atomicity
o Transaction
o Isolation
o Concurrency
128. ____________________occurs when the same data is stored multiple times
o Normalisation
o Denormalization
o Persistent
129. Creating a database design that only stores each logical data item in only one place is the database is called______________________.
o Normalization
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
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.
133. The ________________ property allows several users to update the same data in a controlled manner so that result of the updates is correct
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
When a database design is in ____________, each value in a tuple is in atomic value.
First normal form
Second normal form
Third normal form
Forth normal form
135. What does CAP stand for?///////////////////////////
a. Consistency, Atomicity, Partition Tolerance
b. Consistency, Availability, Partition Tolerance
c. Commitment, Availability, Partition Tolerance
d. Consistency, Availability, Persistence
136. What does BASE stand for?///////////////////////////
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
137. What does ACID stand for?/////////////////////
a. Available, Consistent, Isolation, and Durability
b. Atomic, Consistent, Isolation, and Durability
c. Atomic, Consistent, Isolation, and Dependent
d. Atomic, Consistent, Index, and Durability
138. Which of the following is used to denote the selection operation in the relational algebra?///////////////////////
a. Pi (Greek)
b. Sigma (Greek)
c. Lambda (Greek)
d. Omega (Greek)
139. Normalization is a process of organizing the data in database to avoid
data redundancy
insertion anomaly
, update anomaly
deletion anomaly
140. Relational Algebra is a _____ query language that takes two relation as input and produces another relation as output of the query.///////////////////////////////////
a. Relational
b. Structural
c. Procedural
d. Fundamental
141. Which of the following is a NoSQL Database Type?///////////////////////////////
a. JSON
b. SQL
c. Document databases
d. All of the mentioned
142. Which of the following are simplest NoSQL databases?///////////////////////////////////
a. Wide-column
b. Document
c. Key-value
143. Which of the following is not a NoSQL database?//////////////////////////////
a. Cassandra
b. None of the mentioned
c. SQL Server
d. MondoDB
144. A ______ is an indirect functional dependency, one I which X->Z only by virtue of X->Y and Y->Z.//////////////////////
a. Multivalued Dependencies
b. Join Dependency
c. Trivial Functional Dependency
d. Transitive Dependency
145. NoSQL database is used mainly for handling large volumes of _____ data.
a. Structured
b. Semi-structured
c. Unstructured
146. What is the correct order of clauses for a proper SQL query?
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
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.
a. Candidate
b. Join
c. Functional
d. None of the Mentioned
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)
a. Transitive Dependency
b. Insertion Anomaly
c. Referential Integrity Constraint
d. Normal Form
149. Most NoSQL databases support automatic ______, meaning that you get high availability and disaster recovery
a. Scalability
b. Processing
d. Replication
c. All of the mentioned
150. A table is in 3NF if it is in 2NF and if it has no
a. Functional Dependencies
b. Transitive Dependencies
d. Multivalued Dependencies
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.
152. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Person table?
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’
153. Which of the following is NOT a language element of SQL?
a. Data mining
b. Expression
c. Query
d. Clause
e. Statement
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?
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’);
155. With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?
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
156. With SQL, how can you delete the records where the “Address” is “Almaty” in the Student Table?
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
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”?
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%’;
158. Which term is used to describe data organized in rows and columns?
a. Query
b. Index
c. Table
d. Program
159. Which of the following DROP statements is INCORRECT?
a. DROP INDEX
b. DROP ROW
c. DROP TABLE
d. DROP DATABASE
160. The information system life cycle has been called
macro life cycle
micro life cycle
logical design
161. The database system life cycle has been referred to as
162. Data model mapping is also called
163. XML attribute values must always be enclosed in quotes
164. Numeric array – An array with a numeric index. Values are stored and accessed in linear fashion
165. How will you concatenate two strings?
a. Using append() function
b. Using . operator
c. Using + operator
d. Using add() function
166. A ______ iterator lists only the attribute types that appear in a query result in SQLJ.
a. Named iterator
b. Positional iterator
c. Cursor
167. A safer way to do inserts and other queries is through the use of placeholders (specifies by ? symbol) in PHP
168. The Web Services Architecture supports interaction between a server provider, service requestor, and service registry.
169. Characteristic that allows program-data independence and program-operation independence
a. Atomicity property
b. Data abstraction
c. Attribute
d. Data dictionary (or data repository system or information repository)
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
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
a. I, III
b. I, II
c. I, II, III
d. II, III
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.
a. $_SERVER[‘REMOTE_ADDRESS’]
b. $_SERVER[‘SERVER_NAME’]
c. $_SERVER[‘REMOTE_HOST’]
d. $_SERVER[‘QUERY_STRING’]
e. $_SERVER['PATH_INFO']
173. SQLJ was developed after JDBC, which is used for accessing SQL data-bases from Java using function calls
174. What does XML stand for?
a. eXtra Modern Link
b. Example Markup Language
c. eXtensible Markup Language
d. X- Markup Language
175. In which type of PHP arrays the element values can be strings or integers?
Indexed
numeric
none
associative
176. Data that is derived from the database files but not explicitly stored.
a. Transaction
b. Virtual data
c. Relational data model
d. Relationship
177. A ________ iterator is associated with a query result in SQLJ by listing the attribute names and types that appear in the query result
a. Positional
b. Named
178. XQuery is the language for querying XML data
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})
overlapping
joint
disjoint
union
