Kopieren und bearbeiten

DatabaseDesignFinal

Beschreibung

Quiz am DatabaseDesignFinal, erstellt von Dias Khalelov am 29/12/2016.
Dias Khalelov
Quiz von Dias Khalelov, aktualisiert more than 1 year ago
Dias Khalelov
Erstellt von Dias Khalelov vor fast 8 Jahre
816
2
0

Zusammenfassung der Ressource

Frage 1

Frage
The __operator returns all tuples in one relation that are not found in the other relation.
Antworten
  • Select
  • None
  • intersect
  • difference

Frage 2

Frage
The__ operator combines all tuples from two relations excluding duplicates.
Antworten
  • Intersect
  • difference
  • union
  • divide

Frage 3

Frage
The HAVING clause does which of the following?
Antworten
  • Acts like a WHERE clause but HAVING is used for columns rather than groups.
  • Acts like a WHERE clause but HAVING is used for rows rather than columns.
  • Acts like a WHERE clause but HAVING is used for groups rather than rows.
  • Acts EXACTLY like a WHERE clause.

Frage 4

Frage
The NULL SQL keyword is used to…
Antworten
  • Represent 0 value
  • Represent a missing or unknown value. NULL in SQL represents nothing.
  • Represent positive infinity
  • Represent negative infinity

Frage 5

Frage
The SQL BETWEEN operator..
Antworten
  • None of the given
  • Specifies which tables we are selecting from
  • Specifies that a column is a primary key
  • Specifies a range to test

Frage 6

Frage
The AVG SQL function return the…
Antworten
  • Maximum value from a column
  • Average number of rows in all tables
  • Average value in a column
  • The sum of values in a column

Frage 7

Frage
The command to remove row from CUSTOMER table is:
Antworten
  • REMOVE FROM customer
  • DROP FROM customer
  • UPDATE FROM customer
  • DELETE FROM customer WHERE…

Frage 8

Frage
What type of join is needed when you wish to include rows that do not have matching values?
Antworten
  • OUTER and INNER JOIN
  • INNER JOIN
  • OUTER JOIN
  • None of the given

Frage 9

Frage
What does the following SQL statement do: SELECT Customer, COUNT(Order) FROM Sales GROUP BY Customer HAVING COUNT (Order)>5
Antworten
  • Selects the total number of orders from the Sales table, if this number is greater than 5
  • Selects all customers with number of orders from table Sales that have made more than 5 orders
  • None of the give
  • Selects all customers from the Sales table

Frage 10

Frage
What operator tests column for the absence of data ?
Antworten
  • NOT operator
  • IS NULL operator
  • EXIST operator
  • None of the given

Frage 11

Frage
What does the SQL FROM clause do?
Antworten
  • Specifies a search condition
  • None of the given
  • Specifies the columns we are retrieving
  • Specifies the table to retrieve rows from

Frage 12

Frage
What does follow after the SQL SELECT clause?
Antworten
  • None of the given
  • List of columns that will selected or the * symbol
  • Selection condition
  • The name of the table we are selecting from

Frage 13

Frage
What is the keyword you would use before adding conditions to your query?
Antworten
  • EQUALS
  • WHAT
  • CONDITIONS
  • WHERE

Frage 14

Frage
What is meant by the following relational statement STUDENT X COURSE ?
Antworten
  • Compute the full outer join between the STUDENT and COURSE relations
  • Compute the left outer join between the STUDENT and COURSE relations
  • Compute the right outer join between the STUDENT and COURSE relations
  • Compute the cartesian between the STUDENT and COURSE relations

Frage 15

Frage
What does follow after the SQL WHERE clause?
Antworten
  • List of columns to be selected
  • None of the given
  • Name of the table we are selecting from
  • Selection condition

Frage 16

Frage
What is meant by the term union compatibility?
Antworten
  • None
  • When two or more tables share the same (or compatible) domains
  • When two or more tables share the same number of columns and when they share the same domains
  • When two or more tables share the same number of columns

Frage 17

Frage
What keyword can you use to search for a string in a column?
Antworten
  • FIND STRING
  • LIKE
  • CONTAINS STRING
  • HAS STRING

Frage 18

Frage
What is the meaning of LIKE ‘%0%0%’
Antworten
  • Feature begins with the two 0’s
  • Feature ends with two 0’s
  • Feature has more than two 0’s
  • Feature has two 0’s in it, at any position

Frage 19

Frage
What is the purpose of the SQL AS clause?
Antworten
  • The AS clause is used with the aggregate functions only
  • None of the given
  • The AS clause defines a search condition
  • The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column

Frage 20

Frage
Which product is returned in a join query have no join condition:
Antworten
  • None
  • Equijoins
  • Both
  • Cartesian

Frage 21

Frage
Which SQL statement will selects all rows from a table called “Customers” and orders the result by “customer name” ?
Antworten
  • SELECT * FROM Customers ORDERED customer_name
  • SELECT * FROM Customers ORDERED BY’ customer_name
  • SELECT * FROM Customers ORDER customer_name
  • SELECT * FROM Customers ORDER ON customer_name

Frage 22

Frage
Which SQL statement is used to extract data from a database?
Antworten
  • EXTRACT
  • OPEN
  • SELECT
  • GET

Frage 23

Frage
Which of the following is a legal expression in SQL?
Antworten
  • SELECT NULL FROM Employee;
  • SELECT name FROM Employee WHEN salary = NULL;
  • None of the given
  • SELECT name FROM Employee;

Frage 24

Frage
Which SQL keyword is used to retrieve a maximum value?
Antworten
  • TOP
  • MOST
  • UPPER
  • MAX

Frage 25

Frage
Which SQL statement is used to return only different (unique) values?
Antworten
  • SELECT *
  • SELECT DISTINCT
  • SELECT DIFFERENT
  • SELECT UNIQUE

Frage 26

Frage
Which one of the following sorts rows in SQL?
Antworten
  • ORDER BY
  • GROUP BY
  • ALIGN BY
  • SORT BY

Frage 27

Frage
Which of the following are the five built-in functions provided by SQL?
Antworten
  • SUM,AVG,MULT,DIV,MIN
  • SUM,AVG,MIN,MAX,MULT
  • SUM,AVG,MIN,MAX,NAME
  • COUNT,SUM,AVG,MAX,MIN

Frage 28

Frage
Which of the following is the correct order of keywords for SQL SELECT statements?
Antworten
  • FROM,WHERE,SELECT
  • SELECT,WHERE,FROM
  • WHERE,FROM,SELECT
  • SELECT,FROM,WHERE

Frage 29

Frage
Which SQL keyword is used to sort the result set?
Antworten
  • ⦁ ORDER BY
  • ⦁ SORT
  • ⦁ FILTER
  • ⦁ SORT BY

Frage 30

Frage
Which of the following is NOT a relational algebra operators used in basic queries?
Antworten
  • ⦁ Select
  • ⦁ Locate
  • ⦁ Project
  • ⦁ Join

Frage 31

Frage
Which of the following is not a SQL database manipulation statement?
Antworten
  • ⦁ SELECT
  • ⦁ CREATE TABLE
  • ⦁ DELETE
  • ⦁ UPDATE

Frage 32

Frage
Which of the following SQL statements deletes all rows in table called SalesData?
Antworten
  • ⦁ DELETE FROM SalesData
  • ⦁ DELETE * FROM SalesData
  • ⦁ DELETE ALL SalesData
  • ⦁ DELETE SalesData

Frage 33

Frage
Which of the following is an SQL aggregate function?
Antworten
  • ⦁ ALTER
  • ⦁ MIN
  • ⦁ BETWEEN
  • ⦁ CREATE

Frage 34

Frage
Which of the following is not DML statement?
Antworten
  • ⦁ UPDATE
  • ⦁ INSERT
  • ⦁ ALTER TABLE
  • ⦁ DELETE

Frage 35

Frage
With SQL, how do you select all the columns from a table named “Persons”?
Antworten
  • ⦁ SELECT *.Persons;
  • ⦁ SELECT [all] FROM Persons;
  • ⦁ SELECT * FROM Persons;
  • ⦁ SELECT Persons;

Frage 36

Frage
With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?
Antworten
  • ⦁ SELECT * FROM Persons SORT BY ‘FirstName’ DESC;
  • ⦁ SELECT * FROM Persons ORDER BY FirstName DESC;
  • ⦁ SELECT * FROM Persons SORT ‘FirstName’ DESC;
  • ⦁ SELECT * FROM Persons ORDER FirstName DESC;

Frage 37

Frage
With SQL, how can you return the number of records in the “Persons” table?
Antworten
  • ⦁ SELECT COLUMNS(*) FROM Persons
  • ⦁ SELECT COUNT() FROM Persons
  • ⦁ SELECT COLUMNS() FROM Persons
  • ⦁ SELECT COUNT(*) FROM Persons

Frage 38

Frage
With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” is “Peter”?
Antworten
  • ⦁ SELECT * FROM Persons WHERE FirstName = ‘Peter’
  • ⦁ SELECT [all] FROM Persons WHERE FirstName = ‘Peter’
  • ⦁ SELECT [all] FROM Persons WHERE FirstName LIKE ‘Peter’
  • ⦁ SELECT * FROM Persons WHERE FirstName <> ‘Peter

Frage 39

Frage
With SQL, how do you select all the records from a table named “Persons” where the “FirstName” is ”Peter” and the “LastName” is “Jackson”?
Antworten
  • ⦁ SELECT * FROM Persons WHERE LastName = ‘Jackson’;
  • ⦁ SELECT FirstName = ’Peter’, LastName = ‘Jackson’ FROM Persons;
  • ⦁ SELECT * FROM Persons WHERE FirstName <> ‘Peter’ AND LastName<>’Jackson’;
  • ⦁ SELECT * FROM Persons WHERE FirstName = ‘Peter’ AND LastName =’Jackson’;

Frage 40

Frage
How to select all data from student table starting the name from letter ’r’ ?
Antworten
  • ⦁ SELECT * FROM student WHERE name LIKE ‘%’
  • ⦁ SELECT * FROM student WHERE name LIKE ‘%r’
  • ⦁ SELECT * FROM student WHERE name LIKE ‘r%’
  • ⦁ SELECT * FROM student WHERE name LIKE ‘%r%’

Frage 41

Frage
SQL query and data modification commands make up a(n)___
Antworten
  • ⦁ DCL
  • ⦁ DDL
  • ⦁ DML
  • ⦁ TCL

Frage 42

Frage
DML is used to
Antworten
  • ⦁ Add and delete tables
  • ⦁ Add/modify/delete data in the database
  • ⦁ Specify the structure of a database
  • ⦁ Manipulate the structure of database applications

Frage 43

Frage
If you want to apply second condition to your statement where both statements must be true, what keyword would you use between the conditions?
Antworten
  • ⦁ AND
  • ⦁ TRUE
  • ⦁ WHERE
  • ⦁ BOTH

Frage 44

Frage
Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79
Antworten
  • ⦁ SELECT *FROM weather WHERE humidity NOT BETWEEN 63 AND 79
  • ⦁ SELECT *FROM weather WHERE humidity BETWEEN 63 AND 79
  • ⦁ SELECT *FROM weather WHERE humidity = 63 to 79
  • ⦁ SELECT *FROM weather WHERE humidity 63 AND 79

Frage 45

Frage
Like operator uses __ and ___.
Antworten
  • ⦁ Asterisk(*); percent sign(%)
  • ⦁ Question mark(?); asterisk(*)
  • ⦁ Percent sign(%); underscore(_)
  • ⦁ Underscore(_); question mark(?)

Frage 46

Frage
You can add a row using SQL in a database with which of the following?
Antworten
  • ⦁ ADD
  • ⦁ MAKE
  • ⦁ INSERT
  • ⦁ CREATE

Frage 47

Frage
A subquery in an SQL SELECT statement is enclosed in:
Antworten
  • ⦁ Braces - {…}
  • ⦁ CAPITAL LETTERS
  • ⦁ Parenthesis - (…)
  • ⦁ Brackets – […]

Frage 48

Frage
Which of the SQL statements is correct?
Antworten
  • SELECT Username, Password WHERE Username = 'user1'
  • SELECT Username AND Password FROM Users
  • None of the given
  • SELECT Username, Password FROM Users

Frage 49

Frage
Which of the following is a DML statement?
Antworten
  • DROP TABLE
  • ALTER TABLE
  • CREATE TABLE
  • SELECT

Frage 50

Frage
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"?
Antworten
  • SELECT * FROM Persons WHERE FirstName='a';
  • SELECT * FROM Persons WHERE FirstName LIKE '%a';
  • SELECT * FROM Persons WHERE FirstName='%a%';
  • SELECT * FROM Persons WHERE FirstName LIKE 'a%';

Frage 51

Frage
What SQL structure is used to limit column values of a table?
Antworten
  • None of the given
  • The VALUE constraint
  • The CHECK constraint
  • The LIMIT constraint

Frage 52

Frage
Which of the following is used to denote the projection operation in relational algebra?
Antworten
  • Pi (Greek)
  • Lambda (Greek)
  • Omega (Greek)
  • Sigma (Greek)

Frage 53

Frage
To define what columns should be displayed in an SQL SELECT statement:
Antworten
  • use USING to name the source table(s) and list the columns to be shown after WHERE.
  • use USING to name the source table(s) and list the columns to be shown after SELECT.
  • use FROM to name the source table(s) and list the columns to be shown after SELECT.
  • use SELECT to name the source table(s) and list the columns to be shown after USING.

Frage 54

Frage
In the query "SELECT address FROM users", what is the column being selected?
Antworten
  • FROM
  • SELECT
  • address
  • users

Frage 55

Frage
Which of the following is used to denote the selection operation in relational algebra?
Antworten
  • Sigma (Greek)
  • Pi (Greek)
  • Lambda (Greek)
  • Omega (Greek)

Frage 56

Frage
Which of the following SQL statements will select all records with all their columns from a table called Sales.
Antworten
  • DELETE FROM Sales
  • None of the given
  • SELECT * FROM Sales
  • SELECT * FROM SALES WHERE OrderID < 1

Frage 57

Frage
To eliminate duplicate values in a column ______ is used
Antworten
  • DISTINCT
  • NODUPLICATE
  • None of these
  • ELIMINATE

Frage 58

Frage
Which SQL functions is used to count the number of rows?
Antworten
  • COUNTOF()
  • SUM()
  • COUNT()
  • NUMBER()

Frage 59

Frage
_____ specifies a search condition for a group or an aggregate function
Antworten
  • ⦁ FROM Clause
  • ⦁ GROUP BY Clause
  • ⦁ HAVING Clause
  • ⦁ WHERE Clause

Frage 60

Frage
What will be the result of the following SQL statement: SELECT * FROM Table1 HAVING Column1 > 10
Antworten
  • a. None of the given
  • b. The SQL statement will generate an error
  • c. The result will be empty data set
  • d. The result will be all rows from Table1 which have Column1 values greater than 10

Frage 61

Frage
The result of an SQL SELECT statement is a(n) _____
Antworten
  • table
  • form
  • report
  • file

Frage 62

Frage
What keyword would you use to group your results by a column’s values?
Antworten
  • ORDER BY
  • BY
  • JOIN
  • GROUP BY

Frage 63

Frage
With SQL, how do you select a column named “FistName” from a table named “Persons”?
Antworten
  • SELECT FirstName FROM Persons;
  • SELECT Persons.FirstName
  • None of the given
  • EXTRACT FirstName FROM Persons

Frage 64

Frage
SQL can be used:
Antworten
  • modify database data only
  • All of the given can be done by SQL
  • query database data only
  • create database structure only

Frage 65

Frage
Which SQL keyword is used to specify conditional search?
Antworten
  • FIND
  • SELECT
  • WHERE
  • SEARCH

Frage 66

Frage
Which of the following is an SQL aggregate function
Antworten
  • SELECT
  • JOIN
  • DISTINCT
  • AVG

Frage 67

Frage
In an SQL SELECT statement querying a single table, the asterisk(*) means that:
Antworten
  • None of the given
  • all records meeting the full criteria are to be returned
  • all columns of the table are to be returned.
  • all records with even partial criteria met are to be returned
Zusammenfassung anzeigen Zusammenfassung ausblenden

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

ähnlicher Inhalt

Abitur Geschichte
benutzer343
C1 Indirekte Rede
Anna Kania
Unsere Erde - Sonnensystem, Klima, Erdschichten etc.
rezension1
Klinische Psychologie-Grundlagen
evasophie
Arbeitsrecht (Fragen)
Maximilian Mustermann
AOW-Verständnisfragen
Lisa-Maria Hauschild
Vetie - Histo & Embryo - P 2017
Fioras Hu
Vetie - Klausur Tierhaltung und Tierhygiene 2018
E. König
Parasitologie 2019
Peter Christian Ponn
Vetie - Tierseuchenbekämpfung 2016
Peter Christian Ponn
Vetie - Milch 2021
Valerie Nymphe
Bibliothek durchsuchen