SDP 6 (2)

1

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

1

If a relation schema has more than one key, each is called a _______ key.

1

A _________conflict arises when an attribute may have different domains in two schemas, e.g. pounds vs kilograms

1

UML _________ diagrams describe the dynamic relationships among components

1

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

1

_____ is the term used to refer to the problems that occur because of difference between the database model and the programming language model.

1

A __________________ is typically used to loop over the tuples in a query result

1

NULL values may mean value unknown, value exists but isn't available, and attribute does not apply to this tuple (value undefined)

1

A THETA JOIN uses any of the comparison operators =,<,> or (not equal)

1

For structured data, the schema information is mixed in with the data values, so it is sometimes referred to as self-describing data

1

The main advantage of using a function call interface is that it makes it easier to access multiple databases within the same application program

1

In PHP, Interpolating variables may occur within double-quoted or single-quoted strings

1

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

1

The ________________ property ensures that either all the database operations in a transaction are executed or none are

1

_______occurs when the same data is stored multiple times

1

Creating a database design that only stores each logical data item in only one place is the database is called______

1

The ________________ property allows several users to update the same data in a controlled manner so that result of the updates is correct

1

An entity cannot exist in a database merely by being a member of a subclass, it must also be a member of the superclass

1

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.

1

The theoretical basis of the relational data model is set theory and first-order predicate logic

1

Semantic integrity constraints may be enforced using mechanisms called triggers and assertions.

1

When mapping a binary M:N relationship type R, create a new relation S to represent R, including as foreign key attributes in S the primary keys of the relations that are the participating entity types (their combination in S is the composite primary key of S).

1

$_SESSION − An associative array containing session variables available to the current script

1

PHP makes use of mail() function to send an email. This function requires three mandatory arguments that specify the recipient's email address, the subject of the the message and the actual message additionally there are other two optional parameters

1

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

1

SQLJ was developed after JDBC, which is used for accessing SQL data- bases from Java using function calls

1

Most NoSQL databases support automatic __________, meaning that you get high availability and disaster recovery

1

The Web Services Architecture supports interaction between a service provider, service requestor, and service registry

1

Multi-line PHP comments start with // and end with #.

1

Define types of abstractions by the relations as "A is made of/composed of B,C,D"

1

FETCH commands are issued in the program; each FETCH moves the cursor to the next row in the result of the query, making it the cur- rent row and copying its attribute values into the C (host language) program variables specified in the FETCH command by an INTO clause.</text>

1

Define types of abstractions by the relations as "B,C,D are special cases of A"

1

A JDBC driver is basically an implementation of the function calls specified in the JDBC application programming interface (API) for a particular vendor's RDBMS

1

In PHP, a numeric array associates a numeric index with each element in the array.

1

Before being able to process JDBC function calls with Java, it is necessary to import the JDBC class libraries, which are called java.sql.*.

1

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

1

Publisher table contains id and name columns. Id is auto incremented and name is of varchar(40) type. Which of the following queries will execute NOT correctly?

1

What is the correct order of clauses for a proper SQL query?

1

Which clause indicates the table(s) from which data is to be retrieved?

1

Which clause is executed first in a SQL query?

1

Which of the following DROP statements is INCORRECT?

1

Which of the following is NOT a language element of SQL?

1

Which operator is used to search for a specified pattern in a column?

1

Which operator is used to select values within a range?

1

Which term is used to describe data organized in rows and columns?

1

With SQL, how can you delete the records where the "Address" is "Almaty" in the Student Table?

1

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

1

With SQL, how can you return the number of records in the "Employee" table?

1

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

1

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Alma" and the "LastName" is "Alimova"?

1

Which of the following is not a NoSQL database ?

1

Which of the following is a NoSQL Database Type ?

1

Which of the following is a wide-column store ?

1

An ODMS provides a unique identity to each independent object stored in the database via a unique, system-generated ________

1

Define types of abstractions by the relations as "A is a member of class B

1

Define types of abstractions by the relations as "B is-an A, C is-an A, D is-an A"

1

How will you close a MySql database using PHP?

1

How will you concatenate two strings?

1

How will you connect a MySql database using PHP?

1

How will you destroy a session in PHP?

1

How will you start a session in PHP?

1

How will you unset a single session variable?

1

Identify 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.

1

In which type of PHP arrays the element values can be strings or integers?

1

In XML schema, the tag ________________ is used to specify foreign keys

1

NoSQL databases is used mainly for handling large volumes of ______________ data

1

Point out the wrong statement

1

The _ notation applies to user-defined subclasses of a specialization that must be ______, as illustrated by the specialization "every STUDENT must be either an GRADUATE_STUDENT, or a UNDERGRADUATE_STUDENT"

1

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})

1

This auto-global built-in array variable which provides the IP (Internet Protocol) address of the client user computer that is accessing the server, for example 129.107.61.8.

1

This auto-global built-in array variable which provides the part of the URL address that comes after a backslash (/) at the end of the URL.

1

This auto-global built-in array variable which provides the string that holds parameters in a URL after a question mark (?) at the end of the URL. This can hold search parameters, for example

1

This auto-global built-in array variablewhich provides the Web site name of the server computer where the PHP interpreter is running.

1

What does PHP stands for

1

What does S in BASE refers to?

1

[What does the term "I" expands to in the term "ACID"?

1

What does XML stand for?

1

What does XSL stand for?

1

What is the correct syntax of the declaration which defines the XML version?

1

Which company did Cassandra was primarily developed in?

1

Which feature of CAP refers to load balancing

1

Which of the following are the simplest NoSQL databases

1

Which of the following is correct about PHP

1

Which of the following is correct about variable naming rules?

1

Which of the following is not a NoSQL database?

1

Which of the following method can be used to create a MySql database using PHP?

1

Which of them could not be applied to techniques for looping through arrays in PHP

1

A key difference between structured and semistructured data concerns how the schema constructs (such as the names of attributes, relationships, and entity types) are handled.

1

A large database typically has large transaction volumes and rates, is used in service sector industries, and runs 24/7

1

A library of functions, also known as an application programming interface (API), is used to access the database

1

A safer way to do inserts and other queries is through the use of placeholders (specified by the ? symbol) in PHP

1

Associative array − An array with strings as index. This stores element values in association with key values rather than in a strict linear index order.

1

In SQLJ, an iterator is a type of object associated with a collection (set or multiset) of records in a query result.

1

In SQLJ, embedded SQL commands are preceded by #sql.

1

In XML schema, it is possible to specify constraints that correspond to unique and primary key constraints in a relational database, as well as foreign keys constraints.

1

Interfaces are defined to provide a common function names to the implementers. Different implementers can implement those interfaces according to their requirements. You can say, interfaces are skeletons which are implemented by developers.

1

Numeric array − An array with a numeric index. Values are stored and accessed in linear fashion.

1

OPEN CURSOR command is issued to indicate that we are done with processing the result of the query associated with that cursor.

1

PHP is written in C and usually comes installed with Unix; for other operating systems, the PHP interpreter can be downloaded from http://www.php.net.

1

The cursor is declared when the SQL query command is declared in the program. Later in the program, an OPEN CURSOR command fetches the query result from the database and sets the cursor to a position before the first row in the result of the query

1

The typical mechanisms for making an object persistent are naming and reachability

1

XML attribute values must always be enclosed in quotes

1

XML elements cannot be empty

1

XML's goal is to replace HTML

1

XQuery is the language for querying XML data

1

The case represents a single superclass/subclass relationship with more than one superclass, where the superclasses represent different entity types

1

When a database design is in ____________, each value in a tuple is in atomic value.

1

Redundancy leads to three potential problems. Briefly describe each of the three.

1

What two things does minimizing redundancy imply

1

What are the four informal guidelines that may be used to measure the quality of a relation schema design?

1

What are the three goals of database design?

1

Identify two of the three factors to consider in choosing one DBMS over another

1

Identify the three criteria to guide the choice of physical database design options

1

A join operation joins _ tables into _.

1

A primary key should be defined as:
I. NULL
II. NOT NULL
III. Optional

1

A subquery in an SQL SELECT statement is enclosed in:

1

SQL query and modification commands make up a(n) ________ .

1

The command to eliminate a table from a database is:

1

________ stores are used to store information about networks, such as social connections.

1

A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z

1

A table is in 3NF if it is in 2NF and if it has no ____________

1

A table is in BCNF if it is in 3NF and if every determinant is a ___________ key.

1

Anomalies are avoided by splitting the offending relation into multiple relations, is also known as

1

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

1

For select operation the appear in the subscript and the ___ argument appears in the parenthesis after the sigma.

1

If X -> Y, which of the following would make Y fully dependent on X?

1

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.

1

In EER modeling, specialization is the process of generating

1

In precedence of set operators the expression is evaluated from

1

The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.

1

The functional dependency X -> Y is true if

1

The result of a set difference operation r - s will be

1

What does a projection operation do?

1

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)

1

Which is a join condition contains an equality operator

1

Which is a unary operation

1

Which of the following is a fundamental operation in relational algebra

1

Which of the following is not a restriction for a table to be a relation?

1

Which of the following is used to denote the selection operation in relational algebra?

1

Y is transitively dependent on X, if

1

For two tables to be union compatible, corresponding columns from each table should have which of the following?

- at Test sobre SDP 6 (2), creado por хомяк убийца el 17/12/2017.

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

If a relation schema has more than one key, each is called a _______ key.

A _________conflict arises when an attribute may have different domains in two schemas, e.g. pounds vs kilograms

UML _________ diagrams describe the dynamic relationships among components

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

_____ is the term used to refer to the problems that occur because of difference between the database model and the programming language model.

A __________________ is typically used to loop over the tuples in a query result

NULL values may mean value unknown, value exists but isn't available, and attribute does not apply to this tuple (value undefined)

A THETA JOIN uses any of the comparison operators =,<,> or (not equal)

For structured data, the schema information is mixed in with the data values, so it is sometimes referred to as self-describing data

The main advantage of using a function call interface is that it makes it easier to access multiple databases within the same application program

In PHP, Interpolating variables may occur within double-quoted or single-quoted strings

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

The ________________ property ensures that either all the database operations in a transaction are executed or none are

_______occurs when the same data is stored multiple times

Creating a database design that only stores each logical data item in only one place is the database is called______

The ________________ property allows several users to update the same data in a controlled manner so that result of the updates is correct

An entity cannot exist in a database merely by being a member of a subclass, it must also be a member of the superclass

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.

The theoretical basis of the relational data model is set theory and first-order predicate logic