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