SDP 6 (2)

Question

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

Answer 1

o LEFT OUTER JOIN

Answer 2

o RIGHT OUTER JOIN

Answer 3

o FULL OUTER JOIN

Answer 4

o LEFT INNER JOIN

Answer 5

o Candidate

Answer 6

o Constraints

Answer 7

o Behavioral

Answer 8

o Structural

Answer 9

o persistent object

Answer 10

o instance variable

Answer 11

o attribute

Answer 12

o object structure

Answer 13

o Independence mismatch

Answer 14

o Denormalisation

Answer 15

o Redundancy

Answer 16

o Duplication

Answer 17

o Cursor {iterator variable}

Answer 18

o Shared variable

Answer 19

o Communication variables

Answer 20

o Atomicity

Answer 21

o Transaction

Answer 22

o Isolation

Answer 23

o Concurrency

Answer 24

o Redundancy

Answer 25

o Normalisation

Answer 26

o Denormalization

Answer 27

o Persistent

Answer 28

o Redundancy

Answer 29

o Normalization

Answer 30

o Denormalization

Answer 31

o Persistent

Answer 32

o Atomicity

Answer 33

o Transaction

Answer 34

o Isolation

Answer 35

o Concurrency

Answer 36

processing

Answer 37

scalability

Answer 38

replication

Answer 39

All of the mentioned

Answer 40

Classification

Answer 41

Aggregation

Answer 42

Generalization

Answer 43

Specialization

Answer 44

Classification

Answer 45

Aggregation

Answer 46

Generalization

Answer 47

Specialization

Answer 48

UPDATE Persons SET LastName='Hansen' WHERE LastName='Nilsen'

Answer 49

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

Answer 50

MODIFY Persons SET LastName='Hansen' WHERE LastName='Nilsen'

Answer 51

UPDATE FROM Persons SET LastName='Nilsen' WHERE LastName='Hansen'

Answer 52

INSERT INTO Publisher (name) values ('O'Reilly');

Answer 53

INSERT INTO Publisher (name) values ('O Reilly');

Answer 54

INSERT INTO Publisher (name) values ('OReilly');

Answer 55

INSERT INTO Publisher (name) values ('O-Reilly');

Answer 56

SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

Answer 57

SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING

Answer 58

SELECT, FROM, GROUP BY, WHERE, HAVING, ORDER BY

Answer 59

SELECT, FROM, WHERE, HAVING, GROUP BY, ORDER BY

Answer 60

SELECT, FROM, ORDER BY, WHERE, GROUP BY, HAVING

Answer 61

• SELECT

Answer 62

• DROP TABLE

Answer 63

• DROP DATABASE

Answer 64

• DROP ROW

Answer 65

• DROP INDEX

Answer 66

Expression

Answer 67

Data mining

Answer 68

DROP ROW Student ='Almaty' FROM Address

Answer 69

DELETE FROM Student ROW Address ='Almaty'

Answer 70

DROP ROW Address ='Almaty' FROM Student

Answer 71

DELETE ROW Address ='Almaty' FROM Student

Answer 72

SELECT * FROM Persons GROUP BY FirstName DESC

Answer 73

SELECT * FROM Persons WHERE FirstName DESC

Answer 74

SELECT * FROM Persons ORDER BY FirstName

Answer 75

SELECT * FROM Persons ORDER BY FirstName DESC

Answer 76

SELECT COUNT(*) FROM Employee

Answer 77

SELECT * FROM Employee GROUP BY

Answer 78

SELECT NUM(*) FROM Employee

Answer 79

RETURN COUNT(*) FROM Employee

Answer 80

SELECT * FROM Persons WHERE FirstName LIKE 'a%';

Answer 81

SELECT * FROM Persons WHERE FirstName LIKE '%a%';

Answer 82

SELECT All FROM Persons WHERE FirstName LIKE='a';

Answer 83

SELECT * FROM Persons WHERE FirstName LIKE 'a*';

Answer 84

SELECT * FROM Persons WHERE FirstName=' Alma ' AND LastName=' Alimova'

Answer 85

SELECT * FROM Persons WHERE FirstName=' Alma ' OR LastName=' Alimova'

Answer 86

SELECT FROM Persons WHERE FirstName=' Alma ' AND LastName=' Alimova'

Answer 87

SELECT * FROM Persons HAVING FirstName=' Alma ' AND LastName=' Alimova'

Answer 88

SQL Server

Answer 89

None of the mentioned

Answer 90

Document databases

Answer 91

All of the mentioned

Answer 92

object identifier (OID)

Answer 93

indirect pointer

Answer 94

constructor

Answer 95

Classification

Answer 96

Aggregation

Answer 97

Generalization

Answer 98

Specialization

Answer 99

Classification

Answer 100

Aggregation

Answer 101

Generalization

Answer 102

Specialization

Answer 103

mysql_destroy

Answer 104

mysql_exit

Answer 105

mysql_close

Answer 106

Using . operator

Answer 107

Using + operator

Answer 108

Using add() function

Answer 109

Using append() function

Answer 110

mysql_connection

Answer 111

mysql_query

Answer 112

mysql_fetch_array

Answer 113

mysql_connect

Answer 114

session_destroy()

Answer 115

destroy_session()

Answer 116

$_SESSION['destroy']

Answer 117

$_SESSION['']

Answer 118

session_start()

Answer 119

start_session()

Answer 120

$_SESSION['start']

Answer 121

$_SESSION['']

Answer 122

![CDATA[<?phpunset($_SESSION['counter']);?>]]

Answer 123

![CDATA[<?phpisset($_SESSION['counter']); ?>]]

Answer 124

$_SESSION['unset']

Answer 125

$_SESSION['']

Answer 126

associative

Answer 127

xsd:keyref

Answer 128

xsd:element

Answer 129

xsd: unique

Answer 130

xsd:foreignkey

Answer 131

unstructured

Answer 132

structured

Answer 133

semi-structured

Answer 134

all of the mentioned

Answer 135

Non Relational databases require that schemas be defined before you can add data

Answer 136

NoSQL databases are built to allow the insertion of data without a predefined schema

Answer 137

NewSQL databases are built to allow the insertion of data without a predefined schema

Answer 138

All of the mentioned

Answer 139

d, disjoint

Answer 140

o, overlapping

Answer 141

overlapping

Answer 142

$_SERVER['SERVER_NAME']

Answer 143

$_SERVER['REMOTE_ADDRESS']

Answer 144

$_SERVER['REMOTE_HOST']

Answer 145

$_SERVER['PATH_INFO']

Answer 146

$_SERVER['QUERY_STRING']

Answer 147

$_SERVER['SERVER_NAME']

Answer 148

$_SERVER['REMOTE_ADDRESS']

Answer 149

$_SERVER['REMOTE_HOST']

Answer 150

$_SERVER['PATH_INFO']

Answer 151

$_SERVER['QUERY_STRING']

Answer 152

$_SERVER['SERVER_NAME']

Answer 153

$_SERVER['REMOTE_ADDRESS']

Answer 154

$_SERVER['REMOTE_HOST']

Answer 155

$_SERVER['PATH_INFO']

Answer 156

$_SERVER['QUERY_STRING']

Answer 157

$_SERVER['SERVER_NAME']

Answer 158

$_SERVER['REMOTE_ADDRESS']

Answer 159

$_SERVER['REMOTE_HOST']

Answer 160

$_SERVER['PATH_INFO']

Answer 161

$_SERVER['QUERY_STRING']

Answer 162

Personal Hypertext Processor

Answer 163

PHP: Hypertext Preprocessor

Answer 164

Private Home Page

Answer 165

Private Hypertext Preprocessor

Answer 166

System Consistence

Answer 167

System Availability

Answer 168

Changing System

Answer 169

System Stability

Answer 170

Inseparable

Answer 171

Indispensable

Answer 172

eXtensible Markup Language

Answer 173

Example Markup Language

Answer 174

X-Markup Language

Answer 175

eXtra Modern Link

Answer 176

eXtensible Stylesheet Language

Answer 177

eXtra Style Language

Answer 178

eXpandable Style Language

Answer 179

eXtensible Style Listing

Answer 180

<?xml version="1.0" />

Answer 181

<?xml version="1.0"?>

Answer 182

Answer 183

None of these

Answer 184

Wide-column

Answer 185

All of the mentioned

Answer 186

PHP is a recursive acronym for "PHP: Hypertext Preprocessor".]

Answer 187

PHP is a server side scripting language that is embedded in HTML

Answer 188

It is used to manage dynamic content, databases, session tracking, even build entire e-commerce sites

Answer 189

All of these statement

Answer 190

Variable names must begin with a letter or underscore character.

Answer 191

A variable name can consist of numbers, letters, underscores.

Answer 192

you cannot use characters like + , - , % , ( , ) . & , etc in a variable name.

Answer 193

All of these statement

Answer 194

SQL Server

Answer 195

None of the mentioned

Answer 196

mysql_connect()

Answer 197

mysql_query()

Answer 198

mysql_close()

Answer 199

None of the above

Answer 200

$courses = ('Database', 'OS', 'Graphics', 'Data Mining');

Answer 201

$courses = array('Database', 'OS', 'Graphics', 'Data Mining');

Answer 202

$teaching = array('Database' => 'Smith', 'OS' => 'Carrick', 'Graphics' => 'Kam');

Answer 203

$teaching['Graphics'] = 'Benson';

Answer 204

$alt_row_color = array('blue', 'yellow');

Answer 205

overlapping

Answer 206

First normal form

Answer 207

Second normal form

Answer 208

Third normal form

Answer 209

Forth normal form

Answer 210

Duplication of effort

Answer 211

Storage space is wasted

Answer 212

Multiple occurrences of data may become inconsistent

Answer 213

Minimizing redundant storage of the same information.

Answer 214

Reducing the need for multiple updates to maintain consistency across multiple copies of the same information.

Answer 215

Making sure the semantics of the attributes is clear in the schema.

Answer 216

Reducing the redundant information in tuples.

Answer 217

Reducing the NULL values in tuples.

Answer 218

Disallowing the possibility of generating spurious tuples.

Answer 219

Satisfy the information content requirements of the specified users and applications.

Answer 220

Provide a natural and easy-to-understand structuring of the information.

Answer 221

Support processing requirements and any performance objectives

Answer 222

Organization-wide adoption of a certain philosophy (data model, vendor, methodology, tools).

Answer 223

Familiarity of personnel with the system

Answer 224

Availability of vendor services

Answer 225

Response time.

Answer 226

Space utilization

Answer 227

Transaction throughput.

Answer 228

three, two

Answer 229

three, one

Answer 230

I, II, III

Answer 231

braces -- {...}.

Answer 232

CAPITAL LETTERS

Answer 233

parenthesis -- (...)

Answer 234

brackets -- [...].

Answer 235

• REMOVE TABLE TableName

Answer 236

• DROP TABLE TableName

Answer 237

• DELETE TABLE TableName

Answer 238

• UPDATE TABLE TableName

Answer 239

• Key-value

Answer 240

• Wide-column

Answer 241

• Multivalued Dependencies

Answer 242

• Join Dependency

Answer 243

• Trivial Functional Dependency

Answer 244

• Transitive Dependencies

Answer 245

• Functional Dependencies

Answer 246

• Transitive Dependencies

Answer 247

• Trivial Functional Dependency

Answer 248

• Multivalued Dependencies

Answer 249

• Dependent

Answer 250

• Normal

Answer 251

• Candidate

Answer 252

Both Normal and Candidate

Answer 253

• Accupressure

Answer 254

• Decomposition

Answer 255

• Both Decomposition and Precomposition

Answer 256

• Precomposition

Answer 257

• Predicates, relation

Answer 258

• Relation, Predicates

Answer 259

• Operation, Predicates

Answer 260

• Relation, Operation

Answer 261

• X consists of multiple attributes

Answer 262

• Y is a single attribute

Answer 263

• Y consists of multiple attributes

Answer 264

• X is a single attribute

Answer 265

• Candidate

Answer 266

• Functional

Answer 267

• None of the Mentioned

Answer 268

• entities out of attributes

Answer 269

• attributes out of entities

Answer 270

• subclasses out of superclasses

Answer 271

• superclasses out of subclasses

Answer 272

• Left to left

Answer 273

• Left to right

Answer 274

• Right to left

Answer 275

• From user specification

Answer 276

• Set-difference

Answer 277

• Difference

Answer 278

• Intersection

Answer 279

a value of X uniquely determines a value of Y

Answer 280

the value of Y depends on the collective values of X

Answer 281

the value of X depends on the collective values of Y

Answer 282

a value of Y uniquely determines a value of X

Answer 283

those tuples that are in s but not in r

Answer 284

those tuples that are in r but not in s

Answer 285

tuples in s after deducting their values by the corresponding values in the tuples in r

Answer 286

tuples in r after deducting their values by the corresponding values in the tuples in s

Answer 287

It extends the number of rows in a table.

Answer 288

It extends the number of columns in a table

Answer 289

It selects columns from a table

Answer 290

It selects rows from a table.

Answer 291

Transitive Dependency

Answer 292

Insertion Anomaly

Answer 293

Referential Integrity Constraint

Answer 294

Normal Form

Answer 295

Selection operation

Answer 296

Primitive operation

Answer 297

Projection operation

Answer 298

Generalized selection

Answer 299

Set intersection

Answer 300

Natural join

Answer 301

Assignment

Answer 302

None of the mentioned

Answer 303

The cells of the table must contain a single value

Answer 304

The columns must be ordered

Answer 305

No two rows in a table may be identical

Answer 306

X -> A, B and Y -> A, B

Answer 307

X -> Y and A -> Y

Answer 308

X -> A, B and A -> Y

Answer 309

X -> Y and Y -> A

Answer 310

the same domain

Answer 311

the same name

Answer 312

different domains

Answer 313

different names

	Criado por хомяк убийца quase 7 anos atrás

Próximo

SDP 6 (2)

Descrição

Resumo de Recurso

Questão 1

Questão 2

Questão 3

Questão 4

Questão 5

Questão 6

Questão 7

Questão 8

Questão 9

Questão 10

Questão 11

Questão 12

Questão 13

Questão 14

Questão 15

Questão 16

Questão 17

Questão 18

Questão 19

Questão 20

Questão 21

Questão 22

Questão 23

Questão 24

Questão 25

Questão 26

Questão 27

Questão 28

Questão 29

Questão 30

Questão 31

Questão 32

Questão 33

Questão 34

Questão 35

Questão 36

Questão 37

Questão 38

Questão 39

Questão 40

Questão 41

Questão 42

Questão 43

Questão 44

Questão 45

Questão 46

Questão 47

Questão 48

Questão 49

Questão 50

Questão 51

Questão 52

Questão 53

Questão 54

Questão 55

Questão 56

Questão 57

Questão 58

Questão 59

Questão 60

Questão 61

Questão 62

Questão 63

Questão 64

Questão 65

Questão 66

Questão 67

Questão 68

Questão 69

Questão 70

Questão 71

Questão 72

Questão 73

Questão 74

Questão 75

Questão 76