Flashcards
ISDBASE Finals Reviewer
Cards in this deck (42)
- 1(T/F) There is only one type of authentication when logging in to visual studioFalse
- 2What is the usual data type of foreign keyint
- 3What does SQL stands forStructured Query Language
- 4(T/F) You can access other database servers by entering the computer name of the remote database server when you login to windowsFalse
- 5(T/F) A table can be created without a databaseFalse
- 6What is the right data type for phone number?numeric (18, 0)
- 7What window do you use to create a queryNew Query Window
- 8When creating a new database the shortcut way, which folder do you right click?Database Folder
- 9A column of table is called _______field
- 10(T/F) the term "sa" means software adminFalse (Server Admin)
- 11(T/F) When creating a database, the default should be set to [master]True
- 12You are recording audit logs for employees, which is the right datatype for audit logsdatetime
- 13Is a structured set of data stored in a computerDatabase
- 14What is the right data type for the plate number of a vehiclenvarchar(8)
- 15A complete row of data in a table is called _________record
(**Singular, not plural) - 16A select statement that displays all records from the cake table (Remember me)Select statement select * from cake
- 17In declaring a relationship between employee table and salary table (SalaryID - PK) which statement is best suited for the taskSalaryIDK
(IDK = I don't know) - 18What does DML stand forIt stann for Data Manipulation Language
- 19(T/F) Putting a check mark on the [allow nulls] would enable the columnFalse
- 20Which of the items is SQL not capable ofUpdate Records in Master
- 21When writing an SQL statement, which character should be put to end the statementsemi-colon
[ ; ] - 22What is the right data type for foreign keysINT
- 23(T/F) The shortcut way of creating a table is possible by right clicking on the database folderFalse
(**Should be on the tables folder) - 24What does DDL stands forData Definition Language
- 25Is the wildcard that shows all recordsasterisk
[ * ] - 26What does RDBMS meanRelational Database Management Systems
- 27(T/F) Insert, update, delete, alter, create and execute are SQL commandsFalse
- 28Is a database computer language designed for managing data held in a relational database management systemSQL
- 29Is a GUI tool for configuringMicrosoft SQL managing server studio
- 30CRUD stands for Create, Update, Delete and ReplaceFalse
( Create - Read - Update - Delete ) - 31What do you call that starts with @ symbol in SQLVariables
- 32What do you need in order to make a connection string from your program to your databaseapp.config
- 33In order to connect your program to the database in app.config, you need to type this line of codes: (*hint: it's case-sensitive)connectionString=”Server= TAFT-CL331;Database=DatabaseDB;UID=sa;PWD=benilde
- 34What do you call a line of codes with <>Section
- 35What should be the naming convention for [Appliance ID]'s text boxtxtApplianceID
- 36How much value can i.e. nvarchar(max) hold1,000,000,000
(1 billion characters roughly or 2Gb in storage) - 37What is the highest value of a float number3.4 × 10^38
( both positive and negative) - 38Highest value of an integer2,147,483,647
- 39What are the values of boolean data type?1 or 0 | yes or no | true or false
- 40What is the proper format for datetypemm/dd/yyyy 00:00:00
- 41Can you encrypt password using stored procedure?True
(by assigning a variable) - 42Full name of our ISDBASE prof/parentMr. Angel Martin S. Manalansan
Information
- Description
- Flashcards on ISDBASE Finals Reviewer, created by Martin Agpalza on 15/04/2019.
- Created by
- Martin Agpalza
- Views
- 5
- Rating