Practice Sql Server Multiple Choice Questions with Answers Quiz-2

Q.1.

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)
SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)
SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)
SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

Q.2.

INSERT INTO tblNhanVienVALUES(N'Lê Văn Tám','04/30/1975')N character is stands for?

A String
An unicode string (Vietnameses)
varchar string
nvarchar string

Q.3.

With database qlBanHangtblNhanVien(MaNV, HoTen, MaCV, MaPB)tblPhongBan(MaPB, TenPB)tblChucVu(MaCV, TenCV)Which table do we insert data into first?

1, 2, 3
2, 3, 1
3, 1, 2
2, 1, 3

Q.4.

I want to create a table in my table named "actors" with two columns: "name" and "age." What statement will do this?

CREATE TABLE actors (name TEXT, age INTEGER);
CREATE actors WITH COLUMNS (name, age);
CREATE DATABASE actors WITH COLUMNS (name TEXT, age INTEGER);
CREATE actors (name, age): TABLE, TEXT, INTEGER;

Q.5.

I want to add the actor "Brad Pitt" (agedto my table "actors." Which statement will do this?

INSERT INTO actors VALUES ("Brad Pitt", 56);
INSERT "Brad Pitt" AND 56 INTO actors;
UPDATE age = 56 WHERE name = "Brad Pitt";
CREATE ENTRY ("Brad Pitt", 56) IN TABLE actors;

Q.6.

I want to select EVERY column and entry in my "actors" table. How can I do that?

SELECT * FROM actors;
SELECT age FROM actors;
SELECT * FROM actors WHERE age > 30;
SELECT name, age FROM actors WHERE age < 30;

Q.7.

I want to select all columns in my "actors" table for all actors older thanHow can I do that?

SELECT * FROM actors;
SELECT age FROM actors;
SELECT * FROM actors WHERE age > 30;
SELECT name, age FROM actors WHERE age < 30;

Q.8.

Reason for Mirroring Databse

Back up of the DB
Running the Copy of the DB simultaniously
To avoid slowness
Provide ExraSecurity

Q.9.

Advantages of Mirroring DB

Quick access of the DB
Less DownTime
Automatic Failover
All of the Above

Q.10.

There are 3 Transaction Log Backup files take on10th Sept, 14th Sept and 16th Sept. Which Backup files will be taken into account for Restoration

16th Sept
10th Sept
14th Sept
All of the Above

Q.11.

If there are 2 Differential backup, a) taken on 4th Sept and b) bckup taken on 8th Sept. Which bckup file will be considered for "Restore"

4th Sept
8th Sept
Both Backup
None

Q.12.

Which of the Codd rule is associated with thestatement that changes in the data storage should not affect programs that access the data?

Information Rule
Comprehensive Sub Language
Physical Data Independence Rule
Distribution Rule

Q.13.

The table emp hasrecords. This value corresponds to which of the following term?

Relation
Degree
Cardinality
Domain

Q.14.

Main editions of SQL server

Entp Edition
Standard Edition
Business Intelligence Edition
All of the above

Q.15.

You are required to update the phone number for only the DesignerID "SMIin the "Designer" table. Which of these would successfully do that?

UPDATE Designer SET PhoneNo = '01224123456'
UPDATE Designer (PhoneNo) VALUES ('01224123456')
UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'
UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

Q.16.

You are required to update the Price =for the ProductID include5 in the "Product" table. Which of these would successfully do that?

UPDATE Product SET Price = 10 WHERE ProductID = (1 and 5 and 10)
UPDATE Product SET Price = 10 WHERE ProductID = (1 or 5 or 10)
UPDATE Product SET Price = 10 WHERE ProductID in (1, 5, 10)
UPDATE Product SET Price = 10 WHERE ProductID all (1, 5, 10)

Q.17.

In what order does SQL process the instructions?

FROM - SELECT - WHERE - ORDER BY
WHERE - FROM - SELECT - ORDER BY
SELECT - FROM - WHERE - ORDER BY
SELECT - FROM - ORDER By - WHERE

Q.18.

Which of the following is not a database data type?

text
number
array
date

Q.19.

Which example of the field name below is in camel case?

First Name
firstName
FIRSTNAME
firstname

Q.20.

Which symbol would you use to represent more than 50

= 50
< 50
> 50
# 50

Support mcqgeeks.com by disabling your adblocker.