Copiar y Editar

DatabaseDesignFinal

Descripción

Test sobre DatabaseDesignFinal, creado por Dias Khalelov el 29/12/2016.
Dias Khalelov
Test por Dias Khalelov, actualizado hace más de 1 año
Dias Khalelov
Creado por Dias Khalelov hace más de 7 años
801
2
0

Resumen del Recurso

Pregunta 1

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

Pregunta 2

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

Pregunta 3

Pregunta
The HAVING clause does which of the following?
Respuesta
  • 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.

Pregunta 4

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

Pregunta 5

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

Pregunta 6

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

Pregunta 7

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

Pregunta 8

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

Pregunta 9

Pregunta
What does the following SQL statement do: SELECT Customer, COUNT(Order) FROM Sales GROUP BY Customer HAVING COUNT (Order)>5
Respuesta
  • 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

Pregunta 10

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

Pregunta 11

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

Pregunta 12

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

Pregunta 13

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

Pregunta 14

Pregunta
What is meant by the following relational statement STUDENT X COURSE ?
Respuesta
  • 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

Pregunta 15

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

Pregunta 16

Pregunta
What is meant by the term union compatibility?
Respuesta
  • 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

Pregunta 17

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

Pregunta 18

Pregunta
What is the meaning of LIKE ‘%0%0%’
Respuesta
  • 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

Pregunta 19

Pregunta
What is the purpose of the SQL AS clause?
Respuesta
  • 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

Pregunta 20

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

Pregunta 21

Pregunta
Which SQL statement will selects all rows from a table called “Customers” and orders the result by “customer name” ?
Respuesta
  • 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

Pregunta 22

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

Pregunta 23

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

Pregunta 24

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

Pregunta 25

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

Pregunta 26

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

Pregunta 27

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

Pregunta 28

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

Pregunta 29

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

Pregunta 30

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

Pregunta 31

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

Pregunta 32

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

Pregunta 33

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

Pregunta 34

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

Pregunta 35

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

Pregunta 36

Pregunta
With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?
Respuesta
  • ⦁ 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;

Pregunta 37

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

Pregunta 38

Pregunta
With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” is “Peter”?
Respuesta
  • ⦁ 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

Pregunta 39

Pregunta
With SQL, how do you select all the records from a table named “Persons” where the “FirstName” is ”Peter” and the “LastName” is “Jackson”?
Respuesta
  • ⦁ 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’;

Pregunta 40

Pregunta
How to select all data from student table starting the name from letter ’r’ ?
Respuesta
  • ⦁ 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%’

Pregunta 41

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

Pregunta 42

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

Pregunta 43

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

Pregunta 44

Pregunta
Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79
Respuesta
  • ⦁ 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

Pregunta 45

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

Pregunta 46

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

Pregunta 47

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

Pregunta 48

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

Pregunta 49

Pregunta
Which of the following is a DML statement?
Respuesta
  • DROP TABLE
  • ALTER TABLE
  • CREATE TABLE
  • SELECT

Pregunta 50

Pregunta
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"?
Respuesta
  • 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%';

Pregunta 51

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

Pregunta 52

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

Pregunta 53

Pregunta
To define what columns should be displayed in an SQL SELECT statement:
Respuesta
  • 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.

Pregunta 54

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

Pregunta 55

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

Pregunta 56

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

Pregunta 57

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

Pregunta 58

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

Pregunta 59

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

Pregunta 60

Pregunta
What will be the result of the following SQL statement: SELECT * FROM Table1 HAVING Column1 > 10
Respuesta
  • 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

Pregunta 61

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

Pregunta 62

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

Pregunta 63

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

Pregunta 64

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

Pregunta 65

Pregunta
Which SQL keyword is used to specify conditional search?
Respuesta
  • FIND
  • SELECT
  • WHERE
  • SEARCH

Pregunta 66

Pregunta
Which of the following is an SQL aggregate function
Respuesta
  • SELECT
  • JOIN
  • DISTINCT
  • AVG

Pregunta 67

Pregunta
In an SQL SELECT statement querying a single table, the asterisk(*) means that:
Respuesta
  • 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
Mostrar resumen completo Ocultar resumen completo

¿Quieres crear tus propios Tests gratis con GoConqr? Más información.

Similar

Animales y sus Características
Diego Santos
ADMINISTRACION
edward.chonon
La transición a la democracia
ignaciobll
8 Frases de Ánimo que te Motivarán en la Vuelta a Clase
maya velasquez
Factorización
maya velasquez
INGENIERIA DE LAS TELECOMUNICACIONES
Alejandra Diaz Ibarra
Plantilla para Presentar Trabajos con Mapas Mentales
Diego Santos
Mapa Mental Administración Financiera
Cristian Neftalí
Antibióticos
Romina Andrea C Pino
INGENIERÍA CIVÍL QUÍMICA
camila.bertiola
El proyecto de empresa
belenssdl
Explorar la Librería