Quiz
SDP6 part B
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (70)
1101. The $d->query function takes an SQL command as its string argument and sends it to the database server for execution.
- ATrue
- BFalse
2102. The _____ is a collection of several libraries of functions for enhancing PHP.
- Aa) DBMS
- Bb) PHP Extension and Application Repository (PEAR)
- Cc) MYSQL
- Dd) PHP SQL
3103. The _____ variable is similar to cursor and iterator variables.
- Aa) $d->query
- Bb) post
- Cc) $r
4105. The PHP function $d->nextID creates a sequence of unique values for a particular table.
- ATrue
- BFalse
5106. Creating a database design that only stores each logical data item in only one place in the database.
- ANormalization
- BNormal
- CNf2
- DNf3
6114. 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
- Ao LEFT OUTER JOIN
- Bo RIGHT OUTER JOIN
- Co FULL OUTER JOIN
- Do LEFT INNER JOIN
7115. If a relation schema has more than one key, each is called a _______ key.
- Ao Candidate
- Bo Primary
- Co Public
- Do Foreign
8116. A ¬¬¬_________conflict arises when an attribute may have different domains in two schemas, e.g. pounds vs kilograms
- Ao Domain
- Bo Type
- Co Norming
- Do Constraints
9117. UML _________ diagrams describe the dynamic relationships among components
- Ao Behavioral
- Bo Structural
- Co Class
- Do Direct
10118. 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
- Ao persistent object
- Bo instance variable
- Co attribute
- Do object structure
11119. __________________ is the term used to refer to the problems that occur because of difference between the database model and the programming language model.
- Ao Independence mismatch
- Bo Denormalisation
- Co Redundancy
- Do Duplication
12120. A __________________ is typically used to loop over the tuples in a query result
- Ao Cursor {iterator variable}
- Bo Shared variable
- Co Communication variables
- Do fetch
13122. A THETA JOIN uses any of the comparison operators =,<,>
- ATrue
- BFalse
14123. For structured data, the schema information is mixed in with the data values, so it is sometimes referred to as self-describing data
- ATrue
- BFalse
15124. The main advantage of using a function call interface is that it makes it easier to access multiple databases within the same application program
- ATrue
- BFalse
16125. In PHP, Interpolating variables may occur within double-quoted or single-quoted strings
- ATrue
- BFalse
17126. In PHP, the $d->query function takes an SQL command as its string argument and sends it to the database server for execution.
- ATrue
- BFalse
18127. The ________________ property ensures that either all the database operations in a transaction are executed or none are
- Ao Atomicity
- Bo Transaction
- Co Isolation
- Do Concurrency
19128. ____________________occurs when the same data is stored multiple times
- Ao Redundancy
- Bo Normalisation
- Co Denormalization
- Do Persistent
20129. Creating a database design that only stores each logical data item in only one place is the database is called______________________.
- Ao Redundancy
- Bo Normalization
- Co Denormalization
- Do Persistent
21131. An entity cannot exist in a database merely by being a member of a subclass, it must also be a member of the superclass
- ATrue
- BFalse
22132. 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.
- ATrue
- BFalse
23133. The ________________ property allows several users to update the same data in a controlled manner so that result of the updates is correct
- Ao Atomicity
- Bo Transaction
- Co Isolation
- Do Concurrency
24134. 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
- ATrue
- BFalse
25When a database design is in ____________, each value in a tuple is in atomic value.
- AFirst normal form
- BSecond normal form
- CThird normal form
- DForth normal form
26135. What does CAP stand for?///////////////////////////
- Aa. Consistency, Atomicity, Partition Tolerance
- Bb. Consistency, Availability, Partition Tolerance
- Cc. Commitment, Availability, Partition Tolerance
- Dd. Consistency, Availability, Persistence
27136. What does BASE stand for?///////////////////////////
- Aa. Basically Available, System-State, Eventually Consistent
- Bb. Basically Available, Soft-State, Eventually Consistent
- Cc. Broadly Available, Soft-State, Eventually Consistent
- Dd. Basically Available, Soft-State, Evenly Consistent
28137. What does ACID stand for?/////////////////////
- Aa. Available, Consistent, Isolation, and Durability
- Bb. Atomic, Consistent, Isolation, and Durability
- Cc. Atomic, Consistent, Isolation, and Dependent
- Dd. Atomic, Consistent, Index, and Durability
29138. Which of the following is used to denote the selection operation in the relational algebra?///////////////////////
- Aa. Pi (Greek)
- Bb. Sigma (Greek)
- Cc. Lambda (Greek)
- Dd. Omega (Greek)
30139. Normalization is a process of organizing the data in database to avoid
- Adata redundancy
- Binsertion anomaly
- C, update anomaly
- Ddeletion anomaly
31140. Relational Algebra is a _____ query language that takes two relation as input and produces another relation as output of the query.///////////////////////////////////
- Aa. Relational
- Bb. Structural
- Cc. Procedural
- Dd. Fundamental
32141. Which of the following is a NoSQL Database Type?///////////////////////////////
- Aa. JSON
- Bb. SQL
- Cc. Document databases
- Dd. All of the mentioned
33142. Which of the following are simplest NoSQL databases?///////////////////////////////////
- Aa. Wide-column
- Bb. Document
- Cc. Key-value
- Dd. All of the mentioned
34143. Which of the following is not a NoSQL database?//////////////////////////////
- Aa. Cassandra
- Bb. None of the mentioned
- Cc. SQL Server
- Dd. MondoDB
35144. A ______ is an indirect functional dependency, one I which X->Z only by virtue of X->Y and Y->Z.//////////////////////
- Aa. Multivalued Dependencies
- Bb. Join Dependency
- Cc. Trivial Functional Dependency
- Dd. Transitive Dependency
36145. NoSQL database is used mainly for handling large volumes of _____ data.
- Aa. Structured
- Bb. Semi-structured
- Cc. Unstructured
- Dd. All of the mentioned
37146. What is the correct order of clauses for a proper SQL query?
- Aa. SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY
- Bb. SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING
- Cc. SELECT, FROM, GROUP BY, WHERE, HAVING, ORDER BY
- Dd. SELECT, FROM, WHERE, HAVING, GROUP BY, ORDER BY
- Ee. SELECT, FROM, ORDER BY, WHERE, GROUP BY, HAVING
38147. 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.
- Aa. Candidate
- Bb. Join
- Cc. Functional
- Dd. None of the Mentioned
39148. 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)
- Aa. Transitive Dependency
- Bb. Insertion Anomaly
- Cc. Referential Integrity Constraint
- Dd. Normal Form
40149. Most NoSQL databases support automatic ______, meaning that you get high availability and disaster recovery
- Aa. Scalability
- Bb. Processing
- Cd. Replication
- Dc. All of the mentioned
41150. A table is in 3NF if it is in 2NF and if it has no
- Aa. Functional Dependencies
- Bb. Transitive Dependencies
- Cc. Trivial Functional Dependency
- Dd. Multivalued Dependencies
42151. 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.
- ATrue
- BFalse
43152. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Person table?
- Aa. MODIFY Persons SET LastName=’Hansen’ WHERE LastName=’Nilsen’
- Bb. UPDATE Persons SET LastName=’Hansen’ WHERE LastName=’Nilsen’
- Cc. UPDATE FROM Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
- Dd. UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
44153. Which of the following is NOT a language element of SQL?
- Aa. Data mining
- Bb. Expression
- Cc. Query
- Dd. Clause
- Ee. Statement
45154. 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?
- Aa. INSERT INTO Publisher (name) values(‘OReilly’);
- Bb. INSERT INTO Publisher (name) values(‘O-Reilly’);
- Cc. INSERT INTO Publisher (name) values(‘O’Reilly’);
- Dd. INSERT INTO Publisher (name) values(‘O Reilly’);
46155. With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?
- Aa. SELECT * FROM Persons GROUP BY FirstName DESC
- Bb. SELECT * FROM Persons ORDER BY FirstName
- Cb. SELECT * FROM Persons GROUP BY FirstName DESC
- Dd. SELECT * FROM Persons WHERE FirstName DESC
47156. With SQL, how can you delete the records where the “Address” is “Almaty” in the Student Table?
- Aa. DELETE ROW Address=’Almaty’ FROM Student
- Bb. DELETE FROM Student ROW Address=’Almaty’
- Cc. DROP ROW Address=’Almaty’ FROM Student
- Dd. DROP ROW Address=’Almaty’ FROM Address
48157. 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”?
- Aa. SELECT * FROM Persons WHERE FirstName LIKE ‘%a%’;
- Bb. SELECT ALL FROM Persons WHERE FirstName LIKE ‘a’;
- Cc. SELECT * FROM Persons WHERE FirstName LIKE ‘a’;
- Dd. SELECT * FROM Persons WHERE FirstName LIKE ‘a%’;
49158. Which term is used to describe data organized in rows and columns?
- Aa. Query
- Bb. Index
- Cc. Table
- Dd. Program
50159. Which of the following DROP statements is INCORRECT?
- Aa. DROP INDEX
- Bb. DROP ROW
- Cc. DROP TABLE
- Dd. DROP DATABASE
51160. The information system life cycle has been called
- Amacro life cycle
- Bmicro life cycle
- Clogical design
52161. The database system life cycle has been referred to as
- Amacro life cycle
- Bmicro life cycle
- Clogical design
53162. Data model mapping is also called
- Amacro life cycle
- Bmicro life cycle
- Clogical design
54163. XML attribute values must always be enclosed in quotes
- ATrue
- BFalse
55164. Numeric array – An array with a numeric index. Values are stored and accessed in linear fashion
- ATrue
- BFalse
56165. How will you concatenate two strings?
- Aa. Using append() function
- Bb. Using . operator
- Cc. Using + operator
- Dd. Using add() function
57166. A ______ iterator lists only the attribute types that appear in a query result in SQLJ.
- Aa. Named iterator
- Bb. Positional iterator
- Cc. Cursor
58167. A safer way to do inserts and other queries is through the use of placeholders (specifies by ? symbol) in PHP
- ATrue
- BFalse
59168. The Web Services Architecture supports interaction between a server provider, service requestor, and service registry.
- ATrue
- BFalse
60169. Characteristic that allows program-data independence and program-operation independence
- Aa. Atomicity property
- Bb. Data abstraction
- Cc. Attribute
- Dd. Data dictionary (or data repository system or information repository)
61170. 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
- ATrue
- BFalse
62171. 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
- Aa. I, III
- Bb. I, II
- Cc. I, II, III
- Dd. II, III
63172. 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.
- Aa. $_SERVER[‘REMOTE_ADDRESS’]
- Bb. $_SERVER[‘SERVER_NAME’]
- Cc. $_SERVER[‘REMOTE_HOST’]
- Dd. $_SERVER[‘QUERY_STRING’]
- Ee. $_SERVER['PATH_INFO']
64173. SQLJ was developed after JDBC, which is used for accessing SQL data-bases from Java using function calls
- ATrue
- BFalse
65174. What does XML stand for?
- Aa. eXtra Modern Link
- Bb. Example Markup Language
- Cc. eXtensible Markup Language
- Dd. X- Markup Language
66175. In which type of PHP arrays the element values can be strings or integers?
- AIndexed
- Bnumeric
- Cnone
- Dassociative
67176. Data that is derived from the database files but not explicitly stored.
- Aa. Transaction
- Bb. Virtual data
- Cc. Relational data model
- Dd. Relationship
68177. A ________ iterator is associated with a query result in SQLJ by listing the attribute names and types that appear in the query result
- Aa. Positional
- Bb. Named
- Cc. Cursor
69178. XQuery is the language for querying XML data
- ATrue
- BFalse
70180. 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})
- Aoverlapping
- Bjoint
- Cdisjoint
- Dunion
Information
- Description
- Quiz on SDP6 part B, created by Ara BOSS on 15/12/2017.
- Author
- Ara BOSS
- Language
- English
- Views
- 78
- Rating
- No ratings yet Rate this quiz