SQL Server Indexing Interview Questions 

Can you provide any guidance on how to go about it. Basically its an ERP system for small firms and runs of Microsoft Server 2003 and uses SQL database. I have some idea on how sql works and if you can provide me some guidance on how to audit sql database, (like how to get the user logs, how to enable the audit logs, etc). Any help will be greatly appreciated. Thank you,

In a (simplified) database catalog, the DBMS needs to store the following information:
• Record all the tables of the database, which all have unique names and owners (assume owner is the user who creates the table). Tables can be base relations or views.
• The users are identified by a unique user-name and each of them has a password.
• A view is defined as the result of an SQL query, whose columns can be addressed by a name or column number.
• A base relation has:
o One or more named attributes, each of which has a data type and the NOT NULL constraint.
o One or more named indices, each of which consists of one or more attribute of the base relation. There is a specification of order direction, which must either be ASC (ascending) or DESC (descending).
o A primary key, which consists of one or more attributes of the base relation.
o One or more foreign keys, which consists of one or more attributes of the base relation, referring to attributes of (other) tables.
• Keep the access rights of users to a table: select, update, or delete.

a) Draw an ER diagram to depict your design about the entities and their relations in the database catalog. You have to show the cardinality. State any further assumptions that you have made in your design. Remember to show the primary key and foreign keys.

I have never moved a webpage from one host server to the next or needed to switch programming environments so I have many questions regarding how to do this. I am not a developer so please be don't be upset that I might be asking odd questions or using incorrect terminology- I am trying to learn what I need to do here.

I have a website with 4 pages currently being built on a server that runs coldfusion. I need to hook up one of the pages to a SQL database and another needs to be a form. The way that webpages normally do this on the current server are coldfusion includes.

But this site will soon be moving from this host to an outside source and I do not think the server will be running coldfusion.

Right now my page are titled like this: index.cfm or help.cfm

Every page on this server (thousands of them) have the cfm suffix so that is why i have been using the cfm suffix on my new pages thoguh they are not yet dynamic. Can I use the cfm suffix on servers that don't run coldfusion, even if the page doesn't actually have any coldfusion code?

Maybe if the pages don't have any coldfusion the can simply have the .htm suffix...but I will still need to have at least two pages that have some sort of dynamic coding - so will those pages need the correct suffix? If the new host is using ASP - will my two dynamic pages need .asp suffixes and the other pages are .htm?

Can you mix suffixes on one site?

Someone who is really good at programming, and codenig stuff like php, my sql, main stuff like that. cause my problem is complicated and i need someone who knows what they are doing:

ok now my problem is that im have set up a user script with monthly payments and everything, but when i test to see if people an sign up i get::

Warning: Cannot modify header information - headers already sent by(output started at /home/*******/public_html/*****/registra... in /home/*******/public_html/*****/registra... on line 250

and when i go to both lines they tell me:

Line 250::

header('Location: index.php?action=pay&user_id=' . $user->user_id. '&user_membership=' . $_POST['user_membership']);

whats happening

In Access' table Design View, you will see many of a field's properties (characteristics that define a field).

a. True
b. False

Save answer


Question 2 (1 point)
Typically, the field on the "many" side of a one-to-many relationship in Access shares the same name as the primary key in the table on the "one" side.

a. True
b. False

Save answer


Question 3 (1 point)
Which of the following is not an advantage to using Microsoft Access for listing information?

a. Duplicate data is minimized
b. Provides powerful mathematical functions like
Excel
c. Data entry is fast and easy
d. Information is secure through the use of passwords

Save answer


Question 4 (1 point)
In database terminology, a ______ is defined as the smallest unit of data organization consisting of a specific category of data.

a. record
b. table
c. object
d. field

Save answer


Question 5 (1 point)
Which of Access' keyboard shortcuts is used to move to the last field of the last record in a table?

a. [Ctrl]
b. [Ctrl][End]
c. [End]
d. [Shift][Tab]

Save answer


Question 6 (1 point)
What is the name of the thin line that separates field names in Access that can be dragged to the left or right to resize a column?

a. Column sizer
b. Resize line
c. Field selector
d. Column separator

Save answer


Question 7 (1 point)
Which of the following is not one of the options that you can select in Access' Navigation Pane?

a. Tables
b. Reports
c. SQL
d. Queries

Save answer


Question 8 (1 point)
The Access table data type that allows for the storage of Office and Windows files that can be linked or embedded is _______.

a. OLE Object
b. Text
c. Memo
d. Number

Save answer


Question 9 (1 point)
What is the name given to the field in an Access table that uniquely identifies each record in the table?

a. Primary Key
b. Index Field
c. Foreign Key
d. Relationship Indicator

Save answer


Question 10 (1 point)
A ___________ relationship between two tables means that a record from one table is related to one or many records in a second table.

a. multi-table
b. key-to-key
c. one-to-many
d. primary-foreign

Hey Everyone,

I have asked this question before but i am just not understanding. What i am trying to do is at the top i am going to have links. The links are to the values that appear under the field status in my ticket table on my sql server. So for example in my status field i have the value Open. At the top you will see Open an when you click on Open below in the table (where all the records are displayed) it will only display records with the value of Open . But i can not seem to get the link part of this working.

right now this is what i been trying to do

ticket holds are all the records
<cfquery name="ticket" datasource="CustomerSupport">
SELECT pk_ticketID,status,title,
date_last_modified,date_submitted,cust...
FROM
dbo.tbl_CS_ticketMaster
</cfquery>

this is the link at top which the user should click.
<cfoutput>
<a href="index.cfm?status=#Open#>Open</a>
</cfoutput>

where all the records will be displayed
<cfoutput query="ticket"></cfoutput>

if someone could explain to me what i am doing wrong i would really appreciate it :).

Thank you in advance,
Rach

Simply put, I am looking for the quickest and easiest way to get a database-driven website up so I can put an end to having to enter stats manually on pages.

Mind you, I don't know anything about SQl or any databases and do not understand PHP or any other language beyond HTML. I do learn quickly, though.

Example of site: http://trendon.org/launch/index.htm

If you click on the player named Alexander, I'd just like to be able to enter his stats into a DB for all succeeding seasons and then call it from the webpage. That's it. Nothing insane or over-the-top.

Will CF do this for me? I know PHP will, but it seems like too much; like eating a candy bar with a steamshovel.

This code is written in PL/SQL any one can give me brief description about it? any thoughts will be appreciated.

TYPE t_RtsReasons IS TABLE OF t_RtsReason INDEX BY BINARY_INTEGER;

PROCEDURE get_rts_reasons(p_Mag IN NUMBER, p_RtsReasons OUT t_RtsReasons) IS
CURSOR C IS

select
palcent,
pallibl
from
parlgene@tpx
where
palnmag=p_Mag and
palctab=30 and
palcent between 500 and 599 and
pallang=
(select
parlibc
from
pardgene@tpx
where
parnmag=palnmag and
parctab=726 and
parcent=1)

order by
palcent;

i NUMBER(9):=1;

BEGIN
FOR R IN C LOOP
p_RtsReasons(i):=R;
i:=i+1;
END LOOP;
END;

I'm attempting to add the "auto_increment" option to an existing row in an existing table (containing data). The row NEWS_ID is int(10) and is indexed. I'm using the following command

ALTER TABLE ytc_news MODIFY news_id AUTO_INCREMENT;

and getting the following error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AUTO_INCREMENT' at line 1

What am I doing wrong?

Thanks.

d.dub/

Here is my SQL statement:

"SELECT albums.title, albums.ID, artists.title, artists.ID FROM albums, artists WHERE albums.artistID = artists.ID "

when i echo this: $row_randAlbQuery['albums.ID'];

i get this error:

Notice: Undefined index: albums.ID in C:\sites\premium18\purposebuilt\webroot\... on line 166

any idea why? is there a way of doing it without using AS everwhere?

I have a SQL database which has a number of tables, I have a table which has the names of all the tables in the database. I first need to derive name of a table from this table and then query that table. So the query is like:
SELECT * FROM (SELECT TABLE FROM INDEX_TABLE).
Please solve this problem for me as it is really urgent!! Thank you!! I got a project stuck because of this!! And I shall surely put your name on my project and shall personally tell you when it is online!!

I have a program that has some multi-select boxes that will gather information about delimiting values in an SQL query. I need to be able to find out which items in the listbox are selected. The following command is useful for only retrieving the value of the first selected index

Level.Items[Level.SelectedIndex].ToStr...

Please help. Multi-Select box is called Level.

I would like to know what google and yahoo webcrawlers can read.

Teh reason is, I have a website that has many html anchor text links but many more things on the site are much more complicated.

The navigation is javascript, the press releases and other important information are in a SQL database and that database is linked to the page using CF includes.

So what I really want to knowis :can a webcrawler folow the cf includes to the database information on a html page and index those links?

I am interested in reading some source information so please site your sources. Also, please explain things in plain english, not programming lingo.

Thank you!

10 points to best answer!

This code is written in PL/SQL any one can give me brief description about it? any thoughts will be appreciated.

TYPE t_RtsReasons IS TABLE OF t_RtsReason INDEX BY BINARY_INTEGER;

PROCEDURE get_rts_reasons(p_Mag IN NUMBER, p_RtsReasons OUT t_RtsReasons) IS
CURSOR C IS
select
palcent,
pallibl
from
parlgene@tpx
where
palnmag=p_Mag and
palctab=30 and
palcent between 500 and 599 and
pallang=
(select
parlibc
from
pardgene@tpx
where
parnmag=palnmag and
parctab=726 and
parcent=1)

order by
palcent;

i NUMBER(9):=1;

BEGIN
FOR R IN C LOOP
p_RtsReasons(i):=R;
i:=i+1;
END LOOP;
END;

When i try to creat a database i get this error


Error
SQL query:

CREATE TABLE `donavons_Testdatabase`.`Kelly` (
`price` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`dis` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
INDEX ( `price` , `dis` )
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_bin

MySQL said:

#1170 - BLOB/TEXT column 'price' used in key specification without a key length

Can you help me fix it. Or give me step by step setup on the host monster mysql database.

PS if someone that knows what they are doing could IM ME that would be asome! THANK YOU SO MUCH FOR ALL YOUR HELP