Kopieren und bearbeiten

364 Practice Questions

Beschreibung

98-364 Database Fundamentals Quiz am 364 Practice Questions, erstellt von sharcondria_salo am 09/10/2015.
sharcondria_salo
Quiz von sharcondria_salo, aktualisiert more than 1 year ago
sharcondria_salo
Erstellt von sharcondria_salo vor etwa 9 Jahre
54
0
0

Zusammenfassung der Ressource

Frage 1

Frage
What command do you use to perform a query in SQL?
Antworten
  • USE
  • SELECT
  • QUERY
  • CHOSE

Frage 2

Frage
What wildcard character retrieves all records with the SELECT command?
Antworten
  • *
  • %
  • $
  • ?

Frage 3

Frage
What would you use to combine two parameters in a query in SQL
Antworten
  • PLUS
  • BOTH
  • COMBINE
  • AND

Frage 4

Frage
What clause would you use with the SELECT command that would pull records based on a range?
Antworten
  • COMBO
  • BETWEEN
  • OR
  • COMBINE

Frage 5

Frage
What keyword used with the SELECT statement is used to not output specified records?
Antworten
  • OR
  • DISALLOW
  • DISREGARD
  • NOT

Frage 6

Frage
What would you use to combine columns from two different tables?
Antworten
  • AND
  • BETWEEN
  • JOIN
  • COMBINE

Frage 7

Frage
Which clause used with the SELECT command will return values that you want to exclude from the normal parameters?
Antworten
  • EXCEPT
  • INTERSECT
  • SEARCH
  • EXCLUDE

Frage 8

Frage
What clause is used to combine related data from multiple table sources?
Antworten
  • COMBINE
  • AND
  • JOIN
  • PLUS

Frage 9

Frage
What statement would you use to add data to a table?
Antworten
  • ADD
  • INSERT
  • JOIN
  • PRESENT

Frage 10

Frage
What statement would you use to change data in a table?
Antworten
  • CHANGE
  • MODIFY
  • INSERT
  • UPDATE

Frage 11

Frage
What statement is used to delete one or more rows in a table?
Antworten
  • DELETE
  • REMOVE
  • TRUNCATE
  • CHANGE

Frage 12

Frage
What statement is used to delete a table from a database?
Antworten
  • DELETE
  • DROP
  • REMOVE
  • TRUNCATE

Frage 13

Frage
How can you prevent the accidental loss of an entire table?
Antworten
  • Use the DELETE TRANS command
  • Use the LOOPBACK command.
  • Use the SAFEDELETE command.
  • Use referential integrity.

Frage 14

Frage
What do you perform when you want to recall specific records from a database?
Antworten
  • recall
  • virtual extraction
  • reach
  • query

Frage 15

Frage
What command would you use to delete a table while leaving the table structure in place for future use?
Antworten
  • DELETE TABLE
  • TRUNCATE TABLE
  • REMOVE TABLE
  • STOP TABLE

Frage 16

Frage
What 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]
Antworten
  • SELECT *
  • FROM Users
  • WHERE State = 'CA'

Frage 17

Frage
What 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]
Antworten
  • FROM Users
  • SELECT First_Name, Last_Name
  • WHERE Gender = 'F' AND State = 'CA'

Frage 18

Frage
What 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]
Antworten
  • SELECT First_Name, Last_Name
  • FROM Users
  • WHERE NOT Department = 'IT'

Frage 19

Frage
What statement would you use to delete the Equipment table? [blank_start]DROP TABLE Equipment[blank_end]
Antworten
  • DROP TABLE Equipment

Frage 20

Frage
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
Antworten
  • View
  • Function
  • Index
  • Stored procedure
  • Trigger

Frage 21

Frage
One reason to add an index is to:
Antworten
  • Decrease storage space.
  • Increase database security.
  • Improve performance of select statements.
  • Improve performance of insert statements.

Frage 22

Frage
You have the first table that contains the following data. You break the table into the following two tables. This process is referred to as:
Image:
cd32e289-8ed7-415f-b593-26f7a9c70c69 (image/jpeg)
Antworten
  • defragmentation
  • normalization
  • fragmentation
  • denormalization

Frage 23

Frage
You have a table that contains the following data. Which database term is used to describe the relationship between ProductID and ProductCategory?
Image:
670ac789-3bcb-4de3-ace4-78fd11296609 (image/jpeg)
Antworten
  • Cohort
  • Relationally dependent
  • Deterministic
  • Functionally dependent
  • Compositional

Frage 24

Frage
Which key uniquely identifies a row in a table?
Antworten
  • foreiqn
  • primary
  • local
  • superkey

Frage 25

Frage
Which statement creates a composite key?
Antworten

Frage 26

Frage
What 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]
Antworten
  • SELECT First_Name, Last_Name, ID_Number
  • FROM Users

Frage 27

Frage
At 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?
Antworten
  • The Customer table no longer exists.
  • The Customer table is unaffected
  • The Customer table exists but has no data.
  • The script fails.

Frage 28

Frage
In which situation do you need to perform a restore on a database?
Antworten
  • when data becomes corrupted in the database
  • when you need to roll back a transaction
  • when you encounter an error in your application
  • when data needs to be deleted from the database

Frage 29

Frage
Which command should you use to give a user permission to read the data in a table?
Antworten
  • ALLOW SELECT
  • LET READ
  • PERMIT READ
  • GRANT SELECT

Frage 30

Frage
You need to enable a new employee to authenticate to your database. Which command should you use?
Antworten
  • ALLOW USER
  • CREATE USER
  • ADD USER
  • INSERT USER
  • ALTER USER

Frage 31

Frage
Which keyword can be used in a create table statement?
Antworten
  • ORDER BY
  • DISTINCT
  • GROUP BY
  • UNIQUE

Frage 32

Frage
You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?
Antworten
  • INTEGER
  • DOUBLE
  • COUNT
  • FLOAT

Frage 33

Frage
Which statement will result in the creation of an index?
Antworten

Frage 34

Frage
You 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?
Image:
13c4a9d1-28f1-4616-9e84-09fdcdb9286d (image/jpeg)
Antworten
  • an error stating that NULL values are not allowed
  • a new row in the table
  • an error stating that duplicate IDs are not allowed
  • a syntax error

Frage 35

Frage
You 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?
Antworten
  • VARCHAR (3, 30)
  • CHAR (3, 30)
  • VARCHAR (30)
  • CHAR (30)

Frage 36

Frage
One reason to create a stored procedure is to:
Antworten
  • Improve performance.
  • Minimize storage space.
  • Bypass case sensitivity requirements.
  • Give the user control of the query logic.

Frage 37

Frage
Which permission does a user need in order to run a stored procedure?
Antworten
  • EXECUTE
  • ALLOW
  • CALL
  • RUN

Frage 38

Frage
You 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:
Antworten
  • Empty
  • Deleted
  • Unchanged
  • Archived

Frage 39

Frage
In SQL, an insert statement is used to add a:
Antworten
  • User to a database.
  • Row of data to a table.
  • Table to a database.
  • Column to a table definition.

Frage 40

Frage
Which of the following is NOT stored in the sysobjects system table?
Antworten
  • Functions
  • Triggers
  • Constraints
  • Indexes

Frage 41

Frage
[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.
Antworten
  • ADD
  • none of the above
  • SUBTRACT
  • MINUS

Frage 42

Frage
Which of the following range conditions would generate a syntax error?
Antworten
  • salary <= 50000 AND salary >= 10000
  • salary between (10000 AND 50000) AND (60000 and 90000)
  • salary >=10000 AND salary <= 50000
  • salary BETWEEN 10000 AND 50000

Frage 43

Frage
Which statement is false?
Antworten
  • A table provides structure to store data.
  • A table can be created in a graphical interface and using syntax.
  • A database cannot parse out redundant data.
  • A database retrieves data from different tables and views.

Frage 44

Frage
What is collation?
Antworten
  • It is data design and organizations process applied to data structures, based on rules that help building relational databases.
  • It 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.
  • It 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.
  • It refers to a set of rules that determine how data is sorted and compared

Frage 45

Frage
Which of the following conditions will you use in a WHERE clause to select all last names that start with J?
Antworten
  • WHERE LastName = 'J*'
  • WHERE LastName LIKE 'J%'
  • WHERE LastName = 'J%'
  • WHERE LastName LIKE 'J'

Frage 46

Frage
What is the best data type to store the birthdays of the greatest scientists, starting with Leonardo Da Vinci's birthday of April 15, 1452?
Antworten
  • INT
  • VARCHAR
  • DATETIME
  • SMALLDATETIME

Frage 47

Frage
If you need to calculate a percentage value, what data type is the best option?
Antworten
  • Float
  • Integer
  • SmallInt
  • BigInt

Frage 48

Frage
You have a column that will only contain from 0 to 1024. What is the most economical data type to use for the column?
Antworten
  • SMALLINT
  • DECIMAL(3)
  • TINYINT
  • INT

Frage 49

Frage
What is the statement used to suppress the '(1 row(s) affected.' after executing query statements?
Antworten
  • SET NO COUNTING
  • SET NO COUNT
  • SET NO COUNTING ON
  • SET NOCOUNT ON

Frage 50

Frage
Which of the following is not supported by the ALTER TABLE command?
Antworten
  • Modifying the data type of an existing column.
  • Adding a new column to a table.
  • Changing the IDENTITY constraint of an existing column
  • Deleting multiple columns from an existing table.

Frage 51

Frage
If the data is May 1st 2011 at 09:23AM. What will be the result of the following SELECT statement? SELECT GETDATE() + 3
Antworten
  • 05/01/2014 09:23 AM
  • 08/04/2011 09:23AM
  • 05/04/2011 09:23AM
  • A SQL Server Database Error. A DATETIME value and an INT value cannot be added together.

Frage 52

Frage
What will be the output of the following statement? SELECT CHARINDEX('GM',"The best TTS solutions are provided by GMetrix', -1)
Antworten
  • 8
  • 1
  • 39
  • 40
  • 0

Frage 53

Frage
What will be the result of the following statement? SELECT CAST (-1 AS SMALLDATETIME)
Antworten
  • 1752-01-01 00:00:00.000
  • 1752-12-31 00:00:00.000
  • The system will generate an error. Only positive integer values can be converted to a SMALLDATETIME data type.
  • 1900-01-01 00:00:00.000

Frage 54

Frage
What will be the result of the following statement? SELECT REPLACE ('The best TTS solutions is provided by GMetrix', 's', 'z')
Antworten
  • None of the above
  • The beszt TTSz szolutionsz isz provided by GMetrix
  • A SQL Server Orthographic error
  • The bezt TTz zolutionz iz provided by GMetrix

Frage 55

Frage
What command would you use to display all records from the clients table that have the state of New Mexico and the city of Roswell?
Antworten
  • SELECT * FROM clients WHERE state = "New Mexico" AND City = "Roswell"
  • SELECT * FROM clients WHERE state = New Mexico AND City = Roswell
  • SELECT * FROM clients WHERE state = 'New Mexico' OR City = 'Roswell'
  • SELECT * FROM clients WHERE state = 'New Mexico' AND City = 'Roswell'

Frage 56

Frage
What will be the results of the following statement? CREATE VIEW cambridge_data AS SELECT NoControl, FullName FROM cambridge ORDER BY FullName
Antworten
  • A SQL Sever Database Error because the clause ORDER BY is not valid in the creation of a view.
  • A SQL Sever Database Error because the CREATE VIEW statement is not within a BEGIN/END block.
  • A SQL Sever Database Error because the same column cannot be used multiple times in the statement.
  • The creation of a view called cambridge_date with the data ordered by the field FullName.

Frage 57

Frage
What is the right way to get an accurate count of the number of records in a table?
Antworten
  • SELECT * FROM table1
  • All of the above
  • SELECT rows FROM sysindexes where name like 'IX_table1'
  • SELECT COUNT (*) FROM table1

Frage 58

Frage
What is a subquery?
Antworten
  • A query that displays only the rows that match in two joined tables.
  • A particular case when one table joins itself with one or more aliases to avoid confusion.
  • A join that displays only the rows even if they do not have related rows in the joined table.
  • A select statement that is nested within another T-SQL statement.

Frage 59

Frage
SELECT STR(938.56, 6, 1)
Antworten
  • 938.56
  • 938.5
  • 0938.5
  • 938.6

Frage 60

Frage
What are the entities that can be viewed in the SQL Server Utility?
Antworten
  • Instances of SQL Server, Data-Tier apps, Database Files, Volumes
  • Disks, Volumes, Users
  • Instances of SQL Server, Users, Store Procedures, Volumes
  • Instances of SQL Server, Store Procedures, Tables

Frage 61

Frage
Which of the following could not be used as a primary key?
Antworten
  • Employee Number
  • Serial number for an electronic component
  • Social Security Number
  • A table can contain only one FOREIGN key

Frage 62

Frage
Which of the following can be used to improve query performance?
Antworten
  • All of the above
  • UNIQUE index
  • PRIMARY KEY
  • CLUSTERED index

Frage 63

Frage
Which of the following statements is not true about a FOREIGN KEY?
Antworten
  • A table can contain only one FOREIGN key.
  • You can create a foreign key by defining a FOREIGN KEY constraint when you create or alter a table.
  • A FOREIGN KEY enforces referential integrity by ensuring only valid data is stored.
  • A foreign key is a combination of one or more columns used to establish and enforce a link between the data in two tables.

Frage 64

Frage
Which of the following is NOT true about the PRIMARY KEY constraint?
Antworten
  • It is always created as CLUSTERED.
  • It is a column that participates in the PRIMARY KEY constraint cannot accept NULL values.
  • It can be composed of more than 1 column.
  • It enforces data uniqueness by creating a unique index for the primary key columns.

Frage 65

Frage
What is the DBCC command used for checking that tables in the db and the indexes are correctly linked?
Antworten
  • CHECKLINK
  • CHECKDB
  • CHECKFILEGROUP
  • CHECKALLOC

Frage 66

Frage
Which of the following is NOT a fixed server role?
Antworten
  • Accessadmin
  • Diskadmin
  • Setupadmin
  • Securityadmin

Frage 67

Frage
The 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?
Antworten
  • Create a logon trigger to prevent logons after normal business hours.
  • Write a store procedure to respond to all logon events and prevent logons after hours.
  • Create a SQL Server Agent job to shut down the server after 6:00pm and restart before 7:00am.
  • Broadcast a notification indicating the business hours.

Frage 68

Frage
The 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?
Antworten
  • Restore the full backup
  • Restore the transaction log
  • Backup the transaction log
  • Restore the most recent differential backup

Frage 69

Frage
[blank_start]Backup[blank_end] is the best method to prevent the loss of data.
Antworten
  • Backup
  • Redundant NIC's
  • UPS
  • RAID

Frage 70

Frage
We 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:
Antworten
  • 157.3563 MB
  • 1.573563 GB
  • 15.73563 MB
  • 1.573563 MB

Frage 71

Frage
How many files does Microsoft SQL Server use to store the database?
Antworten
  • 6
  • 3
  • 2
  • 4

Frage 72

Frage
What is the sub-language that allows user to insert, delete, and update data in a database?
Antworten
  • T-SQL
  • DML
  • DDL
  • CRUD

Frage 73

Frage
Which of these sentences is incorrect?
Antworten
  • SELECT * FROM cambridge WHERE id IN (1,3,5)
  • SELECT * FROM cambridge WHERE id NOT IN (1,5)
  • SELECT * FROM cambridge WHEREid BETWEEN (1,5)
  • SELECT * FROM cambridge WHERE id <> (15)

Frage 74

Frage
The DROP command allows you to [blank_start]permanently delete a database/table.[blank_end]
Antworten
  • permanently delete a database/table.
  • create new objects like a database/table
  • delete a record from a table.
  • modify the definition of an object.

Frage 75

Frage
Which three are T-SQL commands to handle privileges? (Choose three.)
Antworten
  • REFUSE
  • DENY
  • PERMIT
  • GRANT
  • RECIND
  • REVOKE

Frage 76

Frage
[blank_start]DROP LOGIN[blank_end] removes a SQL Server login account.
Antworten
  • DROP LOGIN
  • DELETE LOGIN
  • DELETE USER
  • DROP USER

Frage 77

Frage
What does SQL stand for?
Antworten
  • Structured Question Language
  • Structured Query Language
  • Structured Query Log
  • Strong Question Language

Frage 78

Frage
What are three types of databases?
Antworten
  • Context Model, Associative Model, Entity-Attribute-Value (EAV) data model
  • Oracle, DB2, SQL Server
  • Network Model, Relational Model, Object Oriented Model
  • Relational, Flat File, Hierarchical

Frage 79

Frage
What is the maximum date value that can be stored in a SMALLDATETIME data type?
Antworten
  • June 6, 2079
  • December 31, 9999
  • July 6, 2079
  • December 31, 2079

Frage 80

Frage
What is a view?
Antworten
  • A virtual table created by a query joining one or more tables
  • A command to recover the content of a table.
  • A physical copy of a table
  • The result of the execution of a query

Frage 81

Frage
Which option is not a T-SQL command to handle privileges?
Antworten
  • PERMIT
  • DENY
  • REVOKE
  • GRANT

Frage 82

Frage
What is a trigger?
Antworten
  • A named group of SQL statements that have been previously created and stored in the server database.
  • A physical structure containing pointers to the data.
  • A subset of a table.
  • A SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs.

Frage 83

Frage
The WHERE clause allows you to [blank_start]obtain a subset of rows.[blank_end]
Antworten
  • obtain a subset of rows.
  • view a subset of columns.
  • update the values inside record/records.
  • order a subset of rows.

Frage 84

Frage
Consider a query of two tables. The results contains only the rows that have a match in both tables. What kind of JOIN was used?
Antworten
  • RIGHT OUTER JOIN
  • INNER JOIN
  • LEFT OUTER JOIN
  • FULL OUTER JOIN

Frage 85

Frage
What statement is used to retrieve data from a database?
Antworten
  • READ
  • SELECT
  • GET
  • EXTRACT

Frage 86

Frage
The result of the query: SELECT COUNT (*) from employees will be:
Antworten
  • All of the above.
  • All the records that contains the character *.
  • All the records of the table employees.
  • The number of rows in the table employees.

Frage 87

Frage
What is the result of the following query: SELECT MAX (salary) from employee
Antworten
  • The average salary of all employees.
  • The salary of the employee with the highest value in the identifier column.
  • The maximum salary of all employees.
  • The salary of the employee called Max.

Frage 88

Frage
What statement is used to remove a record from a table?
Antworten
  • REMOVE
  • TRUNCATE
  • DELETE
  • ERASE

Frage 89

Frage
What does the following statment do? SELECT DATEADD(DD, 0, DATEDIFF(DD, 0, GETDATE()))
Antworten
  • The statement will generate an error. The second parameter of the DATEDIFF function should be a DATETIME data type.
  • Return the current system date unchanged.
  • Return the integer value of the current system date.
  • Return just the date part of the current system date removing the time.

Frage 90

Frage
How many levels of normal forms are there?
Antworten
  • 7
  • 3
  • 5
  • 11

Frage 91

Frage
What determines a database in the third normal form?
Antworten
  • The table faithfully represents a relation and has not repeating groups.
  • Every non-prime attribute ins non-transitively dependent on every candidate key in the table.
  • Every non-trivial join dependency in the table is implied by the superkeys of the table.
  • No non-prime attribute in the table is functionally dependent on a proper subset of a candidate key.

Frage 92

Frage
A unique constraint allows you to specify _________________.
Antworten
  • each record in a database table.
  • the types of data a user can insert into the database.
  • that data is entered into a cell.
  • which column should not contain duplicate values.

Frage 93

Frage
An index allows you to ______________________.
Antworten
  • increase the performance of a query.
  • order the columns in a table.
  • write better queries.
  • define the maximum size of a table.

Frage 94

Frage
SQL code injection is _________________________.
Antworten
  • an insert statement.
  • a technique that exploits security vulnerabilities in the db layer of an application.
  • the execution of a store procedure.
  • the use of SQL statements in high level languages.

Frage 95

Frage
[blank_start]Dbcreator[blank_end] can create, alter, and resize databases.
Antworten
  • Dbcreator
  • Diskadmin
  • Bulkadmin
  • Setupadmin

Frage 96

Frage
Members of what fixed database role cannot add, modify or delete any data in the tables within a database, regardless of other roles?
Antworten
  • db_datareader
  • db_denydatawriter
  • db_backupoperator
  • db_ddladmin

Frage 97

Frage
Which of the following fixed server roles can shut down the SQL Server?
Antworten
  • serveradmin
  • processadmin
  • securityadmin
  • setupadmin

Frage 98

Frage
What are the three different methods for which a user can be identified in Server Level security?
Antworten
  • None of the above.
  • Windows user login, SQL Server login, Use of Credentials
  • Root, SA, SQL Server login
  • Windows user login, membership in a windows group, SQL Server login

Frage 99

Frage
[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.
Antworten
  • Full backup
  • Differential backup
  • Daily backup
  • Incremental backup

Frage 100

Frage
Which of the following, is the filename extension of Microsoft SQL Server transaction log?
Antworten
  • .mdf
  • .ldf
  • .ndf
  • .log

Frage 101

Frage
What type of data structure improves data recovery speed?
Antworten
  • tri
  • filter
  • Index
  • Transaction Log

Frage 102

Frage
Which of the following is a collection of programs that enable you to capture, organize, and select data from a database?
Antworten
  • disk program
  • group spreadsheets
  • application DAT
  • DBMS

Frage 103

Frage
Which of the following defines a simple database using two-dimensional tables consisting of rows and columns?
Antworten
  • flat-type database
  • hierarchical database
  • Relational Database
  • table as a database

Frage 104

Frage
Which of the following refers to a database with multiple tables with parent / child relationships and a child can have more than one parent?
Antworten
  • flat file database
  • hierarchical database
  • Relational Database
  • table as database

Frage 105

Frage
Which allows multiple users to access both a SQL database?
Antworten
  • database server
  • workstation
  • collector
  • computer located in the center of the building

Frage 106

Frage
Among 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?
Antworten
  • checker
  • validator
  • scanner
  • constraint

Frage 107

Frage
Among the following, which is the main tool used to configure the databases to Microsoft SQL Server?
Antworten
  • DBS
  • SSMS
  • SQL Configuration Tool
  • ODBC SQL emulator

Frage 108

Frage
Which 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?
Antworten
  • DML
  • DDE
  • DDL
  • DAT

Frage 109

Frage
Which of the following statements is a T-SQL subset responsible for creating database objects such as tables and stored procedures?
Antworten
  • DML
  • DDE
  • DDL
  • DAT

Frage 110

Frage
Which statement type uses USE, CREATE, ALTER, and DROP?
Antworten
  • DML
  • DDE
  • DDL
  • DAT

Frage 111

Frage
Which of the following refers to the statement allowing you to delete the table in a SQL database?
Antworten
  • DELETE
  • LED
  • DROP
  • REMOVE

Frage 112

Frage
Which of the following refers to the statement that you can use to remove rows from a table?
Antworten
  • SELECT
  • UPDATE
  • DELETE
  • STOP

Frage 113

Frage
Which of the following statements is the primary method to program and manage SQL Server?
Antworten
  • DOS Commands
  • SQLCMD Scripts
  • XQuery
  • T-SQL

Frage 114

Frage
Which of the following allows you to execute SQL commands in an application from the command line?
Antworten
  • DOS Commands
  • SQLCMD Scripts
  • XQuery
  • Transact-SQK

Frage 115

Frage
[blank_start]Database[blank_end] is an organized collection of data, usually stored electronically.
Antworten
  • Database

Frage 116

Frage
The main data files used on a Microsoft SQL server have an extension [blank_start].mdf[blank_end]
Antworten
  • .mdf

Frage 117

Frage
Which statement is used to add or remove columns in a table? [blank_start]ALTER[blank_end]
Antworten
  • ALTER

Frage 118

Frage
What command can you use to change the context of the database? [blank_start]USE[blank_end]
Antworten
  • USE
Zusammenfassung anzeigen Zusammenfassung ausblenden

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

ähnlicher Inhalt

LEK 1
Max Muster
Zivilrecht - Definitionen
myJurazone
Schülern richtig Feedback geben
Laura Overhoff
Raumfahrt II
Christian Kunzi
Historische Quellenanalyse für Abitur & Matura
Elena Koch
Testfragen Sozialpsychologie
Sven Christian
Grundbegriffe der Kunst
K Gal
Themen der Vektorrechnung II
Paula Raithel
Vetie - MiBi 2013
Fioras Hu
Vetie - Lebensmittel 2022
Ann Borg
Vetie Spezielle Pathologie 2022
Alessandro Bertino
Bibliothek durchsuchen