Copiar e Editar

SDP6 part B

Descrição

Quiz sobre SDP6 part B, criado por Ara BOSS em 15-12-2017.
Ara BOSS
Quiz por Ara BOSS, atualizado more than 1 year ago
Ara BOSS
Criado por Ara BOSS quase 7 anos atrás
66
1
0

Resumo de Recurso

Questão 1

Questão
101. The $d->query function takes an SQL command as its string argument and sends it to the database server for execution.
Responda
  • True
  • False

Questão 2

Questão
102. The _____ is a collection of several libraries of functions for enhancing PHP.
Responda
  • a) DBMS
  • b) PHP Extension and Application Repository (PEAR)
  • c) MYSQL
  • d) PHP SQL

Questão 3

Questão
103. The _____ variable is similar to cursor and iterator variables.
Responda
  • a) $d->query
  • b) post
  • c) $r

Questão 4

Questão
105. The PHP function $d->nextID creates a sequence of unique values for a particular table.
Responda
  • True
  • False

Questão 5

Questão
106. Creating a database design that only stores each logical data item in only one place in the database.
Responda
  • Normalization
  • Normal
  • Nf2
  • Nf3

Questão 6

Questão
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
Responda
  • o LEFT OUTER JOIN
  • o RIGHT OUTER JOIN
  • o FULL OUTER JOIN
  • o LEFT INNER JOIN

Questão 7

Questão
115. If a relation schema has more than one key, each is called a _______ key.
Responda
  • o Candidate
  • o Primary
  • o Public
  • o Foreign

Questão 8

Questão
116. A ¬¬¬_________conflict arises when an attribute may have different domains in two schemas, e.g. pounds vs kilograms
Responda
  • o Domain
  • o Type
  • o Norming
  • o Constraints

Questão 9

Questão
117. UML _________ diagrams describe the dynamic relationships among components
Responda
  • o Behavioral
  • o Structural
  • o Class
  • o Direct

Questão 10

Questão
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
Responda
  • o persistent object
  • o instance variable
  • o attribute
  • o object structure

Questão 11

Questão
119. __________________ is the term used to refer to the problems that occur because of difference between the database model and the programming language model.
Responda
  • o Independence mismatch
  • o Denormalisation
  • o Redundancy
  • o Duplication

Questão 12

Questão
120. A __________________ is typically used to loop over the tuples in a query result
Responda
  • o Cursor {iterator variable}
  • o Shared variable
  • o Communication variables
  • o fetch

Questão 13

Questão
122. A THETA JOIN uses any of the comparison operators =,<,>
Responda
  • True
  • False

Questão 14

Questão
123. For structured data, the schema information is mixed in with the data values, so it is sometimes referred to as self-describing data
Responda
  • True
  • False

Questão 15

Questão
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
Responda
  • True
  • False

Questão 16

Questão
125. In PHP, Interpolating variables may occur within double-quoted or single-quoted strings
Responda
  • True
  • False

Questão 17

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

Questão 18

Questão
127. The ________________ property ensures that either all the database operations in a transaction are executed or none are
Responda
  • o Atomicity
  • o Transaction
  • o Isolation
  • o Concurrency

Questão 19

Questão
128. ____________________occurs when the same data is stored multiple times
Responda
  • o Redundancy
  • o Normalisation
  • o Denormalization
  • o Persistent

Questão 20

Questão
129. Creating a database design that only stores each logical data item in only one place is the database is called______________________.
Responda
  • o Redundancy
  • o Normalization
  • o Denormalization
  • o Persistent

Questão 21

Questão
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
Responda
  • True
  • False

Questão 22

Questão
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.
Responda
  • True
  • False

Questão 23

Questão
133. The ________________ property allows several users to update the same data in a controlled manner so that result of the updates is correct
Responda
  • o Atomicity
  • o Transaction
  • o Isolation
  • o Concurrency

Questão 24

Questão
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
Responda
  • True
  • False

Questão 25

Questão
When a database design is in ____________, each value in a tuple is in atomic value.
Responda
  • First normal form
  • Second normal form
  • Third normal form
  • Forth normal form

Questão 26

Questão
135. What does CAP stand for?///////////////////////////
Responda
  • a. Consistency, Atomicity, Partition Tolerance
  • b. Consistency, Availability, Partition Tolerance
  • c. Commitment, Availability, Partition Tolerance
  • d. Consistency, Availability, Persistence

Questão 27

Questão
136. What does BASE stand for?///////////////////////////
Responda
  • 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

Questão 28

Questão
137. What does ACID stand for?/////////////////////
Responda
  • a. Available, Consistent, Isolation, and Durability
  • b. Atomic, Consistent, Isolation, and Durability
  • c. Atomic, Consistent, Isolation, and Dependent
  • d. Atomic, Consistent, Index, and Durability

Questão 29

Questão
138. Which of the following is used to denote the selection operation in the relational algebra?///////////////////////
Responda
  • a. Pi (Greek)
  • b. Sigma (Greek)
  • c. Lambda (Greek)
  • d. Omega (Greek)

Questão 30

Questão
139. Normalization is a process of organizing the data in database to avoid
Responda
  • data redundancy
  • insertion anomaly
  • , update anomaly
  • deletion anomaly

Questão 31

Questão
140. Relational Algebra is a _____ query language that takes two relation as input and produces another relation as output of the query.///////////////////////////////////
Responda
  • a. Relational
  • b. Structural
  • c. Procedural
  • d. Fundamental

Questão 32

Questão
141. Which of the following is a NoSQL Database Type?///////////////////////////////
Responda
  • a. JSON
  • b. SQL
  • c. Document databases
  • d. All of the mentioned

Questão 33

Questão
142. Which of the following are simplest NoSQL databases?///////////////////////////////////
Responda
  • a. Wide-column
  • b. Document
  • c. Key-value
  • d. All of the mentioned

Questão 34

Questão
143. Which of the following is not a NoSQL database?//////////////////////////////
Responda
  • a. Cassandra
  • b. None of the mentioned
  • c. SQL Server
  • d. MondoDB

Questão 35

Questão
144. A ______ is an indirect functional dependency, one I which X->Z only by virtue of X->Y and Y->Z.//////////////////////
Responda
  • a. Multivalued Dependencies
  • b. Join Dependency
  • c. Trivial Functional Dependency
  • d. Transitive Dependency

Questão 36

Questão
145. NoSQL database is used mainly for handling large volumes of _____ data.
Responda
  • a. Structured
  • b. Semi-structured
  • c. Unstructured
  • d. All of the mentioned

Questão 37

Questão
146. What is the correct order of clauses for a proper SQL query?
Responda
  • 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

Questão 38

Questão
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.
Responda
  • a. Candidate
  • b. Join
  • c. Functional
  • d. None of the Mentioned

Questão 39

Questão
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)
Responda
  • a. Transitive Dependency
  • b. Insertion Anomaly
  • c. Referential Integrity Constraint
  • d. Normal Form

Questão 40

Questão
149. Most NoSQL databases support automatic ______, meaning that you get high availability and disaster recovery
Responda
  • a. Scalability
  • b. Processing
  • d. Replication
  • c. All of the mentioned

Questão 41

Questão
150. A table is in 3NF if it is in 2NF and if it has no
Responda
  • a. Functional Dependencies
  • b. Transitive Dependencies
  • c. Trivial Functional Dependency
  • d. Multivalued Dependencies

Questão 42

Questão
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.
Responda
  • True
  • False

Questão 43

Questão
152. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Person table?
Responda
  • 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’

Questão 44

Questão
153. Which of the following is NOT a language element of SQL?
Responda
  • a. Data mining
  • b. Expression
  • c. Query
  • d. Clause
  • e. Statement

Questão 45

Questão
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?
Responda
  • 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’);

Questão 46

Questão
155. With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?
Responda
  • 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

Questão 47

Questão
156. With SQL, how can you delete the records where the “Address” is “Almaty” in the Student Table?
Responda
  • 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

Questão 48

Questão
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”?
Responda
  • 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%’;

Questão 49

Questão
158. Which term is used to describe data organized in rows and columns?
Responda
  • a. Query
  • b. Index
  • c. Table
  • d. Program

Questão 50

Questão
159. Which of the following DROP statements is INCORRECT?
Responda
  • a. DROP INDEX
  • b. DROP ROW
  • c. DROP TABLE
  • d. DROP DATABASE

Questão 51

Questão
160. The information system life cycle has been called
Responda
  • macro life cycle
  • micro life cycle
  • logical design

Questão 52

Questão
161. The database system life cycle has been referred to as
Responda
  • macro life cycle
  • micro life cycle
  • logical design

Questão 53

Questão
162. Data model mapping is also called
Responda
  • macro life cycle
  • micro life cycle
  • logical design

Questão 54

Questão
163. XML attribute values must always be enclosed in quotes
Responda
  • True
  • False

Questão 55

Questão
164. Numeric array – An array with a numeric index. Values are stored and accessed in linear fashion
Responda
  • True
  • False

Questão 56

Questão
165. How will you concatenate two strings?
Responda
  • a. Using append() function
  • b. Using . operator
  • c. Using + operator
  • d. Using add() function

Questão 57

Questão
166. A ______ iterator lists only the attribute types that appear in a query result in SQLJ.
Responda
  • a. Named iterator
  • b. Positional iterator
  • c. Cursor

Questão 58

Questão
167. A safer way to do inserts and other queries is through the use of placeholders (specifies by ? symbol) in PHP
Responda
  • True
  • False

Questão 59

Questão
168. The Web Services Architecture supports interaction between a server provider, service requestor, and service registry.
Responda
  • True
  • False

Questão 60

Questão
169. Characteristic that allows program-data independence and program-operation independence
Responda
  • a. Atomicity property
  • b. Data abstraction
  • c. Attribute
  • d. Data dictionary (or data repository system or information repository)

Questão 61

Questão
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
Responda
  • True
  • False

Questão 62

Questão
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
Responda
  • a. I, III
  • b. I, II
  • c. I, II, III
  • d. II, III

Questão 63

Questão
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.
Responda
  • a. $_SERVER[‘REMOTE_ADDRESS’]
  • b. $_SERVER[‘SERVER_NAME’]
  • c. $_SERVER[‘REMOTE_HOST’]
  • d. $_SERVER[‘QUERY_STRING’]
  • e. $_SERVER['PATH_INFO']

Questão 64

Questão
173. SQLJ was developed after JDBC, which is used for accessing SQL data-bases from Java using function calls
Responda
  • True
  • False

Questão 65

Questão
174. What does XML stand for?
Responda
  • a. eXtra Modern Link
  • b. Example Markup Language
  • c. eXtensible Markup Language
  • d. X- Markup Language

Questão 66

Questão
175. In which type of PHP arrays the element values can be strings or integers?
Responda
  • Indexed
  • numeric
  • none
  • associative

Questão 67

Questão
176. Data that is derived from the database files but not explicitly stored.
Responda
  • a. Transaction
  • b. Virtual data
  • c. Relational data model
  • d. Relationship

Questão 68

Questão
177. A ________ iterator is associated with a query result in SQLJ by listing the attribute names and types that appear in the query result
Responda
  • a. Positional
  • b. Named
  • c. Cursor

Questão 69

Questão
178. XQuery is the language for querying XML data
Responda
  • True
  • False

Questão 70

Questão
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})
Responda
  • overlapping
  • joint
  • disjoint
  • union

Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.

Semelhante

Óptica Geométrica
Bruno Fernandes3682
Quiz Geral
MarisaS
Fotossíntese
joana_pinto_202
HISTÓRIA DA EDUCAÇÃO NO BRASIL
vanessasenez
Português para o ENEM
Alessandra S.
REAÇÕES QUÍMICAS
alessandra
Guia - 2ª Fase do Exame da Ordem
Alice Sousa
Revisão de Direito Penal
Alice Sousa
Quiz sobre Freud
Yasmin Padovan
Dos Direitos da Personalidade (Arts. 11º ao 21º)
Luiz Concursos
Revisão 2- PROVA DE SARGENTO - MARINHA - EA-HSG - ( Com Verificação )
Nilzeir Reis
Explore a Biblioteca