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
0 h : 0 m : 1 s