Kopieren und bearbeiten

SDP6 part B

Beschreibung

Quiz am SDP6 part B, erstellt von Ara BOSS am 15/12/2017.
Ara BOSS
Quiz von Ara BOSS, aktualisiert more than 1 year ago
Ara BOSS
Erstellt von Ara BOSS vor fast 7 Jahre
66
1
0

Zusammenfassung der Ressource

Frage 1

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

Frage 2

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

Frage 3

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

Frage 4

Frage
105. The PHP function $d->nextID creates a sequence of unique values for a particular table.
Antworten
  • True
  • False

Frage 5

Frage
106. Creating a database design that only stores each logical data item in only one place in the database.
Antworten
  • Normalization
  • Normal
  • Nf2
  • Nf3

Frage 6

Frage
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
Antworten
  • o LEFT OUTER JOIN
  • o RIGHT OUTER JOIN
  • o FULL OUTER JOIN
  • o LEFT INNER JOIN

Frage 7

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

Frage 8

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

Frage 9

Frage
117. UML _________ diagrams describe the dynamic relationships among components
Antworten
  • o Behavioral
  • o Structural
  • o Class
  • o Direct

Frage 10

Frage
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
Antworten
  • o persistent object
  • o instance variable
  • o attribute
  • o object structure

Frage 11

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

Frage 12

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

Frage 13

Frage
122. A THETA JOIN uses any of the comparison operators =,<,>
Antworten
  • True
  • False

Frage 14

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

Frage 15

Frage
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
Antworten
  • True
  • False

Frage 16

Frage
125. In PHP, Interpolating variables may occur within double-quoted or single-quoted strings
Antworten
  • True
  • False

Frage 17

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

Frage 18

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

Frage 19

Frage
128. ____________________occurs when the same data is stored multiple times
Antworten
  • o Redundancy
  • o Normalisation
  • o Denormalization
  • o Persistent

Frage 20

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

Frage 21

Frage
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
Antworten
  • True
  • False

Frage 22

Frage
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.
Antworten
  • True
  • False

Frage 23

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

Frage 24

Frage
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
Antworten
  • True
  • False

Frage 25

Frage
When a database design is in ____________, each value in a tuple is in atomic value.
Antworten
  • First normal form
  • Second normal form
  • Third normal form
  • Forth normal form

Frage 26

Frage
135. What does CAP stand for?///////////////////////////
Antworten
  • a. Consistency, Atomicity, Partition Tolerance
  • b. Consistency, Availability, Partition Tolerance
  • c. Commitment, Availability, Partition Tolerance
  • d. Consistency, Availability, Persistence

Frage 27

Frage
136. What does BASE stand for?///////////////////////////
Antworten
  • 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

Frage 28

Frage
137. What does ACID stand for?/////////////////////
Antworten
  • a. Available, Consistent, Isolation, and Durability
  • b. Atomic, Consistent, Isolation, and Durability
  • c. Atomic, Consistent, Isolation, and Dependent
  • d. Atomic, Consistent, Index, and Durability

Frage 29

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

Frage 30

Frage
139. Normalization is a process of organizing the data in database to avoid
Antworten
  • data redundancy
  • insertion anomaly
  • , update anomaly
  • deletion anomaly

Frage 31

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

Frage 32

Frage
141. Which of the following is a NoSQL Database Type?///////////////////////////////
Antworten
  • a. JSON
  • b. SQL
  • c. Document databases
  • d. All of the mentioned

Frage 33

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

Frage 34

Frage
143. Which of the following is not a NoSQL database?//////////////////////////////
Antworten
  • a. Cassandra
  • b. None of the mentioned
  • c. SQL Server
  • d. MondoDB

Frage 35

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

Frage 36

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

Frage 37

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

Frage 38

Frage
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.
Antworten
  • a. Candidate
  • b. Join
  • c. Functional
  • d. None of the Mentioned

Frage 39

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

Frage 40

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

Frage 41

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

Frage 42

Frage
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.
Antworten
  • True
  • False

Frage 43

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

Frage 44

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

Frage 45

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

Frage 46

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

Frage 47

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

Frage 48

Frage
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”?
Antworten
  • 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%’;

Frage 49

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

Frage 50

Frage
159. Which of the following DROP statements is INCORRECT?
Antworten
  • a. DROP INDEX
  • b. DROP ROW
  • c. DROP TABLE
  • d. DROP DATABASE

Frage 51

Frage
160. The information system life cycle has been called
Antworten
  • macro life cycle
  • micro life cycle
  • logical design

Frage 52

Frage
161. The database system life cycle has been referred to as
Antworten
  • macro life cycle
  • micro life cycle
  • logical design

Frage 53

Frage
162. Data model mapping is also called
Antworten
  • macro life cycle
  • micro life cycle
  • logical design

Frage 54

Frage
163. XML attribute values must always be enclosed in quotes
Antworten
  • True
  • False

Frage 55

Frage
164. Numeric array – An array with a numeric index. Values are stored and accessed in linear fashion
Antworten
  • True
  • False

Frage 56

Frage
165. How will you concatenate two strings?
Antworten
  • a. Using append() function
  • b. Using . operator
  • c. Using + operator
  • d. Using add() function

Frage 57

Frage
166. A ______ iterator lists only the attribute types that appear in a query result in SQLJ.
Antworten
  • a. Named iterator
  • b. Positional iterator
  • c. Cursor

Frage 58

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

Frage 59

Frage
168. The Web Services Architecture supports interaction between a server provider, service requestor, and service registry.
Antworten
  • True
  • False

Frage 60

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

Frage 61

Frage
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
Antworten
  • True
  • False

Frage 62

Frage
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
Antworten
  • a. I, III
  • b. I, II
  • c. I, II, III
  • d. II, III

Frage 63

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

Frage 64

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

Frage 65

Frage
174. What does XML stand for?
Antworten
  • a. eXtra Modern Link
  • b. Example Markup Language
  • c. eXtensible Markup Language
  • d. X- Markup Language

Frage 66

Frage
175. In which type of PHP arrays the element values can be strings or integers?
Antworten
  • Indexed
  • numeric
  • none
  • associative

Frage 67

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

Frage 68

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

Frage 69

Frage
178. XQuery is the language for querying XML data
Antworten
  • True
  • False

Frage 70

Frage
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})
Antworten
  • overlapping
  • joint
  • disjoint
  • union
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

Elektromagnetismus
Peter Kasebacher
OEKO VO
Anna Huber
2C Entwicklungspsychologie
petra.drewitz
Lernplan Analysis
Hanna Marie Hock
U1 Buchproduktion
Lena A.
PAED
M T
Vetie - Tierzucht & Genetik - 2016
Fioras Hu
Prüfungsthemen APSY EURO-FH B.Sc.
??? ???
Vetie PathoHisto 2018
Juliane Arendt
Innere 2015 Vetie
Mailin Hein
Vetie - Fleisch 2019
Fioras Hu
Bibliothek durchsuchen