Quiz
364 Practice Questions
This quiz has question types that open in the usual player.
Questions in this quiz (118)
1What command do you use to perform a query in SQL?
- AUSE
- BSELECT
- CQUERY
- DCHOSE
2What wildcard character retrieves all records with the SELECT command?
- A*
- B%
- C$
- D?
3What would you use to combine two parameters in a query in SQL
- APLUS
- BBOTH
- CCOMBINE
- DAND
4What clause would you use with the SELECT command that would pull records based on a range?
- ACOMBO
- BBETWEEN
- COR
- DCOMBINE
5What keyword used with the SELECT statement is used to not output specified records?
- AOR
- BDISALLOW
- CDISREGARD
- DNOT
6What would you use to combine columns from two different tables?
- AAND
- BBETWEEN
- CJOIN
- DCOMBINE
7Which clause used with the SELECT command will return values that you want to exclude from the normal parameters?
- AEXCEPT
- BINTERSECT
- CSEARCH
- DEXCLUDE
8What clause is used to combine related data from multiple table sources?
- ACOMBINE
- BAND
- CJOIN
- DPLUS
9What statement would you use to add data to a table?
- AADD
- BINSERT
- CJOIN
- DPRESENT
10What statement would you use to change data in a table?
- ACHANGE
- BMODIFY
- CINSERT
- DUPDATE
11What statement is used to delete one or more rows in a table?
- ADELETE
- BREMOVE
- CTRUNCATE
- DCHANGE
12What statement is used to delete a table from a database?
- ADELETE
- BDROP
- CREMOVE
- DTRUNCATE
13How can you prevent the accidental loss of an entire table?
- AUse the DELETE TRANS command
- BUse the LOOPBACK command.
- CUse the SAFEDELETE command.
- DUse referential integrity.
14What do you perform when you want to recall specific records from a database?
- Arecall
- Bvirtual extraction
- Creach
- Dquery
15What command would you use to delete a table while leaving the table structure in place for future use?
- ADELETE TABLE
- BTRUNCATE TABLE
- CREMOVE TABLE
- DSTOP TABLE
16What statement would you use to pull all records in which the State is CA from the Users table?
[blank_start]SELECT *[blank_end]
[blank_start]FROM Users[blank_end]
[blank_start]WHERE State = 'CA'[blank_end]- ASELECT *
- BFROM Users
- CWHERE State = 'CA'
17What statement would you use to pull First_Name and Last_Name from the Users table in which Gender is F and State is CA?
[blank_start]SELECT First_Name, Last_Name[blank_end]
[blank_start]FROM Users[blank_end]
[blank_start]WHERE Gender = 'F' AND State = 'CA'[blank_end]- AFROM Users
- BSELECT First_Name, Last_Name
- CWHERE Gender = 'F' AND State = 'CA'
18What statement would you use to list the First_Name and Last_Name from the Users table which Department is not IT?
[blank_start]SELECT First_Name, Last_Name[blank_end]
[blank_start]FROM Users[blank_end]
[blank_start]WHERE NOT Department = 'IT'[blank_end]- ASELECT First_Name, Last_Name
- BFROM Users
- CWHERE NOT Department = 'IT'
19What statement would you use to delete the Equipment table?
[blank_start]DROP TABLE Equipment[blank_end]- ADROP TABLE Equipment
20The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
- AView
- BFunction
- CIndex
- DStored procedure
- ETrigger
21One reason to add an index is to:
- ADecrease storage space.
- BIncrease database security.
- CImprove performance of select statements.
- DImprove performance of insert statements.
22You have the first table that contains the following data.
You break the table into the following two tables.
This process is referred to as:
- Adefragmentation
- Bnormalization
- Cfragmentation
- Ddenormalization
23You have a table that contains the following data.
Which database term is used to describe the relationship between ProductID and
ProductCategory?
- ACohort
- BRelationally dependent
- CDeterministic
- DFunctionally dependent
- ECompositional
24Which key uniquely identifies a row in a table?
- Aforeiqn
- Bprimary
- Clocal
- Dsuperkey
25Which statement creates a composite key?
- A
- B
- C
- D
- A
26What statement would you use to pull First_Name, Last_Name, and ID_Number from the Users table?
[blank_start]SELECT First_Name, Last_Name, ID_Number[blank_end]
[blank_start]FROM Users[blank_end]- ASELECT First_Name, Last_Name, ID_Number
- BFROM Users
27At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600
hours), you create a table named Customer and import data into the table. At 5:00 P.M.
(1700 hours), your server fails.
You run a script to apply only the 3:00 P.M. backup to your database. What is the result of
the script?- AThe Customer table no longer exists.
- BThe Customer table is unaffected
- CThe Customer table exists but has no data.
- DThe script fails.
28In which situation do you need to perform a restore on a database?
- Awhen data becomes corrupted in the database
- Bwhen you need to roll back a transaction
- Cwhen you encounter an error in your application
- Dwhen data needs to be deleted from the database
29Which command should you use to give a user permission to read the data in a table?
- AALLOW SELECT
- BLET READ
- CPERMIT READ
- DGRANT SELECT
30You need to enable a new employee to authenticate to your database.
Which command should you use?- AALLOW USER
- BCREATE USER
- CADD USER
- DINSERT USER
- EALTER USER
31Which keyword can be used in a create table statement?
- AORDER BY
- BDISTINCT
- CGROUP BY
- DUNIQUE
32You need to store product quantities, and you want to minimize the amount of storage
space that is used. Which data type should you use?- AINTEGER
- BDOUBLE
- CCOUNT
- DFLOAT
33Which statement will result in the creation of an index?
- A
- B
- C
- D
- A
34You have the following table definition:
CREATE TABLE Road
(RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)
You execute the following statement:
INSERT INTO Road VALUES (1234, 36)
What is the result?
- Aan error stating that NULL values are not allowed
- Ba new row in the table
- Can error stating that duplicate IDs are not allowed
- Da syntax error
35You need to store product names that vary from three to 30 characters. You also need to
minimize the amount of storage space that is used.
Which data type should you use?- AVARCHAR (3, 30)
- BCHAR (3, 30)
- CVARCHAR (30)
- DCHAR (30)
36One reason to create a stored procedure is to:
- AImprove performance.
- BMinimize storage space.
- CBypass case sensitivity requirements.
- DGive the user control of the query logic.
37Which permission does a user need in order to run a stored procedure?
- AEXECUTE
- BALLOW
- CCALL
- DRUN
38You have a table named Product. You create a view that includes all the products from the
Product table that are in the Furniture category.
You execute a statement on the Product table that deletes all the products in the Furniture
category.
After you execute the statement, the result set of the view is:- AEmpty
- BDeleted
- CUnchanged
- DArchived
39In SQL, an insert statement is used to add a:
- AUser to a database.
- BRow of data to a table.
- CTable to a database.
- DColumn to a table definition.
40Which of the following is NOT stored in the sysobjects system table?
- AFunctions
- BTriggers
- CConstraints
- DIndexes
41[blank_start]ADD[blank_end] is a reserved keyword in SQL SERVER 2008 and therefore cannot be used as an object name or as a column name in a table, unless delimited.
- AADD
- Bnone of the above
- CSUBTRACT
- DMINUS
42Which of the following range conditions would generate a syntax error?
- Asalary <= 50000 AND salary >= 10000
- Bsalary between (10000 AND 50000) AND (60000 and 90000)
- Csalary >=10000 AND salary <= 50000
- Dsalary BETWEEN 10000 AND 50000
43Which statement is false?
- AA table provides structure to store data.
- BA table can be created in a graphical interface and using syntax.
- CA database cannot parse out redundant data.
- DA database retrieves data from different tables and views.
44What is collation?
- AIt is data design and organizations process applied to data structures, based on rules that help building relational databases.
- BIt is a concept in SQL Server by which we can add other SQL Server to a group and query both the SQL Servers dbs using T-SQL statements.
- CIt means that the data in the db is organized so that all the data elements relating to the same real-world event or object are linked together.
- DIt refers to a set of rules that determine how data is sorted and compared
45Which of the following conditions will you use in a WHERE clause to select all last names that start with J?
- AWHERE LastName = 'J*'
- BWHERE LastName LIKE 'J%'
- CWHERE LastName = 'J%'
- DWHERE LastName LIKE 'J'
46What is the best data type to store the birthdays of the greatest scientists, starting with Leonardo Da Vinci's birthday of April 15, 1452?
- AINT
- BVARCHAR
- CDATETIME
- DSMALLDATETIME
47If you need to calculate a percentage value, what data type is the best option?
- AFloat
- BInteger
- CSmallInt
- DBigInt
48You have a column that will only contain from 0 to 1024. What is the most economical data type to use for the column?
- ASMALLINT
- BDECIMAL(3)
- CTINYINT
- DINT
49What is the statement used to suppress the '(1 row(s) affected.' after executing query statements?
- ASET NO COUNTING
- BSET NO COUNT
- CSET NO COUNTING ON
- DSET NOCOUNT ON
50Which of the following is not supported by the ALTER TABLE command?
- AModifying the data type of an existing column.
- BAdding a new column to a table.
- CChanging the IDENTITY constraint of an existing column
- DDeleting multiple columns from an existing table.
51If the data is May 1st 2011 at 09:23AM. What will be the result of the following SELECT statement?
SELECT GETDATE() + 3- A05/01/2014 09:23 AM
- B08/04/2011 09:23AM
- C05/04/2011 09:23AM
- DA SQL Server Database Error. A DATETIME value and an INT value cannot be added together.
52What will be the output of the following statement?
SELECT CHARINDEX('GM',"The best TTS solutions are provided by GMetrix', -1)- A8
- B1
- C39
- D40
- E0
53What will be the result of the following statement?
SELECT CAST (-1 AS SMALLDATETIME)- A1752-01-01 00:00:00.000
- B1752-12-31 00:00:00.000
- CThe system will generate an error. Only positive integer values can be converted to a SMALLDATETIME data type.
- D1900-01-01 00:00:00.000
54What will be the result of the following statement?
SELECT REPLACE ('The best TTS solutions is provided by GMetrix', 's', 'z')- ANone of the above
- BThe beszt TTSz szolutionsz isz provided by GMetrix
- CA SQL Server Orthographic error
- DThe bezt TTz zolutionz iz provided by GMetrix
55What command would you use to display all records from the clients table that have the state of New Mexico and the city of Roswell?
- ASELECT * FROM clients WHERE state = "New Mexico" AND City = "Roswell"
- BSELECT * FROM clients WHERE state = New Mexico AND City = Roswell
- CSELECT * FROM clients WHERE state = 'New Mexico' OR City = 'Roswell'
- DSELECT * FROM clients WHERE state = 'New Mexico' AND City = 'Roswell'
56What will be the results of the following statement?
CREATE VIEW cambridge_data AS SELECT NoControl, FullName FROM cambridge ORDER BY FullName- AA SQL Sever Database Error because the clause ORDER BY is not valid in the creation of a view.
- BA SQL Sever Database Error because the CREATE VIEW statement is not within a BEGIN/END block.
- CA SQL Sever Database Error because the same column cannot be used multiple times in the statement.
- DThe creation of a view called cambridge_date with the data ordered by the field FullName.
57What is the right way to get an accurate count of the number of records in a table?
- ASELECT * FROM table1
- BAll of the above
- CSELECT rows FROM sysindexes where name like 'IX_table1'
- DSELECT COUNT (*) FROM table1
58What is a subquery?
- AA query that displays only the rows that match in two joined tables.
- BA particular case when one table joins itself with one or more aliases to avoid confusion.
- CA join that displays only the rows even if they do not have related rows in the joined table.
- DA select statement that is nested within another T-SQL statement.
59SELECT STR(938.56, 6, 1)
- A938.56
- B938.5
- C0938.5
- D938.6
60What are the entities that can be viewed in the SQL Server Utility?
- AInstances of SQL Server, Data-Tier apps, Database Files, Volumes
- BDisks, Volumes, Users
- CInstances of SQL Server, Users, Store Procedures, Volumes
- DInstances of SQL Server, Store Procedures, Tables
61Which of the following could not be used as a primary key?
- AEmployee Number
- BSerial number for an electronic component
- CSocial Security Number
- DA table can contain only one FOREIGN key
62Which of the following can be used to improve query performance?
- AAll of the above
- BUNIQUE index
- CPRIMARY KEY
- DCLUSTERED index
63Which of the following statements is not true about a FOREIGN KEY?
- AA table can contain only one FOREIGN key.
- BYou can create a foreign key by defining a FOREIGN KEY constraint when you create or alter a table.
- CA FOREIGN KEY enforces referential integrity by ensuring only valid data is stored.
- DA foreign key is a combination of one or more columns used to establish and enforce a link between the data in two tables.
64Which of the following is NOT true about the PRIMARY KEY constraint?
- AIt is always created as CLUSTERED.
- BIt is a column that participates in the PRIMARY KEY constraint cannot accept NULL values.
- CIt can be composed of more than 1 column.
- DIt enforces data uniqueness by creating a unique index for the primary key columns.
65What is the DBCC command used for checking that tables in the db and the indexes are correctly linked?
- ACHECKLINK
- BCHECKDB
- CCHECKFILEGROUP
- DCHECKALLOC
66Which of the following is NOT a fixed server role?
- AAccessadmin
- BDiskadmin
- CSetupadmin
- DSecurityadmin
67The Cambridge db is acesses by several users in LA, regularly during business hours. You need to ensure that personnel cannot login on to db outside of normal business hours, which is defined as 8:00am to 5:00m, Monday through Saturday, what should you do?
- ACreate a logon trigger to prevent logons after normal business hours.
- BWrite a store procedure to respond to all logon events and prevent logons after hours.
- CCreate a SQL Server Agent job to shut down the server after 6:00pm and restart before 7:00am.
- DBroadcast a notification indicating the business hours.
68The Cambridge db is using full recovery model. You perform full backups once a week on Friday nights and differential backups every day. If the Cambridge db fails on Friday morning, what should you do first?
- ARestore the full backup
- BRestore the transaction log
- CBackup the transaction log
- DRestore the most recent differential backup
69[blank_start]Backup[blank_end] is the best method to prevent the loss of data.
- ABackup
- BRedundant NIC's
- CUPS
- DRAID
70We have the following table:
Name varchar(50)
Lastname varchar(50)
Email varchar(50)
Phone varchar(15)
If we need to store 100,000 records, the estimate size of the table will be:- A157.3563 MB
- B1.573563 GB
- C15.73563 MB
- D1.573563 MB
71How many files does Microsoft SQL Server use to store the database?
- A6
- B3
- C2
- D4
72What is the sub-language that allows user to insert, delete, and update data in a database?
- AT-SQL
- BDML
- CDDL
- DCRUD
73Which of these sentences is incorrect?
- ASELECT * FROM cambridge WHERE id IN (1,3,5)
- BSELECT * FROM cambridge WHERE id NOT IN (1,5)
- CSELECT * FROM cambridge WHEREid BETWEEN (1,5)
- DSELECT * FROM cambridge WHERE id <> (15)
74The DROP command allows you to [blank_start]permanently delete a database/table.[blank_end]
- Apermanently delete a database/table.
- Bcreate new objects like a database/table
- Cdelete a record from a table.
- Dmodify the definition of an object.
75Which three are T-SQL commands to handle privileges? (Choose three.)
- AREFUSE
- BDENY
- CPERMIT
- DGRANT
- ERECIND
- FREVOKE
76[blank_start]DROP LOGIN[blank_end] removes a SQL Server login account.
- ADROP LOGIN
- BDELETE LOGIN
- CDELETE USER
- DDROP USER
77What does SQL stand for?
- AStructured Question Language
- BStructured Query Language
- CStructured Query Log
- DStrong Question Language
78What are three types of databases?
- AContext Model, Associative Model, Entity-Attribute-Value (EAV) data model
- BOracle, DB2, SQL Server
- CNetwork Model, Relational Model, Object Oriented Model
- DRelational, Flat File, Hierarchical
79What is the maximum date value that can be stored in a SMALLDATETIME data type?
- AJune 6, 2079
- BDecember 31, 9999
- CJuly 6, 2079
- DDecember 31, 2079
80What is a view?
- AA virtual table created by a query joining one or more tables
- BA command to recover the content of a table.
- CA physical copy of a table
- DThe result of the execution of a query
81Which option is not a T-SQL command to handle privileges?
- APERMIT
- BDENY
- CREVOKE
- DGRANT
82What is a trigger?
- AA named group of SQL statements that have been previously created and stored in the server database.
- BA physical structure containing pointers to the data.
- CA subset of a table.
- DA SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs.
83The WHERE clause allows you to [blank_start]obtain a subset of rows.[blank_end]
- Aobtain a subset of rows.
- Bview a subset of columns.
- Cupdate the values inside record/records.
- Dorder a subset of rows.
84Consider a query of two tables. The results contains only the rows that have a match in both tables. What kind of JOIN was used?
- ARIGHT OUTER JOIN
- BINNER JOIN
- CLEFT OUTER JOIN
- DFULL OUTER JOIN
85What statement is used to retrieve data from a database?
- AREAD
- BSELECT
- CGET
- DEXTRACT
86The result of the query:
SELECT COUNT (*) from employees
will be:- AAll of the above.
- BAll the records that contains the character *.
- CAll the records of the table employees.
- DThe number of rows in the table employees.
87What is the result of the following query:
SELECT MAX (salary) from employee- AThe average salary of all employees.
- BThe salary of the employee with the highest value in the identifier column.
- CThe maximum salary of all employees.
- DThe salary of the employee called Max.
88What statement is used to remove a record from a table?
- AREMOVE
- BTRUNCATE
- CDELETE
- DERASE
89What does the following statment do?
SELECT DATEADD(DD, 0, DATEDIFF(DD, 0, GETDATE()))- AThe statement will generate an error. The second parameter of the DATEDIFF function should be a DATETIME data type.
- BReturn the current system date unchanged.
- CReturn the integer value of the current system date.
- DReturn just the date part of the current system date removing the time.
90How many levels of normal forms are there?
- A7
- B3
- C5
- D11
91What determines a database in the third normal form?
- AThe table faithfully represents a relation and has not repeating groups.
- BEvery non-prime attribute ins non-transitively dependent on every candidate key in the table.
- CEvery non-trivial join dependency in the table is implied by the superkeys of the table.
- DNo non-prime attribute in the table is functionally dependent on a proper subset of a candidate key.
92A unique constraint allows you to specify _________________.
- Aeach record in a database table.
- Bthe types of data a user can insert into the database.
- Cthat data is entered into a cell.
- Dwhich column should not contain duplicate values.
93An index allows you to ______________________.
- Aincrease the performance of a query.
- Border the columns in a table.
- Cwrite better queries.
- Ddefine the maximum size of a table.
94SQL code injection is _________________________.
- Aan insert statement.
- Ba technique that exploits security vulnerabilities in the db layer of an application.
- Cthe execution of a store procedure.
- Dthe use of SQL statements in high level languages.
95[blank_start]Dbcreator[blank_end] can create, alter, and resize databases.
- ADbcreator
- BDiskadmin
- CBulkadmin
- DSetupadmin
96Members of what fixed database role cannot add, modify or delete any data in the tables within a database, regardless of other roles?
- Adb_datareader
- Bdb_denydatawriter
- Cdb_backupoperator
- Ddb_ddladmin
97Which of the following fixed server roles can shut down the SQL Server?
- Aserveradmin
- Bprocessadmin
- Csecurityadmin
- Dsetupadmin
98What are the three different methods for which a user can be identified in Server Level security?
- ANone of the above.
- BWindows user login, SQL Server login, Use of Credentials
- CRoot, SA, SQL Server login
- DWindows user login, membership in a windows group, SQL Server login
99[blank_start]Full backup[blank_end] preserves data by creating multiple copies that are based on the differences in the data. A successive copy of the data contains only that portion which has changed sine the preceding copy has been created.
- AFull backup
- BDifferential backup
- CDaily backup
- DIncremental backup
100Which of the following, is the filename extension of Microsoft SQL Server transaction log?
- A.mdf
- B.ldf
- C.ndf
- D.log
101What type of data structure improves data recovery speed?
- Atri
- Bfilter
- CIndex
- DTransaction Log
102Which of the following is a collection of programs that enable you to capture, organize, and select data from a database?
- Adisk program
- Bgroup spreadsheets
- Capplication DAT
- DDBMS
103Which of the following defines a simple database using two-dimensional tables consisting of rows and columns?
- Aflat-type database
- Bhierarchical database
- CRelational Database
- Dtable as a database
104Which of the following refers to a database with multiple tables with parent / child relationships and a child can have more than one parent?
- Aflat file database
- Bhierarchical database
- CRelational Database
- Dtable as database
105Which allows multiple users to access both a SQL database?
- Adatabase server
- Bworkstation
- Ccollector
- Dcomputer located in the center of the building
106Among the following, which sets limits or rules placed on a file or a column to ensure that the data is considered valid for a database?
- Achecker
- Bvalidator
- Cscanner
- Dconstraint
107Among the following, which is the main tool used to configure the databases to Microsoft SQL Server?
- ADBS
- BSSMS
- CSQL Configuration Tool
- DODBC SQL emulator
108Which of the following is the language element allowing you to use statements, such as INSERT, UPDATE and DELETE to manipulate the data in any SQL Server table?
- ADML
- BDDE
- CDDL
- DDAT
109Which of the following statements is a T-SQL subset responsible for creating database objects such as tables and stored procedures?
- ADML
- BDDE
- CDDL
- DDAT
110Which statement type uses USE, CREATE, ALTER, and DROP?
- ADML
- BDDE
- CDDL
- DDAT
111Which of the following refers to the statement allowing you to delete the table in a SQL database?
- ADELETE
- BLED
- CDROP
- DREMOVE
112Which of the following refers to the statement that you can use to remove rows from a table?
- ASELECT
- BUPDATE
- CDELETE
- DSTOP
113Which of the following statements is the primary method to program and manage SQL Server?
- ADOS Commands
- BSQLCMD Scripts
- CXQuery
- DT-SQL
114Which of the following allows you to execute SQL commands in an application from the command line?
- ADOS Commands
- BSQLCMD Scripts
- CXQuery
- DTransact-SQK
115[blank_start]Database[blank_end] is an organized collection of data, usually stored electronically.
- ADatabase
116The main data files used on a Microsoft SQL server have an extension [blank_start].mdf[blank_end]
- A.mdf
117Which statement is used to add or remove columns in a table?
[blank_start]ALTER[blank_end]- AALTER
118What command can you use to change the context of the database?
[blank_start]USE[blank_end]- AUSE
Information
- Description
- 98-364 Database Fundamentals Quiz on 364 Practice Questions, created by sharcondria_salo on 09/10/2015.
- Author
- sharcondria_salo
- Language
- English
- Views
- 121
- Tags
- Rating
- 5.0 out of 5 · 1 rating Rate this quiz